http://www.sysaid.com/Sysforums/posts/list/108.page JForum - http://www.jforum.net
Here is the scenario:
We had a instance of sysaid installed and connected to an SQL DB. Somehow the install was corrupted so we made a new install and pointed it to the SQL DB. Whenever I try to log in with the account info it will not let me. I have tried using the ResetPassword utility but it does not work. It gives me this:

initSysAid is initializing log4j
Initializing log4j with: ../root/WEB-INF/log4j.properties
log4j:WARN No appenders could be found for logger (com.ilient).
log4j:WARN Please initialize the log4j system properly.
The account_id: BradyIndustries_trial has been found.
java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__sysaid_u__7C9273
C5625A9A57'. Cannot insert duplicate key in object 'dbo.sysaid_user'. The duplic
ate key value is (sysaid_admin).
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava:36
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:225
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.
java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java
:546)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPre
paredStatement.java:504)
at com.bitmechanic.sql.PooledPreparedStatement.executeUpdate(Unknown Sou
rce)
at com.ilient.util.ResetPassword.main(Unknown Source)

C:\Program Files (x86)\SysAidServer\util>

Please let me know if you know how to fix this.]]> http://www.sysaid.com/Sysforums/posts/preList/8158/33637.page http://www.sysaid.com/Sysforums/posts/preList/8158/33637.page GMT
Thank you for the post.

I have noted that this issue has resoled already in service request number 501400.

Next time, please open a service request helpdesk@sysaid.com directly since this issue is too complex and urgent to handle over the community.

Best regards,

Zehavit,
SysAid]]> http://www.sysaid.com/Sysforums/posts/preList/8158/33962.page http://www.sysaid.com/Sysforums/posts/preList/8158/33962.page GMT