Today our developer reported he could not connect to Sunopsis Designer. I tried to login to Designer and got this error:
"Invalid User or Password (Security Repository Connection)
com.sunopsis.core.n Object does not exist in the database BatchUpdateSize: null
I created a new test connection to our master repository, connected, and got the same message. I found that using SQL Server Management Studio I could access our SQL Master repository database using the very account and password used in the connection box. The only other account used in the connection box is that of SUPERVIOSR, which I don't think anyone would have changed. I checked "snparams.bat" for any obvious signs of corruption but found none.
Next I started the Agent in a DOS box. It showed the same error but additionally
ConnectConnection:com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:SQLServer <computername> 1433; SelectMethod=Cursor snp_m INTERNALMASTER13465634
Caused by. com.sunopsis.core.n Object does not exist in database BatchUpdateSize:null
Any ideas what to check next?
The "null" values for all the parameters indicates that either:
1. The connection to the database holding the Master Repository did not succeed, or
2. The schema to which the connection is made does not contain Sunopsis/ODI Master Repository tables ( at least the SNP_CONNECT, and SNP_TECHNO are missing... )