search

assasafras / git_tutorial

Tutorial
0 stars 0 forks source link

Job Failed: NZReports - EOM - Monthly 1st (4am) | Step 1 | Update FLXRAEOMAppr records #37

Closed assasafras closed 8 years ago

assasafras commented 8 years ago

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

  1. NZReports Stored procedures not updated in UAT.
  2. Columns [CCDPReason] and ProductType are too short.

    Solution

  3. 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).
  4. [CCDPReason] changed from varchar(64) to varchar(256)
  5. [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 - FLXRAEOMAppr.sql"

assasafras commented 8 years ago

Working in UAT