Wednesday, September 04, 2013

BI Publisher Report Error: Caused by: Root problem: oracle.apps.xdo.XDOException:No corresponding LOB data found

We were doing some cleanup of BI Publisher reports. Some of reports were importing one sub template. That sub template's name was changed. We modified most of the reports and changed the imported sub template name. In few reports we missed to change sub template's name. When user ran the report they got following error

The error message has sql statement that caused the error and bind variables too were displayed. When i ran failed sql statements using bind variables displayed in OPP log file, sql was returning one row. I could not figure out the reason for failure. So i opened the rtf template and i noticed the import statements towards the bottom of the rtf template. i checked the properties and found old sub template name. I corrected the sub template name and report worked fine.

The sql statements shown in OPP log file was used for sub template too but bind variable information for sub template was not displayed in the OPP log file. Bind variable information was displayed for main report template. It seems Oracle development wanted to display enough information for debugging but they were displaying irrelevant bind variable information. If they had displayed correct values of bind variables that caused sql statement to fail, it would have been 30 second job to figure out root cause.

No comments:

Post a Comment