09-16-2011 09:20 AM - edited 03-10-2019 06:24 PM
Hello everyone,
I have installed ACS 5.2 appliance and try to backup report to remote database(MS SQL Server 2005) using remote database settings.
But the database is empty and the job in scheduler is failed.
So I check MonitoringAndReportingScheduler.log and found the log message in the attached file.
I try to find out answer in Cisco Support Community but found nothing.
But I google an article almost the same condiction as mine.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_26931183.html
I wonder what database configuration should I alter to meet the requirement of this report backup.
Because there is nothing about database in ACS configuration guide.
Does anyone succefully using this function?
What does "
I have changed database collation from SQL Latin to no SQL and it's working." in the article mean?
Thanks in advanced.
Solved! Go to Solution.
09-16-2011 11:48 PM
Hi, Mason,
It's most probably because of the CSCtk83179 ACS 5 View export to remote SQL DB not working.
You have to wait for ACS 5.3 or patch 7 for ACS 5.2.
Cheers, Irina
---
PS: Please, rate helpful posts!
09-16-2011 11:48 PM
Hi, Mason,
It's most probably because of the CSCtk83179 ACS 5 View export to remote SQL DB not working.
You have to wait for ACS 5.3 or patch 7 for ACS 5.2.
Cheers, Irina
---
PS: Please, rate helpful posts!
11-09-2011 01:53 AM
We tried yesterday with 5.3, doesn't look better ...
11-09-2011 04:35 AM
Hello, Rishi,
Well, it's hard to say what problem could you encounter without seeing logs ;-) If the error is exactly the same, I'd suggest to open a TAC case - as the bug, I've mentioned, is fixed in ACS 5.3.
Cheers, Irina
---
PS: Please, rate helpful posts!
11-09-2011 04:58 AM
We opened a case.
Here's the message in the scheduler :
ExportDataJob | Remote Database export Utility | System | Wed Nov 09 07:30:01 CET 2011 | Export Data run Failed. | Failed |
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide