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 number
JR32220
Reported component name
INFO SRVR PLATF
Reported component ID
5724Q3612
Reported release
810
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-03-02
Closed date
2009-03-17
Last modified date
2009-12-15
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 December 2009