5 Replies Latest reply: May 15, 2014 10:02 AM by Jeff C RSS

    Need understanding of scripts

    Jeff C

      Each day I receive a zip file that I need to process through Data Pump.  I have set up a batch process to is to open the zip file, unzip it to a specific directory.  The script is under the Script tabe on the Process Properties.

       

      Shell("""D:\Zip Extraction for WSJ\prebatch WAUDIT.bat""",AppWinStyle.Hide,True)

       

       

      Here is the batch:

       

      d:

       

      cd d:\7zip\

       

      7za.exe e -og:\"cis files"\"route smart" g:\"cis files"\DataPump\"Wall Street Journal"\WAUDT140085.ZIP

       

      If I edit, compile and test it works perfectly and the txt file is there for the process to run.  But I can not get the process to run the script so the process prerequisites are never met.  I have tried making it a Cmd on the XprjEditor as a prerequisite but it still will not run.

       

      Log file:

       

      11-04-2008 13:06:33 Created.

           

      time  2008-11-04T13:06:33

       

       

      + 11-04-2008 13:06:33 In PreProcess

           

      time  2008-11-04T13:06:33

       

       

      + 11-04-2008 13:06:33 Process prerequisites were not met: File '
      pmcserver\e\CIS FILES\ROUTE SMART\WAUDT140085.TXT' does not exist.

           

      time  2008-11-04T13:06:33

       

       

      + 11-04-2008 13:06:33 Retry has been scheduled for 2008-11-04T13:08:00

           

      time  2008-11-04T13:06:33

       

       

      + 11-04-2008 13:08:00 In PreProcess

           

      time  2008-11-04T13:08:00

       

       

      + 11-04-2008 13:08:00 Process prerequisites were not met: File '
      pmcserver\e\CIS FILES\ROUTE SMART\WAUDT140085.TXT' does not exist.

           

      time  2008-11-04T13:08:00

       

       

      + 11-04-2008 13:08:00 Retry has been scheduled for 2008-11-04T13:09:00

           

      time  2008-11-04T13:08:00

       

       

      + 11-04-2008 13:08:36 Cancel requested.

           

      time  2008-11-04T13:08:36

       

       

      + 11-04-2008 13:08:36 Cancelled.

       

       

      Anyone have any ideas what I am doing wrong?

        • Need understanding of scripts
          joey

          Is the D drive or G drive in your script a network mapped drive?

            • Need understanding of scripts
              Jeff C

              D: is local, g is mapped.  I changed the batch to:

               

               

              net use /DELETE g:

               

              net use g:
              pmcserver\e

               

              d:

               

              cd d:\7zip\

               

              7za.exe e -og:\"cis files"\"route smart" g:\"cis files"\datapump\"wall street journal"\JAUDT140084.ZIP

               

              The batch files work perfectly and the project works perfectly but I can not get the project to execute the batch. 

               

               

              Here is what happens when I run the process:

               

              11-06-2008 16:24:38 Created.

                   

              time  2008-11-06T16:24:38

               

               

              + 11-06-2008 16:24:48 Process prerequisites were not met: External process failed to complete in 10000 milliseconds.

                   

              time  2008-11-06T16:24:48

               

               

              + 11-06-2008 16:24:48 Retry has been scheduled for 2008-11-06T16:26:00

                   

              time  2008-11-06T16:24:48

               

               

              + 11-06-2008 16:26:10 Process prerequisites were not met: External process failed to complete in 10000 milliseconds.

                   

              time  2008-11-06T16:26:10

               

               

              + 11-06-2008 16:26:10 Retry has been scheduled for 2008-11-06T16:27:00

                   

              time  2008-11-06T16:26:10

               

               

              + 11-06-2008 16:26:23 Cancel requested.

                   

              time  2008-11-06T16:26:23

               

               

              + 11-06-2008 16:26:23 Cancelled.

               

              Still confused.  I am sure that there is just something simple that needs to be changed, but don't know what. 

              Thanks