Error updating to 7014 with MSSQL
Hi. i have SupportCenter Plus running ion a RedHat Linux Server, and the backend Database is a MS SQL Server 2000.
When i try to update, the next message appears
.
./UpdateManager.sh
/home/AdventNet/Apps/SupportCenter
Starting to take backup ....
Backup operation completed
java.sql.SQLException: User does not have permission to perform this operation on database 'supportcenter'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)
at org.enhydra.jdbc.core.CoreStatement.execute(CoreStatement.java:87)
at com.adventnet.servicedesk.updatemgr.util.SCPreProcessor.changeDBCase(SCPreProcessor.java:1287)
at com.adventnet.servicedesk.updatemgr.util.SCPreProcessor.install(SCPreProcessor.java:468)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(Unzipper.java:311)
at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationClasses(Unzipper.java:138)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:273)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223)
at java.lang.Thread.run(Unknown Source)
Problem during installation of patch java.sql.SQLException: User does not have permission to perform this operation on database 'supportcenter'.
reverting in preprocessor
=======================================================
Error : Please wait reverting to old build!!!
1. Renaming modified mysql
2. Extracting backup mysql
=======================================================
Thanks in advance
New to ADSelfService Plus?