Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

ACS5.5 Export Data run Failed

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#                   

Everyone's tags (1)
1 REPLY

Hey,Could you attach the logs

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

225
Views
0
Helpful
1
Replies
CreatePlease login to create content