| Asset ID: |
1-72-2155368.1 |
| Update Date: | 2017-02-23 |
| Keywords: | |
Solution Type
Problem Resolution Sure
Solution
2155368.1
:
E5MS 46.0 TimeOut Error During Execution of Reports Via Inet Reporting Studio
| Related Items |
- Oracle Communications EAGLE (Software)
|
| Related Categories |
- PLA-Support>Sun Systems>CommsGBU>Global Signaling Solutions>SN-SND: Tekelec EMS
|
In this Document
Created from <SR 3-12388115021>
Applies to:
Oracle Communications EAGLE (Software) - Version E5-MS 46.0 and later
Tekelec
Symptoms
Getting Time Out during execution default report via i-net Clear Report.
Cause
Issue appears due to delay in fetching data from Mysql for Meas Reports Generated by Reporting Studio.
The error received is QUERY TIMEOUT which shows that the issue is due to delay in fetching the required data from Mysql DB.
Solution
Increase the Mysql Query Timeout Value
Please contact Technical Support Center for changing Query Timeout Value
Increase the Mysql Query Timeout Value in ReportViewer.jar file through these steps:
- Change directory
cd /usr/local/i-net\ Clear\ Reports/
- Stop E5MS Reporting Studio
sh stopListener.sh
- Replace the ReportViewer.jar File with the new file with query timeout value set to 0 (i.e. infinite). This File can be received from CoE (Center of Excellence).
- Start E5MS Reporting Studio:
sh startListener.sh
Decrease the Retention Time
- Login to Mysql:
cd /Tekelec/WebNMS/mysql/bin
./mysql -uroot -p<password for mysql user root>
- Run sql queries:
UPDATE tekelec_meas_reports SET DB_RETENTION_DAYS='7' where TABLE_NAME='TEK_MEAS_COMP_LINK';
UPDATE tekelec_meas_reports SET DB_RETENTION_DAYS='7' where TABLE_NAME='TEK_MEAS_COMP_LNKSET';
Repeat this step all the other Reports Tables in tekelec_meas_reports Table
Attachments
This solution has no attachment
