Multi-step Job Execution in IPD

 37 Replies
 3 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Page 2 of 2 << < 12
Author
Messages
steve finger
Veteran Member
Posts: 47
Veteran Member
    and why is this still multi-step?
    TimC
    Veteran Member
    Posts: 84
    Veteran Member
      Because that's the way it was created. The error that I'm getting is "JOB #### NOT FOUND" when it clearly exists under the same domain service account that I'm logged into IPD as. Why is the job not being found?
      But, we did create another test simple job and still getting the error. We're at v10.
      steve finger
      Veteran Member
      Posts: 47
      Veteran Member
        so, if you are logged in to LID, TEST product line, logged in as "serviceuser", pull up the AP150, enter 101EMP as the jobname name and hit inquire, you don't get "job not found"?
        TimC
        Veteran Member
        Posts: 84
        Veteran Member
          That's the oddity. It's absolutely there. It's a multi-step. So, I wonder if I'm missing something in the query string to identity the job/step...
          JimY
          Veteran Member
          Posts: 510
          Veteran Member
            I seem to remember someone mentioning that if the job is created using LID that it would not be available to a webrun. If it is created through Portal then it is. Not sure why.
            steve finger
            Veteran Member
            Posts: 47
            Veteran Member
              And why would that be? My mom told me when i was mere tadpole that if i swalllowed my gum, it would stay in my stomach for 7 years.

              I know from exerience that LID jobs can be used in a webrun. Just to make sure, i created a test this morning with a CU201 and ran it. IPAv10.1.1.43
              steve finger
              Veteran Member
              Posts: 47
              Veteran Member

                Because having multi-step jobs is an unnecessary complication in IPA, i've never had the need to do anything as a multi-step job...so i can't address the issue with experience backing me up.

                but before i'd bang my head against the wall for days trying to make it work, i'd take a few minutes and break it into separate jobs.

                David Williams
                Veteran Member
                Posts: 1127
                Veteran Member
                  I was going off of my previous experience (where I couldn't see jobs created in LID within Portal) when I said I didn't think LID jobs could be executed via the Web Run and Steve corrected my misunderstanding.
                  David Williams
                  steve finger
                  Veteran Member
                  Posts: 47
                  Veteran Member

                    Not trying to be "snarky"...just trying to point out with a little humor that we shouldn't believe everything we hear.... especially in a place where expert opinion is expected.

                     

                    plus it's early.....a lighter, kinder, gentler time and place for some folks

                    Bob Canham
                    Veteran Member
                    Posts: 217
                    Veteran Member
                      you can run multi-step jobs using webrun fine, there shouldn't be a problem with that. Where you'll run into issues is with trying to use a Lawson Transaction node to query and update the job parameters.

                      When you create a job in jobdef, it is a multistep job. These cannot be opened on the program forms (i.e. AP150) because the forms don't have a mechanism to target a specific step. Because IPA uses the same API as portal, you're limited to only things that can be done in portal. So, any jobs that you want to update in IPA need to be created on the program form, not in jobdef.
                      TimC
                      Veteran Member
                      Posts: 84
                      Veteran Member
                        Got the answer from Infor. ***********

                        Fix:
                        1. see KB1661080. You need to feed vars _f12-_f18 AND the _STEPNBR var is ZERO-based. So, the first step is _STEPNBR=0 and the 2nd step=1 and so on....

                        Fix:
                        A cool technique they gave me is to download Fiddler. www.Fiddler.com
                        2 .Run Fidder with Capturing on (first panel in status bar at bottom left). Click on/off.
                        type "cls" to clear the results in the black bar just above the status bar to the left
                        3. Update the job in Mingle.
                        4. Turn off capturing in Fidder
                        5. Look at the results box and select the URL: 'servlet/Router/Transaction/Erp.
                        That will display all the xml parameters you'll need in the transaction query.
                        6. Create a LawsonQuery node for each step and pass in the appropriate parameters.
                        TimC
                        Veteran Member
                        Posts: 84
                        Veteran Member
                          OK. I got thru to INFOR. They helped me with the syntax of the Multi-step job. It requires _STEPNBR and several _f# values in order to update. They had me use Fiddler and turn on "Capturing", then hit the "Change" button in mingle to save the job parms. Then go back to fiddler and turn off Capturing. If you go back to the Results panel in Fiddler, and click one of the results, it will return the XML with _f12-_f18 values that need to be submitted. Also, the _STEPNBR parameter is 0-based. So, Step 1 is _STEPNBR 0 and so on. I just replaced some of the values with variables. You'll need a query for each step. So, I run the job via a WebRun node, then update the date parameters for the next time it's supposed to run. Some run all 5 biz days, some Tuesdays, some Thursdays, etc... I have a subflow that calc's the next dates based on today that returns payment and payThrough dates for the next ones coming up. Daily would be tmro, Next Tues, next thurs. I have javascript Assign node that receives the parameters, then also I have a custom database with holiday dates. It queries that and checks if the paymentDate is a holiday and adds a day if so. It returns the dates as a string "paymentDate:20170405|payThroughDate:20170406". it also doesn't seem to support returning that as a JSON structure {surrounded by braces}. So, I had to treat it as a string. No biggie.

                          So, I appended this to the query and got it to run.
                          &_STEPNBR=0&_f12=&_f13=.prt&_f14=&_f15=&_f16=1_f17=Yes&_f18=D:\Infortest\law/print///1
                          TimC
                          Veteran Member
                          Posts: 84
                          Veteran Member
                            Ah.. this web site cut out the parameter values in the query string. So, I'll rewrite.

                            &_STEPNBR=0&_f12=&_f13=.prt&_f14=&_f15=&_f16=1_f17=Yes&_f18=D:\Infortest\law/print/(!userName)/(!jobName)/1
                            Page 2 of 2 << < 12