no records in MYSQL dataase

Document ID : KB000103064
Last Modified Date : 22/06/2018
Show Technical Document Details
Question:
How to check MYSQL connection to write records in History file on a Linux system?
Answer:
First perform a loopback transfer with XTRACE=10 and look for the SQLConnection for user =root as follows:

sqlutil 5759: About to SQLConnect user = root. 
sqlutil 5761: Time at start of SQLConnect=1529503148 
sqlutil 5767: SQLConnect rc = 0, time = 1529503148 
sqlutil 5782: SQLAllocHandle rc = 0 
sqlutil 5786: SQLExecDirect rc = 0 
sqlutil 5798: Transfer record inserted into the database successfully. 

Second ran a test within the GUI. Therefore login as root and goto directory /opt/CA/XCOM/bin and enter command StandaloneUI.sh.
To test your connection to the database use the TEST button to see if they have a connection to the database. The test button is in the Global Parameters in the History section.