Failing a job process to export to MS Excel via third part's software

[former_member533461]

Hi, I am exporting Crystal Reports file to MS Excel file via a third party's software. We have 5 different testing environments and the report job process fails in only one specific environment and each file cause different error such as; 

- Error: CrystalDecisions.CrystalReports.Engine.ExportException

- Error: Timed out after 60 minutes during iteration 1 of the loop

I checked permission setup in SQL Server level(SQL Server 2008): Databases >> relevant database >> Security >> Users >> the user which is used as a system user to run the job process >> properties >> General and Securables and those settings look fine. User role setting is correct as well. I also restarted the service of the environment in the server but it did not solve this issue.

Are there any other settings to check when testing environment is being built?

Thank you,

Christine

[former_member292966 · Accepted solution]

Hi Christine,

Are you able to print the report to a screen or a different format?  I'd be interested in finding out if it's a problem with the report and not a problem with exporting to Excel.

You said it's working in the other testing environments.  If you grab a copy of a report from another test environment and copy it into this one, how does it work?

If you take the query the report is passing, you can get it if you open the report in Crystal and go to Database | Show SQL Query.  Run that query in SQL Server using the same SQL Server account the vendor app is using, this show us if the problem is in SQL Server or not.

Do you know what version of Crystal Reports the reports were developed in?

Unfortunately the error isn't very helpful.  Check to see if the SQL Server Agent returns a better error message.  The errors you show are from Crystal but SQL Server may shed some light as to what's happening.

You may need to go back to the vendor for help on this.  Their code behind may be doing something to the report we can't see and wouldn't be able to troubleshoot.

Good luck,

Brian

[former_member533461 · Accepted solution]

Hi Brian. Thank you for your reply. So far, all the reports which are failngs are trying to export to Excel. And I copied those reports from the other environment we successfully tested to this environment. And queries in both environments are the same.. And I am using Crystal Report 2011.

Unfortunately, I cannot release the details of errors because the error messages includes confidential information although I know it will help you to understand more.(The above errors are raised in the vendor's system)

I will check database driver and other things you advised me. Thank you again.

[DellSC · Accepted solution]

You're probably going to have to contact your vendor for assistance with this.  Since we have no way of knowing what their code looks like or how they implemented the export functionality, it would be very difficult, if not impossible, for us to diagnose the issue.

-Dell

[former_member533461 · Accepted solution]

Thank you, Dell. I have already discussed with the vendor but they have no idea either.. but will try to discuss with them again.

[former_member183750 · Accepted solution]

Hi Christine

If the vendor has no idea, it is their responsibility to then take up the issue and ask us for help. They can do so in these forums, or they can create a phone. case. But they are the ones that should be doing the heavy lifting here. Not you

Just as an FYI; Phone cases can be created here:

Crystal Single Case Technical Support - SAP Business Objects US Online Store | SAP Online Store

But don't create a phone case your self. All that you will be told is that since it is a 3rd party app, they should be calling...

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[former_member533461 · Accepted solution]

Thank you Ludek! It is really hard to investigate this issue since our vendor does not release all the codes of the system. We need assume and try again and again.. I will let the vendor know the phone case forum and this forum. Thank you again

[former_member183750 · Accepted solution]

Good luck Christine. I really am keeping my fingers crossed

- Ludek

[former_member292966]

One more thing I forgot to check.  Make sure the database driver, whether ODBC or native, to SQL Server is the same as the other machines.

Good luck,

Brian