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:
- On the menu bar, select Data Access > Data Providers > Edit.
- 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.
- 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’.
- Run the query.
- Repeat these steps for any additional data providers in the document.