JR30336: JOB ABORTS WHEN ~ LAST CHAR OF VARCHAR FIELD

APAR status

• Closed as program error.

Error description

• Job aborts when ~ is the last char in a VarChar column
  

Local fix

• change field to NVarChar
  
  This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DSR ODBC stage on IS 801 and  IS 801 fixed pack1 Redhat
  ****************************************************************
  PROBLEM DESCRIPTION:
  Job intermittely aborts when running with DRS ODBC stage on IS
  801 fix pack1 on RedHat linux. Job is connecting to MSSQL
  server using DRS ODBC stage. Job aborts
  Program "JOB.1726307290.DT.1477854031.TRANS1": Line 334,
  Exception raised in GCI subroutine:
  Access violation.
  Attempting to Cleanup after ABORT raised in stage
  PMR87483L6Q000_no_sort..xfmChange
  DataStage Phantom Aborting with @ABORT.CODE = 3
  
  ****************************************************************
  RECOMMENDATION:
  install patch patch_JR30336_server_redhat.tar
  
  ****************************************************************
  

Problem conclusion

• Memory allocation issue.  missing assignment
  

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

• DRS
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSN

     UP