This discussion is archived
2 Replies Latest reply: Dec 7, 2012 1:27 PM by 645832 RSS

** Urgent *** Sunopsis V 4.1 Designer, Agent, won't start

645832 Newbie
Currently Being Moderated
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

ConnectType: null
conName: null
DServeName: null
FetchArray:null
FirstDate:null
FirstUser:null

.....
pass:null
UserName:null
ConnectConnection:com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:SQLServer <computername> 1433; SelectMethod=Cursor snp_m INTERNALMASTER13465634
ConnectIdnull at
com.sunopsis.dwg.cmd..ha.(h.java)
com.sunopsis.h.a.run(a.java)
...

Caused by. com.sunopsis.core.n Object does not exist in database BatchUpdateSize:null

------------------

Any ideas what to check next?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points