ACS 5.2 remote database setting problem

Answered Question
Sep 16th, 2011

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.

I have this problem too.
0 votes
Correct Answer by iilyinas about 2 years 7 months ago

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!

  • 1
  • 2
  • 3
  • 4
  • 5
Average Rating: 5 (1 ratings)
Correct Answer
iilyinas Fri, 09/16/2011 - 23:48

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!

iilyinas Wed, 11/09/2011 - 04:35

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!

rishi.sumbal Wed, 11/09/2011 - 04:58

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

Actions

Login or Register to take actions

This Discussion

Posted September 16, 2011 at 9:20 AM
Stats:
Replies:4 Avg. Rating:5
Views:1287 Votes:0
Shares:0

Related Content

Discussions Leaderboard