I am trying to delete a site, but get the following error: FAILURE :Site is being used by a module. Hence cannot delete it.
I cannot find the association with the site anywhere. Here is the log file entry with the errors within:
Caused by: java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "WorkOrder_FK4". The conflict occurred in database "servicedesk", table "dbo.WorkOrder", column 'DEPTID'. at com.adventnet.db.adapter.Jdbc20DBAdapter.handleSQLException(Jdbc20DBAdapter.java:1042) at com.adventnet.db.adapter.Jdbc20DBAdapter.execute(Jdbc20DBAdapter.java:320) at com.adventnet.db.api.RelationalAPI.execute(RelationalAPI.java:639) at com.adventnet.persistence.DeleteUtil.executeDelete(DeleteUtil.java:376) ... 93 more Caused by: java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "WorkOrder_FK4". The conflict occurred in database "servicedesk", table "dbo.WorkOrder", column 'DEPTID'. 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.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:104) at com.adventnet.db.adapter.Jdbc20DBAdapter.execute(Jdbc20DBAdapter.java:311) ... 95 more
[12:49:04:618]|[03-04-2009]|[com.adventnet.servicedesk.utils.ServiceDeskUtil]|[SEVERE]|[25]|: Error code : 1016| [12:49:04:618]|[03-04-2009]|[com.adventnet.servicedesk.utils.ServiceDeskUtil]|[SEVERE]|[25]|: Error row : <AdventNetErrorCode ERRORCODE="1016" ERRORSTRING="ER_ROW_IS_REFERENCED" ERRORMESSAGE="Cannot delete or update a parent row: a foreign key constraint fails" />| [12:49:04:618]|[03-04-2009]|[com.adventnet.servicedesk.utils.ServiceDeskUtil]|[SEVERE]|[25]|: FAILURE :Site is being used by a module. Hence cannot delete it.| [12:49:04:618]|[03-04-2009]|[com.adventnet.servicedesk.utils.ServiceDeskUtil]|[SEVERE]|[25]|: Site is being used by a module. Hence cannot delete it. : Cannot delete or update a parent row: a foreign key constraint fails| [12:49:06:149]|[03-04-2009]|[com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTaskChecker]|[INFO]|[23]|: MailFetchingTaskChecker instantiated. | [12:49:06:149]|[03-04-2009]|[com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTaskChecker]|[INFO]|[23]|: MailFetchingTaskChecker ---> executeTask() called ... | [12:49:06:149]|[03-04-2009]|[com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTaskChecker]|[INFO]|[23]|: To check server start vs current time for mail checker task| [12:49:06:149]|[03-04-2009]|[com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTaskChecker]|[INFO]|[23]|: Server started earlier time : Wed Mar 04 10:43:02 GMT 2009 and hence proceeding with mail checker thread..| [12:49:06:149]|[03-04-2009]|[com.adventnet.sqlone.search.dbcrawler.ejb.internal.DatabaseCrawler]|[INFO]|[23]|: Connection obtained for crawling the database <AppIndexingInfo CRID="134" APPLICATIONID="1" APPLICATIONNAME="ServiceDesk" APPDSNAME="default" MAXWORDSIZE="200" INDEXINGDELIMITERS=",:@-. (){}" ENABLEPARTIALSEARCH="true" ENABLEDYNAMICINDEXING="true" ENABLEINCREMENTALINDEXING="false" POPULATE_FK_REL="false" STATUS="0" />| [12:49:10:195]|[03-04-2009]|[com.adventnet.servicedesk.setup.action.AdminErrorLogAction]|[INFO]|[25]|: execute method called| [12:49:10:195]|[03-04-2009]|[com.adventnet.servicedesk.setup.action.AdminErrorLogAction]|[INFO]|[25]|: forwardedFrom : getAttribute : null| [12:49:10:195]|[03-04-2009]|[com.adventnet.servicedesk.setup.action.AdminErrorLogAction]|[INFO]|[25]|: forwardedFrom : getParameter : null| [12:49:10:195]|[03-04-2009]|[com.adventnet.servicedesk.setup.action.AdminErrorLogAction]|[INFO]|[25]|: forwardedFrom : null| [12:49:20:695]|[03-04-2009]|[com.adventnet.servicedesk.tools.AuthenticateNtlm]|[INFO]|[25]|: NTLM Challenge to get postdata from IE After validation| [12:49:20:695]|[03-04-2009]|[com.adventnet.servicedesk.tools.AuthenticateNtlm]|[INFO]|[25]|: NTLM Challenge to get postdata from IE After validation| [12:49:20:695]|[03-04-2009]|[com.adventnet.servicedesk.search.action.SearchNAction]|[INFO]|[25]|: Search params : txt : FAILURE :Site is being used by a module. Hence cannot delete it., module : System Log| [12:49:20:695]|[03-04-2009]|[com.adventnet.servicedesk.search.action.SearchNAction]|[INFO]|[25]|: Module name in SearchNAction : System Log| [12:49:20:695]|[03-04-2009]|[com.adventnet.servicedesk.search.action.SearchNAction]|[INFO]|[25]|: forwardedFrom : setAttribute : FAILURE :Site is being used by a module. Hence cannot delete it.| [12:49:20:695]|[03-04-2009]|[com.adventnet.servicedesk.setup.action.AdminErrorLogAction]|[INFO]|[25]|: execute method called| [12:49:20:695]|[03-04-2009]|[com.adventnet.servicedesk.setup.action.AdminErrorLogAction]|[INFO]|[25]|: forwardedFrom : getAttribute : FAILURE :Site is being used by a module. Hence cannot delete it.| [12:49:20:695]|[03-04-2009]|[com.adventnet.servicedesk.setup.action.AdminErrorLogAction]|[INFO]|[25]|: forwardedFrom : FAILURE :Site is being used by a module. Hence cannot delete it.| [12:49:27:304]|[03-04-2009]|[com.adventnet.servicedesk.tools.AuthenticateNtlm]|[INFO]|[25]|: NTLM Challenge to get postdata from IE After validation| [12:49:27:304]|[03-04-2009]|[com.adventnet.servicedesk.tools.AuthenticateNtlm]|[INFO]|[25]|: NTLM Challenge to get postdata from IE After validation| [12:49:27:304]|[03-04-2009]|[com.adventnet.servicedesk.search.action.SearchNAction]|[INFO]|[25]|: Search params : txt : zurich, module : System Log| [12:49:27:304]|[03-04-2009]|[com.adventnet.servicedesk.search.action.SearchNAction]|[INFO]|[25]|: Module name in SearchNAction : System Log| [12:49:27:304]|[03-04-2009]|[com.adventnet.servicedesk.search.action.SearchNAction]|[INFO]|[25]|: forwardedFrom : setAttribute : zurich| [12:49:27:304]|[03-04-2009]|[com.adventnet.servicedesk.setup.action.AdminErrorLogAction]|[INFO]|[25]|: execute method called| [12:49:27:304]|[03-04-2009]|[com.adventnet.servicedesk.setup.action.AdminErrorLogAction]|[INFO]|[25]|: forwardedFrom : getAttribute : zurich| [12:49:27:304]|[03-04-2009]|[com.adventnet.servicedesk.setup.action.AdminErrorLogAction]|[INFO]|[25]|: forwardedFrom : zurich| [12:49:38:897]|[03-04-2009]|[SYSOUT]|[INFO]|[25]|: THE NAME OF THE USER IS :::::jdxsj| [12:49:38:897]|[03-04-2009]|[SYSOUT]|[INFO]|[25]|: THE Current time is :::::1236170978757| [12:49:38:897]|[03-04-2009]|[SYSOUT]|[INFO]|[25]|: CREATING ZIPUTIL INSTANCE| [12:49:38:897]|[03-04-2009]|[SYSOUT]|[INFO]|[25]|: :::ENTERED ZIPCREATOR:::| [12:49:38:897]|[03-04-2009]|[SYSOUT]|[INFO]|[25]|: The logs folder is C:AdventNetMEServiceDeskserverdefaultlog| [12:49:38:897]|[03-04-2009]|[com.adventnet.servicedesk.helpdesk.action.SupportZipUtil]|[INFO]|[25]|: File path obtained while zipping : C:AdventNetMEServiceDeskserverdefaultlogserverout0.txt|
The site I am trying to remove is Zurich. Any ideas?