Posted: 13 Aug 2015 12:35 EDT 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?
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.
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.