PA52 ProcessFlow

 10 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
kdcoate
New Member Send Private Message
Posts: 0
New Member
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
Send Private Message
Posts: 3351
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
New Member Send Private Message
Posts: 0
New Member
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
New Member Send Private Message
Posts: 0
New Member
_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
Deleted User
New Member Send Private Message
Posts: 0
New Member
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
Send Private Message
Posts: 3351
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
New Member Send Private Message
Posts: 0
New Member
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
Send Private Message
Posts: 3351
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
New Member Send Private Message
Posts: 0
New Member
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.
Deleted User
New Member Send Private Message
Posts: 0
New Member
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
New Member Send Private Message
Posts: 0
New Member
Of course - the index. I changed my field numbers and values from 1-12 to 0-11 and it works perfectly now.Thank you.