Prev
Next
Forums Integration / Customization IPA/ProcessFlow

PA52 ProcessFlow

 10 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
kdcoate
Veteran Member
Posts: 44
Veteran Member
7/27/2009 5:44 PM
    I have a ProcessFlow set up to read data from a file and create pending personnel actions.  I've included all of the PCT-FLD-NBR and PAT-NEW-VALUE fields along with the _HK value.  When I build the AGS call in ProcessFlow, cut and paste it from the ProcessFlow log and execute it through the browser, the personnel actions are added correctly.  However, when I run the ProcessFlow and the AGS call is executed through ProcessFlow, I receive the error "New value must be spcaes because line has no item."  Does anyone have any suggestions?
    John Henley
    Posts: 3353
    7/27/2009 7:07 PM
      Can you post the AGS call here?
      How exactly are you addressing field number and new value...it's PAT-FLD-NBR-1 (1:12), PAT-FLD-NBR-2 (1:12), etc. and PCT-NEW-VALUE-1(1:12), etc.
      Thanks for using the LawsonGuru.com forums!
      John
      kdcoate
      Veteran Member
      Posts: 44
      Veteran Member
      7/27/2009 7:38 PM
        Here's the call: 

        _PDL=CBPROD9&_TKN=PA52.1&_E...;_EOT=TRUE

        I've also tried changing the Field Names and New Values to just PAT-FLD-NBR-1, PCT-NE-VALUE-1 but I haven't had any luck with that either.  Thanks John.

        kdcoate
        Veteran Member
        Posts: 44
        Veteran Member
        7/27/2009 7:43 PM
          _PDL=CBPROD9&_TKN=PA52.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=A&PCT-COMPANY=1&PCT-EMPLOYEE=3210&PCT-ACTION-CODE=SALARY%20%20%20%20&PCT-EFFECT-DATE=20090727&PCT-REASON1=MARKET&PCT-REASON2=RESPON&IMMEDIATE-ACTION=N&PCT-UPDATE-BENEFIT=Y&PCT-UPD-ABS-MGMT=N&PCT-UPDATE-REQ-DED=N&PCT-EDM-EFFECT-DT=20090727&PAT-FLD-NBR-1Ar1=64&PAT-FLD-NBR-1Ar2=73&PAT-FLD-NBR-1Ar3=135&PAT-FLD-NBR-1Ar4=63&PAT-FLD-NBR-1Ar5=136&PAT-FLD-NBR-1Ar6=106&PAT-FLD-NBR-1Ar7=62&PAT-FLD-NBR-1Ar8=%20&PAT-FLD-NBR-1Ar9=%20&PAT-FLD-NBR-1Ar10=%20&PAT-FLD-NBR-1Ar11=%20&PAT-FLD-NBR-1Ar12=%20&PAT-FLD-NBR-2Ar1=%20PAT-FLD-NBR-2Ar2=%20PAT-FLD-NBR-2Ar3=%20PAT-FLD-NBR-2Ar4=%20PAT-FLD-NBR-2Ar5=%20PAT-FLD-NBR-2Ar6=%20PAT-FLD-NBR-2Ar7=%20PAT-FLD-NBR-2Ar8=%20PAT-FLD-NBR-2Ar9=%20PAT-FLD-NBR-2Ar10=%20PAT-FLD-NBR-2Ar11=%20PAT-FLD-NBR-2Ar12=%20&PAT-FLD-NBR-3Ar1=%20PAT-FLD-NBR-3Ar2=%20PAT-FLD-NBR-3Ar3=%20PAT-FLD-NBR-3Ar4=%20PAT-FLD-NBR-3Ar5=%20PAT-FLD-NBR-3Ar6=%20PAT-FLD-NBR-3Ar7=%20PAT-FLD-NBR-3Ar8=%20PAT-FLD-NBR-3Ar9=%20PAT-FLD-NBR-3Ar10=%20PAT-FLD-NBR-3Ar11=%20PAT-FLD-NBR-3Ar12=%20&PCT-NEW-VALUE-1r1=%20&PCT-NEW-VALUE-1r2=%20&PCT-NEW-VALUE-1r3=%20&PCT-NEW-VALUE-1r4=%20&PCT-NEW-VALUE-1r5=%20&PCT-NEW-VALUE-1r6=%20&PCT-NEW-VALUE-1r7=88752.61&PCT-NEW-VALUE-1r8=%20&PCT-NEW-VALUE-1r9=%20&PCT-NEW-VALUE-1r10=%20&PCT-NEW-VALUE-1r11=%20&PCT-NEW-VALUE-1r12=%20&PCT-NEW-VALUE-2r1=%20&PCT-NEW-VALUE-2r2=%20&PCT-NEW-VALUE-2r3=%20&PCT-NEW-VALUE-2r4=%20&PCT-NEW-VALUE-2r5=%20&PCT-NEW-VALUE-2r6=%20&PCT-NEW-VALUE-2r7=%20&PCT-NEW-VALUE-2r8=%20&PCT-NEW-VALUE-2r9=%20&PCT-NEW-VALUE-2r10=%20&PCT-NEW-VALUE-2r11=%20&PCT-NEW-VALUE-2r12=%20&PCT-NEW-VALUE-3r1=%20&PCT-NEW-VALUE-3r2=%20&PCT-NEW-VALUE-3r3=%20&PCT-NEW-VALUE-3r4=%20&PCT-NEW-VALUE-3r5=%20&PCT-NEW-VALUE-3r6=%20&PCT-NEW-VALUE-3r7=%20&PCT-NEW-VALUE-3r8=%20&PCT-NEW-VALUE-3r9=%20&PCT-NEW-VALUE-3r10=%20&PCT-NEW-VALUE-3r11=%20&PCT-NEW-VALUE-3r12=%20&_HK=0001000003210SALARY%20%20%20%2020090727&_DELIM=%09&_OUT=XML&_EOT=TRUE
          Gary Davies
          Veteran Member
          Posts: 248
          Veteran Member
          7/27/2009 7:56 PM
            Dont pass %20 for the Fld Nbrs and New Values you are not setting a value for.

            Your call should look like this:

            PDL=CBPROD9&_TKN=PA52.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=A&PCT-COMPANY=1&PCT-EMPLOYEE=3210&PCT-ACTION-CODE=SALARY%20%20%20%20&PCT-EFFECT-DATE=20090727&PCT-REASON1=MARKET&PCT-REASON2=RESPON&IMMEDIATE-ACTION=N&PCT-UPDATE-BENEFIT=Y&PCT-UPD-ABS-MGMT=N&PCT-UPDATE-REQ-DED=N&PCT-EDM-EFFECT-DT=20090727&PAT-FLD-NBR-1Ar1=64&PAT-FLD-NBR-1Ar2=73&PAT-FLD-NBR-1Ar3=135&PAT-FLD-NBR-1Ar4=63&PAT-FLD-NBR-1Ar5=136&PAT-FLD-NBR-1Ar6=106&PAT-FLD-NBR-1Ar7=62&PCT-NEW-VALUE-1r7=88752.61&_HK=0001000003210SALARY%20%20%20%2020090727&_DELIM=%09&_OUT=XML&_EOT=TRUE

            Any NEW-VALUE field you do want to blank you must pass the value *BLANK.

            John Henley
            Posts: 3353
            7/27/2009 7:58 PM
              Posted By kdcoate on 07/27/2009 03:43 PM
              _PDL=CBPROD9&_TKN=PA52.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=A&PCT-COMPANY=1&PCT-EMPLOYEE=3210&PCT-ACTION-CODE=SALARY%20%20%20%20&PCT-EFFECT-DATE=20090727&PCT-REASON1=MARKET&PCT-REASON2=RESPON&IMMEDIATE-ACTION=N&PCT-UPDATE-BENEFIT=Y&PCT-UPD-ABS-MGMT=N&PCT-UPDATE-REQ-DED=N&PCT-EDM-EFFECT-DT=20090727&PAT-FLD-NBR-1Ar1=64&PAT-FLD-NBR-1Ar2=73&PAT-FLD-NBR-1Ar3=135&PAT-FLD-NBR-1Ar4=63&PAT-FLD-NBR-1Ar5=136&PAT-FLD-NBR-1Ar6=106&PAT-FLD-NBR-1Ar7=62&PAT-FLD-NBR-1Ar8=%20&PAT-FLD-NBR-1Ar9=%20&PAT-FLD-NBR-1Ar10=%20&PAT-FLD-NBR-1Ar11=%20&PAT-FLD-NBR-1Ar12=%20&PAT-FLD-NBR-2Ar1=%20PAT-FLD-NBR-2Ar2=%20PAT-FLD-NBR-2Ar3=%20PAT-FLD-NBR-2Ar4=%20PAT-FLD-NBR-2Ar5=%20PAT-FLD-NBR-2Ar6=%20PAT-FLD-NBR-2Ar7=%20PAT-FLD-NBR-2Ar8=%20PAT-FLD-NBR-2Ar9=%20PAT-FLD-NBR-2Ar10=%20PAT-FLD-NBR-2Ar11=%20PAT-FLD-NBR-2Ar12=%20&PAT-FLD-NBR-3Ar1=%20PAT-FLD-NBR-3Ar2=%20PAT-FLD-NBR-3Ar3=%20PAT-FLD-NBR-3Ar4=%20PAT-FLD-NBR-3Ar5=%20PAT-FLD-NBR-3Ar6=%20PAT-FLD-NBR-3Ar7=%20PAT-FLD-NBR-3Ar8=%20PAT-FLD-NBR-3Ar9=%20PAT-FLD-NBR-3Ar10=%20PAT-FLD-NBR-3Ar11=%20PAT-FLD-NBR-3Ar12=%20&PCT-NEW-VALUE-1r1=%20&PCT-NEW-VALUE-1r2=%20&PCT-NEW-VALUE-1r3=%20&PCT-NEW-VALUE-1r4=%20&PCT-NEW-VALUE-1r5=%20&PCT-NEW-VALUE-1r6=%20&PCT-NEW-VALUE-1r7=88752.61&PCT-NEW-VALUE-1r8=%20&PCT-NEW-VALUE-1r9=%20&PCT-NEW-VALUE-1r10=%20&PCT-NEW-VALUE-1r11=%20&PCT-NEW-VALUE-1r12=%20&PCT-NEW-VALUE-2r1=%20&PCT-NEW-VALUE-2r2=%20&PCT-NEW-VALUE-2r3=%20&PCT-NEW-VALUE-2r4=%20&PCT-NEW-VALUE-2r5=%20&PCT-NEW-VALUE-2r6=%20&PCT-NEW-VALUE-2r7=%20&PCT-NEW-VALUE-2r8=%20&PCT-NEW-VALUE-2r9=%20&PCT-NEW-VALUE-2r10=%20&PCT-NEW-VALUE-2r11=%20&PCT-NEW-VALUE-2r12=%20&PCT-NEW-VALUE-3r1=%20&PCT-NEW-VALUE-3r2=%20&PCT-NEW-VALUE-3r3=%20&PCT-NEW-VALUE-3r4=%20&PCT-NEW-VALUE-3r5=%20&PCT-NEW-VALUE-3r6=%20&PCT-NEW-VALUE-3r7=%20&PCT-NEW-VALUE-3r8=%20&PCT-NEW-VALUE-3r9=%20&PCT-NEW-VALUE-3r10=%20&PCT-NEW-VALUE-3r11=%20&PCT-NEW-VALUE-3r12=%20&_HK=0001000003210SALARY%20%20%20%2020090727&_DELIM=%09&_OUT=XML&_EOT=TRUE

              I don't know if this happened when you posted it or not, but some of your values are missing the ampersand between them, and that might be causing the AGS call to think you are populating something that you don't mean to...
              Thanks for using the LawsonGuru.com forums!
              John
              kdcoate
              Veteran Member
              Posts: 44
              Veteran Member
              7/27/2009 8:08 PM
                I tried that as well, but I still received the same error. Do you know the difference between the way the call is processed in the browser and the way it's processed through ProcessFlow?
                John Henley
                Posts: 3353
                7/27/2009 8:40 PM
                  Two other things to look at:
                  1- Remember that in LSF9, rows start with zero--not one, so r1 thru r12 should be r0 thru r11.
                  2- Another thing to try is to just pass the field number for the item you're trying to update...leave the others off.
                  Thanks for using the LawsonGuru.com forums!
                  John
                  kdcoate
                  Veteran Member
                  Posts: 44
                  Veteran Member
                  7/27/2009 8:47 PM
                    I've broken down the build of the AGS call in ProcessFlow to only include the selected field numbers and values. Here's what I get:

                    Transaction Call String _PDL=CBPROD9&_TKN=PA52.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=A&PCT-COMPANY=1&PCT-EMPLOYEE=3210&PCT-ACTION-CODE=SALARY%20%20%20%20&PCT-EFFECT-DATE=20090727&PCT-REASON1=MARKET&PCT-REASON2=RESPON&IMMEDIATE-ACTION=N&PCT-UPDATE-BENEFIT=Y&PCT-UPD-ABS-MGMT=N&PCT-UPDATE-REQ-DED=N&PCT-EDM-EFFECT-DT=20090727&PAT-FLD-NBR-1Ar1=64&PAT-FLD-NBR-1Ar2=73&PAT-FLD-NBR-1Ar3=135&PAT-FLD-NBR-1Ar4=63&PAT-FLD-NBR-1Ar5=136&PAT-FLD-NBR-1Ar6=106&PAT-FLD-NBR-1Ar7=62&PCT-NEW-VALUE-1r7=88752.61&_HK=0001000003210SALARY%20%20%20%2020090727&_DELIM=%09&_OUT=XML&_EOT=TRUE
                    Error while Executing activity : Type=AGS, ActivityName=xHire, ActivityId=AGS114, WorkUnit=22172 Date:07/27/2009 Time:17:35:40
                    AGS error: New value must be spaces because line has no item

                    This call will also Add successfully when pasted into the browser so there has to be something different about how ProcessFlow is parsing the call.
                    Gary Davies
                    Veteran Member
                    Posts: 248
                    Veteran Member
                    7/27/2009 9:19 PM
                      Actually, I would leave the field numbers in. There is a bug with PA100 That it dies not report a changed value properly if the previous fields field number is blank even if that previous field had no change. It still updates just doesn't report it correctly.

                      Your call looks fine. Are the field numbers correct? I am puzzled that you say if you cut and opaste the call in the URL that it works. Could it be an HR09 issue where salary is a secured field for your pfadmin user?
                      kdcoate
                      Veteran Member
                      Posts: 44
                      Veteran Member
                      7/27/2009 9:20 PM
                        Of course - the index. I changed my field numbers and values from 1-12 to 0-11 and it works perfectly now.Thank you.