Executed as user: FLEXIRENT\syssqlint02.
String or binary data would be truncated. [SQLSTATE 22001](Error 8152) The statement has been terminated. [SQLSTATE 01000](Error 3621). The step failed.
Issue
NZReports Stored procedures not updated in UAT.
Columns [CCDPReason] and ProductType are too short.
Solution
Ran scripts in "K:\PMO\Projects\1180 - FCM 2008 Upgrade\4. Deployment\Stored Procedures & Views\PRODAKL006P\NZReports" against INTGAKL006v (UAT's current Bullwinkle SQL Server).
[CCDPReason] changed from varchar(64) to varchar(256)
[ProductType] changed from varchar(64) to varchar(128)
Note: Steps 2 and 3 exst in a script called "K:\PMO\Projects\1180 - FCM 2008 Upgrade\3.Development\NZReports\Alter Table - FLXRAEOMCont.sql"
Message
Executed as user: FLEXIRENT\syssqlint02. String or binary data would be truncated. [SQLSTATE 22001](Error 8152) The statement has been terminated. [SQLSTATE 01000](Error 3621). The step failed.
Issue
Solution
Note: Steps 2 and 3 exst in a script called "K:\PMO\Projects\1180 - FCM 2008 Upgrade\3.Development\NZReports\Alter Table - FLXRAEOMCont.sql"