search

assasafras / git_tutorial

Tutorial
0 stars 0 forks source link

Job Failed: Collections - Daily (7am) - Generate Collections PPSRUploadFiles #8

Closed assasafras closed 8 years ago

assasafras commented 8 years ago

Details

Date: 29/09/2016 2:43:24 p.m. Log: Job History (Collections - Daily (7am)) Step ID: 7 Server: INTGAKL006V Job Name: Collections - Daily (7am) Step Name: Generate Collections PPSRUploadFiles

Message

Executed as user: FLEXIRENT\syssqlint02. Microsoft (R) SQL Server Execute Package Utility Version 10.0.6000.29 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 2:43:24 p.m. Error: 2016-09-29 14:43:24.87
Code: 0xC002F210
Source: Insert FCM Notes Execute SQL Task
Description: Executing the query " insert into FCM15.dbo.Notes (SPNoteCategoryId, Us..." failed with the following error: "Could not find server 'prodakl006p' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 2:43:24 p.m.
Finished: 2:43:25 p.m.
Elapsed: 0.827 seconds.
The package execution failed. The step failed.

assasafras commented 8 years ago

Issue

References found in script to "PRODAKL006P"

Solution

Renamed references to "PRODAKL006P" to "Bullwinkle"

assasafras commented 8 years ago

New Issue

Message

Executed as user: FLEXIRENT\syssqlint02. Microsoft (R) SQL Server Execute Package Utility Version 10.0.6000.29 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 4:56:39 p.m.
Error: 2016-09-29 16:56:39.71
Code: 0xC002F210
Source: Insert FCM Notes Execute SQL Task
Description: Executing the query " insert into FCM15.dbo.Notes (SPNoteCategoryId, Us..." failed with the following error: "Invalid object name 'Bullwinkle.dbo.flxUDC'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 4:56:39 p.m.
Finished: 4:56:39 p.m.
Elapsed: 0.718 seconds. The package execution failed. The step failed.

assasafras commented 8 years ago

Solution

Added Bullwinkle.Bullwinkle.dbo.flxUDC instead of just Bullwinkle.dbo.flxUDC