cannot delete site

cannot delete site

Hi,

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?

Thanks,
Davey

































































                  New to ADSelfService Plus?