Discussion
Stratosphere Technical Consulting
US
Last activity: 13 Aug 2015 14:51 EDT
Comma separated values not parsing in File Service
I am doing the file service exercise and the service succeeds however it does not load to the data table. When I go to clipboard I notice that there is an error and the values are not parsing but everything seems to be configured correctly in my parse and service rules. It is trying to load the entire line into the courselength property and choking on invalid value for decimal property?
screenshot of clipboard : http://imgur.com/T6GZiZn
Pegasystems Inc.
US
Hello,
From your screenshot it appears that you entered test data of "1234,PRPC,Adv,3.0" which is appropriate comma delimited format. But it didn't get parsed and was mapped to the clipboard property "CourseLength" which is a decimal property and you are trying to enter and save a string. Save will fail.
Please double check that you are using a Parse Delimted rule in SAE-HRServices-Data-Courses. The parsing details should have the 4 clipboard properties identified and mapped. .ID, .pyLabel, .Title, and .CourseLength.
This Parse Delimited rule should be referenced on the Request tab of the Service File rule.
Please note, depending on what you've done thus far in the system as part of your troubleshooting you may have some deferred saves that are not committed or rolledback. Those will prevent any further saves from being successful. Recommend you add a rollback step to your activity at the beginning to so some cleanup before continuing troubleshooting.
Regards,
Tara
Pega Academy Support Team
Stratosphere Technical Consulting
US
Thanks Tara. Everything you suggested I have checked except for the rollback. I will try that, In rollback step should step page be blank ?
Thanks.
Pegasystems Inc.
US
Hello,
The page does not matter for the rollback method. You are rolling back all deferred operations on the current thread. My assumption you're unit testing with the Standard thread. Sometimes this is an area that trips up students when troubleshooting this exercise. It may not even be an issue for you. But since you are running into some saving issues it leads me to think that there might be something on the list. You can always check to see if anything is on the deferred ops list by adding a step in your activity to show-html and use the section deferredops.
Per the help: Rollback Use this method to cancel or withdraw any previous uncommitted changes to the PegaRULES database (and to external databases accessed from an external class) from the current Thread. All pending Obj-Save and Obj-Delete methods are cancelled.
Regards,
Tara
Hello,
The page does not matter for the rollback method. You are rolling back all deferred operations on the current thread. My assumption you're unit testing with the Standard thread. Sometimes this is an area that trips up students when troubleshooting this exercise. It may not even be an issue for you. But since you are running into some saving issues it leads me to think that there might be something on the list. You can always check to see if anything is on the deferred ops list by adding a step in your activity to show-html and use the section deferredops.
Per the help: Rollback Use this method to cancel or withdraw any previous uncommitted changes to the PegaRULES database (and to external databases accessed from an external class) from the current Thread. All pending Obj-Save and Obj-Delete methods are cancelled.
Regards,
Tara
Pega Academy Support Team