search

assasafras / git_tutorial

Tutorial
0 stars 0 forks source link

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

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)
Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003](Error 8153)
The statement has been terminated. [SQLSTATE 01000](Error 3621). The step failed.

Issue

  1. NZReports Stored procedures not updated in UAT.
  2. Columns [DPReason] and [RAID] are too short in table NZReports.dbo.FLXCreditCheckEOM.

    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. [DPReason] changed from varchar(64) to varchar(256)
  5. [RAID] changed from varchar(12) to varchar(16)

Note: Steps 2 and 3 exst in a script called "K:\PMO\Projects\1180 - FCM 2008 Upgrade\3.Development\NZReports\Alter Table - FLXCreditCheckEOM.sql"

assasafras commented 8 years ago

Working in UAT