Buy or Renew
Buy or Renew
Duo Security forums now LIVE! Get answers to all your Duo Security questions. Learn more
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
612
Views
0
Helpful
1
Replies

ACS5.5 Export Data run Failed

weiyong wu
Level 1
Level 1

‎05-26-2014 10:45 PM - edited ‎03-10-2019 09:45 PM

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#                   

Labels:
Preview file
15 KB
0 Helpful
1 Reply 1

edwardcollins7
Level 1
Level 1

‎05-27-2014 12:09 AM

Hey,

Could you attach the logs as a file?

These logs are in warn level, could you turn on the debugs.

acs-config

use GUI password

then

debug-log mgmt level debug

Rate if Useful :)

Sharing knowledge makes you Immortal.

Regards,

Ed

0 Helpful
Customers Also Viewed These Support Documents