ACS5.5 Export Data run Failed

weiyong wu — Mon, 11 Mar 2019 04:45:06 GMT

ACS5.5 doesn't function Remote Database with Microsoft Database SQL2008R2

error log as following:

acs5a/admin# sho acs-logs filename MonitoringAndReportingScheduler.log
Apr 15 2014 02:12:12 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:369) WARN Timer-1 Acs.MGMT.ACSVIEW View Database service are s
tarted for runinng
Apr 15 2014 02:12:12 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:440) WARN Timer-1 Acs.MGMT.ACSVIEW Loading jobs from database.
.......
Apr 15 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeJob.execute(DBPurgeJob.java:103) WARN DefaultQuartzScheduler_Worker-1 Acs.MGMT.ACSVIEW
DB Purge Job: The number of incoming log messages is reaching the threshold value :0.06
Apr 15 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.<init>(DBPurgeImpl.java:82) WARN DefaultQuartzScheduler_Worker-1 Acs.MGMT.ACSVIEW
Last Purge Date: 20140415
Apr 15 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.executePurge(DBPurgeImpl.java:513) WARN DefaultQuartzScheduler_Worker-1 Acs.MGMT.A
CSVIEW executePurge incremental mode active: false
Apr 15 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.purgeTransactionLog(DBPurgeUtil.java:595) WARN DefaultQuartzScheduler_Worker-1 Acs
.MGMT.ACSVIEW Purging Transaction log through DBPurgeDAO call...
Apr 15 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentMonthToPurge(DBPurgeUtil.java:885) WARN DefaultQuartzScheduler_Worker
-1 Acs.MGMT.ACSVIEW Most Recent Month To Purge config mode :false
Apr 15 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentMonthToPurge(DBPurgeUtil.java:890) WARN DefaultQuartzScheduler_Worker
-1 Acs.MGMT.ACSVIEW Most Recent Month To Purge CurrentMonth :4 Window size :12
Apr 15 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:798) WARN DefaultQuartzSchedul
er_Worker-1 Acs.MGMT.ACSVIEW MostRecentDataToPurgeDateString month :4Current Month:4Current Day:15
Apr 15 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:813) WARN DefaultQuartzSchedul
er_Worker-1 Acs.MGMT.ACSVIEW MostRecentDataToPurgeDateString previous Year :2013
Apr 15 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:816) WARN DefaultQuartzSchedul
er_Worker-1 Acs.MGMT.ACSVIEW Configuration Mode :falsedelim value :
Apr 15 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:832) WARN DefaultQuartzSchedul
er_Worker-1 Acs.MGMT.ACSVIEW Most Recent Data to Purge Datestring: 20130431
Apr 15 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.executePurge(DBPurgeImpl.java:567) WARN DefaultQuartzScheduler_Worker-1 Acs.MGMT.A
CSVIEW Last Backup timestamp : 20140415
Apr 15 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.executePurge(DBPurgeImpl.java:584) WARN DefaultQuartzScheduler_Worker-1 Acs.MGMT.A
CSVIEW Incremental backup mode is not configured and checking whether the day is end of month
Apr 15 2014 04:45:18 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:369) WARN main Acs.MGMT.ACSVIEW View Database service are star
ted for runinng
Apr 15 2014 04:45:18 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:440) WARN main Acs.MGMT.ACSVIEW Loading jobs from database....
....
Apr 15 2014 04:49:13 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:369) WARN main Acs.MGMT.ACSVIEW View Database service are star
ted for runinng
Apr 15 2014 04:49:13 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:440) WARN main Acs.MGMT.ACSVIEW Loading jobs from database....
....
May 23 2014 07:31:07 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:369) WARN main Acs.MGMT.ACSVIEW View Database service are star
ted for runinng
May 23 2014 07:31:07 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:440) WARN main Acs.MGMT.ACSVIEW Loading jobs from database....
....
May 23 2014 08:04:42 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:369) WARN main Acs.MGMT.ACSVIEW View Database service are star
ted for runinng
May 23 2014 08:04:42 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:440) WARN main Acs.MGMT.ACSVIEW Loading jobs from database....
....
May 23 2014 08:55:12 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:369) WARN main Acs.MGMT.ACSVIEW View Database service are star
ted for runinng
May 23 2014 08:55:13 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:440) WARN main Acs.MGMT.ACSVIEW Loading jobs from database....
....
May 24 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeJob.execute(DBPurgeJob.java:103) WARN DefaultQuartzScheduler_Worker-2 Acs.MGMT.ACSVIEW
DB Purge Job: The number of incoming log messages is reaching the threshold value :0.02
May 24 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.<init>(DBPurgeImpl.java:82) WARN DefaultQuartzScheduler_Worker-2 Acs.MGMT.ACSVIEW
Last Purge Date: 20140415
May 24 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.executePurge(DBPurgeImpl.java:513) WARN DefaultQuartzScheduler_Worker-2 Acs.MGMT.A
CSVIEW executePurge incremental mode active: false
May 24 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.purgeTransactionLog(DBPurgeUtil.java:595) WARN DefaultQuartzScheduler_Worker-2 Acs
.MGMT.ACSVIEW Purging Transaction log through DBPurgeDAO call...
May 24 2014 04:00:01 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentMonthToPurge(DBPurgeUtil.java:885) WARN DefaultQuartzScheduler_Worker
-2 Acs.MGMT.ACSVIEW Most Recent Month To Purge config mode :false
May 24 2014 04:00:01 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentMonthToPurge(DBPurgeUtil.java:890) WARN DefaultQuartzScheduler_Worker
-2 Acs.MGMT.ACSVIEW Most Recent Month To Purge CurrentMonth :5 Window size :12
May 24 2014 04:00:01 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:798) WARN DefaultQuartzSchedul
er_Worker-2 Acs.MGMT.ACSVIEW MostRecentDataToPurgeDateString month :5Current Month:5Current Day:24
May 24 2014 04:00:01 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:813) WARN DefaultQuartzSchedul
er_Worker-2 Acs.MGMT.ACSVIEW MostRecentDataToPurgeDateString previous Year :2013
May 24 2014 04:00:01 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:816) WARN DefaultQuartzSchedul
er_Worker-2 Acs.MGMT.ACSVIEW Configuration Mode :falsedelim value :
May 24 2014 04:00:01 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:832) WARN DefaultQuartzSchedul
er_Worker-2 Acs.MGMT.ACSVIEW Most Recent Data to Purge Datestring: 20130531
May 24 2014 04:00:01 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.executePurge(DBPurgeImpl.java:567) WARN DefaultQuartzScheduler_Worker-2 Acs.MGMT.A
CSVIEW Last Backup timestamp : 20140415
May 24 2014 04:00:01 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.executePurge(DBPurgeImpl.java:584) WARN DefaultQuartzScheduler_Worker-2 Acs.MGMT.A
CSVIEW Incremental backup mode is not configured and checking whether the day is end of month
May 25 2014 10:33:49 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:369) WARN main Acs.MGMT.ACSVIEW View Database service are star
ted for runinng
May 25 2014 10:33:50 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:440) WARN main Acs.MGMT.ACSVIEW Loading jobs from database....
....
May 26 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeJob.execute(DBPurgeJob.java:103) WARN DefaultQuartzScheduler_Worker-2 Acs.MGMT.ACSVIEW
DB Purge Job: The number of incoming log messages is reaching the threshold value :0
May 26 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.<init>(DBPurgeImpl.java:82) WARN DefaultQuartzScheduler_Worker-2 Acs.MGMT.ACSVIEW
Last Purge Date: 20140415
May 26 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.executePurge(DBPurgeImpl.java:513) WARN DefaultQuartzScheduler_Worker-2 Acs.MGMT.A
CSVIEW executePurge incremental mode active: false
May 26 2014 04:00:01 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.purgeTransactionLog(DBPurgeUtil.java:595) WARN DefaultQuartzScheduler_Worker-2 Acs
.MGMT.ACSVIEW Purging Transaction log through DBPurgeDAO call...
May 26 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentMonthToPurge(DBPurgeUtil.java:885) WARN DefaultQuartzScheduler_Worker
-2 Acs.MGMT.ACSVIEW Most Recent Month To Purge config mode :false
May 26 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentMonthToPurge(DBPurgeUtil.java:890) WARN DefaultQuartzScheduler_Worker
-2 Acs.MGMT.ACSVIEW Most Recent Month To Purge CurrentMonth :5 Window size :12
May 26 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:798) WARN DefaultQuartzSchedul
er_Worker-2 Acs.MGMT.ACSVIEW MostRecentDataToPurgeDateString month :5Current Month:5Current Day:26
May 26 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:813) WARN DefaultQuartzSchedul
er_Worker-2 Acs.MGMT.ACSVIEW MostRecentDataToPurgeDateString previous Year :2013
May 26 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:816) WARN DefaultQuartzSchedul
er_Worker-2 Acs.MGMT.ACSVIEW Configuration Mode :falsedelim value :
May 26 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:832) WARN DefaultQuartzSchedul
er_Worker-2 Acs.MGMT.ACSVIEW Most Recent Data to Purge Datestring: 20130531
May 26 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.executePurge(DBPurgeImpl.java:567) WARN DefaultQuartzScheduler_Worker-2 Acs.MGMT.A
CSVIEW Last Backup timestamp : 20140415
May 26 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.executePurge(DBPurgeImpl.java:584) WARN DefaultQuartzScheduler_Worker-2 Acs.MGMT.A
CSVIEW Incremental backup mode is not configured and checking whether the day is end of month
May 27 2014 00:05:23 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:369) WARN main Acs.MGMT.ACSVIEW View Database service are star
ted for runinng
May 27 2014 00:05:23 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:440) WARN main Acs.MGMT.ACSVIEW Loading jobs from database....
....
May 27 2014 00:18:08 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:369) WARN main Acs.MGMT.ACSVIEW View Database service are star
ted for runinng
May 27 2014 00:18:08 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:440) WARN main Acs.MGMT.ACSVIEW Loading jobs from database....
....
May 27 2014 00:25:58 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:369) WARN main Acs.MGMT.ACSVIEW View Database service are star
ted for runinng
May 27 2014 00:25:59 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:440) WARN main Acs.MGMT.ACSVIEW Loading jobs from database....
....
May 27 2014 00:38:06 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:369) WARN main Acs.MGMT.ACSVIEW View Database service are star
ted for runinng
May 27 2014 00:38:06 com.cisco.nm.acs.view.common.jobmgr.JobManager.start(JobManager.java:440) WARN main Acs.MGMT.ACSVIEW Loading jobs from database....
....
May 27 2014 03:40:03 com.cisco.nm.acs.view.common.remotedatabase.ExportDataJob.execute(ExportDataJob.java:132) ERROR DefaultQuartzScheduler_Worker-10 Ac
s.MGMT.ACSVIEW Export Data : exception org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []
; SQL state [HY000]; error code [-660];
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.; ne
sted exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:397)
at com.cisco.nm.acs.view.dbms.impl.RemoteDatabaseDAOImpl.exportTables(RemoteDatabaseDAOImpl.java:473)
at com.cisco.nm.acs.view.dbms.impl.RemoteDatabaseDAOImpl.exportDataToRemoteDatabase(RemoteDatabaseDAOImpl.java:203)
at com.cisco.nm.acs.view.common.remotedatabase.ExportDataJob.execute(ExportDataJob.java:125)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:447)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:399)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
... 6 more
Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at sybase.jdbc.sqlanywhere.IIPreparedStatement.execute(Native Method)
at sybase.jdbc.sqlanywhere.IPreparedStatement.execute(IPreparedStatement.java:368)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
... 10 more

May 27 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeJob.execute(DBPurgeJob.java:103) WARN DefaultQuartzScheduler_Worker-1 Acs.MGMT.ACSVIEW
DB Purge Job: The number of incoming log messages is reaching the threshold value :0.01
May 27 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.<init>(DBPurgeImpl.java:82) WARN DefaultQuartzScheduler_Worker-1 Acs.MGMT.ACSVIEW
Last Purge Date: 20140415
May 27 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.executePurge(DBPurgeImpl.java:513) WARN DefaultQuartzScheduler_Worker-1 Acs.MGMT.A
CSVIEW executePurge incremental mode active: false
May 27 2014 04:00:00 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.purgeTransactionLog(DBPurgeUtil.java:595) WARN DefaultQuartzScheduler_Worker-1 Acs
.MGMT.ACSVIEW Purging Transaction log through DBPurgeDAO call...
May 27 2014 04:00:01 com.cisco.nm.acs.view.common.remotedatabase.ExportDataJob.execute(ExportDataJob.java:132) ERROR DefaultQuartzScheduler_Worker-2 Acs
.MGMT.ACSVIEW Export Data : exception org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL [];
SQL state [HY000]; error code [-660];
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.; ne
sted exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:397)
at com.cisco.nm.acs.view.dbms.impl.RemoteDatabaseDAOImpl.exportTables(RemoteDatabaseDAOImpl.java:473)
at com.cisco.nm.acs.view.dbms.impl.RemoteDatabaseDAOImpl.exportDataToRemoteDatabase(RemoteDatabaseDAOImpl.java:203)
at com.cisco.nm.acs.view.common.remotedatabase.ExportDataJob.execute(ExportDataJob.java:125)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:447)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:399)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
... 6 more
Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at sybase.jdbc.sqlanywhere.IIPreparedStatement.execute(Native Method)
at sybase.jdbc.sqlanywhere.IPreparedStatement.execute(IPreparedStatement.java:368)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
... 10 more

May 27 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentMonthToPurge(DBPurgeUtil.java:885) WARN DefaultQuartzScheduler_Worker
-1 Acs.MGMT.ACSVIEW Most Recent Month To Purge config mode :false
May 27 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentMonthToPurge(DBPurgeUtil.java:890) WARN DefaultQuartzScheduler_Worker
-1 Acs.MGMT.ACSVIEW Most Recent Month To Purge CurrentMonth :5 Window size :12
May 27 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:798) WARN DefaultQuartzSchedul
er_Worker-1 Acs.MGMT.ACSVIEW MostRecentDataToPurgeDateString month :5Current Month:5Current Day:27
May 27 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:813) WARN DefaultQuartzSchedul
er_Worker-1 Acs.MGMT.ACSVIEW MostRecentDataToPurgeDateString previous Year :2013
May 27 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:816) WARN DefaultQuartzSchedul
er_Worker-1 Acs.MGMT.ACSVIEW Configuration Mode :falsedelim value :
May 27 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeUtil.getMostRecentDataToPurgeDateString(DBPurgeUtil.java:832) WARN DefaultQuartzSchedul
er_Worker-1 Acs.MGMT.ACSVIEW Most Recent Data to Purge Datestring: 20130531
May 27 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.executePurge(DBPurgeImpl.java:567) WARN DefaultQuartzScheduler_Worker-1 Acs.MGMT.A
CSVIEW Last Backup timestamp : 20140415
May 27 2014 04:00:02 com.cisco.nm.acs.view.common.dbpurge.DBPurgeImpl.executePurge(DBPurgeImpl.java:584) WARN DefaultQuartzScheduler_Worker-1 Acs.MGMT.A
CSVIEW Incremental backup mode is not configured and checking whether the day is end of month
May 27 2014 04:20:01 com.cisco.nm.acs.view.common.remotedatabase.ExportDataJob.execute(ExportDataJob.java:132) ERROR DefaultQuartzScheduler_Worker-3 Acs
.MGMT.ACSVIEW Export Data : exception org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL [];
SQL state [HY000]; error code [-660];
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.; ne
sted exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:397)
at com.cisco.nm.acs.view.dbms.impl.RemoteDatabaseDAOImpl.exportTables(RemoteDatabaseDAOImpl.java:473)
at com.cisco.nm.acs.view.dbms.impl.RemoteDatabaseDAOImpl.exportDataToRemoteDatabase(RemoteDatabaseDAOImpl.java:203)
at com.cisco.nm.acs.view.common.remotedatabase.ExportDataJob.execute(ExportDataJob.java:125)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:447)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:399)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
... 6 more
Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at sybase.jdbc.sqlanywhere.IIPreparedStatement.execute(Native Method)
at sybase.jdbc.sqlanywhere.IPreparedStatement.execute(IPreparedStatement.java:368)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
... 10 more

May 27 2014 04:40:00 com.cisco.nm.acs.view.common.remotedatabase.ExportDataJob.execute(ExportDataJob.java:132) ERROR DefaultQuartzScheduler_Worker-4 Acs
.MGMT.ACSVIEW Export Data : exception org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL [];
SQL state [HY000]; error code [-660];
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.; ne
sted exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:397)
at com.cisco.nm.acs.view.dbms.impl.RemoteDatabaseDAOImpl.exportTables(RemoteDatabaseDAOImpl.java:473)
at com.cisco.nm.acs.view.dbms.impl.RemoteDatabaseDAOImpl.exportDataToRemoteDatabase(RemoteDatabaseDAOImpl.java:203)
at com.cisco.nm.acs.view.common.remotedatabase.ExportDataJob.execute(ExportDataJob.java:125)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:447)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:399)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
... 6 more
Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at sybase.jdbc.sqlanywhere.IIPreparedStatement.execute(Native Method)
at sybase.jdbc.sqlanywhere.IPreparedStatement.execute(IPreparedStatement.java:368)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
... 10 more

May 27 2014 05:00:00 com.cisco.nm.acs.view.common.remotedatabase.ExportDataJob.execute(ExportDataJob.java:132) ERROR DefaultQuartzScheduler_Worker-5 Acs
.MGMT.ACSVIEW Export Data : exception org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL [];
SQL state [HY000]; error code [-660];
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.; ne
sted exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:397)
at com.cisco.nm.acs.view.dbms.impl.RemoteDatabaseDAOImpl.exportTables(RemoteDatabaseDAOImpl.java:473)
at com.cisco.nm.acs.view.dbms.impl.RemoteDatabaseDAOImpl.exportDataToRemoteDatabase(RemoteDatabaseDAOImpl.java:203)
at com.cisco.nm.acs.view.common.remotedatabase.ExportDataJob.execute(ExportDataJob.java:125)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in RemoteDatabaseMap.xml.
--- The error occurred while applying a parameter map.
--- Check the RemoteDatabaseMap.exportDataToRemoteDB-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:447)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:399)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
... 6 more
Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server '172.16.9.250': [FreeTDS][SQL Server]Statement(s) could not be prepared.
at sybase.jdbc.sqlanywhere.IIPreparedStatement.execute(Native Method)
at sybase.jdbc.sqlanywhere.IPreparedStatement.execute(IPreparedStatement.java:368)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
... 10 more

acs5a/admin#

topic ACS5.5 Export Data run Failed in Network Access Control

ACS5.5 Export Data run Failed

Hey,Could you attach the logs