JR35099: PARALLEL JOB ABORTS WITH: "DBNAME: UNSUPPORTED DATA TYPE [SYBUTILS.C:2239]"

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• Parallel job abort with message similar to:
  ##E IIS-DSEE-SYAS-00057 19:17:16(001) <sdb01>  Unsupported Data
  Type  [sybutils.C:2239]
  ##E IIS-DSEE-SYAS-00008 19:17:16(002) <sdb01> Error while
  Preparing the Schema  [sybread_ct.C:450]
  ##E IIS-DSEE-TFIP-00034 19:17:16(004)
  <APT_TransformOperatorImplV0S5_Job_Name_Transformer01 in
  Transformer01> Error when checking operator: Could not find
  input field "TIMESTAMP". [api/interface_rep.C:3174]
  ##W IIS-DSEE-TFIP-00096 19:17:16(005) <sdb01> When checking
  operator: The modify operator keeps field "TIMESTAMP" which is
  not present in the output interface. [api/interface_rep.C:6940]
  ##W IIS-DSEE-TFIP-00096 19:17:16(006) <sdb01> When checking
  operator: The modify operator keeps field "VERSION" which is not
  present in the output interface. [api/interface_rep.C:6940]
  ##E IIS-DSEE-TFIP-00034 19:17:16(007)
  <APT_TransformOperatorImplV0S5_Job_Name_Transformer01 in
  Transformer01> Error when checking operator: Could not find
  input field "VERSION". [api/interface_rep.C:3174]
  ##E IIS-DSEE-TFIP-00034 19:17:16(008)
  <APT_TransformOperatorImplV0S5_Job_Name_Transformer01 in
  Transformer01> Error when checking operator: Could not find
  input field "EVENT_TYPE". [api/interface_rep.C:3174]
  ##W IIS-DSEE-TFIP-00096 19:17:16(009) <sdb01> When checking
  operator: The modify operator keeps field "EVENT_TYPE" which is
  not present in the output interface. [api/interface_rep.C:6940]
  ##W IIS-DSEE-TFIP-00096 19:17:16(010) <sdb01> When checking
  operator: The modify operator keeps field "REASON_TEXT" which is
  not present in the output interface. [api/interface_rep.C:6940]
  ##E IIS-DSEE-TFIP-00034 19:17:16(011)
  <APT_TransformOperatorImplV0S5_Job_Name_Transformer01 in
  Transformer01> Error when checking operator: Could not find
  input field "REASON_TEXT". [api/interface_rep.C:3174]
  ##E IIS-DSEE-TFIP-00034 19:17:16(012)
  <APT_TransformOperatorImplV0S5_Job_Name_Transformer01 in
  Transformer01> Error when checking operator: Could not find
  input field "ORDER_ID". [api/interface_rep.C:3174]
  ##E IIS-DSEE-TFSR-00019 19:17:16(013) <main_program> Could not
  check all operators because of previous error(s)
  [api/step_rep.C:1186]
  ##W IIS-DSEE-TFIP-00096 19:17:16(014) <sdb01> When checking
  operator: The modify operator keeps field "ORDER_ID" which is
  not present in the output interface. [api/interface_rep.C:6940]
  ##E IIS-DSEE-TCOS-00029 19:17:16(015) <main_program> Creation of
  a step finished with status = FAILED. [osh.C:1081]
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All Platforms, jobs using Sybase EE
  ****************************************************************
  PROBLEM DESCRIPTION:
  Job using Sybase EE with ASE aborts with "Unsupported Data
  Type"
  
  ****************************************************************
  RECOMMENDATION:
  Install patch form JR35099
  ****************************************************************
  

Problem conclusion

• Some data structures were getting corrupted due to which correct
  datatype could not be determined.
  Fixed the problem of data structures getting corrupted.
  

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:

Modules/Macros

• SYBASEEE
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP