January 16, 2013 at 2:37 pm
I am using SQL 2008 server and an external vendor changed the particular warehouse name for the IMPORT file that I was receiving through my SQL server from them. I get an error under the SQL Server Agent stating the IMPORTFROMXXX has failed. When I open the Job that is running notice that the warehouse name under the import file script is incorrect when I change it to the new name it still fails. How do I go about correcting this? Is there same place I should be typing credentials somewhere within my SQL server so the warehouse date outside my network know who I am?
I have attached some screen shots of my issue.
Thank you,
January 16, 2013 at 2:42 pm
miles411 (1/16/2013)
I am using SQL 2008 server and an external vendor changed the particular warehouse name for the IMPORT file that I was receiving through my SQL server from them. I get an error under the SQL Server Agent stating the IMPORTFROMXXX has failed. When I open the Job that is running notice that the warehouse name under the import file script is incorrect when I change it to the new name it still fails. How do I go about correcting this? Is there same place I should be typing credentials somewhere within my SQL server so the warehouse date outside my network know who I am?I have attached some screen shots of my issue.
Thank you,
Need a bit more information here to offer any help. Let's start with the error message. What does it say?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 16, 2013 at 2:50 pm
It states:
Job failed.
I attached 2 screen shots to my last e-mail that I got form my SQL server.
I have attached them again here.
January 16, 2013 at 3:07 pm
You are going to have to provide some details. We can't see your screen and we have no idea what this is doing. You said something about the file name has changed. How do you have the job setup? Is the filename hardcoded? Is it in the DB somewhere?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 16, 2013 at 3:09 pm
If you open the Job History for this job it will show you the step details. Go to the step that failed and look at the error message.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 16, 2013 at 3:11 pm
Our outside vendor changed the name the of what the database warehouse was called recently and since then my users with Access that is link to our internal SQL database cannot pull the required information. I believe the name is embedded under the step dialogue box. It is a Transact-SQL script (T-SQL) type step. Under the command box is state drop table select*into XXX_XX_XXXXXX from XXX_XXXX_XXview.dbo.wh_employees.
January 16, 2013 at 3:13 pm
It stated: "Quit the job reporting failure"
January 16, 2013 at 3:14 pm
It quits the import phase of the process. It fails at that step.
January 16, 2013 at 3:18 pm
miles411 (1/16/2013)
Our outside vendor changed the name the of what the database warehouse was called recently and since then my users with Access that is link to our internal SQL database cannot pull the required information. I believe the name is embedded under the step dialogue box. It is a Transact-SQL script (T-SQL) type step. Under the command box is state drop table select*into XXX_XX_XXXXXX from XXX_XXXX_XXview.dbo.wh_employees.
Can you change it to the correct name?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 16, 2013 at 3:20 pm
miles411 (1/16/2013)
It stated: "Quit the job reporting failure"
It actually will also say "See the Job History for details". As I said previously you need open the job history so you can see what the error message says. Without that information there is way anybody knows where to begin.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 16, 2013 at 3:21 pm
This is the detailed error:
Date1/16/2013 4:00:00 PM
LogJob History (ImportFromITDWH)
Step ID1
ServerWSDSQL
Job NameImportFromITDWH
Step NameImport
Duration00:00:00
Sql Severity11
Sql Message ID7202
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: NT AUTHORITY\NETWORK SERVICE. Could not find server 'ciw_prod' 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. [SQLSTATE 42000] (Error 7202). The step failed.
January 16, 2013 at 3:22 pm
Here is the detailed error message:
Date1/16/2013 4:00:00 PM
LogJob History (ImportFromITDWH)
Step ID1
ServerWSDSQL
Job NameImportFromITDWH
Step NameImport
Duration00:00:00
Sql Severity11
Sql Message ID7202
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: NT AUTHORITY\NETWORK SERVICE. Could not find server 'ciw_prod' 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. [SQLSTATE 42000] (Error 7202). The step failed.
January 16, 2013 at 3:24 pm
It seems you don't have a linkserver named "ciw_prod" in your system. Did the name of the link server change? Was it deleted?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 16, 2013 at 3:27 pm
The server name did change from something else to the the name "ciw_prod" I made the change in the step file and it still failed.
January 16, 2013 at 3:28 pm
Should I make the change somewhere else other than the import file embedded command name.
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply