Hi,

If you right click on the Manager node from the Console, there is an option to 'Synchronize local database'. By clicking on this menu option, you can synchronize the local database.

The details of this option -
Symantec ESM stores the policy run summary data and module message details in two databases: the manager sumfinal database on the manager computer and the local summary database on the ESM console computer.

As you cannot access the data in a manager sumfinal database directly, the ESM console provides a way to upload the information to your local summary database. You must use the third-party database management or report generation software to query the local summary database. This query capability provides great flexibility in analyzing the network resource vulnerabilities identified by Symantec ESM policy runs.

When a query requires summary information only, you should choose to synchronize the database. This process takes only a fraction of the time required to upload module message details from managers. The ESM console can selectively store summary information from a single manager, all of the managers in a region, or all managers connected to the ESM console.

The local summary database is a component of the ESM console. When the ESM console creates a user account, it also creates a local summary database file for the account. Use the Discretionary Access Control List (ACL) in Windows to secure this local summary database file. See the Windows help for information on accessing the ACL. Only the user who is logged on to the ESM console account should have full control over the file.

The local summary database is a Microsoft Access relational database in .mdb native file format. You can access this database with Microsoft Access or use it as an ODBC data source.

Please let me know if this doesnot answer your query.

Regards,
-Rupali

Hi,

Thanks for your reply, but I already know what you said.
The problem is the synchronization between sumfinal database on the manager and the local summary database on my computer does not work!
I have always the same error : "Syntax error (missing operator) in expression".

I don't know how I can find the error in the communication between the manager and my computer.
My manager is on Solaris et my computer on windows. Is it possible that the problem is due to non-standard character (like éèà, etc...)?

I think I can't analyze the communication with a sniffer for example because it use CSP protocole, is it right?

Regards,
Damien

Hi Damien,

As per the Anjali's suggestion, Can you try to run the ciffix?

If it doent work ,please get in touch with the support team. It will help us to find out the issue and resolve it ASAP.

Yes, the communication uses CSP protocol, but I have never tried using N/W sniffers to sniff the communication between ESM components.

Regards,
-Rupali

Hi Rupali,

I launched the utility several times ciffix, but I always have the same problem

And I have already contacted support, but not put anything, the problem is still there.

Regards,
Damien