JR57012: Connectivity Plugin Infrastructure generates a conversion warning while handling a timestamp datatype

APAR status

• Closed as program error.

Error description

• The following warning can be seen for a timestamp field if the
  input to this timestamp column doesn't contain a time
  information(like "YYYY-MM-DD') :
  Attempt to convert String value "" to Timestamp type
  unsuccessful
  

Local fix

• Generate an input data in a format like "YYYY-MM-DD HH:MM:SS"
  for timestamp fields.
  

Problem summary

• Connectors on server canvas generates a conversion warning while
   handling a timestamp datatype.
  
  The following warning was seen for a timestamp field if the
  input to this timestamp column doesn't contain a time
  information(like "YYYY-MM-DD') :
  Attempt to convert String value "" to Timestamp type
  unsuccessful
  

Problem conclusion

• Made the required code changes in server connector framework to
  handle the date format for timestamp columns correctly
  

Temporary fix

• Change the i/p date format to "YYYY-MM-DD HH:MI:SS" to resolve
  the issue
  

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

• RB50 PSY

     UP