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 With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

|||hey - did you ever get this to work? Im having the same issue - its a SSIS pkg that ran on one box and I moved to another box (64 bit if that makes a diff) - any info is greatly apprecaited - thanks.|||

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

|||After settings Precompile to True, you need to open and close script editor(s) to actually precompile the script in the task. Then re-deploy the pockage to target system.|||Also remove all the break points in the code, having break points prevents from recompilation. I guess this issue would be fixed by SP2|||Just an FYI I had all my scripts set to PrecompileScriptIntoBinaryCode=True however when developing in 32bit and deploying to 64bit seemingly randomly I will get the "script failed to load" error. I just open the script and compile it again and save and that usually does the trick.|||

Also if the problem still persists and you keep getting the same error I am sure you are not taking the dtsx file from bin folder to execute. The file created by designer (Business Intelligence Development Studio) is only useful for debug and development mode. After building the solution one should use dtsx created in bin folder. This solution worked for me.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

|||

I too have similar doubt as that of Paulino. I've 50+ packages with 60+ script tasks. Is there any way, I can compile using a command in command prompt? Any help would be highly appreciated.

My Regards

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

|||hey - did you ever get this to work? Im having the same issue - its a SSIS pkg that ran on one box and I moved to another box (64 bit if that makes a diff) - any info is greatly apprecaited - thanks.|||

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

|||After settings Precompile to True, you need to open and close script editor(s) to actually precompile the script in the task. Then re-deploy the pockage to target system.|||Also remove all the break points in the code, having break points prevents from recompilation. I guess this issue would be fixed by SP2|||Just an FYI I had all my scripts set to PrecompileScriptIntoBinaryCode=True however when developing in 32bit and deploying to 64bit seemingly randomly I will get the "script failed to load" error. I just open the script and compile it again and save and that usually does the trick.|||

Also if the problem still persists and you keep getting the same error I am sure you are not taking the dtsx file from bin folder to execute. The file created by designer (Business Intelligence Development Studio) is only useful for debug and development mode. After building the solution one should use dtsx created in bin folder. This solution worked for me.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

sql

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

|||hey - did you ever get this to work? Im having the same issue - its a SSIS pkg that ran on one box and I moved to another box (64 bit if that makes a diff) - any info is greatly apprecaited - thanks.|||

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

|||After settings Precompile to True, you need to open and close script editor(s) to actually precompile the script in the task. Then re-deploy the pockage to target system.|||Also remove all the break points in the code, having break points prevents from recompilation. I guess this issue would be fixed by SP2|||Just an FYI I had all my scripts set to PrecompileScriptIntoBinaryCode=True however when developing in 32bit and deploying to 64bit seemingly randomly I will get the "script failed to load" error. I just open the script and compile it again and save and that usually does the trick.|||

Also if the problem still persists and you keep getting the same error I am sure you are not taking the dtsx file from bin folder to execute. The file created by designer (Business Intelligence Development Studio) is only useful for debug and development mode. After building the solution one should use dtsx created in bin folder. This solution worked for me.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

|||hey - did you ever get this to work? Im having the same issue - its a SSIS pkg that ran on one box and I moved to another box (64 bit if that makes a diff) - any info is greatly apprecaited - thanks.|||

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

|||After settings Precompile to True, you need to open and close script editor(s) to actually precompile the script in the task. Then re-deploy the pockage to target system.|||Also remove all the break points in the code, having break points prevents from recompilation. I guess this issue would be fixed by SP2|||Just an FYI I had all my scripts set to PrecompileScriptIntoBinaryCode=True however when developing in 32bit and deploying to 64bit seemingly randomly I will get the "script failed to load" error. I just open the script and compile it again and save and that usually does the trick.|||

Also if the problem still persists and you keep getting the same error I am sure you are not taking the dtsx file from bin folder to execute. The file created by designer (Business Intelligence Development Studio) is only useful for debug and development mode. After building the solution one should use dtsx created in bin folder. This solution worked for me.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

|||hey - did you ever get this to work? Im having the same issue - its a SSIS pkg that ran on one box and I moved to another box (64 bit if that makes a diff) - any info is greatly apprecaited - thanks.|||

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

|||After settings Precompile to True, you need to open and close script editor(s) to actually precompile the script in the task. Then re-deploy the pockage to target system.|||Also remove all the break points in the code, having break points prevents from recompilation. I guess this issue would be fixed by SP2|||Just an FYI I had all my scripts set to PrecompileScriptIntoBinaryCode=True however when developing in 32bit and deploying to 64bit seemingly randomly I will get the "script failed to load" error. I just open the script and compile it again and save and that usually does the trick.|||

Also if the problem still persists and you keep getting the same error I am sure you are not taking the dtsx file from bin folder to execute. The file created by designer (Business Intelligence Development Studio) is only useful for debug and development mode. After building the solution one should use dtsx created in bin folder. This solution worked for me.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

|||hey - did you ever get this to work? Im having the same issue - its a SSIS pkg that ran on one box and I moved to another box (64 bit if that makes a diff) - any info is greatly apprecaited - thanks.|||

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

|||After settings Precompile to True, you need to open and close script editor(s) to actually precompile the script in the task. Then re-deploy the pockage to target system.|||Also remove all the break points in the code, having break points prevents from recompilation. I guess this issue would be fixed by SP2|||Just an FYI I had all my scripts set to PrecompileScriptIntoBinaryCode=True however when developing in 32bit and deploying to 64bit seemingly randomly I will get the "script failed to load" error. I just open the script and compile it again and save and that usually does the trick.|||

Also if the problem still persists and you keep getting the same error I am sure you are not taking the dtsx file from bin folder to execute. The file created by designer (Business Intelligence Development Studio) is only useful for debug and development mode. After building the solution one should use dtsx created in bin folder. This solution worked for me.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

|||hey - did you ever get this to work? Im having the same issue - its a SSIS pkg that ran on one box and I moved to another box (64 bit if that makes a diff) - any info is greatly apprecaited - thanks.|||

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

|||After settings Precompile to True, you need to open and close script editor(s) to actually precompile the script in the task. Then re-deploy the pockage to target system.|||Also remove all the break points in the code, having break points prevents from recompilation. I guess this issue would be fixed by SP2|||Just an FYI I had all my scripts set to PrecompileScriptIntoBinaryCode=True however when developing in 32bit and deploying to 64bit seemingly randomly I will get the "script failed to load" error. I just open the script and compile it again and save and that usually does the trick.|||

Also if the problem still persists and you keep getting the same error I am sure you are not taking the dtsx file from bin folder to execute. The file created by designer (Business Intelligence Development Studio) is only useful for debug and development mode. After building the solution one should use dtsx created in bin folder. This solution worked for me.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

sql

JOB With SSIS Step Fails If Package Contains A Script Task

I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed."

I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine.

Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line.

Only if I include the Package in a job step with the Script Task enabled does it fail.

Any help would be appreciated.I've no real idea about this Steve except to say have you got the script code pre-compiled? If so, try it without (and vica versa).

-Jamie|||

Sorry for not posting this sooner, Jamie...Yes, setting the Script Task "PrecompileScriptIntoBinaryCode" Property to True resolved the issue.

-Steve

|||hey - did you ever get this to work? Im having the same issue - its a SSIS pkg that ran on one box and I moved to another box (64 bit if that makes a diff) - any info is greatly apprecaited - thanks.|||

Juantana,

Yes, set your Script Task "PrecompileScriptIntoBinaryCode" Property=True and then open and close your script. Save, redeploy and it should work. Let me know if you have any questions.

-Steve

|||

Hi,

Inspite of putting the PrecompileScriptintoBinarycode Property = True, it is not working. Do you have any suggestions?

Thanks.

|||After settings Precompile to True, you need to open and close script editor(s) to actually precompile the script in the task. Then re-deploy the pockage to target system.|||Also remove all the break points in the code, having break points prevents from recompilation. I guess this issue would be fixed by SP2|||Just an FYI I had all my scripts set to PrecompileScriptIntoBinaryCode=True however when developing in 32bit and deploying to 64bit seemingly randomly I will get the "script failed to load" error. I just open the script and compile it again and save and that usually does the trick.|||

Also if the problem still persists and you keep getting the same error I am sure you are not taking the dtsx file from bin folder to execute. The file created by designer (Business Intelligence Development Studio) is only useful for debug and development mode. After building the solution one should use dtsx created in bin folder. This solution worked for me.

Thanks

Mohit

|||NOTE: I got this same error message with Precompile option set to True.

Problem was that a variable name script used was not passed in. Go figure|||

I have about 30 dtxs that I would like to recompile its scripts to solve this issue. I would like to avoid to open each package, then open each script in the package and do the save to recomplie.

Is there a way to recompile from the command line?

Thanks!

|||

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

|||

Chris Honcoop wrote:

Previously I said "randomly" but I think I have it figured out when this error occurs:

If I am working on a package, open a different package and copy a script object and paste into the one I am working on it will not work in 64-bit without a recompile (but will work in 32 bit).

Sounds like it might be a bug. Could you submit it at http://connect.microsoft.com?

-Jamie

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 runs succesfully, but database not updated

I have created a job to run an executable. This executable has to read an
Excelsheet in order to import the data into the database.
I got the message that the job has run succesfully, but the data is not in
the database.
My job looks like this:
c:\mydirectory\bin\excelimport.exe /Slocal) /D:DataComp 20051020
S: --> the local server
D:--> database name
Thank you for your help.
Kind regards,
LoHi
You don't say where the job expects the excel file to be! Have you looks at
SQL profiler to see what is happening when the program runs?
John
"lo" wrote:

> I have created a job to run an executable. This executable has to read an
> Excelsheet in order to import the data into the database.
> I got the message that the job has run succesfully, but the data is not in
> the database.
> My job looks like this:
> c:\mydirectory\bin\excelimport.exe /Slocal) /D:DataComp 20051020
> S: --> the local server
> D:--> database name
> --
> Thank you for your help.
> Kind regards,
> Lo|||I have run the profiler, but here as well I get no error message once or eve
r.
I have updated the string like this
c:\mydirectory\bin\excelimport.exe /Slocal) /D:[DataComp 20051020]
The path to the excel sheet is in the excelimport.exe.
Do you have any other idea'
Thank you for your help.
Kind regards,
Lo
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You don't say where the job expects the excel file to be! Have you looks a
t
> SQL profiler to see what is happening when the program runs?
> John
> "lo" wrote:
>|||Hi
I would not expect any error messages from SQL Profile, just the information
about which database it is running against and what SQL statements are being
executed by the job. You can then confirm that it is not connecting to the
correct database or that it is not finding the file.
Do you have a dynamic properties task to change the destination database?
You may want to see http://www.sqldts.com/default.aspx?252
John
"lo" wrote:
[vbcol=seagreen]
> I have run the profiler, but here as well I get no error message once or e
ver.
> I have updated the string like this
> c:\mydirectory\bin\excelimport.exe /Slocal) /D:[DataComp 20051020]
> The path to the excel sheet is in the excelimport.exe.
> Do you have any other idea'
>
> --
> Thank you for your help.
> Kind regards,
> Lo
>
> "John Bell" wrote:
>

Job runs succesfully, but database not updated

I have created a job to run an executable. This executable has to read an
Excelsheet in order to import the data into the database.
I got the message that the job has run succesfully, but the data is not in
the database.
My job looks like this:
c:\mydirectory\bin\excelimport.exe /S:(local) /D:DataComp 20051020
S: --> the local server
D:--> database name
--
Thank you for your help.
Kind regards,
LoHi
You don't say where the job expects the excel file to be! Have you looks at
SQL profiler to see what is happening when the program runs?
John
"lo" wrote:
> I have created a job to run an executable. This executable has to read an
> Excelsheet in order to import the data into the database.
> I got the message that the job has run succesfully, but the data is not in
> the database.
> My job looks like this:
> c:\mydirectory\bin\excelimport.exe /S:(local) /D:DataComp 20051020
> S: --> the local server
> D:--> database name
> --
> Thank you for your help.
> Kind regards,
> Lo|||I have run the profiler, but here as well I get no error message once or ever.
I have updated the string like this
c:\mydirectory\bin\excelimport.exe /S:(local) /D:[DataComp 20051020]
The path to the excel sheet is in the excelimport.exe.
Do you have any other idea'
Thank you for your help.
Kind regards,
Lo
"John Bell" wrote:
> Hi
> You don't say where the job expects the excel file to be! Have you looks at
> SQL profiler to see what is happening when the program runs?
> John
> "lo" wrote:
> > I have created a job to run an executable. This executable has to read an
> > Excelsheet in order to import the data into the database.
> > I got the message that the job has run succesfully, but the data is not in
> > the database.
> > My job looks like this:
> > c:\mydirectory\bin\excelimport.exe /S:(local) /D:DataComp 20051020
> > S: --> the local server
> > D:--> database name
> >
> > --
> > Thank you for your help.
> >
> > Kind regards,
> >
> > Lo|||Hi
I would not expect any error messages from SQL Profile, just the information
about which database it is running against and what SQL statements are being
executed by the job. You can then confirm that it is not connecting to the
correct database or that it is not finding the file.
Do you have a dynamic properties task to change the destination database?
You may want to see http://www.sqldts.com/default.aspx?252
John
"lo" wrote:
> I have run the profiler, but here as well I get no error message once or ever.
> I have updated the string like this
> c:\mydirectory\bin\excelimport.exe /S:(local) /D:[DataComp 20051020]
> The path to the excel sheet is in the excelimport.exe.
> Do you have any other idea'
>
> --
> Thank you for your help.
> Kind regards,
> Lo
>
> "John Bell" wrote:
> > Hi
> >
> > You don't say where the job expects the excel file to be! Have you looks at
> > SQL profiler to see what is happening when the program runs?
> >
> > John
> >
> > "lo" wrote:
> >
> > > I have created a job to run an executable. This executable has to read an
> > > Excelsheet in order to import the data into the database.
> > > I got the message that the job has run succesfully, but the data is not in
> > > the database.
> > > My job looks like this:
> > > c:\mydirectory\bin\excelimport.exe /S:(local) /D:DataComp 20051020
> > > S: --> the local server
> > > D:--> database name
> > >
> > > --
> > > Thank you for your help.
> > >
> > > Kind regards,
> > >
> > > Lo

Job not working in SQL server

Hi,
I have put a job with 3 steps.
But appear this message : "The job failed. The Job was
invoked by Schedule 15 (IMPORT_DBF_TO_SQL). The last step
to run was step 3 (IMPORT_DBF_TO_SQL)".
What I Can do to solve this problem'
ThanksYou need to see what Step 3 :- IMPORT_DBF_TO_SQL is trying to do.
I would imagine it executes a DTS Package, hopefully that DTS package was
designed to produce a Log output file. That Log file will give you the real
reason for the failure.
--
HTH
Ryan Waight, MCDBA, MCSE
"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
news:0a4001c3b4d7$da8407c0$a301280a@.phx.gbl...
> Hi,
> I have put a job with 3 steps.
> But appear this message : "The job failed. The Job was
> invoked by Schedule 15 (IMPORT_DBF_TO_SQL). The last step
> to run was step 3 (IMPORT_DBF_TO_SQL)".
> What I Can do to solve this problem'
> Thanks
>|||Hi,
But its very strange, because i have in another SQL server
the same job and it's ok!!
the steps are:
1- DeleteCurrentData -- Transact-SQL Script
2- Convert DAT to DBF -- Transact-SQL Script
3- IMPORT_DBF_TO_SQL -- Operating System Command
>--Original Message--
>You need to see what Step 3 :- IMPORT_DBF_TO_SQL is
trying to do.
>I would imagine it executes a DTS Package, hopefully that
DTS package was
>designed to produce a Log output file. That Log file will
give you the real
>reason for the failure.
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
>news:0a4001c3b4d7$da8407c0$a301280a@.phx.gbl...
>> Hi,
>> I have put a job with 3 steps.
>> But appear this message : "The job failed. The Job was
>> invoked by Schedule 15 (IMPORT_DBF_TO_SQL). The last
step
>> to run was step 3 (IMPORT_DBF_TO_SQL)".
>> What I Can do to solve this problem'
>> Thanks
>>
>
>.
>|||It is impossible for us to know why it fails when all you tell us is that it fails.
Specify an output file for that jobstep and look at the messages in there. Hopefully this program
produces output from which you can determine what it wrong.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
news:084901c3b4df$9edff550$a501280a@.phx.gbl...
> Hi,
> But its very strange, because i have in another SQL server
> the same job and it's ok!!
> the steps are:
> 1- DeleteCurrentData -- Transact-SQL Script
> 2- Convert DAT to DBF -- Transact-SQL Script
> 3- IMPORT_DBF_TO_SQL -- Operating System Command
>
>
> >--Original Message--
> >You need to see what Step 3 :- IMPORT_DBF_TO_SQL is
> trying to do.
> >
> >I would imagine it executes a DTS Package, hopefully that
> DTS package was
> >designed to produce a Log output file. That Log file will
> give you the real
> >reason for the failure.
> >
> >--
> >HTH
> >Ryan Waight, MCDBA, MCSE
> >
> >"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
> >news:0a4001c3b4d7$da8407c0$a301280a@.phx.gbl...
> >> Hi,
> >>
> >> I have put a job with 3 steps.
> >> But appear this message : "The job failed. The Job was
> >> invoked by Schedule 15 (IMPORT_DBF_TO_SQL). The last
> step
> >> to run was step 3 (IMPORT_DBF_TO_SQL)".
> >>
> >> What I Can do to solve this problem'
> >>
> >> Thanks
> >>
> >>
> >
> >
> >.
> >|||In the output file the message that appear are
"SQL Server Scheduled Job 'import-DBF_to_SQL'
(0x3CB9A4AA25D87B408BF4C3272F2F4C8B) - Status: Failed -
Invoked on: 2003-11-27 04:00:00 - Message: The job
failed. The Job was invoked by Schedule 15
(IMPORT_DBF_TO_SQL). The last step to run was step 3
(IMPORT_DBF_TO_SQL). "
>--Original Message--
>It is impossible for us to know why it fails when all you
tell us is that it fails.
>Specify an output file for that jobstep and look at the
messages in there. Hopefully this program
>produces output from which you can determine what it
wrong.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
>news:084901c3b4df$9edff550$a501280a@.phx.gbl...
>> Hi,
>> But its very strange, because i have in another SQL
server
>> the same job and it's ok!!
>> the steps are:
>> 1- DeleteCurrentData -- Transact-SQL Script
>> 2- Convert DAT to DBF -- Transact-SQL Script
>> 3- IMPORT_DBF_TO_SQL -- Operating System Command
>>
>>
>> >--Original Message--
>> >You need to see what Step 3 :- IMPORT_DBF_TO_SQL is
>> trying to do.
>> >
>> >I would imagine it executes a DTS Package, hopefully
that
>> DTS package was
>> >designed to produce a Log output file. That Log file
will
>> give you the real
>> >reason for the failure.
>> >
>> >--
>> >HTH
>> >Ryan Waight, MCDBA, MCSE
>> >
>> >"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in
message
>> >news:0a4001c3b4d7$da8407c0$a301280a@.phx.gbl...
>> >> Hi,
>> >>
>> >> I have put a job with 3 steps.
>> >> But appear this message : "The job failed. The Job
was
>> >> invoked by Schedule 15 (IMPORT_DBF_TO_SQL). The last
>> step
>> >> to run was step 3 (IMPORT_DBF_TO_SQL)".
>> >>
>> >> What I Can do to solve this problem'
>> >>
>> >> Thanks
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||That is not the output file. In the job *step*, right tab, you have an option to specify an output
file for the jobstep. This is where all the messages from the command are written. After executing
the job, check this file.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
news:0a2d01c3b4fb$b7513790$a501280a@.phx.gbl...
> In the output file the message that appear are
> "SQL Server Scheduled Job 'import-DBF_to_SQL'
> (0x3CB9A4AA25D87B408BF4C3272F2F4C8B) - Status: Failed -
> Invoked on: 2003-11-27 04:00:00 - Message: The job
> failed. The Job was invoked by Schedule 15
> (IMPORT_DBF_TO_SQL). The last step to run was step 3
> (IMPORT_DBF_TO_SQL). "
>
> >--Original Message--
> >It is impossible for us to know why it fails when all you
> tell us is that it fails.
> >Specify an output file for that jobstep and look at the
> messages in there. Hopefully this program
> >produces output from which you can determine what it
> wrong.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at: http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
> >news:084901c3b4df$9edff550$a501280a@.phx.gbl...
> >> Hi,
> >>
> >> But its very strange, because i have in another SQL
> server
> >> the same job and it's ok!!
> >> the steps are:
> >> 1- DeleteCurrentData -- Transact-SQL Script
> >> 2- Convert DAT to DBF -- Transact-SQL Script
> >> 3- IMPORT_DBF_TO_SQL -- Operating System Command
> >>
> >>
> >>
> >>
> >> >--Original Message--
> >> >You need to see what Step 3 :- IMPORT_DBF_TO_SQL is
> >> trying to do.
> >> >
> >> >I would imagine it executes a DTS Package, hopefully
> that
> >> DTS package was
> >> >designed to produce a Log output file. That Log file
> will
> >> give you the real
> >> >reason for the failure.
> >> >
> >> >--
> >> >HTH
> >> >Ryan Waight, MCDBA, MCSE
> >> >
> >> >"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in
> message
> >> >news:0a4001c3b4d7$da8407c0$a301280a@.phx.gbl...
> >> >> Hi,
> >> >>
> >> >> I have put a job with 3 steps.
> >> >> But appear this message : "The job failed. The Job
> was
> >> >> invoked by Schedule 15 (IMPORT_DBF_TO_SQL). The last
> >> step
> >> >> to run was step 3 (IMPORT_DBF_TO_SQL)".
> >> >>
> >> >> What I Can do to solve this problem'
> >> >>
> >> >> Thanks
> >> >>
> >> >>
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

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 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 through scheduler

I run a DTS job manually, it works fine woth no proble.
However, if I schedule it to run, it always fails
with the following message: ( in the Event Viewer )
Event Type: Warning
Description:
SQL Server Scheduled Job 'BackorderByItemReport'
(0x6C0FDB5A6F7B6149AB8565F9F349FDE4) - Status: Failed -
Invoked on: 2003-09-09 14:44:00 - Message: The job
failed. The Job was invoked by Schedule 2
(BackorderByItemReport). The last step to run was step 1
(BackorderByItemReport).
Since the message doesn't provide enough info, I have no
idea about what's wrong. BTW, I have set up the
SQLServerAgent service running as a network user who is
also a member of the Local System Admin Group.
Has anybody experienced this?
Thanx.
Y.J.Yanjie,
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default.aspx?scid=kb;en-us;269074
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Yanjie Ren" <yren@.cc3.com> wrote in message
news:640d01c377aa$773abe30$a501280a@.phx.gbl...
> I run a DTS job manually, it works fine woth no proble.
> However, if I schedule it to run, it always fails
> with the following message: ( in the Event Viewer )
> Event Type: Warning
> Description:
> SQL Server Scheduled Job 'BackorderByItemReport'
> (0x6C0FDB5A6F7B6149AB8565F9F349FDE4) - Status: Failed -
> Invoked on: 2003-09-09 14:44:00 - Message: The job
> failed. The Job was invoked by Schedule 2
> (BackorderByItemReport). The last step to run was step 1
> (BackorderByItemReport).
> Since the message doesn't provide enough info, I have no
> idea about what's wrong. BTW, I have set up the
> SQLServerAgent service running as a network user who is
> also a member of the Local System Admin Group.
> Has anybody experienced this?
> Thanx.
> Y.J.
>

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

Job failing

I have a scheduled job on a SQL 2000 database which is failing. Here is the error message :

The job failed. Unable to determine if the owner (caci\snasir) of job Integrity Checks Job for DB Maintenance Plan 'IDS' has server access (reason: Could not obtain information about Windows NT group/user 'caci\snasir'. [SQLSTATE 42000] (Error 8198)).

I am the SA on the instance. I wonder why would I be getting this error message? I am able to logon to this instance and browse and change things. So clearly it recognizes me. But when I run the job it fails. Wonder why? my SQL Server version is 8.0.

The Job is owned by [caci\snasir]. The error indicates that SQL Server cannot validate [caci\snasir] credentials.

It may be better to transfer the job ownership to [sa].

Job failed with error 3624

Hi Guys,
In my develoment server, I got error with 3624 when job running, error
message is like:
Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:
m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
[SQLSTATE 01000] (Error 3624). The step failed.
The server was very slow, and like hang up. I cannot connect to server from
my computer. after while, maybe 4 minutes roughly, the server was recovered.
I got that error, and the job runing correctly.
the job runs every one minute to pupulate into a table, which selected from
other tables, and server is a subscriber server that has data replicated
from other server. Can somebody tell me what is reason? Thanks.Why nobody answer me this question? nobody had this error?
"Iter" wrote:
> Hi Guys,
> In my develoment server, I got error with 3624 when job running, error
> message is like:
> Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:
> m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
> [SQLSTATE 01000] (Error 3624). The step failed.
> The server was very slow, and like hang up. I cannot connect to server from
> my computer. after while, maybe 4 minutes roughly, the server was recovered.
> I got that error, and the job runing correctly.
> the job runs every one minute to pupulate into a table, which selected from
> other tables, and server is a subscriber server that has data replicated
> from other server. Can somebody tell me what is reason? Thanks.|||This can either be a corruption in the database (see DBCC CHECKDB) or a bug in the product (open a
case with MS if DBCC doesn't report a corruption).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:E9DF8C82-38F6-4737-A2FC-E775CA38D522@.microsoft.com...
> Why nobody answer me this question? nobody had this error?
>
> "Iter" wrote:
>> Hi Guys,
>> In my develoment server, I got error with 3624 when job running, error
>> message is like:
>> Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
>> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:
>> m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
>> [SQLSTATE 01000] (Error 3624). The step failed.
>> The server was very slow, and like hang up. I cannot connect to server from
>> my computer. after while, maybe 4 minutes roughly, the server was recovered.
>> I got that error, and the job runing correctly.
>> the job runs every one minute to pupulate into a table, which selected from
>> other tables, and server is a subscriber server that has data replicated
>> from other server. Can somebody tell me what is reason? Thanks.|||I checked the database with dbcc checkdb, no error reported. Is this sql
server software bug? Thanks.
"Tibor Karaszi" wrote:
> This can either be a corruption in the database (see DBCC CHECKDB) or a bug in the product (open a
> case with MS if DBCC doesn't report a corruption).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:E9DF8C82-38F6-4737-A2FC-E775CA38D522@.microsoft.com...
> > Why nobody answer me this question? nobody had this error?
> >
> >
> > "Iter" wrote:
> >
> >> Hi Guys,
> >> In my develoment server, I got error with 3624 when job running, error
> >> message is like:
> >> Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
> >> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:
> >> m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
> >> [SQLSTATE 01000] (Error 3624). The step failed.
> >> The server was very slow, and like hang up. I cannot connect to server from
> >> my computer. after while, maybe 4 minutes roughly, the server was recovered.
> >> I got that error, and the job runing correctly.
> >> the job runs every one minute to pupulate into a table, which selected from
> >> other tables, and server is a subscriber server that has data replicated
> >> from other server. Can somebody tell me what is reason? Thanks.
>|||Yes, if the database comes out clean, I'd strongly suspect a bug. Perhaps you can try this on the
most recent service pack and/or check if there are hotfixes available for this?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:C5F65767-84F7-4E7A-9E8E-444CBA9F55EB@.microsoft.com...
>I checked the database with dbcc checkdb, no error reported. Is this sql
> server software bug? Thanks.
>
> "Tibor Karaszi" wrote:
>> This can either be a corruption in the database (see DBCC CHECKDB) or a bug in the product (open
>> a
>> case with MS if DBCC doesn't report a corruption).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Iter" <Iter@.discussions.microsoft.com> wrote in message
>> news:E9DF8C82-38F6-4737-A2FC-E775CA38D522@.microsoft.com...
>> > Why nobody answer me this question? nobody had this error?
>> >
>> >
>> > "Iter" wrote:
>> >
>> >> Hi Guys,
>> >> In my develoment server, I got error with 3624 when job running, error
>> >> message is like:
>> >> Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
>> >> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:
>> >> m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
>> >> [SQLSTATE 01000] (Error 3624). The step failed.
>> >> The server was very slow, and like hang up. I cannot connect to server from
>> >> my computer. after while, maybe 4 minutes roughly, the server was recovered.
>> >> I got that error, and the job runing correctly.
>> >> the job runs every one minute to pupulate into a table, which selected from
>> >> other tables, and server is a subscriber server that has data replicated
>> >> from other server. Can somebody tell me what is reason? Thanks.
>>

JOB failed and QA

Hi,
I had created a sp run as a job, daily. if I execute this sp from QA, it's
work, clean.
but if I run the job, it failed with message (job details):
...ta would be truncated. [SQLSTATE 22001] (Error 8152) String or binary
data would be truncated. [SQLSTATE 22001] (Error 8152) String or binary
data would be truncated. [SQLSTATE 22001] (Error 8152) String or binary
data would be truncated. [SQLSTATE 22001] (Error 8152) String or binary
data would be truncated. [SQLSTATE 22001] (Error 8152) String or binary
data would be truncated. [SQLSTATE 22001] (Error 8152) String or binary
data would be truncated. [SQLSTATE 22001] (Error 8152) String or binary
data would be truncated. [SQLSTATE 22001] (Error 8152) String or binary
data would be truncated. [SQLSTATE 22001] (Error 8152) [SQLSTATE 01000]
(Error 0) The statement has been terminated. [SQLSTATE 01000] (Error 3621)
[SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) The statement has
been terminated. [SQLSTATE 01000] (Error 3621) [SQLSTATE 01000] (Error 0)
[SQLSTATE 01000] (Error 0) [SQLSTATE 0... The step failed.
the sp create a temporary table, fill some fields with sum() from other
table, then calculate the stock field from these fields value. at the end of
sp, the temporary table will update a table.
did I missed something?
I use SQL 7 sp 1 on NT4.
thanks in advance.
TeguhI think it's a data types problem too. so I've copied the exact columns from
the target table. all numeric type is decimal(18,2). There's no error
message when run from QA, it's fully worked.
both from QA and JOB I use the same command:
exec spproc_McUnscanQCMFG
but the job still fail. is there any different conditions for job and QA?
here the script:
Select [Item Code], [Item Name], [Stock PPS], [Stock Calc], [Differences],
[Beg. Stock], [Not Finish1Lot], Claim,
[MPC In], [MPC Out], [Scan MC], [WH Location], UOM, [Type]
Into #CheckInvMfg
From (Select IL_ItemCode as [Item Code], PartBom_Partname as [Item
Name],
IL_QuantityOnLocation as [Stock PPS],
IL_QuantityOnLocation as [Stock Calc],
IL_QuantityOnLocation as [Differences], IL_QuantityOnLocation
as [Beg. Stock],
IL_QuantityOnLocation as [Not Finish1Lot],
IL_QuantityOnLocation as Claim, IL_QuantityOnLocation as [MPC
In], IL_QuantityOnLocation as [MPC Out],
IL_QuantityOnLocation as [Scan MC], IL_WHLocation as [WH
Location],
PartBom_UnitOfMeasure as UOM, PartBOM_Type AS [Type]
From Tb_Ic_ItemLocation, Tb_Mst_PartBom Where Il_ItemCode =PartBom_partCode ) Mfg
-- Get / calculate Claim for Mfg
Update #CheckInvMfg
Set Claim = QtyClaim
From (Select cl_MatCode,
CASE CL_UOMClaim WHEN 'KG' THEN Sum( cl_ClaimQty) *
1000)
ELSE Sum(cl_ClaimQty)
END as QtyClaim
From tb_IC_Claim
Where Month(cl_lastupdate) = @.i_Periode and
Year(cl_lastupdate) = @.i_Tahun
and cl_moveto = @.i_MfgWarehouse and cl_postedstatus ='Posted'
Group by cl_matcode, CL_UOMClaim ) claim
Where cl_MatCode = [Item Code]
......
"jobi" <jobi@.reply2.group> wrote in message
news:bdph9e$jio$1@.reader08.wxs.nl...
> execute the same query in QA and put a "select min(sum_result ) ,
> max(sum_result ) from (yourquery) q " on it.
> Check for allowed values for them.
> Look at BOL for "Data Types"
> jobi|||The behaviour of the sp should be the same in QA than in sqlagent.
Are you sure you are running the same object ? (you don't specify e.g.
dbo.spproc_McUnscanQCMFG)
Check out if there exists more than one spproc_McUnscanQCMFG (with different
owners)
If not, check ms-site for issues with sql7 sp1 (btw sp4 is the current one)
jobi
"Teguh R" <priska@.hotpop.com> wrote in message
news:ORQmXgSQDHA.3144@.tk2msftngp13.phx.gbl...
> I think it's a data types problem too. so I've copied the exact columns
from
> the target table. all numeric type is decimal(18,2). There's no error
> message when run from QA, it's fully worked.
> both from QA and JOB I use the same command:
> exec spproc_McUnscanQCMFG
> but the job still fail. is there any different conditions for job and QA?
>
> here the script:
> Select [Item Code], [Item Name], [Stock PPS], [Stock Calc], [Differences],
> [Beg. Stock], [Not Finish1Lot], Claim,
> [MPC In], [MPC Out], [Scan MC], [WH Location], UOM, [Type]
> Into #CheckInvMfg
> From (Select IL_ItemCode as [Item Code], PartBom_Partname as [Item
> Name],
> IL_QuantityOnLocation as [Stock PPS],
> IL_QuantityOnLocation as [Stock Calc],
> IL_QuantityOnLocation as [Differences],
IL_QuantityOnLocation
> as [Beg. Stock],
> IL_QuantityOnLocation as [Not Finish1Lot],
> IL_QuantityOnLocation as Claim, IL_QuantityOnLocation as
[MPC
> In], IL_QuantityOnLocation as [MPC Out],
> IL_QuantityOnLocation as [Scan MC], IL_WHLocation as [WH
> Location],
> PartBom_UnitOfMeasure as UOM, PartBOM_Type AS [Type]
> From Tb_Ic_ItemLocation, Tb_Mst_PartBom Where Il_ItemCode => PartBom_partCode ) Mfg
> -- Get / calculate Claim for Mfg
> Update #CheckInvMfg
> Set Claim = QtyClaim
> From (Select cl_MatCode,
> CASE CL_UOMClaim WHEN 'KG' THEN Sum( cl_ClaimQty) *
> 1000)
> ELSE Sum(cl_ClaimQty)
> END as QtyClaim
> From tb_IC_Claim
> Where Month(cl_lastupdate) = @.i_Periode and
> Year(cl_lastupdate) = @.i_Tahun
> and cl_moveto = @.i_MfgWarehouse and cl_postedstatus => 'Posted'
> Group by cl_matcode, CL_UOMClaim ) claim
> Where cl_MatCode = [Item Code]
> ......
>
>
> "jobi" <jobi@.reply2.group> wrote in message
> news:bdph9e$jio$1@.reader08.wxs.nl...
> > execute the same query in QA and put a "select min(sum_result ) ,
> > max(sum_result ) from (yourquery) q " on it.
> >
> > Check for allowed values for them.
> > Look at BOL for "Data Types"
> > jobi
>
>|||IMO the "change the data type to exact type of target table" solved your
problem.
The upgrade to sp4 should make you sqlserver more reliable.
jobi
"Teguh R" <priska@.hotpop.com> wrote in message
news:uXfmJDATDHA.2148@.TK2MSFTNGP11.phx.gbl...
> I've installed sp4 and change the data type to exact type of target table,
> it's work now.
> But I still wonder, why previously it's works in QA but failed in JOB
> execution?
> I mean, QA has loose checking, less strong type setting parameters than
JOB
> execution?
>
> "jobi" <jobi@.reply2.group> wrote in message
> news:be39nd$gda$1@.reader08.wxs.nl...
> > The behaviour of the sp should be the same in QA than in sqlagent.
> >
> > Are you sure you are running the same object ? (you don't specify e.g.
> > dbo.spproc_McUnscanQCMFG)
> > Check out if there exists more than one spproc_McUnscanQCMFG (with
> different
> > owners)
> > If not, check ms-site for issues with sql7 sp1 (btw sp4 is the current
> one)
> >
> > jobi
> >
> >
> > "Teguh R" <priska@.hotpop.com> wrote in message
> > news:ORQmXgSQDHA.3144@.tk2msftngp13.phx.gbl...
> > > I think it's a data types problem too. so I've copied the exact
columns
> > from
> > > the target table. all numeric type is decimal(18,2). There's no error
> > > message when run from QA, it's fully worked.
> > >
> > > both from QA and JOB I use the same command:
> > >
> > > exec spproc_McUnscanQCMFG
> > >
> > > but the job still fail. is there any different conditions for job and
> QA?
> > >
> > >
> > >
> > > here the script:
> > >
> > > Select [Item Code], [Item Name], [Stock PPS], [Stock Calc],
> [Differences],
> > > [Beg. Stock], [Not Finish1Lot], Claim,
> > > [MPC In], [MPC Out], [Scan MC], [WH Location], UOM,
> [Type]
> > > Into #CheckInvMfg
> > > From (Select IL_ItemCode as [Item Code], PartBom_Partname as
> [Item
> > > Name],
> > > IL_QuantityOnLocation as [Stock PPS],
> > > IL_QuantityOnLocation as [Stock Calc],
> > > IL_QuantityOnLocation as [Differences],
> > IL_QuantityOnLocation
> > > as [Beg. Stock],
> > > IL_QuantityOnLocation as [Not Finish1Lot],
> > > IL_QuantityOnLocation as Claim, IL_QuantityOnLocation as
> > [MPC
> > > In], IL_QuantityOnLocation as [MPC Out],
> > > IL_QuantityOnLocation as [Scan MC], IL_WHLocation as [WH
> > > Location],
> > > PartBom_UnitOfMeasure as UOM, PartBOM_Type AS [Type]
> > > From Tb_Ic_ItemLocation, Tb_Mst_PartBom Where Il_ItemCode => > > PartBom_partCode ) Mfg
> > >
> > > -- Get / calculate Claim for Mfg
> > > Update #CheckInvMfg
> > > Set Claim = QtyClaim
> > > From (Select cl_MatCode,
> > > CASE CL_UOMClaim WHEN 'KG' THEN Sum( cl_ClaimQty)
*
> > > 1000)
> > > ELSE Sum(cl_ClaimQty)
> > > END as QtyClaim
> > > From tb_IC_Claim
> > > Where Month(cl_lastupdate) = @.i_Periode and
> > > Year(cl_lastupdate) = @.i_Tahun
> > > and cl_moveto = @.i_MfgWarehouse and
cl_postedstatus
> => > > 'Posted'
> > > Group by cl_matcode, CL_UOMClaim ) claim
> > > Where cl_MatCode = [Item Code]
> > > ......
> > >
> > >
> > >
> > >
> > > "jobi" <jobi@.reply2.group> wrote in message
> > > news:bdph9e$jio$1@.reader08.wxs.nl...
> > > > execute the same query in QA and put a "select min(sum_result ) ,
> > > > max(sum_result ) from (yourquery) q " on it.
> > > >
> > > > Check for allowed values for them.
> > > > Look at BOL for "Data Types"
> > > > jobi
> > >
> > >
> > >
> >
> >
>