Reports are failing in BOE CMC

[Former Member]

Hi,

Some of my scheduled reports are failing and throwing me an *Error in File ~tmp1b186edade3f8f0.rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: 229 ]. They are working fine SQL DB and crystal reports designer.

Edited by: nrkc@99 on Feb 2, 2012 4:53 PM

[Former Member]

Hi,

Go to CMC > Folder in which the report is there> Right click on the report> select schedule from the list>a dailog box will open.In the left pane you will see database logon-->click on database logon and provide the credentials for the database.then schedule the report.

Let me know of it was help ful.

regards,

Prithvi

[Former Member]

I already done that, I still wonder why it was failing continuously .

[Former Member]

Hi,

Ensure that the user has the appropriate rights in the database to access the tables the report is using.

This problem may arise when a report is created by a user who has the appropriate rights, but is then run by a user who does not have those rights.

You can also do one more thing..

Open the Crystal Report(s) in the Crystal Reports Designer.--> Go to 'File' Menu -->Select 'Page Setup'. -->Check 'No Printer' option. --> Save the Crystal Report again into repository

And then try scheduling again

regards,

Prithvi