JR30409: THE PROVIDED INSERT STATEMENT DID NOT PREPARE CORRECTLY;

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 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