search

assasafras / git_tutorial

Tutorial
0 stars 0 forks source link

Job Failed: NZReports - Daily (3am) | Step 5 | TRL Daily Dishonours #6

Closed assasafras closed 8 years ago

assasafras commented 8 years ago

Job Details

Job Name: NZReports - Daily (3am) Job Step Name: TRL Daily Dishonours

Error Message

Executed as user: FLEXIRENT\syssqlint02. Statement(s) could not be prepared. [SQLSTATE 42000](Error 8180) Could not use view or function 'ReportScripts.dbo.TRLDailyDishonours' because of binding errors. [SQLSTATE 42000](Error 4413) Could not find server 'PRODAKL006P' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. [SQLSTATE 42000](Error 7202). The step failed.

assasafras commented 8 years ago

Think this is an issue with the linked server that has been set up even though it appearss to be pointing to the right thing.

assasafras commented 8 years ago

Apperently it was a bad linked server.

assasafras commented 8 years ago

Getting issues in UAT...

Message

Executed as user: FLEXIRENT\syssqlint02. Procedure sp_TRLSendDailyDishonours has no parameters and arguments were supplied. [SQLSTATE 42000](Error 8146). The step failed.

Issue

NZReports Stored procedures not updated in UAT.

Solution

  1. Updated sp_TRLSendDailyDishonours.sql script to accept two parameters (@recip and @profile) in "K:\PMO\Projects\1180 - FCM 2008 Upgrade\4. Deployment\Stored Procedures & Views\PRODAKL006P\NZReports".
  2. 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).
assasafras commented 8 years ago

This is working now in UAT.

assasafras commented 8 years ago

This Job was dropped from the 3am Job as it is in the 8pm job and is for the current day so makes no snese running it at 3am.