03.03.2013 00:00:00.023 INFO : TruncateLogODB started 03.03.2013 00:00:00.820 INFO : TruncateLogODB finished 03.03.2013 00:00:00.820 DEBUG: TruncateLogODB - следующий запуск 03.03.2013 2:00:00 03.03.2013 00:31:53.851 FATAL: Configuration exception ru.crystalservice.scheduler.configuration.ConfigurationException: Ошибка чтения настроек из БД at ru.crystalservice.scheduler.configuration.Configuration.getTasksFromDB(Unknown Source) at ru.crystalservice.scheduler.configuration.Configuration.getTasks(Unknown Source) at ru.crystalservice.scheduler.Scheduler.main(Unknown Source) at ru.crystalservice.scheduler.DBService.main(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:244) at java.lang.Thread.run(Unknown Source) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: SQL Server did not return a response. The connection has been closed.. at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1509) at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1427) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1204) at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(SQLServerConnection.java:1054) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:758) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) ... 10 more 03.03.2013 00:34:59.921 INFO : 03.03.2013 00:34:59.984 INFO : Service starting... 03.03.2013 00:34:59.984 INFO : ************************ 03.03.2013 00:34:59.984 INFO : * Build id: 23.08.2010 * 03.03.2013 00:34:59.984 INFO : ************************ 03.03.2013 00:35:00.000 INFO : DebugLevel = DEBUG 03.03.2013 00:35:05.156 DEBUG: *** 03.03.2013 00:35:05.156 DEBUG: Создаем задание 'BackUpOBD' 03.03.2013 00:35:05.171 DEBUG: Создаем расписание Каждый день в 9:00:00 03.03.2013 00:35:05.171 DEBUG: Создаем шаг 'BackUpODB' 03.03.2013 00:35:05.171 DEBUG: *** 03.03.2013 00:35:05.171 DEBUG: Создаем задание 'CheckSpaces' 03.03.2013 00:35:05.171 DEBUG: Создаем расписание Каждый день в 23:00:00 03.03.2013 00:35:05.171 DEBUG: Создаем шаг 'CheckDbSize' 03.03.2013 00:35:05.171 DEBUG: Создаем шаг 'CheckFreeSize' 03.03.2013 00:35:05.187 DEBUG: *** 03.03.2013 00:35:05.187 DEBUG: Создаем задание 'ChequeIndexDefrag' 03.03.2013 00:35:05.187 DEBUG: Создаем расписание Каждый день в 21:00:00 03.03.2013 00:35:05.187 DEBUG: Создаем шаг 'TableIndexDefrag' 03.03.2013 00:35:05.187 DEBUG: *** 03.03.2013 00:35:05.187 DEBUG: Создаем задание 'ChequetoArchive' 03.03.2013 00:35:05.187 DEBUG: Создаем расписание Каждый день в 3:00:00 03.03.2013 00:35:05.187 DEBUG: Создаем шаг 'ChequeArchive' 03.03.2013 00:35:05.187 DEBUG: Создаем шаг 'TruncateLogADB' 03.03.2013 00:35:05.187 DEBUG: Создаем шаг 'BackUpADB' 03.03.2013 00:35:05.187 DEBUG: *** 03.03.2013 00:35:05.187 DEBUG: Создаем задание 'CropADB' 03.03.2013 00:35:05.187 DEBUG: Создаем расписание Каждый день в 1:00:00 03.03.2013 00:35:05.187 DEBUG: Создаем шаг 'CropADB' 03.03.2013 00:35:05.187 DEBUG: *** 03.03.2013 00:35:05.187 DEBUG: Создаем задание 'LogsShrink' 03.03.2013 00:35:05.187 DEBUG: Создаем расписание Каждый день в 22:00:00 03.03.2013 00:35:05.187 DEBUG: Создаем шаг 'LogsShrink' 03.03.2013 00:35:05.187 DEBUG: *** 03.03.2013 00:35:05.187 DEBUG: Создаем задание 'TruncateLogODB' 03.03.2013 00:35:05.187 DEBUG: Создаем расписание Каждый день c 0:00:00 до 23:59:59 раз в 2 час. 03.03.2013 00:35:05.187 DEBUG: Создаем шаг 'TruncateLogODB' 03.03.2013 00:35:05.187 DEBUG: *** 03.03.2013 00:35:05.187 DEBUG: Создаем задание 'UpdateStatistics' 03.03.2013 00:35:05.187 DEBUG: Создаем расписание Каждый день в 7:00:00 03.03.2013 00:35:05.187 DEBUG: Создаем шаг 'ChequeStat' 03.03.2013 00:35:05.187 DEBUG: Initialized pool DEFAULTDATALINK; url = jdbc:sqlserver://127.0.0.1;databasename=SES_Service 03.03.2013 00:35:05.187 INFO : ******* Service started ******* 03.03.2013 00:35:05.187 INFO : 03.03.2013 00:35:05.203 DEBUG: Created a new connection as sa in pool DEFAULTDATALINK for class Alarmer. Now have 1 connections checked out. 03.03.2013 00:35:05.218 INFO : Tasks count is 8 03.03.2013 00:35:05.218 DEBUG: BackUpOBD - следующий запуск 03.03.2013 9:00:00 03.03.2013 00:35:05.218 DEBUG: ChequeIndexDefrag - следующий запуск 03.03.2013 21:00:00 03.03.2013 00:35:05.218 DEBUG: LogsShrink - следующий запуск 03.03.2013 22:00:00 03.03.2013 00:35:05.234 DEBUG: TruncateLogODB - следующий запуск 03.03.2013 2:00:00 03.03.2013 00:35:05.234 DEBUG: ChequetoArchive - следующий запуск 03.03.2013 3:00:00 03.03.2013 00:35:05.234 DEBUG: CheckSpaces - следующий запуск 03.03.2013 23:00:00 03.03.2013 00:35:05.234 DEBUG: UpdateStatistics - следующий запуск 03.03.2013 7:00:00 03.03.2013 00:35:05.250 DEBUG: CropADB - следующий запуск 03.03.2013 1:00:00 03.03.2013 01:00:00.083 INFO : CropADB started 03.03.2013 01:00:05.380 INFO : CropADB finished 03.03.2013 01:00:05.380 DEBUG: CropADB - следующий запуск 04.03.2013 1:00:00 03.03.2013 02:00:00.429 INFO : TruncateLogODB started 03.03.2013 02:00:05.523 DEBUG: Created a new connection as sa in pool DEFAULTDATALINK for class Alarmer. Now have 2 connections checked out. 03.03.2013 02:00:05.539 INFO : TruncateLogODB finished 03.03.2013 02:00:05.539 DEBUG: TruncateLogODB - следующий запуск 03.03.2013 4:00:00 03.03.2013 03:00:00.277 INFO : ChequetoArchive started 03.03.2013 03:00:22.402 ERROR: ChequeArchive: doStep exception; command = 'EXEC cp_MoveChequeToArchive :0' com.microsoft.sqlserver.jdbc.SQLServerException: Insert Error: Column name or number of supplied values does not match table definition. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:156) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1373) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:371) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:322) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4003) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1550) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:133) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:304) at ru.crystalservice.scheduler.steps.StepSql.execSqlCommand(Unknown Source) at ru.crystalservice.scheduler.steps.StepDBService.doStep(Unknown Source) at ru.crystalservice.scheduler.steps.Step.execute(Unknown Source) at ru.crystalservice.scheduler.tasks.Task.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 03.03.2013 03:00:22.496 ERROR: ChequeArchive: doStep exception; Insert Error: Column name or number of supplied values does not match table definition. 03.03.2013 03:00:33.637 DEBUG: Created a new connection as sa in pool DEFAULTDATALINK for class BackUpADB. Now have 1 connections checked out. 03.03.2013 03:00:33.637 ERROR: BackUpADB: doStep exception; command = 'EXEC cp_BackupDB :1' com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:156) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1373) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:371) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:322) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4003) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1550) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:133) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:304) at ru.crystalservice.scheduler.steps.StepSql.execSqlCommand(Unknown Source) at ru.crystalservice.scheduler.steps.StepDBService.doStep(Unknown Source) at ru.crystalservice.scheduler.steps.Step.execute(Unknown Source) at ru.crystalservice.scheduler.tasks.Task.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 03.03.2013 03:00:33.637 ERROR: BackUpADB: doStep exception; SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online. 03.03.2013 03:00:35.387 INFO : ChequetoArchive finished 03.03.2013 03:00:35.387 DEBUG: ChequetoArchive - следующий запуск 04.03.2013 3:00:00 03.03.2013 04:00:00.107 INFO : TruncateLogODB started 03.03.2013 04:00:01.950 INFO : TruncateLogODB finished 03.03.2013 04:00:01.950 DEBUG: TruncateLogODB - следующий запуск 03.03.2013 6:00:00 03.03.2013 06:00:00.023 INFO : TruncateLogODB started 03.03.2013 06:00:00.476 INFO : TruncateLogODB finished 03.03.2013 06:00:00.476 DEBUG: TruncateLogODB - следующий запуск 03.03.2013 8:00:00 03.03.2013 07:00:00.358 INFO : UpdateStatistics started 03.03.2013 07:00:06.233 DEBUG: Created a new connection as sa in pool DEFAULTDATALINK for class Alarmer. Now have 2 connections checked out. 03.03.2013 07:02:35.312 INFO : UpdateStatistics finished 03.03.2013 07:02:35.312 DEBUG: UpdateStatistics - следующий запуск 04.03.2013 7:00:00 03.03.2013 08:00:00.018 INFO : TruncateLogODB started 03.03.2013 08:00:00.408 INFO : TruncateLogODB finished 03.03.2013 08:00:00.408 DEBUG: TruncateLogODB - следующий запуск 03.03.2013 10:00:00 03.03.2013 09:00:00.548 INFO : BackUpOBD started 03.03.2013 10:00:01.514 INFO : TruncateLogODB started 03.03.2013 10:00:01.514 WARN : TruncateLogODB: 03.03.2013 9:00:00 задание 'BackUpODB.5' заблокировало '8' 03.03.2013 10:00:01.514 INFO : TruncateLogODB finished 03.03.2013 10:00:01.514 DEBUG: TruncateLogODB - следующий запуск 03.03.2013 12:00:00 03.03.2013 10:29:14.475 ERROR: BackUpODB: doStep exception; command = 'EXEC cp_BackupDB :0' com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:156) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1373) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:371) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:322) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4003) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1550) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:133) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:304) at ru.crystalservice.scheduler.steps.StepSql.execSqlCommand(Unknown Source) at ru.crystalservice.scheduler.steps.StepDBService.doStep(Unknown Source) at ru.crystalservice.scheduler.steps.Step.execute(Unknown Source) at ru.crystalservice.scheduler.tasks.Task.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 03.03.2013 10:29:14.475 ERROR: BackUpODB: doStep exception; SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online. 03.03.2013 10:29:17.334 INFO : BackUpOBD finished 03.03.2013 10:29:17.334 DEBUG: BackUpOBD - следующий запуск 04.03.2013 9:00:00 03.03.2013 12:00:00.127 INFO : TruncateLogODB started 03.03.2013 12:00:00.331 INFO : TruncateLogODB finished 03.03.2013 12:00:00.331 DEBUG: TruncateLogODB - следующий запуск 03.03.2013 14:00:00 03.03.2013 14:00:00.052 INFO : TruncateLogODB started 03.03.2013 14:00:00.239 INFO : TruncateLogODB finished 03.03.2013 14:00:00.239 DEBUG: TruncateLogODB - следующий запуск 03.03.2013 16:00:00 03.03.2013 16:00:01.088 INFO : TruncateLogODB started 03.03.2013 16:00:03.213 INFO : TruncateLogODB finished 03.03.2013 16:00:03.213 DEBUG: TruncateLogODB - следующий запуск 03.03.2013 18:00:00 03.03.2013 18:00:00.183 INFO : TruncateLogODB started 03.03.2013 18:00:03.246 INFO : TruncateLogODB finished 03.03.2013 18:00:03.246 DEBUG: TruncateLogODB - следующий запуск 03.03.2013 20:00:00 03.03.2013 20:00:00.001 INFO : TruncateLogODB started 03.03.2013 20:00:00.157 INFO : TruncateLogODB finished 03.03.2013 20:00:00.157 DEBUG: TruncateLogODB - следующий запуск 03.03.2013 22:00:00 03.03.2013 21:00:00.322 INFO : ChequeIndexDefrag started 03.03.2013 21:00:16.134 DEBUG: Created a new connection as sa in pool DEFAULTDATALINK for class Alarmer. Now have 2 connections checked out. 03.03.2013 21:24:01.015 INFO : ChequeIndexDefrag finished 03.03.2013 21:24:01.015 DEBUG: ChequeIndexDefrag - следующий запуск 04.03.2013 21:00:00 03.03.2013 22:00:00.028 INFO : TruncateLogODB started 03.03.2013 22:00:00.293 INFO : TruncateLogODB finished 03.03.2013 22:00:00.293 DEBUG: TruncateLogODB - следующий запуск 04.03.2013 0:00:00 03.03.2013 22:00:00.325 INFO : LogsShrink started 03.03.2013 22:03:34.846 INFO : LogsShrink finished 03.03.2013 22:03:34.846 DEBUG: LogsShrink - следующий запуск 04.03.2013 22:00:00 03.03.2013 23:00:00.392 INFO : CheckSpaces started 03.03.2013 23:00:01.939 INFO : CheckSpaces finished 03.03.2013 23:00:01.939 DEBUG: CheckSpaces - следующий запуск 04.03.2013 23:00:00