Groff Automation Forum Index
Making software work for you
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister   ProfileProfile   Log inLog in 

Log in to check your private messagesLog in to check your private messages   

Windows Security Update - May 13th 2008

 
Post new topic   Reply to topic    Groff Automation Forum Index -> Program Help
View previous topic :: View next topic  
Author Message
sauberan

Joined: 09 Mar 2005
Posts: 17
PostPosted: Fri May 16, 2008 8:42 am    Post subject: Windows Security Update - May 13th 2008 Reply with quote

Crystal Delivery 7.0.6.8 hasn't worked properly since the last windows update. There were 41 security patches applied. I was wondering if anyone else has come across this issue?

Thanks in advance for your comments.

Mark
Back to top
View user's profile Send private message
werp1978

Joined: 14 May 2008
Posts: 23
PostPosted: Fri May 16, 2008 9:31 am    Post subject: Reply with quote

Try installing 7.0.7.0. I'm using that, but having said that I have no idea if I've got the latest patch installed!
Back to top
View user's profile Send private message
sauberan

Joined: 09 Mar 2005
Posts: 17
PostPosted: Wed May 21, 2008 7:42 am    Post subject: Reply with quote

I updated to the newest version 7.0.7.0 and it work OK the first night, but the same exact issue came up last night. Crystal Delivery would kick off the first report without a problem but didn't loop through the other scheduled reports.

Has anyone else experience this with CD?
Back to top
View user's profile Send private message
cnewell

Joined: 23 Aug 2007
Posts: 11
PostPosted: Thu May 22, 2008 7:58 pm    Post subject: Reply with quote

It might be that your window of exporting for your reports are only a minute or so.
I find that i have to set an export timeframe of an hour or so, then reset the last start date once every month. The reason for this is that crystal delivery will only fire if the last time it executed is more than the time frame. eg if set for each day at 1-2pm to run, then the last time it ran has to be before 2pm or it will NOT run as expected.

so when you manually run them, you have to also change the last run time to before the scheduled time or the next day won't run correctly.

i know this is a confusing post, but the example is solid.
Back to top
View user's profile Send private message
sauberan

Joined: 09 Mar 2005
Posts: 17
PostPosted: Tue May 27, 2008 7:16 am    Post subject: Reply with quote

This isn't the case since I'm well aware to set back the clock on the report so it can fire off the same day but later in the evening.

It seems that I'm having the same problem as this post - http://kgroff.greatboard.com/viewtopic.php?t=743.

Since I upgraded to the newest version of CD, I was wondering if there is an older version which works in AUTO mode until this issue gets resolved?

I did get this error in the process log:

5/27/2008 9:29:57 AM
Messasge: Conversion from string "" to type 'Double' is not valid.
Source: Microsoft.VisualBasic
Stack Trace: at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(String Value, NumberFormatInfo NumberFormat)
at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(String Value)
at CrystalDelivery.frmMain.CheckExports(DateTime datCurrentDate)
Target Site: Double ToDouble(System.String, System.Globalization.NumberFormatInfo)

Thank you.
Back to top
View user's profile Send private message
werp1978

Joined: 14 May 2008
Posts: 23
PostPosted: Tue May 27, 2008 8:25 am    Post subject: Reply with quote

Do you believe this double to string error is because of the windows security and/or version of CD?

I scheduled 20 reports to run over the weekend.... 13 are fine but 7 give lots of errors. Incidentally they run fine in manual mode.
Back to top
View user's profile Send private message
sauberan

Joined: 09 Mar 2005
Posts: 17
PostPosted: Wed May 28, 2008 7:17 am    Post subject: Reply with quote

6 of the 14 reports did run auto mode last night but for the life of me can't understand why the other 8 didn't kick off. I know another forum post references the auto mode issue.

Can any one guide me in the right direction?

Thanks in advance.

Mark
Back to top
View user's profile Send private message
werp1978

Joined: 14 May 2008
Posts: 23
PostPosted: Thu May 29, 2008 3:55 am    Post subject: Reply with quote

sauberan wrote:
6 of the 14 reports did run auto mode last night but for the life of me can't understand why the other 8 didn't kick off. I know another forum post references the auto mode issue.

Can any one guide me in the right direction?

Thanks in advance.

Mark


I found that setting the last export time to some time a few months in the past seems to help somewhat.

EDIT

Also, stagger the export times for your reports. I had some reports not working, I staggered them and that seemed to do the trick.

So, in summary doing the above helped. Not sure which is the important one, but who cares. It seems to work.


Last edited by werp1978 on Fri May 30, 2008 8:13 am; edited 1 time in total
Back to top
View user's profile Send private message
sauberan

Joined: 09 Mar 2005
Posts: 17
PostPosted: Fri May 30, 2008 8:03 am    Post subject: Reply with quote

Ok well I have the same condition as yesterday. 6 of the 14 reports kicked off and CD stalls on the seventh report. I staggered the times so there is a 10 minute gap between reports.

There is nothing in the PC's application log which gives me any indicator why CD is hanging on the seventh report either.

I'm able to run the reports manually without a hiccup.

The only difference I see is that the export Export Interval states "Every Days" whereas the rest are coded as "Every Day".

Once again thank you in advance to any feedback that will help resolve this issue.

Mark
Back to top
View user's profile Send private message
werp1978

Joined: 14 May 2008
Posts: 23
PostPosted: Fri May 30, 2008 8:11 am    Post subject: Reply with quote

sauberan wrote:
Ok well I have the same condition as yesterday. 6 of the 14 reports kicked off and CD stalls on the seventh report. I staggered the times so there is a 10 minute gap between reports.

The only difference I see is that the export Export Interval states "Every Days" whereas the rest are coded as "Every Day".

Once again thank you in advance to any feedback that will help resolve this issue.

Mark


For the one that says "Every Days" go to the schedule settings for that report, and enter "1" for the unit. Looks like you aren't telling it what frequency it needs to do the export.

PS. Dont worry about the tmp files.. i removed that comment from the above post.
Back to top
View user's profile Send private message
sauberan

Joined: 09 Mar 2005
Posts: 17
PostPosted: Thu Jun 05, 2008 7:29 am    Post subject: Reply with quote

Since making the change as suggested, all is well with CD! Thanks to all who responded 8)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Groff Automation Forum Index -> Program Help All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You can delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group

Igloo Theme Version 1.0 :: Created By: Andrew Charron