Crystal Delivery 8.0.0.1

LoveMyITGuy · Posted: Thu Jan 15, 2009 11:18 am Post subject: Crystal Delivery 8.0.0.1

I'm trying to use this application to send a few reports as scheduled, however I am coming across a few issues.

1st - In some cases, the automated reports just wont send as scheduled. Exporting them manually works fine from what I can tell. when they are not sent, an event is logged in the application log regarding crystalcmd.exe and permissions denied. Unfortunately I cleared my log to attempt to resolve the next issue so I will post if/when it reoccurs.

2nd - I have a report that I cannot export automatically or manually. I receive the following in the application event log:
Type: Error
Source: .NET Runtime 2.0 Error
Event ID: 5000
EventType clr20r3, P1 crystalcmd.exe, P2 7.0.4.6, P3 48fe1204, P4 crystaldecisions.reportappserver.datasetconversion, P5 10.5.3700.0, P6 48b540e6, P7 1f, P8 297, P9 2xa1m4tdhkntb0crpv0cdnqc142qyqk, P10 NIL

My initial research indicates that this is an unhanded exception.

Recommendation for future versions: Implement additional error handling. I.E. The instance above, or when e-mailing a file check to see if the file is valid rather than assuming its there (This is another error I received). Additionally, the ability to enable/disable tasks or change the order of reports would be great.

I would love to make a donation, considering that Crystal Server goes for 2K+ you should make a little extra...but if the application isn't reliable for me I cannot justify it at this time.

Also, would you be willing to share the source? I program in VB and may be able to assist if needed

Thanks!

LoveMyITGuy · Posted: Thu Jan 15, 2009 11:20 am Post subject:

Forgot to mention that this application is running on a Windows 2003 server in the event it makes any difference.

LoveMyITGuy · Posted: Thu Jan 15, 2009 12:39 pm Post subject:

Some additional info regarding the 2nd issue in the original post (If I can provide anything else please let me know).

This report is using two connection sources:
1st is DatabasenameA, ServerA, UserIDA
2nd is Database name is blank, ServerB, UserIDB

I tried to view this report using the built in viewer which prompts me to enter my server credentials, it is here I notice two issues.

When prompted for my credentials, the server name is ServerB, the Database is DabasenameA and the login id is UserIDB.

When I enter the credentials for either server, the login request is denied.

I do not see any login attempts at all on ServerA, and cannot tell on ServerB as this is a Cache Database without login auditing for SQL.

Could it be that the Blank Database name in the second connection is causing this issue (If this field is null the Crystal Delivery Application is using the previous value?)

[edit]Looks like that's the issue, which is only present when more than 1 data source is present as all of my other reports work fine with just one datasource and no database name.

I played around with the report config, and populating the spot where a database name would go returned the information I populated in the database name field.

Looks like I will have to create a workaround for now (Use Access as a middle man?)...hopefully this issue will be updated in a later version[/edit]

rayc · Posted: Wed Jan 21, 2009 4:02 pm Post subject:

I've seen posts in the past that Crystal Delivery will not work with Windows Server. I had a similar problem and would up loading on an XP PC and it works fine now.

LoveMyITGuy · Posted: Tue Feb 03, 2009 9:36 am Post subject:

Well it saddens me to say this since I believe this product has great potential, but due to the reliability and other issues I've encountered I've created my own solution using Winbatch. It may not be perfect but at least it runs as scheduled using Windows Scheduler, and if it doesn't then at least I can debug the code and correct it on my own.

If anyone else is interested, I've posted my code below. This will give you a good understanding if you want to create your own code in VBS or etc....