2 Replies Latest reply: Dec 7, 2012 3:27 PM by 645832 RSS

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

    645832
      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?