cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2142
Views
0
Helpful
4
Replies

ACS 5.2 remote database setting problem

Mason Tu
Level 1
Level 1

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.

1 Accepted Solution

Accepted Solutions

iilyinas
Level 3
Level 3

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!

View solution in original post

4 Replies 4

iilyinas
Level 3
Level 3

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!

We tried yesterday with 5.3, doesn't look better ...

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!

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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: