Upgrade to 7017 Failing

Upgrade to 7017 Failing

I'm upgrading from 7010 to 7017 and get the following error. please advise asap.


INFO: Problem during installation of patch
com.adventnet.persistence.DataAccessException: SQLException occured while retrie
ving rows that are to be deleted from the table RecentItems
at com.adventnet.persistence.DeleteUtil.fetchRows(DeleteUtil.java:525)
at com.adventnet.persistence.DeleteUtil.deleteData(DeleteUtil.java:343)
at com.adventnet.persistence.DeleteUtil.delete(DeleteUtil.java:149)
at com.adventnet.persistence.DataAccess.delete(DataAccess.java:887)
at com.adventnet.persistence.DataAccess.delete(DataAccess.java:880)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.poChanges(SDP
reProcessor.java:1130)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.install(SDPre
Processor.java:276)
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:309)
at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationCl
asses(Unzipper.java:136)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPat
ch.java:274)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:2
24)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Some part of your SQL statement is nested too
deeply. Rewrite the query or break it up into smaller queries.
at com.adventnet.db.adapter.Jdbc20DBAdapter.handleSQLException(Jdbc20DBA
dapter.java:1042)
at com.adventnet.db.adapter.Jdbc20DBAdapter.executeQuery(Jdbc20DBAdapter
.java:182)
at com.adventnet.db.api.RelationalAPI.executeQuery(RelationalAPI.java:75
1)
at com.adventnet.persistence.DeleteUtil.fetchRows(DeleteUtil.java:437)
... 15 more
Caused by: java.sql.SQLException: Some part of your SQL statement is nested too
deeply. Rewrite the query or break it up into smaller queries.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava: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.executeSQLQuery(JtdsStatement
.java:418)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.ja
va:1258)
at org.enhydra.jdbc.core.CoreStatement.executeQuery(CoreStatement.java:1
07)
at com.adventnet.db.adapter.Jdbc20DBAdapter.executeQuery(Jdbc20DBAdapter
.java:174)
... 17 more
reverting in preprocessor
=======================================================
Error : Please wait reverting to old build!!!
1. Renaming modified mysql
2. Extracting backup mysql
18-Jun-2008 13:36:20 com.adventnet.j2ee.deployment.service.internal.JarExtractor
extract
INFO: Extraction for C:\AdventNet\ME\ServiceDesk\mysql.zip to C:\AdventNet\ME\S
erviceDesk\mysql
=======================================================
18-Jun-2008 13:36:31 com.adventnet.servicedesk.updatemgr.util.SDPreProcessor <in
it>
SEVERE: Inside SDPreProcessor.

































































                    New to ADSelfService Plus?