Question

3
Replies
242
Views
Close popover
Sudhanshu Kumar Yadav (SudhanshuY)
Labb Consulting
Lead System Architect
Labb Consulting
NL
SudhanshuY Member since 2013 14 posts
Labb Consulting
Posted: May 30, 2017
Last activity: May 31, 2017
Closed

Issue in Calling DB function Using RDB-Open after upgrading from 6.2 SP2 to Pega 7.2.2

Hello,

We have upgrade our application from Pega 6.2 SP2 to Pega 7.2.2 and in our application using RDB-Open we are running below query:

select GETPVIID() as "tempPVIID" from DUAL where rownum = 1

where GETPVIID() is a DB function but after upgrade this script started throwing below error:

java.sql.SQLSyntaxErrorException: ORA-00904: "GETPVIID": invalid identifier

I am attaching also the complete log file. Please let us know why above query is giving error.

System Administration Upgrades
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.