JR32220: NEED ECASE 117458 TO BE PROPAGATED TO IS 8.1

APAR status

• Closed as unreproducible in next release.

Error description

• Using SQL Server Enterprise stage with write option & with
  append mode sometimes results in the following error message:
  
  "Restricted data type attribute violation"
  
  This problem is caused by transformer stages or other similar
  stages that rearrange the column order before sending data to
  the SQL Server stage.
  
  This APAR opened to propagated fix 117458 to IS 8.1
  

Local fix

• Use Server SQL Plugin as a possible work around.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  MS SQL Server operator write stages with upstream transformer
  stage.
  ****************************************************************
  PROBLEM DESCRIPTION:
  MS SQL Server receiving rearranged columns causes a failure.
  ****************************************************************
  RECOMMENDATION:
  Apply this patch to obtain the fix.
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• Already fixed in 117458. This APAR opened to propagate to IS
  8.1.
  

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

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• R810 PSN

     UP