Strange application pop-up error!

Discussion in 'microsoft.public.sqlserver.server' started by Patrick, Oct 11, 2005.

  1. Patrick

    Patrick Guest

    I note many occurence of the following error on a Windows 2000 server with
    SP4, running SQL Server 2000 client:
    Event Type: Information
    Event Source: Application Popup
    Event Category: None
    Event ID: 26
    Date: 10/10/2005
    Time: 09:12:06
    User: N/A
    Computer: MyServer
    Description:
    Application popup: cscript.exe - Application Error : The instruction at
    "0x77f813c1" referenced memory at "0x00000000". The memory could not be
    "read".

    Click on OK to terminate the program
    Click on CANCEL to debug the program

    For more information, see Help and Support Center at
    http://go.microsoft.com/fwlink/events.asp.

    I have referenced
    http://dbforumz.com/DTS-run.exe-Application-Error-ftopict27398.html, but the
    DTS system.out Log indicate the following:
    DTSRun: Loading...
    DTSRun: Executing...
    DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
    DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
    DTSRun OnStart: DTSStep_DTSActiveScriptTask_2
    DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2
    DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1

    i.e., it was merely executing a single line stored procedure (which should
    take <1 second to complete) with SQLTask_1 and SQLTask_2.

    Confused? Any clues why this is the case and how to resolve it?
     
    Patrick, Oct 11, 2005
    #1
    1. Advertisements

  2. Patrick

    Patrick Guest

    Also, the SQL task for SQL_Task1 and SQL_Task2 are against a SQL Server 2000
    database (on another server) using Microsoft OLE DB Provider for SQL Server.
    The DTS package being executed are in structured DTS file in another Windows
    2000 server.
     
    Patrick, Oct 11, 2005
    #2
    1. Advertisements

  3. Patrick

    Jerry Spivey Guest

    Patrick,

    CScript is the host to run the ActiveX scripts on the server. Is CScript
    installed on that server? Are you asking an end-user to interact with a
    popup window? I'd probably break this package down into individual steps
    and troubleshoot from there - easier to determine the offending code. i.e.,
    does the ActiveX parts work by themselves?, the T-SQL parts?

    HTH

    Jerry
     
    Jerry Spivey, Oct 11, 2005
    #3
  4. Hello,

    CScript.exe is the version of Windows Script Host that enables you to run
    scripts from the command prompt:

    http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/wsh/htm/wsR
    unCscript.asp

    To narrow down the issue, please answer the following questions or perform
    steps:

    1. Which application caused this error and when this error occurred? If
    you manually execute the DTS package, did you receive a popup dialog window
    that give the same error message? Can you reproduce the error?

    2. Run a sample Script file:

    a. Create a txt file, which includes the following code:

    wscript.echo "hello world!"

    b. Change the file extension from txt to vbs. Save the file as
    myscript.vbs

    c: Open a command prompt window, run the following code in the window:

    cscript "e:\temp\myscript.vbs"

    Note: by default, cscript.exe is located in the C:\WINDOWS\system32 folder.

    If the sample vbs file can be run successfully, replace the sample file
    with your vbs file and run again. If it fails, check you code. I hope the
    information is helpful.

    Sophie Guo
    Microsoft Online Partner Support

    Get Secure! - www.microsoft.com/security

    =====================================================
    When responding to posts, please "Reply to Group" via your newsreader so
    that others may learn and benefit from your issue.
    =====================================================
    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Sophie Guo [MSFT], Oct 12, 2005
    #4
  5. Patrick

    Lyn Duong Guest

    Hi Sophie,

    I just noticed this email stream and thought I'd ask you for some help
    regarding a similar problem that I am experiencing with dtsrun.exe when
    running a package that does a simple table transformation from sqlserver to
    oracle database.
    I've got sql server 2000 enterprise edition, sp4 installed on windows 2k3 sp1.

    Thanks
    Lyn
     
    Lyn Duong, Nov 3, 2005
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.