locked
SQL Job Error RRS feed

  • Question

  • Hi Experts,

    I am getting following error while executing my package using SQL Server Agent Job.

    Error:

    Message
    Executed as user: G4SAAS\svc-sql. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.1600.1 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  2:25:20 AM  Error: 2010-12-18 02:25:24.04     Code: 0x00000001     Source: File Size      Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.     at System.Windows.Forms.MessageBox.ShowCore(IWin32Window owner, String text, String caption, MessageBoxButtons buttons, MessageBoxIcon icon, MessageBoxDefaultButton defaultButton, MessageBoxOptions options, Boolean showHelp)     at System.Windows.Forms.MessageBox.Show(String text)     at ST_749f47aa478f44f8961f1d07140a042c.csproj.ScriptMain.Main()     --- End of inner exception stack trace ---     at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)     at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)     at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)     at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)     at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)     at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)     at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  2:25:20 AM  Finished: 2:25:24 AM  Elapsed:  4.094 seconds.  The package execution failed.  The step failed.

     

    Please Help me to solve the issue and run my job.

    Thanks in Advance,

     


    Siva
    Saturday, December 18, 2010 7:34 AM

All replies

  • It looks like there is a script that is displaying a message box.  Hopefully it will be a direct call, where the script task or component itself is displaying a message box.  The line will be something like MessageBox.Show or some such. Otherwise it could be an assembly that a script task is referencing.


    Russel Loski, MCT
    Saturday, December 18, 2010 12:05 PM
  • This could be a bug - check out the connect post here.

     

    Although, it very well may not be, check this post out to see if it helps

     


    Please 'Mark as Answer' if found helpful - Chris@tier-1-support

    Tier 1 Support
    Saturday, December 18, 2010 4:53 PM