Operational Defect Database
BugZero updated this defect 58 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
VMware | 374702
Smarts NCM: Which log file can I check to see if database transactions are being executed?
Last update date:
3/22/2024
Affected products:
Smart Assurance - NCM
Affected releases:
No affected releases provided.
Fixed releases:
No fixed releases provided.
Description:
Symptoms
Which log file can I check to see if Smarts Network Configuration Manager (Smarts NCM) database transactions are being executed?
Resolution
To see if database transactions are being carried out, review the server.postmaster file. This file is located under the /var/log/controldb directory. The following are examples of entries that can be found in the file: 2012-09-12 13:48:06.858 EDT - SessionId:5050cad6.4e5b - TransId:0 - STATEMENT: ALTER TABLE ONLY cm_cel_audit_record ADD CONSTRAINT cm_cel_audit_record_pkey PRIMARY KEY (id);2012-09-12 13:48:06.859 EDT - SessionId:5050cad6.4e5b - TransId:0 - ERROR: multiple primary keys for table "cm_config_file" are not allowed 2010-10-08 14:58:10.898 EDT - SessionId:4caf69c2.4dd4 - TransId:7542 - NOTICE: Command executed is: ALTER TABLE voyence.cm_meta_attribute_value DROP CONSTRAINT cm_meta_attribute_value_site_id_fkey The examples above shows output indicating a table drop has taken place or an error has occurred when trying to execute a particular command.
