Description: Many times we faced the issue that the ROC session is getting timeout frequently within 4-5 minutes.
Identification: The entries in the context.xml under conf folder in LISA RAC root directory is set wrong..
Resolution: Correct the entries in the context.xml. Please find correct entries below.
Note: Below is an example where DB is SQLExpress. This setting should be applied in accordance of database vendor been used"
Wrong
connectionName="nolio" connectionPassword="*****" connectionURL="jdbc:sqlserver://localhost:1443//SQLEXPRESS;databaseName=Nolio_Latest_Localhost"
Correct:
Note: Check default port for SQLExpress should be 1433 worth verifying it.
connectionName="nolio" connectionPassword="******" connectionURL="jdbc:sqlserver://localhost:1433;databaseName=Nolio_Latest_Localhost"