APAR status
Closed as program error.
Error description
OracleEnterprise stage causes following error after applying a patch for JR29779 or JR30068. Oracle_Enterprise_5: The provided insert statement did not prepare correctly; please verify that your statement is correct; statement: INSERT INTO t29665a1000 (COL0001, COL0002, COL0003, COL0004, COL0005, COL0006, COL0007, COL0008 COL0009, COL0010, COL0011, COL0012, COL0013, COL0014, COL0015, COL0016, COL0017, COL0018, COL0019, COL0020, COL0021, COL0022, COL0023, COL0024, COL0025, COL0026, COL0027, COL0028, COL0029, COL0030, COL0031, COL0032, COL0033, COL0034, COL0035, COL0036, COL0037, COL0038, COL0039, COL0040, COL0041, COL0042, COL0043, COL0044, COL0045, COL0046, COL0047, COL0048, COL0049, COL0050, COL0051, COL0052, COL0053, COL0054, COL0055, COL0056, COL0057, COL0058, COL0059, COL0060, COL0061, COL0062, COL0063.......
Local fix
This fix is included in 8.0.1 fix pack 3
Problem summary
**************************************************************** USERS AFFECTED: DataStage 7.5.3 All platforms **************************************************************** PROBLEM DESCRIPTION: Oracle EE Upsert stage insert or update statements not preparingcorrectly. **************************************************************** RECOMMENDATION: Upgrade to latest version of the Oracle EE stage. This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
Problem occurred in a parallel jobs with Oracle EE upsert stage.
Temporary fix
Comments
APAR Information
APAR number
JR30409
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
753
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-09-05
Closed date
2008-10-17
Last modified date
2010-12-09
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
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R753 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010