cbudoris
Active Member
I'm putting this here in case anyone else encounters this problem...
We're doing a tools upgrade from 9.1.2 to 9.1.5.2. We've got several BIP documents in production under the old tools, but one of them wasn't rendering at all in the new tools (the other ones were fine). From the WSJ screen, the Report Definition output repository screen is blank, but the Report Definition Job Control search screen will list the job at an E status, with description as "Data Extraction Failure".
Other things you might see, if you run the debug log for the submitted UBE, you might see this message buried in there: Embedded BIP Polling: Unable to update RD job record to WX for Polling.
Right before that message in the log I found this: xmlp_UpdateRepDefJobRecordFromUBE failed
So I did a search on Oracle's site for 'UpdateRepDefJobRecordFromUBE', and came across this bug entered on 3/9/2015:
(NUR = non-update reports)
Bug 20355496 : NUR REPORTS WON'T PUBLISH WITH BIPUB EMBEDDED
https://support.oracle.com/epmos/fa..._afrWindowMode=0&_adf.ctrl-state=1m3b6jy1w_45
Hdr: 20355496 N/A H94 9.1 PRODID-4781 PORTID-226 20085438
Abstract: NUR REPORTS WON'T PUBLISH WITH BIPUB EMBEDDED
*** 01/13/15 06:39 pm ***
When you run the OSHA, BLS or Detailed Incident Reports, they end in error.
Believe it might be because of tools release 9.1.5.
Note from tester:
Upon reviewing the jde.log file for the failed reports, I discovered that
each of these reports is defined as a "read-only" report. Apparently, when
they're run in conjunction with a BIP Report Definition, the system is trying
to update the report definition job record on the F9563110 table, which the
system won't allow for a read-only report. See excerpt from jde.log below,
and full copy of jde.log attached to this ticket. Note that if I create a new
report version that isn't tied to a report definition, that version will run
successfully to completion and produce standard JDE PDF output.
jde.log excerpt follows:
3291/-173328688 MAIN_THREAD Tue Jan 13 22:33:29.075866 runbatch.c935
RUNBATCH: Remote CP=1252, Remote OS=1, Local CP=1252, ConvertToASCII=0
3291/-173328688 WRK:Starting jdeCallObject Tue Jan 13 22:33:30.561471
jdb_exet.c2320
JDB9910018 - Read Only Report, Update not executed
3291/-173328688 WRK:Starting jdeCallObject Tue Jan 13 22:33:30.562722
xmlpextern.cpp1286
JDB_UpdateTable failed for F9563110
What this is saying is that when the report was initially created in OMW, on the initial screen when you're entering the name and system of the UBE, there's a field Update vs non-update report. This is in the table ol910.f9860, SIOMIT. For whatever reason, the developer created it as a non-update report- probably because the report doesn't update statuses or totals. (TBH, I have no idea what this field actually does, and the best thing to to is probably to set it to update and leave it at that. I think I've run into other issues in the past when this was set to 'non-update'.)
In any case, just to a SQL update to that table by setting the SIOMIT to '0', and this problem goes away. Hope this helps.
We're doing a tools upgrade from 9.1.2 to 9.1.5.2. We've got several BIP documents in production under the old tools, but one of them wasn't rendering at all in the new tools (the other ones were fine). From the WSJ screen, the Report Definition output repository screen is blank, but the Report Definition Job Control search screen will list the job at an E status, with description as "Data Extraction Failure".
Other things you might see, if you run the debug log for the submitted UBE, you might see this message buried in there: Embedded BIP Polling: Unable to update RD job record to WX for Polling.
Right before that message in the log I found this: xmlp_UpdateRepDefJobRecordFromUBE failed
So I did a search on Oracle's site for 'UpdateRepDefJobRecordFromUBE', and came across this bug entered on 3/9/2015:
(NUR = non-update reports)
Bug 20355496 : NUR REPORTS WON'T PUBLISH WITH BIPUB EMBEDDED
https://support.oracle.com/epmos/fa..._afrWindowMode=0&_adf.ctrl-state=1m3b6jy1w_45
Hdr: 20355496 N/A H94 9.1 PRODID-4781 PORTID-226 20085438
Abstract: NUR REPORTS WON'T PUBLISH WITH BIPUB EMBEDDED
*** 01/13/15 06:39 pm ***
When you run the OSHA, BLS or Detailed Incident Reports, they end in error.
Believe it might be because of tools release 9.1.5.
Note from tester:
Upon reviewing the jde.log file for the failed reports, I discovered that
each of these reports is defined as a "read-only" report. Apparently, when
they're run in conjunction with a BIP Report Definition, the system is trying
to update the report definition job record on the F9563110 table, which the
system won't allow for a read-only report. See excerpt from jde.log below,
and full copy of jde.log attached to this ticket. Note that if I create a new
report version that isn't tied to a report definition, that version will run
successfully to completion and produce standard JDE PDF output.
jde.log excerpt follows:
3291/-173328688 MAIN_THREAD Tue Jan 13 22:33:29.075866 runbatch.c935
RUNBATCH: Remote CP=1252, Remote OS=1, Local CP=1252, ConvertToASCII=0
3291/-173328688 WRK:Starting jdeCallObject Tue Jan 13 22:33:30.561471
jdb_exet.c2320
JDB9910018 - Read Only Report, Update not executed
3291/-173328688 WRK:Starting jdeCallObject Tue Jan 13 22:33:30.562722
xmlpextern.cpp1286
JDB_UpdateTable failed for F9563110
What this is saying is that when the report was initially created in OMW, on the initial screen when you're entering the name and system of the UBE, there's a field Update vs non-update report. This is in the table ol910.f9860, SIOMIT. For whatever reason, the developer created it as a non-update report- probably because the report doesn't update statuses or totals. (TBH, I have no idea what this field actually does, and the best thing to to is probably to set it to update and leave it at that. I think I've run into other issues in the past when this was set to 'non-update'.)
In any case, just to a SQL update to that table by setting the SIOMIT to '0', and this problem goes away. Hope this helps.
