Skip to Content
author's profile photo Former Member
Former Member

Reports are failing in BOE CMC

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 02, 2012 at 07:51 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.