Upgrade.sh fails for data upgrade with - WARNING: Encountered database error attempting to load jar into Oracle: ORA-00604
Hello,
Our upgrade.sh for data upgrade fails with the below errors:
[java] Oct 27, 2016 10:43:04 AM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] INFO: com/pega/pegarules/data/internal/clipboard/directstream/ReferenceString.class inserted into table.
[java] Oct 27, 2016 10:43:04 AM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] INFO: Temporary table pz_blobtable dropped.
[java] Oct 27, 2016 10:43:04 AM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] WARNING: Encountered database error attempting to load jar into Oracle: ORA-00604: error occurred at recursive SQL level 1
[java] ORA-28003: password verification for the specified password failed
[java] ORA-20002: Password length less than 15
[java]
[java] Throwable occurred: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
[java] ORA-28003: password verification for the specified password failed
[java] ORA-20002: Password length less than 15
We have verified the deployment user username and the password is correct in the setupDatabase.properties file and we have also verified the the privileges mentioned in the guide exists. Please let us know if anyone has faced a similar issue.
**Moderation Team has archived post**
Hello,
Our upgrade.sh for data upgrade fails with the below errors:
[java] Oct 27, 2016 10:43:04 AM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] INFO: com/pega/pegarules/data/internal/clipboard/directstream/ReferenceString.class inserted into table.
[java] Oct 27, 2016 10:43:04 AM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] INFO: Temporary table pz_blobtable dropped.
[java] Oct 27, 2016 10:43:04 AM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] WARNING: Encountered database error attempting to load jar into Oracle: ORA-00604: error occurred at recursive SQL level 1
[java] ORA-28003: password verification for the specified password failed
[java] ORA-20002: Password length less than 15
[java]
[java] Throwable occurred: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
[java] ORA-28003: password verification for the specified password failed
[java] ORA-20002: Password length less than 15
We have verified the deployment user username and the password is correct in the setupDatabase.properties file and we have also verified the the privileges mentioned in the guide exists. Please let us know if anyone has faced a similar issue.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Cognizant
IN
Does this password change every 24 hours, some organizations have such setup.
At the moment when upgrade.sh was run; the password was still the same as what you had in setupDatabase.properties ?
Tata Consultancy Services
SA
Hello,
Yes the password was the same at the time. It is still the same actually, I can connect to the database with the same password too.
Boston Consulting Group
US
A password verify function is assigned to each DB users profile. Based on the error (ORA-20002: Password length less than 15) looks like a requirement of 15 characters is set.
Options:
1) Satisfy the password requirement of 15 characters
2) Ask your DBA to disable the verification/ function