Posted: 16 Nov 2015 15:11 EST Last activity: 17 Nov 2015 12:21 EST
uploading excel file failing with committ error
We have a functionality to upload an excel file which is failing post upgrade. When traced we found the error on tracer on activity Work-.committWithErrorHandling as ** ORA-00904: "INPUTS"."ACCOUNT#1": invalid identifier.
The sql statement generated at the backend is as below
You can not directly import a RAP (Rule Application Product) (.jar) file produced in PRPC 6.3 into Pega 7.1. The way to upgrade an application from PRPC 6.3 to Pega 7.1 is to run the Installation and Upgrade Assistant (IUA) against your PRPC 6.3 Database repository. Once the Repository has been upgraded to Pega 7.1 you can then export the application as a RAP file and then import it into other Pega 7.1 repositories. For more information on using the Installation and Upgrade Assistant in Pega 7.1 please search the PDN for "Installation and Upgrade Assistant" and then download the appropriate Upgrade Guide for the version of PRPC you are upgrading too.
we have upgraded the system the way it is mentioned in 7.1.8 upgrade guide. We have copied entire database from 6.2 and then ran upgrade.sh script to upgrade the platform. Each point mentioned in the upgrade guide has been followed.
We have also completed post upgrade tasks. Now while launching the application we are facing issue while parsing the excel file. So asked for resolution for that issue.