JR45487: Teradata Connector - read job fails with Framework returned error for conversion from string to calendar.

IBM InfoSphere Information Server, Version 9.1.2

APAR status

• Closed as program error.

Error description

• A DataStage job contains Teradata stage which maps a string
  value to timestamp, and the job ran ok.
  After using the Connector Migration Tool to convert the
  Teradata stage to a Teradata Connector stage, the job fails with
  error:
  Framework returned error for conversion from string to calendar:
  Inappropriate type code for field
  Since the stage has setup the Timestamp field as a string in the
  design schema, the Teradata Connector stage behaved as it was
  designed by throwing a conversion error.  However, since both
  the string and calendar data (date, time, and timestamp) are
  known formats they can be converted from one form to another
  with a code change to the Teradata Connector and Server
  framework to implement that functionality.
  

Local fix

Problem summary

• Teradata Connector - read job fails with Framework returned
  error for conversion from string to calendar.
  

Problem conclusion

• The Customer is treating Timestamp field as string in his design
  schema. So, the TDCC is behaving as expected by throwing a
  conversion error.
  

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

• R850 PSY

     UP

• R870 PSY

     UP

• R910 PSY

     UP