Getting ORA-00904: invalid identifier error while running generateddl.sh
Hi All - Can you guys please help me resolve the error which I am getting this while executing the below command for 7.1.9: (FYI--same settings in setupDatabase properties file worked well for older 7.1.4 system but we used only basic command :- generateddl.sh --action upgrade without any dbSchema parameters)
I am assuming that the database information is specified in the setupDatabase.properties file. Does the database user that you are running this script with have permissions to select on everything in the MY_PEGA_RULES and MY_PEGA_DATA schemas?
Thank you Celeste Dufresne!! I checked with DBAs and the DB ID which we are using is having required roles and privileges and still we are getting same error. We tried the simpler format of command to run the script i.e. "generateddl.sh --action upgrade" but this also didn't work and gave same error. we may have to open SR as it is kind of road block for us. please suggest.
From looking at the code and the error message this looks like the database user that is running the script has not been granted the select_catalog_role. Besides all of the privileges to access everything in both schemes the user also needs privileges to analyze any dictionary and needs to be granted the select_catalog_role.
Thank you Celeste Dufresne for your response! Let me check with DBAs about this role and ability to analyze dictionary for this user. Since it was show-stopper issue for us I had opened a SR-A16912. I have provided all the necessary information in this SR. Please let me know if you could find anything else regarding this issue.