Showing posts with label occured. Show all posts
Showing posts with label occured. Show all posts

Tuesday, March 27, 2012

error 1813 with xp_cmdshell

Hi all,
I am trying to launch a xp_cmdshell from a stored procedure to execute a BCP
.
This error occured when my sp is called :
System.Web.HttpUnhandledException: Exception of type
System.Web.HttpUnhandledException was thrown. -->
System.Data.SqlClient.SqlException: A severe error occurred on the current
command.
The results, if any, should be discarded. xp_cmdshell failed to execute,
error 1813 occured while executing CreateProcessAsUserW.
I use SQLServer 2000 SP4 and a system account to launch the xp_cmdshell. The
SQL server agent log on with this same account.
Any idea?
I will appreciate any help.
Regards.
LGHi,
xp_cmdshell executes with the security contect of the SQL Agent Proxy
account when executed by non symin users. This requires you to allow
non-symin users to execute xp_cmdshell (uncheck the 'Only users with
symin privileges...' checkbox under SQL Server Agent properties --> Job
System) and specify a Windows account for the SQL Agent proxy with the
permissions needed to run you application).
See the below URL:-
http://support.microsoft.com/defaul...b;en-us;Q264155
Thanks
Hari
SQL Server MVP
"Laurent G" <LaurentG@.discussions.microsoft.com> wrote in message
news:13FBAEA9-A146-49E0-A42C-1B939CC3DA06@.microsoft.com...
> Hi all,
> I am trying to launch a xp_cmdshell from a stored procedure to execute a
> BCP.
> This error occured when my sp is called :
> System.Web.HttpUnhandledException: Exception of type
> System.Web.HttpUnhandledException was thrown. -->
> System.Data.SqlClient.SqlException: A severe error occurred on the current
> command.
> The results, if any, should be discarded. xp_cmdshell failed to execute,
> error 1813 occured while executing CreateProcessAsUserW.
> I use SQLServer 2000 SP4 and a system account to launch the xp_cmdshell.
> The
> SQL server agent log on with this same account.
> Any idea?
> I will appreciate any help.
> Regards.
> LG|||Thanks a lot Hari, it works now.
"Hari Pra" wrote:

> Hi,
> xp_cmdshell executes with the security contect of the SQL Agent Proxy
> account when executed by non symin users. This requires you to allow
> non-symin users to execute xp_cmdshell (uncheck the 'Only users with
> symin privileges...' checkbox under SQL Server Agent properties --> Job
> System) and specify a Windows account for the SQL Agent proxy with the
> permissions needed to run you application).
> See the below URL:-
> http://support.microsoft.com/defaul...b;en-us;Q264155
>
> Thanks
> Hari
> SQL Server MVP
> "Laurent G" <LaurentG@.discussions.microsoft.com> wrote in message
> news:13FBAEA9-A146-49E0-A42C-1B939CC3DA06@.microsoft.com...
>
>

Monday, March 26, 2012

Error 17805

We have an application that is using our SQL Server 2000 as a repository.
Occassionaly the application displays a "Severe Error Occured" message when
trying to execute a command against the DB.
The SQL Logs show "Error 17805 - Invalid buffer received from client" has
anyone any idea what this means?
We did not write the application so we have no way of knowing what it's
trying to do other than insert data into the database.
Thanks, for any help
BrianHi,
Normally this error occurs due to Network problems and are not critical at
all.
Please look in to the below link for more details;
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=0a0801c3
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0a0801c366
fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
Thanks
Hari
MCDBA
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
> We have an application that is using our SQL Server 2000 as a repository.
> Occassionaly the application displays a "Severe Error Occured" message
when
> trying to execute a command against the DB.
> The SQL Logs show "Error 17805 - Invalid buffer received from client" has
> anyone any idea what this means?
> We did not write the application so we have no way of knowing what it's
> trying to do other than insert data into the database.
> Thanks, for any help
> Brian
>|||Hari,
Thanks for the response, unfortunately I know the network is not the
problem, and whilst this is not causing any issues on the SQL DB, it is
critical as far as the application is concerned as it doesn't work :(
I have check MS KB and I have the latest SP installed, I have an identical
setup on another box and everything is working fine.
Any other clues?
Thanks again for your input
Brian
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Normally this error occurs due to Network problems and are not critical
at
> all.
> Please look in to the below link for more details;
>
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=0a0801c3
>
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
>
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0a0801c366
> fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
> Thanks
> Hari
> MCDBA
>
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
> > We have an application that is using our SQL Server 2000 as a
repository.
> > Occassionaly the application displays a "Severe Error Occured" message
> when
> > trying to execute a command against the DB.
> >
> > The SQL Logs show "Error 17805 - Invalid buffer received from client"
has
> > anyone any idea what this means?
> >
> > We did not write the application so we have no way of knowing what it's
> > trying to do other than insert data into the database.
> >
> > Thanks, for any help
> >
> > Brian
> >
> >
>|||Hi,
From the same machine, Did you tried connecting to SQL server using Query
Analyzer with TCP/IP as well as Named pipes seperately ?.
Thanks
Hari
MCDBA
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:#FFbR1l6DHA.2488@.TK2MSFTNGP09.phx.gbl...
> Hari,
> Thanks for the response, unfortunately I know the network is not the
> problem, and whilst this is not causing any issues on the SQL DB, it is
> critical as far as the application is concerned as it doesn't work :(
> I have check MS KB and I have the latest SP installed, I have an identical
> setup on another box and everything is working fine.
> Any other clues?
> Thanks again for your input
> Brian
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > Normally this error occurs due to Network problems and are not critical
> at
> > all.
> >
> > Please look in to the below link for more details;
> >
> >
>
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=0a0801c3
> >
>
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
> >
>
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0a0801c366
> > fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> > "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> > news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
> > > We have an application that is using our SQL Server 2000 as a
> repository.
> > > Occassionaly the application displays a "Severe Error Occured" message
> > when
> > > trying to execute a command against the DB.
> > >
> > > The SQL Logs show "Error 17805 - Invalid buffer received from client"
> has
> > > anyone any idea what this means?
> > >
> > > We did not write the application so we have no way of knowing what
it's
> > > trying to do other than insert data into the database.
> > >
> > > Thanks, for any help
> > >
> > > Brian
> > >
> > >
> >
> >
>|||I can connect to it just fine, the application that I am having trouble with
is located on a seperate server and, for the most part, has no trouble
connecting to the DB. It's just certain screens that fail with this error.
The SQL Server itself is serving many applications on our network connecting
via TCP and Named Pipes, it's just this one app that is giving us a problem.
I think it's time to get in touch with application vendor to find out what
sort of command it's trying to execute.
Thanks,
Brian
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:e2LqXLn6DHA.1752@.tk2msftngp13.phx.gbl...
> Hi,
> From the same machine, Did you tried connecting to SQL server using Query
> Analyzer with TCP/IP as well as Named pipes seperately ?.
> Thanks
> Hari
> MCDBA
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:#FFbR1l6DHA.2488@.TK2MSFTNGP09.phx.gbl...
> > Hari,
> >
> > Thanks for the response, unfortunately I know the network is not the
> > problem, and whilst this is not causing any issues on the SQL DB, it is
> > critical as far as the application is concerned as it doesn't work :(
> >
> > I have check MS KB and I have the latest SP installed, I have an
identical
> > setup on another box and everything is working fine.
> >
> > Any other clues?
> >
> > Thanks again for your input
> >
> > Brian
> >
> >
> > "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> > news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > >
> > > Normally this error occurs due to Network problems and are not
critical
> > at
> > > all.
> > >
> > > Please look in to the below link for more details;
> > >
> > >
> >
>
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=0a0801c3
> > >
> >
>
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
> > >
> >
>
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0a0801c366
> > > fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > >
> > > "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> > > news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
> > > > We have an application that is using our SQL Server 2000 as a
> > repository.
> > > > Occassionaly the application displays a "Severe Error Occured"
message
> > > when
> > > > trying to execute a command against the DB.
> > > >
> > > > The SQL Logs show "Error 17805 - Invalid buffer received from
client"
> > has
> > > > anyone any idea what this means?
> > > >
> > > > We did not write the application so we have no way of knowing what
> it's
> > > > trying to do other than insert data into the database.
> > > >
> > > > Thanks, for any help
> > > >
> > > > Brian
> > > >
> > > >
> > >
> > >
> >
> >
>

Error 17805

We have an application that is using our SQL Server 2000 as a repository.
Occassionaly the application displays a "Severe Error Occured" message when
trying to execute a command against the DB.
The SQL Logs show "Error 17805 - Invalid buffer received from client" has
anyone any idea what this means?
We did not write the application so we have no way of knowing what it's
trying to do other than insert data into the database.
Thanks, for any help
BrianHi,
Normally this error occurs due to Network problems and are not critical at
all.
Please look in to the below link for more details;
http://groups.google.com/groups?hl=...hreadm=0a0801c3
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUT
F-8%26oe%3DUTF-8%26selm%3D0a0801c366
fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
Thanks
Hari
MCDBA
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
quote:

> We have an application that is using our SQL Server 2000 as a repository.
> Occassionaly the application displays a "Severe Error Occured" message

when
quote:

> trying to execute a command against the DB.
> The SQL Logs show "Error 17805 - Invalid buffer received from client" has
> anyone any idea what this means?
> We did not write the application so we have no way of knowing what it's
> trying to do other than insert data into the database.
> Thanks, for any help
> Brian
>
|||Hari,
Thanks for the response, unfortunately I know the network is not the
problem, and whilst this is not causing any issues on the SQL DB, it is
critical as far as the application is concerned as it doesn't work
I have check MS KB and I have the latest SP installed, I have an identical
setup on another box and everything is working fine.
Any other clues?
Thanks again for your input
Brian
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
quote:

> Hi,
> Normally this error occurs due to Network problems and are not critical

at
quote:

> all.
> Please look in to the below link for more details;
>

http://groups.google.com/groups?hl=...hreadm=0a0801c3
quote:

>

66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/ groups%3Fq%3D17805%2Bin%2B
quote:
darkred">
>

sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUT
F-8%26oe%3DUTF- 8%26selm%3D0a0801c366
quote:
ed">
> fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
> Thanks
> Hari
> MCDBA
>
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
repository.[QUOTE]
> when
has[QUOTE]
>
|||Hi,
From the same machine, Did you tried connecting to SQL server using Query
Analyzer with TCP/IP as well as Named pipes seperately ?.
Thanks
Hari
MCDBA
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:#FFbR1l6DHA.2488@.TK2MSFTNGP09.phx.gbl...
quote:

> Hari,
> Thanks for the response, unfortunately I know the network is not the
> problem, and whilst this is not causing any issues on the SQL DB, it is
> critical as far as the application is concerned as it doesn't work
> I have check MS KB and I have the latest SP installed, I have an identical
> setup on another box and everything is working fine.
> Any other clues?
> Thanks again for your input
> Brian
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
> at
>

http://groups.google.com/groups?hl=...hreadm=0a0801c3
quote:

>

66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/ groups%3Fq%3D17805%2Bin%2B
quote:
darkred">
>

sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUT
F-8%26oe%3DUTF- 8%26selm%3D0a0801c366
quote:
ed">
> repository.
> has
it's[QUOTE]
>
|||I can connect to it just fine, the application that I am having trouble with
is located on a seperate server and, for the most part, has no trouble
connecting to the DB. It's just certain screens that fail with this error.
The SQL Server itself is serving many applications on our network connecting
via TCP and Named Pipes, it's just this one app that is giving us a problem.
I think it's time to get in touch with application vendor to find out what
sort of command it's trying to execute.
Thanks,
Brian
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:e2LqXLn6DHA.1752@.tk2msftngp13.phx.gbl...
quote:

> Hi,
> From the same machine, Did you tried connecting to SQL server using Query
> Analyzer with TCP/IP as well as Named pipes seperately ?.
> Thanks
> Hari
> MCDBA
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:#FFbR1l6DHA.2488@.TK2MSFTNGP09.phx.gbl...
identical[QUOTE]
critical[QUOTE]
>

http://groups.google.com/groups?hl=...hreadm=0a0801c3
quote:

>

66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/ groups%3Fq%3D17805%2Bin%2B
quote:
darkred">
>

sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUT
F-8%26oe%3DUTF- 8%26selm%3D0a0801c366
quote:
ed">
message[QUOTE]
client"[QUOTE]
> it's
>

Friday, February 17, 2012

Error

I am getting the following error

"An error occured during local report processing.Error during processing of 'Validate' report parameter "

Any idea about this error

Do u have any default values or available values for your 'Validate' parameter? If yes, can u give the details?

Shyam

|||

Yes I have default values.That value depends on user selection.If the date difference is less than 15 days.Script will be raised(That I have written using custom code).

|||

can u pls type the whole custom code you have written and then the expression you have used for the default value of the parameter?

Shyam

|||

CUSTOM CODE:

Function CheckSignificantDate(i as integer) as Integer
Dim msg as String

msg = ""
If ( i = 15 ) Then
msg=" Date Diff should be more than 15 Days"
End If

If msg <> "" Then
MsgBox(msg, 16, "Report Validation")
Err.Raise(6,Report) 'Raise an overflow
End If
End Function

EXPRESSION:

=CODE.CheckSignificantDate(DateDiff(DateInterval.Day,Parameters!ToDate.Value,Parameters!FromDate.Value,))

Here I am facing one more problem.In custom code if I take condition (i < 15), for each value script is raising.(i.e for every number.ex: 1,24,33,67..... )

|||

why is that extra comma at the end of your expression (marked in red below)

CODE.CheckSignificantDate(DateDiff(DateInterval.Day,Parameters!ToDate.Value,Parameters!FromDate.Value,))

You are calling the code for all values, so better check the date differentce in the expression itself (using IIf function) and then call the code.

Shyam

|||

Could please help me how to call that function using IIF condition.I can't able to do.

|||

IIf(DateDiff(DateInterval.Day,Parameters!ToDate.Value,Parameters!FromDate.Value) < 15, CODE.CheckSignificantDate(DateDiff(DateInterval.Day,Parameters!ToDate.Value,Parameters!FromDate.Value)), 0)

Shyam

|||

But still I am getting the same problem.

|||

Thanks Shyam I got the solution

|||

Dates problem was solved.After generation of script I am getting the following error.

"An error occured during local report processing.Error during processing of 'Validate' report parameter "