We have tried updating to build 8200 in our test environment and it has failed twice with the same error, see below. Please advise how we can resolve this.

 

22-Apr-2013 16:15:35  [SYSERR]  [INFO] : java.sql.BatchUpdateException: The INSERT statement conflicted with the FOREIGN KEY constraint "IntComponentType_FK1". The conflict occurred in database "servicedesk_New", table "dbo.ComponentType", column 'COMPONENTTYPEID'.
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.db.adapter.Jdbc20DBAdapter.handleSQLException(Jdbc20DBAdapter.java:1192)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.db.api.RelationalAPI.handleException(RelationalAPI.java:680)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.db.api.RelationalAPI.executeBatch(RelationalAPI.java:656)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.persistence.DataAccess.insertRows(DataAccess.java:2193)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.persistence.DataAccess.processInsertRows(DataAccess.java:313)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.persistence.DataAccess.update(DataAccess.java:648)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.persistence.DataAccess.update(DataAccess.java:622)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.updatemgr.conf.XML2DOUpdater.daUpdate(XML2DOUpdater.java:350)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.updatemgr.conf.XML2DOUpdater.diffXml(XML2DOUpdater.java:958)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.updatemgr.conf.XML2DOUpdater.diffXml(XML2DOUpdater.java:850)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.updatemgr.conf.XML2DOUpdater.diffXml(XML2DOUpdater.java:682)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.updatemgr.conf.XML2DOUpdater.updateChanges(XML2DOUpdater.java:156)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.persistence.DefaultPostProcessor.updateDOXmls(DefaultPostProcessor.java:196)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.persistence.DefaultPostProcessor.installPatch(DefaultPostProcessor.java:434)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.servicedesk.updatemgr.util.SDPostProcessorUpd.installPatch(SDPostProcessorUpd.java:96)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.persistence.DefaultPostProcessor.install(DefaultPostProcessor.java:296)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at java.lang.reflect.Method.invoke(Unknown Source)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1406)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1238)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:289)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [SYSERR]  [INFO] :  at java.lang.Thread.run(Unknown Source)
22-Apr-2013 16:15:35  [SYSERR]  [INFO] :

22-Apr-2013 16:15:35  [com.adventnet.persistence.UpdateManagerUtil]  [INFO] : appDO :: [<WritableDataObject>
 <Tables>
[Application] </Tables>
SelectQuery Object:
 Select columnNames=[Application.APPLICATIONNAME, Application.DESCRIPTION, Application.URL, Application.FILENAME, Application.LOADCLIENTMODULES, Application.STATUS, Application.STARTUP, Application.DEPWEIGHT]
 Criteria=(Application.APPLICATIONNAME = 'ServerContainer')
 Number of Objects=0
 Starting row=1
 Order by columnNames=[]
 Table List=[Application AS Application]
 Joins=
 SetLock= false
 <JoinsInDO>
 </JoinsInDO>
 <Operations>
  <UPDATE><Application_PK APPLICATIONNAME="ServerContainer"/></UPDATE>
 </Operations>
 <Rows>
  <Application APPLICATIONNAME="ServerContainer" DESCRIPTION="Server Container Application - Contains all the framework modules" URL="file:/C:/sudha/ServiceDesk/applications/AdventNetServerContainer.eear" FILENAME="AdventNetServerContainer.eear" LOADCLIENTMODULES="false" STATUS="PPM_FAILURE" STARTUP="WARM" DEPWEIGHT="0" />
 </Rows>
</WritableDataObject>
]