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...
>> 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
>
>.
>|||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...
> 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...
> >> 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
> >
> >
> >.
> >|||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...
>> 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...
>> >> 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
>> >
>> >
>> >.
>> >
>
>.
>|||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...
> 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...
> >> 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...
> >> >> 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
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||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?
>--Original Message--
>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...
>> 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...
>> >> 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...
>> >> >> 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
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>|||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...
> 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?
>
> >--Original Message--
> >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...
> >> 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...
> >> >> 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...
> >> >> >> 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
> >> >> >
> >> >> >
> >> >> >.
> >> >> >
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

No comments:

Post a Comment