I'm pretty sure we're got an authentication issue with our scheduled backups failing, and was wondering if this was the case ? I've checked the logs of the serverout file which have been extracted below. Can you advise which credential is failing ? The Database or the account within SDP ? Saying this though, the application Event Log viewer says the backup failed due to the following:
EVENT LOG VIEWER java.io.IOException: The process cannot access the file because another process has locked a portion of the file
SERVER LOGS
00:115]|[09-20-2016]|[com.adventnet.servicedesk.utils.ServiceDeskUtil]|[SEVERE]|[188]|: Exception while getting user credentials in getUserId. Assuming Non-Login view. | [19:15:00:115]|[09-20-2016]|[com.adventnet.sqlone.search.dbcrawler.ejb.internal.DatabaseCrawler]|[INFO]|[188]|: 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" />| [19:15:00:115]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: Starting....| [19:15:00:115]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: Active DB Server = mssql| [19:15:00:227]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: Database connectionProp : null| [19:15:00:227]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.SQLGenerator java.lang.InstantiationException: com.adventnet.db.adapter.SQLGenerator| [19:15:00:227]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: Database started| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: *************************************************************| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: Number of tables found : 1358| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: -------------------------------------------------------------| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: Build number : 9120| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: -------------------------------------------------------------| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: backup_info.xml : true| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: -------------------------------------------------------------| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: Ignored Table List| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: -------------------------------------------------------------| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: AuditRecord| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: OperationAuditRecord| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: AaaAccSession| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: AaaAccSessionAudit| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: AaaAccSessionProp| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: AaaAccHttpSession| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: RecentItems| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: AuditResultProperty| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: AuditResourceProp| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: AuditOperProperty| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: -------------------------------------------------------------| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: Going to take full backup with file attachments| [19:15:00:452]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: -------------------------------------------------------------| [19:15:00:553]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: deleting duplicate entries in WordMap table : 0| [19:15:00:553]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: *************************************************************| [19:15:00:553]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: | [19:15:00:553]|[09-20-2016]|[SYSOUT]|[INFO]|[188]|: