Error starting server
search cancel

Error starting server


Article ID: 115840


Updated On:


CA Harvest Software Change Manager - OpenMake Meister


Installed the Harvest server, but starting the broker it returns an error:

[Oracle][ODBC][Ora]ORA-00942: table or view does not exist 
HServer | 20180917 16:54:57 | ERROR: E03020003: Database error [Oracle][ODBC][Ora]ORA-00942: table or view does not exist 


Harvest v13 64bit on Windows 2016 + Oracle client 11.2, 64bit 
ORACLE DB - running on remote server Linux Redhat 7.4 
Harvest repository not moved/copied from a different server. Created from scratch


From HDBSetup.log we could see that ep i.e (Encrypting user details) part is missing, hence the "default" db credentials are considered to be encrypted as against to the "CR user details". 
As a result, the access to specific tables doesn't exist for that corresponding user and it fails. 
Could you please try to perform an "ep" or try running the following command: 
svrenc -usr YOUR_USER -pw your_password -s 
*-password it means the password which you have given during CR option while creating harvest user. 
Then start the broker.