APAR status
Closed as program error.
Error description
When STP-Oracle job is used to extract rows from Oracle and the procedure type is set to Transform, an incorrect warning with row information is being logged to the director log at the end of the last row. Since the procedure has been executed successfully, there shouldn't be any warning message logged.
Local fix
Use procedure type of Source.
Problem summary
**************************************************************** USERS AFFECTED: All users of Stored Procedure Stage with Oracle as DBVendor and using a transform mode STP stage to read from data from Oracle database. **************************************************************** PROBLEM DESCRIPTION: An incorrect warning message is issued at the end of the execution of the stored procedure while using Oracle as DBVendor option and using EOD (end of data) in transform mode. The warning message will be as follows: pmr29902_STP..Stored_Procedure_0: The value of the row is: DEPTNO = 1 DEPT_NAME = OPERATIONS **************************************************************** RECOMMENDATION: Apply the APAR JR37006 which supersedes this patch. ****************************************************************
Problem conclusion
The return of EOD row returns -1 as OCIStatus and this was incorrectly treated as a warning and hence the message with last row values are printed in Warning log. This has been corrected.
Temporary fix
Comments
APAR Information
APAR number
JR36946
Reported component name
INFO SRVR PLATF
Reported component ID
5724Q3612
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-06-18
Closed date
2010-07-06
Last modified date
2010-07-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFO SRVR PLATF
Fixed component ID
5724Q3612
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
06 July 2010