DatabaseCrawler
Today we have some problem with ServiceDesk the one thing that I notice is that in the serverout log there is a lot of this message
[15:49:07:794]|[11-02-2012]|[com.adventnet.sqlone.search.dbcrawler.ejb.internal.DatabaseCrawler]|[INFO]|[20]|: 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" />|
At the same time I have a lot of suspended processes in the database and they are blocked by a process that does something with audithistory. There is many delete and some selects to the table audithistory
As it is now I have 17 suspended process and unable to use ServiceDesk. I can work around this by restarting the services. But the problem will go away.
What is this delete from audithistory and can it be scheduled so that it runs in none working hours?
Best regards
Peter Samuelsson
Sodra Skogsagarna
[15:49:07:794]|[11-02-2012]|[com.adventnet.sqlone.search.dbcrawler.ejb.internal.DatabaseCrawler]|[INFO]|[20]|: 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" />|
At the same time I have a lot of suspended processes in the database and they are blocked by a process that does something with audithistory. There is many delete and some selects to the table audithistory
As it is now I have 17 suspended process and unable to use ServiceDesk. I can work around this by restarting the services. But the problem will go away.
What is this delete from audithistory and can it be scheduled so that it runs in none working hours?
Best regards
Peter Samuelsson
Sodra Skogsagarna