May 30, 2013 at 10:54 am
Looking at another server that is runnig the same script and the error it is getting is "COUNT field incorrect or syntax error [SQLSTATE 07002] (Error 0). The step failed". Keep in mind these were working a few months ago, just started getting errors. Very strange.
May 31, 2013 at 3:43 am
Brian Seib (5/30/2013)
Looking at another server that is runnig the same script and the error it is getting is "COUNT field incorrect or syntax error [SQLSTATE 07002] (Error 0). The step failed". Keep in mind these were working a few months ago, just started getting errors. Very strange.
Error: 07002 Number of columns does not match number of host variables.
http://msdn.microsoft.com/en-us/library/aa176407%28v=sql.80%29.aspx
Have a look how many columns you selected for an insert.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 10, 2013 at 2:36 pm
Very strange - so I am was looking at one of the servers that this is running on and failing - and after looking through the history is turns out that somedays it works and other days it does not. So that pretty much takes any syntax issues out of the running. So this apparently is requesting information that is hanging some days?. I do not fully understand what the query is doing step by step, but it apparenly relies on the information on the database as it i works one hay and not the other, without my naking any changes to the database. Any ideas?
June 18, 2013 at 6:55 am
Brian Seib (6/10/2013)
Very strange - so I am was looking at one of the servers that this is running on and failing - and after looking through the history is turns out that somedays it works and other days it does not. So that pretty much takes any syntax issues out of the running. So this apparently is requesting information that is hanging some days?. I do not fully understand what the query is doing step by step, but it apparenly relies on the information on the database as it i works one hay and not the other, without my naking any changes to the database. Any ideas?
I suggest you to do an error handling (Just insert an error into another table) and find out what it's.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
May 9, 2016 at 1:31 pm
Thanks for the script.
Viewing 5 posts - 46 through 49 (of 49 total)
You must be logged in to reply to this topic. Login to reply