Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems

Business Objects - Launch Pad - Refreshing Document Error ORA-01843

This article describes what to do if you refresh a Business Objects document and encounter an error "Error during SQL execution: (DA0003)", and when you click on the Details button, additional details of "date format picture ends before converting entire input string State: N/A" OR "Exception: DBD, ORA-01843: not a valid month State: N/A".

You need to re-enter any dates that are hard-coded in conditions in the Query Panel to resolve this issue, which is related to the move of the IRF database to Oracle. Follow these steps:

  1. On the menu bar, select Data Access > Data Providers > Edit.
  2. If you have more than one data provider, you’ll be prompted to select one. You’ll need to repeat the following steps for each data provider that has a hard-coded date in it.
  3. In the Query Panel, click on the date (Operand) in the condition, and either retype the date or reselect the value from a list of values by using ‘Show list of values’.
  4. Run the query.
  5. Repeat these steps for any additional data providers in the document.

Keywords:bis irf BO "date format picture" oracle   Doc ID:19602
Owner:James I.Group:University of Chicago
Created:2011-08-07 18:00 CSTUpdated:2016-08-02 10:45 CST
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  0   3