incomplete PA531

 8 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Jenny Rodriguez
Basic Member
Posts: 9
Basic Member
    We are in the process of testing the APLLOADCSV file we received from our ATS, implementation process still; however the job goes to recovery mode (log below).  I can't figure out why it won't complete.  

    User: LMCNT\JR256107 Job: ATSPA531 Queue: ********** BEGIN: Job Submitted: Wed Jun 25 16:59:24 2014 Step 1: PA531 Started. . . . . .: Wed Jun 25 16:59:24 2014 Token Command. . . . . .: E:\lsftest\law\test\obj\PA531.gnt Executable Command . . .: e:\netexpress\base\bin\win64\run.exe E:\lsftest\law\test\obj\PA531.gnt test NT000000d7 ATSPA531 1 Process ID . . . . . . .: 4532 Running as Account . . .: LMCNT\JR256107 Program Messages: ** Creating .prt and .dtl files Processing PA531 - Applicant Conversion Program **** File Attributes Set For File: APLLOADCSV **** File Path Name was taken from the Work File Name File Options were taken from Users Locale File PathName: E:\lsftest\law/test/work/APLLOADCSV/APLLOADCSV File Options: HasHeader = Yes XlHeader = Yes FldSep ->,<- DateFmt =MMDDCCYY DateSep ->/<- TimeSep ->:<- DecimalSep ->.<- ThouSep -> <- QuoteChar ->"<- FileTerm = None LineTerm = None **** End of File Attributes For File: APLLOADCSV **** **** File Attributes Set For File: APLOUTCSV **** File Path Name was taken from the Work File Name File Options were taken from Users Locale File PathName: E:\lsftest\law/test/work/APLOUTCSV/APLOUTCSV File Options: HasHeader = Yes XltHeader = Yes FldSep ->,<- DateFmt =MMDDCCYY DateSep ->/<- TimeSep ->:<- DecimalSep ->.<- ThouSep -> <- QuoteChar ->"<- FileTerm = None LineTerm = None **** End of File Attributes For File: APLOUTCSV **** Elapsed Time . . . . . .: 00:00:01 ERROR: Stopped On Exit 9. Elapsed Time: 00:00:02 END: Job Ended: Wed Jun 25 16:59:26 2014 
    Jenny Rodriguez
    Basic Member
    Posts: 9
    Basic Member

      User: LMCNT\JR256107                      Job: ATSPA531        Queue: **********

      BEGIN:  Job Submitted:  Wed Jun 25 16:59:24 2014

       

        Step  1:  PA531 Started. . . . . .:  Wed Jun 25 16:59:24 2014

                  Token Command. . . . . .:  E:\lsftest\law\test\obj\PA531.gnt

                  Executable Command . . .:  e:\netexpress\base\bin\win64\run.exe E:\lsftest\law\test\obj\PA531.gnt test NT000000d7 ATSPA531 1

                  Process ID . . . . . . .:  4532

                  Running as Account . . .:  LMCNT\JR256107               

                  Program Messages:

      ** Creating .prt and .dtl files

      Processing PA531 - Applicant Conversion Program

      **** File Attributes Set For File: APLLOADCSV ****

        File Path Name was taken from the Work File Name

        File Options were taken from Users Locale

        File PathName: E:\lsftest\law/test/work/APLLOADCSV/APLLOADCSV             

        File Options:

          HasHeader  = Yes

          XltHeader  = Yes

          FldSep     ->,<- 

          DateFmt    =MMDDCCYY

          DateSep    ->/<-

          TimeSep    ->:<-

          DecimalSep ->.<-

          ThouSep    -> <-

          QuoteChar  ->"<-

          FileTerm   = None

          LineTerm   = None

      **** End of File Attributes For File: APLLOADCSV ****

      **** File Attributes Set For File: APLOUTCSV  ****

        File Path Name was taken from the Work File Name

        File Options were taken from Users Locale

        File PathName: E:\lsftest\law/test/work/APLOUTCSV/APLOUTCSV               

        File Options:

          HasHeader  = Yes

          XltHeader  = Yes

          FldSep     ->,<- 

          DateFmt    =MMDDCCYY

          DateSep    ->/<-

          TimeSep    ->:<-

          DecimalSep ->.<-

          ThouSep    -> <-

          QuoteChar  ->"<-

          FileTerm   = None

          LineTerm   = None

      **** End of File Attributes For File: APLOUTCSV  ****

                  Elapsed Time . . . . . .:  00:00:01

       

        ERROR:    Stopped On Exit 9.

        Elapsed Time:  00:00:02

       

      END:    Job Ended:  Wed Jun 25 16:59:26 2014

       

         

       

      M.J.
      Veteran Member
      Posts: 38
      Veteran Member

        I am no expert on this but I would say it may be the file path name that is setup in the job - it looks like the path has mixed back slashes and forward slashes.

        <<< yours has this path >>>
        File PathName: E:\lsftest\law/test/work/APLLOADCSV/APLLOADCSV             

        My system is on a Unix so that path looks different that this but don't think it would like the mixed path name. I believe with windows it should be all \

        Jenny Rodriguez
        Basic Member
        Posts: 9
        Basic Member
          thanks! I noticed that.  How do i change the file path name? 
          M.J.
          Veteran Member
          Posts: 38
          Veteran Member
            I'm not sure if windows is the same as Unix, I have to use LID to setup my job parameters as portal doesn't have this setting.
            Jenny Rodriguez
            Basic Member
            Posts: 9
            Basic Member

              I was able to change the file path using jobdef in LID.  Still same result.
              jaherb
              Veteran Member
              Posts: 164
              Veteran Member
                Since you are using the default path for the input file, try blanking out the path name and see if the program resolves the file location.... it should.   But also make sure the file is labeled correctly and in the correct path.   It should be in the following path....

                %LAWDIR%//work/APLLOADCSV.   And the file name should be APLLOADCSV.

                Ragu Raghavan
                Veteran Member
                Posts: 476
                Veteran Member
                  I would put in some DISPLAY statemnents, recompile and re-run the job to see where exactly the code bombs at. If this was related to the csv file, I expect to see an error message like this:

                  Unable To Open File With Mode "r"
                  /law9/law/prod/work/wkgx500a/wkgx500a
                  File Open Error:: No such file or directory
                  J Haveman
                  New Member
                  Posts: 3
                  New Member

                    Did you ever solve this problem?