Wednesday, March 21, 2012

Error: 17968, Severity: 15, State: 1

I am running a job every night. It runs fine until last
saturday. In job we are executing 25 stored procedures.
We are getting error after running 12 procedures and
gives error -- "Line 1: Incorrect syntax near '>'.
[SQLSTATE 42000] (Error 170). The step failed". Actually
There is no syntax error. When I checked error log it
shows -- "Operating system error 170., Line 1: Incorrect
syntax near '>'.2004-08-23 20:33:07.27 logon Login
succeeded for user 'US\dashbrd'. Connection: Trusted.
Error encountered while executing xp_sendmail @.query..
Error: 17968, Severity: 15, State: 1 ".
We are running job again starting with stored procedure
12. It is running fine. I don't understand why it
happens? Can any one help melittle tip , when you Operating System Error x , type NET HELPMSG x to see
what it corresponds to , sometimes a valuable clue to whats going on
ie NET HELPMSG 170 gives you "the requested resource was in use"
Andy.
"kishore" <anonymous@.discussions.microsoft.com> wrote in message
news:10d201c48bd5$fa04a5c0$a301280a@.phx.gbl...
> I am running a job every night. It runs fine until last
> saturday. In job we are executing 25 stored procedures.
> We are getting error after running 12 procedures and
> gives error -- "Line 1: Incorrect syntax near '>'.
> [SQLSTATE 42000] (Error 170). The step failed". Actually
> There is no syntax error. When I checked error log it
> shows -- "Operating system error 170., Line 1: Incorrect
> syntax near '>'.2004-08-23 20:33:07.27 logon Login
> succeeded for user 'US\dashbrd'. Connection: Trusted.
> Error encountered while executing xp_sendmail @.query..
> Error: 17968, Severity: 15, State: 1 ".
> We are running job again starting with stored procedure
> 12. It is running fine. I don't understand why it
> happens? Can any one help me|||In error it shows error occured during xp_Sendmail, but
we are not sending any message at that time. Why it
looking for xp_sendmail?In stored procedure we are
updating temp table and deleting temp table after
inserting data into original table. Is while deleting
temp table causes this problem?
>--Original Message--
>little tip , when you Operating System Error x , type
NET HELPMSG x to see
>what it corresponds to , sometimes a valuable clue to
whats going on
>ie NET HELPMSG 170 gives you "the requested resource was
in use"
>Andy.
>"kishore" <anonymous@.discussions.microsoft.com> wrote in
message
>news:10d201c48bd5$fa04a5c0$a301280a@.phx.gbl...
Actually[vbcol=seagreen]
Incorrect[vbcol=seagreen]
>
>.
>|||check to see if there are any triggers on the tables being updated.
Andy.
"kishore" <anonymous@.discussions.microsoft.com> wrote in message
news:09cd01c48c3b$01e37720$a401280a@.phx.gbl...[vbcol=seagreen]
> In error it shows error occured during xp_Sendmail, but
> we are not sending any message at that time. Why it
> looking for xp_sendmail?In stored procedure we are
> updating temp table and deleting temp table after
> inserting data into original table. Is while deleting
> temp table causes this problem?
> NET HELPMSG x to see
> whats going on
> in use"
> message
> Actually
> Incorrect|||No triggers are firing. Up to last week it ran fine.

>--Original Message--
>check to see if there are any triggers on the tables
being updated.
>Andy.
>"kishore" <anonymous@.discussions.microsoft.com> wrote in
message
>news:09cd01c48c3b$01e37720$a401280a@.phx.gbl...
was[vbcol=seagreen]
in[vbcol=seagreen]
last[vbcol=seagreen]
procedures.[vbcol=seagreen]
it[vbcol=seagreen]
Login[vbcol=seagreen]
Trusted.[vbcol=seagreen]
@.query..[vbcol=seagreen]
procedure[vbcol=seagreen]
>
>.
>|||Hi
You may want to try profiling this and see what is being sent to the server.
It sounds as if it could be an unescaped quote type of problem' Is there
any dynamic SQL being used?
John
"kishore" <anonymous@.discussions.microsoft.com> wrote in message
news:1c0f01c48cfb$58107510$a601280a@.phx.gbl...[vbcol=seagreen]
> No triggers are firing. Up to last week it ran fine.
>
> being updated.
> message
> was
> in
> last
> procedures.
> it
> Login
> Trusted.
> @.query..
> procedure|||Hi
I can't really suggest any more except maybe dropping and recreating all the
procedures and the job.
John
"kishore" <anonymous@.discussions.microsoft.com> wrote in message
news:093a01c48ea5$487d3650$a401280a@.phx.gbl...[vbcol=seagreen]
> Created a trace file using profiler. It doesn't help me.
> There is no dynamic sql. In profiler it shows stored
> procedure is completed successfully. After completing the
> stored proc,it sending message as step is failed. Since
> step fails, it doesn't go to the next step.I don't
> understand what is the cause for this error?
>
> sent to the server.
> problem' Is there
> message
> in
> but
> deleting
> type
> to
> resource
> wrote
> until
> and
> near '>'.
> log

No comments:

Post a Comment