3 Replies Latest reply: Jun 11, 2012 10:29 AM by Rob Wunderlich RSS

    Problem executing VBScript with database connection in QMC

    Uday Kumar

      Hi,

       

      I have written a VB Script which connects to database and uses the select query and gets some status flag.

      Using that flag, am checking that condition in the VB Script and archiving the previous qvw file.

      so i have given that vb script path in the Supporting task->External Program-> VB Script task.

      I have given the BAT file which calls the VB Script.

      If i run the BAT file directly, then it works perfectly, but if i run the task in the server, then its showing running, but the archival is not happening.

      Is it because of database connectivity in VB Script, which is making it not to archive?

      can anyone help me?

        • Problem executing VBScript with database connection in QMC
          Rob Wunderlich

          Can you write some log messages out of your script so you can determine what is happening?

           

          -Rob

            • Problem executing VBScript with database connection in QMC
              Uday Kumar

              Hi Rob,

               

              This is the details in the log file

               

              (2012-06-05 14:01:25) Information: Starting task'MARA_ARCHIVE_SCRIPT'. Id:4d2d8042-2504-47da-803d-300d480c391c. Triggered by'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

              (2012-06-05 14:01:25) Information: Entering TaskExecution.

              (2012-06-05 14:01:25) Information: ClusterID=1

              (2012-06-05 14:01:25) Information:QDSID=a9bc0df3-80ed-5137-c0ef-67a390a017ed

              (2012-06-05 14:01:25) Information:TaskID=4d2d8042-2504-47da-803d-300d480c391c

              (2012-06-05 14:01:25) Information:MaxRunTime=1.00:00:00

              (2012-06-05 14:01:25) Information:MachineName=WA00488D

              (2012-06-05 14:01:25) Information: Max attempts:1

              (2012-06-05 14:01:25) Information: Current Attempt=0

              (2012-06-05 14:01:25) Information: Task Dependenciesare OK

              (2012-06-05 14:01:25) Information: Executing "\\Servername\Current\RunVBScript.bat"

              (2012-06-05 14:01:25) Information: Executing commandline:"

              \\Servername\Current\RunVBScript.bat

              " in folder"

              \\Servername\Current".

              (2012-06-05 14:01:28) Information: Process exitedwith exit code: 0 at 6/5/2012 2:01:28 PM

              (2012-06-05 14:01:28) Information: Process exitedwith exit code: 0 at 6/5/2012 2:01:28 PM

              (2012-06-05 14:01:28) Information: Task Execute Duration=00:00:02.9173496

              (2012-06-05 14:01:28) Information: The task"MARA_ARCHIVE_SCRIPT" finished successfully

              (2012-06-05 14:01:28) Information:TaskResult.status=Finished

              (2012-06-05 14:01:28) Information: Notifying alltriggers of new state:Finished

              (2012-06-05 14:01:28) Information: Notifying alltriggers of new state:Finished - completed

              (2012-06-05 14:01:28) Information: Saving TaskResult

               

              It shows its executed successfully, but its not archiving