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.