job_id not found

Hi
I am getting a wierd message when I click on the SnapShot Agent.
Error 14262, The Specified @.job_id (###) does not exist
any idea what could have caused this and what I can do to resolve this
thanks
P
Has someone deleted the job using the management folder in EM? Have a look
in the jobs subfolder and see if the snapshot job has been removed or not.
If it has, then the easiest solution is to set up the publication once
again.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Job Step of more than 3200 characters

Hi,
An ActiveX script has 42318 characters in a vbs file. We are trying to use this .vbs file as a job step. We get this error message:
--
Edit Job Step - 192.168.1.75\TrialJob
--
The specified file ('mailscripts\send_auto_con.vbs'), is 42318 characters in size, which is larger than the available free space in the current Job Step command (3200 characters).
Do you want to continue opening this file but have its contents truncated.
--
Yes No
--
Can we execute the vbs file as such? Can somebody help us with this issue. Thanks in advance.
regards,
MadhuTry executing the vbs file using CScript and a CmdExec job
step instead.
-Sue
On Tue, 18 Nov 2003 03:16:08 -0800, "Madhu"
<anonymous@.discussions.microsoft.com> wrote:
>Hi,
>An ActiveX script has 42318 characters in a vbs file. We are trying to use this .vbs file as a job step. We get this error message:
>--
>Edit Job Step - 192.168.1.75\TrialJob
>--
>The specified file ('mailscripts\send_auto_con.vbs'), is 42318 characters in size, which is larger than the available free space in the current Job Step command (3200 characters).
>Do you want to continue opening this file but have its contents truncated.
>--
>Yes No
>--
>Can we execute the vbs file as such? Can somebody help us with this issue. Thanks in advance.
>regards,
>Madhu|||Hi Sue,
Thanks for the information, could you please elaborate on how we could
achieve this? May be a code snippet or something that would help us.
Thanks in advance,
Madhu
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:9ebkrvool9ie3lq2gtmksanndfsd31u16f@.4ax.com...
> Try executing the vbs file using CScript and a CmdExec job
> step instead.
> -Sue
> On Tue, 18 Nov 2003 03:16:08 -0800, "Madhu"
> <anonymous@.discussions.microsoft.com> wrote:
> >Hi,
> >
> >An ActiveX script has 42318 characters in a vbs file. We are trying to
use this .vbs file as a job step. We get this error message:
> >
> >--
> >Edit Job Step - 192.168.1.75\TrialJob
> >--
> >The specified file ('mailscripts\send_auto_con.vbs'), is 42318 characters
in size, which is larger than the available free space in the current Job
Step command (3200 characters).
> >Do you want to continue opening this file but have its contents
truncated.
> >--
> >Yes No
> >--
> >
> >Can we execute the vbs file as such? Can somebody help us with this
issue. Thanks in advance.
> >
> >regards,
> >
> >Madhu
>|||In a CmdExec step:
CScript.exe /NOLOGO C:\Scripts\YourVBScript.vbs
-Sue
On Tue, 18 Nov 2003 21:09:11 +0530, "Madhu"
<anonymous@.discussions.microsoft.com> wrote:
>Hi Sue,
>Thanks for the information, could you please elaborate on how we could
>achieve this? May be a code snippet or something that would help us.
>Thanks in advance,
>Madhu
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:9ebkrvool9ie3lq2gtmksanndfsd31u16f@.4ax.com...
>> Try executing the vbs file using CScript and a CmdExec job
>> step instead.
>> -Sue
>> On Tue, 18 Nov 2003 03:16:08 -0800, "Madhu"
>> <anonymous@.discussions.microsoft.com> wrote:
>> >Hi,
>> >
>> >An ActiveX script has 42318 characters in a vbs file. We are trying to
>use this .vbs file as a job step. We get this error message:
>> >
>> >--
>> >Edit Job Step - 192.168.1.75\TrialJob
>> >--
>> >The specified file ('mailscripts\send_auto_con.vbs'), is 42318 characters
>in size, which is larger than the available free space in the current Job
>Step command (3200 characters).
>> >Do you want to continue opening this file but have its contents
>truncated.
>> >--
>> >Yes No
>> >--
>> >
>> >Can we execute the vbs file as such? Can somebody help us with this
>issue. Thanks in advance.
>> >
>> >regards,
>> >
>> >Madhu
>|||Thanks Sue,
It worked fine. Thanks for your help.
Regards,
Madhu
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1efkrv8mqqpch05hnp4arl0gbl3gu00fnf@.4ax.com...
> In a CmdExec step:
> CScript.exe /NOLOGO C:\Scripts\YourVBScript.vbs
> -Sue
> On Tue, 18 Nov 2003 21:09:11 +0530, "Madhu"
> <anonymous@.discussions.microsoft.com> wrote:
> >Hi Sue,
> >
> >Thanks for the information, could you please elaborate on how we could
> >achieve this? May be a code snippet or something that would help us.
> >
> >Thanks in advance,
> >
> >Madhu
> >
> >"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> >news:9ebkrvool9ie3lq2gtmksanndfsd31u16f@.4ax.com...
> >> Try executing the vbs file using CScript and a CmdExec job
> >> step instead.
> >>
> >> -Sue
> >>
> >> On Tue, 18 Nov 2003 03:16:08 -0800, "Madhu"
> >> <anonymous@.discussions.microsoft.com> wrote:
> >>
> >> >Hi,
> >> >
> >> >An ActiveX script has 42318 characters in a vbs file. We are trying to
> >use this .vbs file as a job step. We get this error message:
> >> >
> >> >--
> >> >Edit Job Step - 192.168.1.75\TrialJob
> >> >--
> >> >The specified file ('mailscripts\send_auto_con.vbs'), is 42318
characters
> >in size, which is larger than the available free space in the current Job
> >Step command (3200 characters).
> >> >Do you want to continue opening this file but have its contents
> >truncated.
> >> >--
> >> >Yes No
> >> >--
> >> >
> >> >Can we execute the vbs file as such? Can somebody help us with this
> >issue. Thanks in advance.
> >> >
> >> >regards,
> >> >
> >> >Madhu
> >>
> >
>

Job step fails with Error 7399 and 7312

We have a job that intermittently fails on the same step with the same error.
Identical jobs that run before this one always succeed. The step uses the
following T-SQL to update a table on a linked server:
DBCC TRACEON (7300, 3604)
INSERT INTO <linkedservername>.ods.dbo.[!ODSReplicationTimes ]
([Date], Imports, Div)
VALUES (dbo.DateOnly(DATEADD(hh, 7, GETDATE())), GETDATE(), 'wbd')
if the job fails, it is exactly the default timeout of 10 minutes after the
start time, and results in this error:
Executed as user: <username>. OLE DB provider 'SQLOLEDB' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error
trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow returned
0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.
on failure, this step proceeds to a similar step which calls a sproc:
DBCC TRACEON (7300, 3604)
CheckFutureStatus 'JobName Finish','!Check Status WBD',240,240,3,'wbd'
yielding a similar result:
Executed as user: <username>. OLE DB provider 'SQLOLEDB' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error
trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::SetData returned 0x80004005:
]. [SQLSTATE 01000] (Error 7300). The step failed.
I've set the step to retry 3 times/5 minutes to no avail. the traceon
doesn't give any additional information.
Any ideas?
Hello
Did you try to perform a SQL Profiler trace on the server that you have
configured as the linked server to see what happens on that server. I'm
assuming that the query should finish within the 10 minute timeout period.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||What Events/Data would you want to see. anything in particular for this
situation?
"Pankaj Agarwal [MSFT]" wrote:

> Hello
> Did you try to perform a SQL Profiler trace on the server that you have
> configured as the linked server to see what happens on that server. I'm
> assuming that the query should finish within the 10 minute timeout period.
> Thank you for using Microsoft newsgroups.
> Sincerely
> Pankaj Agarwal
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
|||I think it would be beneficial to capture the Execution Statistics, Stored
Procedure and TSQL related events. Also capture SP Recompile, Database File
Autogrow. This would give you at least a starting point to see what event
is the query stuck on. I would also download the blocker script from the
following KB article and run that to see if there is any blocking when the
query does not complete during the 10 min timeout interval.
271509 INF: How to Monitor SQL Server 2000 Blocking
http://support.microsoft.com/?id=271509
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Job step fails with Error 7399 and 7312

We have a job that intermittently fails on the same step with the same error
.
Identical jobs that run before this one always succeed. The step uses the
following T-SQL to update a table on a linked server:
DBCC TRACEON (7300, 3604)
INSERT INTO <linkedservername>.ods.dbo.[!ODSReplicationTimes]
([Date], Imports, Div)
VALUES (dbo.DateOnly(DATEADD(hh, 7, GETDATE())), GETDATE(), 'wbd')
if the job fails, it is exactly the default timeout of 10 minutes after the
start time, and results in this error:
Executed as user: <username>. OLE DB provider 'SQLOLEDB' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE D
B error
trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow returned
0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.
on failure, this step proceeds to a similar step which calls a sproc:
DBCC TRACEON (7300, 3604)
CheckFutureStatus 'JobName Finish','!Check Status WBD',240,240,3,'wbd'
yielding a similar result:
Executed as user: <username>. OLE DB provider 'SQLOLEDB' reported an error.
[SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE D
B error
trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::SetData returned 0x8000
4005:
]. [SQLSTATE 01000] (Error 7300). The step failed.
I've set the step to retry 3 times/5 minutes to no avail. the traceon
doesn't give any additional information.
Any ideas?Hello
Did you try to perform a SQL Profiler trace on the server that you have
configured as the linked server to see what happens on that server. I'm
assuming that the query should finish within the 10 minute timeout period.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||What Events/Data would you want to see. anything in particular for this
situation?
"Pankaj Agarwal [MSFT]" wrote:

> Hello
> Did you try to perform a SQL Profiler trace on the server that you have
> configured as the linked server to see what happens on that server. I'm
> assuming that the query should finish within the 10 minute timeout period.
> Thank you for using Microsoft newsgroups.
> Sincerely
> Pankaj Agarwal
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>|||I think it would be beneficial to capture the Execution Statistics, Stored
Procedure and TSQL related events. Also capture SP Recompile, Database File
Autogrow. This would give you at least a starting point to see what event
is the query stuck on. I would also download the blocker script from the
following KB article and run that to see if there is any blocking when the
query does not complete during the 10 min timeout interval.
271509 INF: How to Monitor SQL Server 2000 Blocking
http://support.microsoft.com/?id=271509
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql

Job step failing with "ConnectionRead (WrapperRead())." error

We have a job step which executes a stored proc that fails intermittently
with this error:
Executed as user: domain\user. ConnectionRead (WrapperRead()). [SQLSTATE
01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11). The step failed.
This stored proc executes just fine through QA.
Could it be that the SP does execute but that the step is being incorrectly
reported as failed?
Thank you
-- alan cranfield, DBAuse same ANSI settings in job like in QA
"Cranfield" wrote:

> We have a job step which executes a stored proc that fails intermittently
> with this error:
> Executed as user: domain\user. ConnectionRead (WrapperRead()). [SQLSTA
TE
> 01000] (Message 258) General network error. Check your network
> documentation. [SQLSTATE 08S01] (Error 11). The step failed.
> This stored proc executes just fine through QA.
> Could it be that the SP does execute but that the step is being incorrectl
y
> reported as failed?
> Thank you
> --
> -- alan cranfield, DBA|||I tried your suggestion. Job step still fails.
This must be a bug. I will raise a case with PSS.
thanks for the reply.
-- cranfield, DBA
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use same ANSI settings in job like in QA
>
> "Cranfield" wrote:
>

Job step failing with "ConnectionRead (WrapperRead())." error

We have a job step which executes a stored proc that fails intermittently
with this error:
Executed as user: domain\user. ConnectionRead (WrapperRead()). [SQLSTATE
01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11). The step failed.
This stored proc executes just fine through QA.
Could it be that the SP does execute but that the step is being incorrectly
reported as failed?
Thank you
--
-- alan cranfield, DBAuse same ANSI settings in job like in QA
"Cranfield" wrote:
> We have a job step which executes a stored proc that fails intermittently
> with this error:
> Executed as user: domain\user. ConnectionRead (WrapperRead()). [SQLSTATE
> 01000] (Message 258) General network error. Check your network
> documentation. [SQLSTATE 08S01] (Error 11). The step failed.
> This stored proc executes just fine through QA.
> Could it be that the SP does execute but that the step is being incorrectly
> reported as failed?
> Thank you
> --
> -- alan cranfield, DBA|||I tried your suggestion. Job step still fails.
This must be a bug. I will raise a case with PSS.
thanks for the reply.
--
-- cranfield, DBA
"Aleksandar Grbic" wrote:
> use same ANSI settings in job like in QA
>
> "Cranfield" wrote:
> > We have a job step which executes a stored proc that fails intermittently
> > with this error:
> >
> > Executed as user: domain\user. ConnectionRead (WrapperRead()). [SQLSTATE
> > 01000] (Message 258) General network error. Check your network
> > documentation. [SQLSTATE 08S01] (Error 11). The step failed.
> >
> > This stored proc executes just fine through QA.
> >
> > Could it be that the SP does execute but that the step is being incorrectly
> > reported as failed?
> >
> > Thank you
> >
> > --
> > -- alan cranfield, DBA

Job step failing with "ConnectionRead (WrapperRead())." error

We have a job step which executes a stored proc that fails intermittently
with this error:
Executed as user: domain\user. ConnectionRead (WrapperRead()). [SQLSTATE
01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11). The step failed.
This stored proc executes just fine through QA.
Could it be that the SP does execute but that the step is being incorrectly
reported as failed?
Thank you
-- alan cranfield, DBA
use same ANSI settings in job like in QA
"Cranfield" wrote:

> We have a job step which executes a stored proc that fails intermittently
> with this error:
> Executed as user: domain\user. ConnectionRead (WrapperRead()). [SQLSTATE
> 01000] (Message 258) General network error. Check your network
> documentation. [SQLSTATE 08S01] (Error 11). The step failed.
> This stored proc executes just fine through QA.
> Could it be that the SP does execute but that the step is being incorrectly
> reported as failed?
> Thank you
> --
> -- alan cranfield, DBA
|||I tried your suggestion. Job step still fails.
This must be a bug. I will raise a case with PSS.
thanks for the reply.
-- cranfield, DBA
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use same ANSI settings in job like in QA
>
> "Cranfield" wrote:

Job not working

The output message is :
" DTSRun: Cannot create COM Server to load and execute
DTS Package. Error -2147221164 (80040154): Class not
registered "Was the package created on a different version of SQL Server ?
have you registered the DTS dlls?
If you have then you may want to reregister them.
Redistributing DTS with your program
http://www.sqldts.com/default.aspx?6,105,225,0,1
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
news:084a01c3b8bc$74b5a690$a501280a@.phx.gbl...
> The output message is :
> " DTSRun: Cannot create COM Server to load and execute
> DTS Package. Error -2147221164 (80040154): Class not
> registered "
>

Job generates login error

I have a package which will run in Management Studio. The package is saved in MSDB. When I try to set up a job, the step errors out with what appears to be a login error. I am specifying windows authentication in the job and also used that when creating the package.

Paul,

the reason is security, probably you created the package with a different account than the sql server agent is running.

Solution:

you can create the package with the agent account,

or in the package -> properties -> security -> protectionlevel -> choose encryptsensitivewithpassword en fill in a password.

greetz

http://www.ns-consulting.be

|||

the package was originally created in management studio using the administrator account. do I need to set up the SQL Agent as a user? Is there a book on SQL Server 2005 which walks you through creating a sample solution from start to finish? I have the Administrator's Consultant and 'Changing the Paradigm' books. SQL Server 2005 is entirely new to me; I was a dba for Sql Server 2000 before this.

Thanks for your help!

Paul

|||

the package was recreated - I changed the encription option to 'Rely on server . . .' and changed the source path from X:\Directory\FileName to \\HostServerName\Directory\FileName.

problem is solved.

Job generates login error

I have a package which will run in Management Studio. The package is saved in MSDB. When I try to set up a job, the step errors out with what appears to be a login error. I am specifying windows authentication in the job and also used that when creating the package.

Paul,

the reason is security, probably you created the package with a different account than the sql server agent is running.

Solution:

you can create the package with the agent account,

or in the package -> properties -> security -> protectionlevel -> choose encryptsensitivewithpassword en fill in a password.

greetz

http://www.ns-consulting.be

|||

the package was originally created in management studio using the administrator account. do I need to set up the SQL Agent as a user? Is there a book on SQL Server 2005 which walks you through creating a sample solution from start to finish? I have the Administrator's Consultant and 'Changing the Paradigm' books. SQL Server 2005 is entirely new to me; I was a dba for Sql Server 2000 before this.

Thanks for your help!

Paul

|||

the package was recreated - I changed the encription option to 'Rely on server . . .' and changed the source path from X:\Directory\FileName to \\HostServerName\Directory\FileName.

problem is solved.

Job generates login error

I have a package which will run in Management Studio. The package is saved in MSDB. When I try to set up a job, the step errors out with what appears to be a login error. I am specifying windows authentication in the job and also used that when creating the package.

Paul,

the reason is security, probably you created the package with a different account than the sql server agent is running.

Solution:

you can create the package with the agent account,

or in the package -> properties -> security -> protectionlevel -> choose encryptsensitivewithpassword en fill in a password.

greetz

http://www.ns-consulting.be

|||

the package was originally created in management studio using the administrator account. do I need to set up the SQL Agent as a user? Is there a book on SQL Server 2005 which walks you through creating a sample solution from start to finish? I have the Administrator's Consultant and 'Changing the Paradigm' books. SQL Server 2005 is entirely new to me; I was a dba for Sql Server 2000 before this.

Thanks for your help!

Paul

|||

the package was recreated - I changed the encription option to 'Rely on server . . .' and changed the source path from X:\Directory\FileName to \\HostServerName\Directory\FileName.

problem is solved.

JOB Failure!

Hi,
I've a question related to JOB failure in the DTS package.
The following is the error from the LOG file.Could some one help me in this
regard,as how i can find the easy way out.
LOG FILE ERROR:
--
Execution Started: 2/24/2005 11:34:06 PM
Execution Completed: 2/25/2005 12:17:56 AM
Total Execution Time: 2629.937 seconds
Package Steps execution information:
Step 'DTSStep_DTSActiveScriptTask_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Error Code: 0
Error Source= Microsoft XML Extensions to SQL Server
Error Description: [DBNETLIB][ConnectionRead (recv()).]General netwo
rk
error. Check your network documentation.
Thanks,
ShyamShyam,
This usually means that there was an actual network problem. A switch or
router may have out of service, a cable disconnected, etc.
RLF
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:25D54BB1-7605-4654-ADBE-7C08CF3901B8@.microsoft.com...
> Hi,
> I've a question related to JOB failure in the DTS package.
> The following is the error from the LOG file.Could some one help me in
> this
> regard,as how i can find the easy way out.
> LOG FILE ERROR:
> --
> Execution Started: 2/24/2005 11:34:06 PM
> Execution Completed: 2/25/2005 12:17:56 AM
> Total Execution Time: 2629.937 seconds
> Package Steps execution information:
> Step 'DTSStep_DTSActiveScriptTask_1' failed
> Step Error Source: Microsoft Data Transformation Services (DTS) Package
> Step Error Description:Error Code: 0
> Error Source= Microsoft XML Extensions to SQL Server
> Error Description: [DBNETLIB][ConnectionRead (recv()).]General net
work
> error. Check your network documentation.
> Thanks,
> Shyam
>

JOB Failure!

Hi,
I've a question related to JOB failure in the DTS package.
The following is the error from the LOG file.Could some one help me in this
regard,as how i can find the easy way out.
LOG FILE ERROR:
--
Execution Started: 2/24/2005 11:34:06 PM
Execution Completed: 2/25/2005 12:17:56 AM
Total Execution Time: 2629.937 seconds
Package Steps execution information:
Step 'DTSStep_DTSActiveScriptTask_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Error Code: 0
Error Source= Microsoft XML Extensions to SQL Server
Error Description: [DBNETLIB][ConnectionRead (recv()).]General network
error. Check your network documentation.
Thanks,
ShyamShyam,
This usually means that there was an actual network problem. A switch or
router may have out of service, a cable disconnected, etc.
RLF
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:25D54BB1-7605-4654-ADBE-7C08CF3901B8@.microsoft.com...
> Hi,
> I've a question related to JOB failure in the DTS package.
> The following is the error from the LOG file.Could some one help me in
> this
> regard,as how i can find the easy way out.
> LOG FILE ERROR:
> --
> Execution Started: 2/24/2005 11:34:06 PM
> Execution Completed: 2/25/2005 12:17:56 AM
> Total Execution Time: 2629.937 seconds
> Package Steps execution information:
> Step 'DTSStep_DTSActiveScriptTask_1' failed
> Step Error Source: Microsoft Data Transformation Services (DTS) Package
> Step Error Description:Error Code: 0
> Error Source= Microsoft XML Extensions to SQL Server
> Error Description: [DBNETLIB][ConnectionRead (recv()).]General network
> error. Check your network documentation.
> Thanks,
> Shyam
>

JOB Failure!

Hi,
I've a question related to JOB failure in the DTS package.
The following is the error from the LOG file.Could some one help me in this
regard,as how i can find the easy way out.
LOG FILE ERROR:
Execution Started: 2/24/2005 11:34:06 PM
Execution Completed: 2/25/2005 12:17:56 AM
Total Execution Time: 2629.937 seconds
Package Steps execution information:
Step 'DTSStep_DTSActiveScriptTask_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Error Code: 0
Error Source= Microsoft XML Extensions to SQL Server
Error Description: [DBNETLIB][ConnectionRead (recv()).]General network
error. Check your network documentation.
Thanks,
Shyam
Shyam,
This usually means that there was an actual network problem. A switch or
router may have out of service, a cable disconnected, etc.
RLF
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:25D54BB1-7605-4654-ADBE-7C08CF3901B8@.microsoft.com...
> Hi,
> I've a question related to JOB failure in the DTS package.
> The following is the error from the LOG file.Could some one help me in
> this
> regard,as how i can find the easy way out.
> LOG FILE ERROR:
> --
> Execution Started: 2/24/2005 11:34:06 PM
> Execution Completed: 2/25/2005 12:17:56 AM
> Total Execution Time: 2629.937 seconds
> Package Steps execution information:
> Step 'DTSStep_DTSActiveScriptTask_1' failed
> Step Error Source: Microsoft Data Transformation Services (DTS) Package
> Step Error Description:Error Code: 0
> Error Source= Microsoft XML Extensions to SQL Server
> Error Description: [DBNETLIB][ConnectionRead (recv()).]General network
> error. Check your network documentation.
> Thanks,
> Shyam
>

Job failure - error msg attached

I have a maintenance job that is failing with the
following error message:
The job failed. Unable to determine if the owner %OWNER%
of job %JOB% has server access (reason: The log for
database 'tempdb' is not available. [SQLSTATE HY000]
(Error 9001)).
Any ideas how to resolve this one? I've looked in the KB
and BOL, and I see entries for the error and the reason
in parentheses, but not with the two together. Was
thinking just cycling the instance might resolve the
issue, but was hoping to avoid doing this. Never seen
this one before, so any help would be appreciated.
Cheers.
All I can think is no DC available for authentication? I suspect the =
reason in brackets to be misleading, if tempdb had lost it's log you =
would be getting many other problems!)
Mike John
"knives" <anonymous@.discussions.microsoft.com> wrote in message =
news:1e30b01c454a9$cf5029c0$a001280a@.phx.gbl...
> I have a maintenance job that is failing with the=20
> following error message:
>=20
> The job failed. Unable to determine if the owner %OWNER%=20
> of job %JOB% has server access (reason: The log for=20
> database 'tempdb' is not available. [SQLSTATE HY000]=20
> (Error 9001)).
>=20
> Any ideas how to resolve this one? I've looked in the KB=20
> and BOL, and I see entries for the error and the reason=20
> in parentheses, but not with the two together. Was=20
> thinking just cycling the instance might resolve the=20
> issue, but was hoping to avoid doing this. Never seen=20
> this one before, so any help would be appreciated.
>=20
> Cheers.
|||I'd start by setting the job owner to sa.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"knives" <anonymous@.discussions.microsoft.com> wrote in message
news:1e30b01c454a9$cf5029c0$a001280a@.phx.gbl...
> I have a maintenance job that is failing with the
> following error message:
> The job failed. Unable to determine if the owner %OWNER%
> of job %JOB% has server access (reason: The log for
> database 'tempdb' is not available. [SQLSTATE HY000]
> (Error 9001)).
> Any ideas how to resolve this one? I've looked in the KB
> and BOL, and I see entries for the error and the reason
> in parentheses, but not with the two together. Was
> thinking just cycling the instance might resolve the
> issue, but was hoping to avoid doing this. Never seen
> this one before, so any help would be appreciated.
> Cheers.

Job failure - error msg attached

I have a maintenance job that is failing with the
following error message:
The job failed. Unable to determine if the owner %OWNER%
of job %JOB% has server access (reason: The log for
database 'tempdb' is not available. [SQLSTATE HY000]
(Error 9001)).
Any ideas how to resolve this one? I've looked in the KB
and BOL, and I see entries for the error and the reason
in parentheses, but not with the two together. Was
thinking just cycling the instance might resolve the
issue, but was hoping to avoid doing this. Never seen
this one before, so any help would be appreciated.
Cheers.All I can think is no DC available for authentication? I suspect the =reason in brackets to be misleading, if tempdb had lost it's log you =would be getting many other problems!)
Mike John
"knives" <anonymous@.discussions.microsoft.com> wrote in message =news:1e30b01c454a9$cf5029c0$a001280a@.phx.gbl...
> I have a maintenance job that is failing with the > following error message:
> > The job failed. Unable to determine if the owner %OWNER% > of job %JOB% has server access (reason: The log for > database 'tempdb' is not available. [SQLSTATE HY000] > (Error 9001)).
> > Any ideas how to resolve this one? I've looked in the KB > and BOL, and I see entries for the error and the reason > in parentheses, but not with the two together. Was > thinking just cycling the instance might resolve the > issue, but was hoping to avoid doing this. Never seen > this one before, so any help would be appreciated.
> > Cheers.|||I'd start by setting the job owner to sa.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"knives" <anonymous@.discussions.microsoft.com> wrote in message
news:1e30b01c454a9$cf5029c0$a001280a@.phx.gbl...
> I have a maintenance job that is failing with the
> following error message:
> The job failed. Unable to determine if the owner %OWNER%
> of job %JOB% has server access (reason: The log for
> database 'tempdb' is not available. [SQLSTATE HY000]
> (Error 9001)).
> Any ideas how to resolve this one? I've looked in the KB
> and BOL, and I see entries for the error and the reason
> in parentheses, but not with the two together. Was
> thinking just cycling the instance might resolve the
> issue, but was hoping to avoid doing this. Never seen
> this one before, so any help would be appreciated.
> Cheers.

Job fails to communicate with SQL Server Agent

Hi,

Just need some help on a job issue.

The job in question gives the below mentioned error when run

Error 22022: Unable to post notification to SQL
ServerAgent (reason: OpenFileMapping()returned error
2, 'The system cannot find the file specified')

This seems to have started after I changed the owner for the Agent and MSSQL service from local service to a domain ID.

FYI, I have also changed the job owner from sa to the domain ID and have tried restarting the agent service in the hope that the Job can speak to the agent .. but it doesnt :(

Microsoft suggests to change some registry entries but I am not sure if that'd work
http://support.microsoft.com/default.aspx?scid=kb;en-us;911841&sd=rss&spid=2852

The server on which this job is hosted is a production box .. so am a litle apprehensive about making any registry changes

Any Suggestions ?

Thanks.

Warm Regards,
Ranjit.Hi people ...

Getting no instant fixes to this issue, I changed the service owner back to local system ... But on doing so .. things took a bad turn and the agent got hung .. we had no option but to call for an emergency reboot ..

That fixed the issue as the agents were set back to their usual settings.

I am still hunting for a permanant solution on this.. so would appreciate any help on this.

Thanks,
Ranjit.|||How did you change the accounts under which Agent & Server services are running? You must do it only via Enterpr. manager, not Windows services.

Job fails in SQL Server 2005 Agent with error "Package not found"

Hello everybody,
I am trying to run an SQL Server 2005 job which is made up of one SSIS
package.
The SSIS package run successfully when I start it manually, but as soon as I
include it in an SQL Server Agent I get the error message mentioned in the
subject.
Any ideas?
Thank you in advance
Massimo SartorisHere is the solution for this issue from Micorosft:
http://support.microsoft.com/Default.aspx?kbid=918760
Bob
"Massimo" wrote:
> Hello everybody,
> I am trying to run an SQL Server 2005 job which is made up of one SSIS
> package.
> The SSIS package run successfully when I start it manually, but as soon as I
> include it in an SQL Server Agent I get the error message mentioned in the
> subject.
> Any ideas?
> Thank you in advance
> Massimo Sartoris|||Thank you, Bob.
I tried the proxy method described in the article, but the job keeps
failing. The error message is now
"A required privilege is not held by the client"
The user is an administrator on the SQL server machine, which privilege is
actually missing?
Thank you
"Bob" wrote:
> Here is the solution for this issue from Micorosft:
> http://support.microsoft.com/Default.aspx?kbid=918760
> Bob
>|||Did you change the SQL Server Service account to use the proxy method?
"Massimo" wrote:
> Thank you, Bob.
> I tried the proxy method described in the article, but the job keeps
> failing. The error message is now
> "A required privilege is not held by the client"
> The user is an administrator on the SQL server machine, which privilege is
> actually missing?
> Thank you
>
>
> "Bob" wrote:
> > Here is the solution for this issue from Micorosft:
> >
> > http://support.microsoft.com/Default.aspx?kbid=918760
> >
> > Bob
> >
>|||Bob,
I did, actually.
I created a credential with an account that has administrator rights
(Username "Massimo")
I created a proxy using that credential.
I changed the step in the SQL Server agent job saying "run as" the proxy
instead of the SQL Agent Service Account
Username "Massimo" is also member of the group SQLServer2005SQLAgentUser
Cheers
Massimo
"Bob" wrote:
> Did you change the SQL Server Service account to use the proxy method?
> "Massimo" wrote:
>

Job fails in SQL Server 2005 Agent with error "Package not found"

Hello everybody,
I am trying to run an SQL Server 2005 job which is made up of one SSIS
package.
The SSIS package run successfully when I start it manually, but as soon as I
include it in an SQL Server Agent I get the error message mentioned in the
subject.
Any ideas?
Thank you in advance
Massimo SartorisHere is the solution for this issue from Micorosft:
http://support.microsoft.com/Default.aspx?kbid=918760
Bob
"Massimo" wrote:

> Hello everybody,
> I am trying to run an SQL Server 2005 job which is made up of one SSIS
> package.
> The SSIS package run successfully when I start it manually, but as soon as
I
> include it in an SQL Server Agent I get the error message mentioned in the
> subject.
> Any ideas?
> Thank you in advance
> Massimo Sartoris

Job fails due to domian acccont

I have job running under a domian\userraccont.. It use to work fine..
suddenly it stoppped working..below is the error message
"""""The job failed. Unable to determine if the owner
(HO_PDOMAIN\cyresextractprod) of job Cypress Reserves Extract Processing has
server access (reason: Could not obtain information about Windows NT
group/user 'HO_PDOMAIN\cyresextractprod'. [SQLSTATE 42000] (Error 819"""
I could not even get the user login info by isuing xp_logininfo command..
I will be gald if any 1 responseCould be
PRB: 8198 Error Message Returned from Job Owned by Windows NT Authenticated
User
http://support.microsoft.com/defaul...b;en-us;q241643
Since we don't allow users to create/own jobs we set all our jobs to be
owned by sa to avoid this issue. This may not be applicable in your
situation but it does mean we never run into this issue :-)
Also have a look at the KB articles returned by this search (watch for URL
wrapping)
%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&withinResults=&QuerySource=gASr_Query&Produc
t=sql2k&Queryc=8198&Query=8198&KeywordType=ALL&maxResults=25&Titles=false&numDays=
&InCC=on" target="_blank">http://support.microsoft.com/search...br />
&InCC=on
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Babu" <Babu@.discussions.microsoft.com> wrote in message
news:47299136-8FE8-4573-8C70-561EE1C27C04@.microsoft.com...
>
> I have job running under a domian\userraccont.. It use to work fine..
> suddenly it stoppped working..below is the error message
> """""The job failed. Unable to determine if the owner
> (HO_PDOMAIN\cyresextractprod) of job Cypress Reserves Extract Processing
> has
> server access (reason: Could not obtain information about Windows NT
> group/user 'HO_PDOMAIN\cyresextractprod'. [SQLSTATE 42000] (Error 819"
""
> I could not even get the user login info by isuing xp_logininfo command..
> I will be gald if any 1 response