JR60940: HANDLE IDENTITY COLUMNS WHEN USING LOAD FUNCTIONALITY IN SNOWFLAKE CONNECTOR.

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

APAR status

• Closed as program error.

Error description

• "net.snowflake.client.jdbc.SnowflakeSQLException: Number of
  columns in file (2) does not match that of the corresponding
  table (3), use file format option
  error_on_column_count_mismatch=false to ignore this error
    File 'loadfile_0_1551113164352.txt.gz', line 2, character 1
    Row 1 starts at line 1, column "MYTABLE"["C2":2]
  

Local fix

• As a workaround ,asked to use Writemode = Insert for this case
  instead of Load from file.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Datastage jobs which use Snowflake connector in target context.
  ****************************************************************
  PROBLEM DESCRIPTION:
  If a table has identity column and if that column is not
  specified in the Job design then LOAD functionality fails.
  ****************************************************************
  RECOMMENDATION:
  Apply patch JR60940
  ****************************************************************
  

Problem conclusion

• Fixed code to make LOAD functionality work even if identity
  columns are not specified in the job design, this is done by
  executing the COPY command with a select statement that contains
   columns defined in the job.
  

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

• RB70 PSY

     UP

• RB71 PSY

     UP