LRM DAP/JDBC Configuration

[PFCCWA]

hello,

we have deployed LRM on windows 2008 64 bit VM.
when starting the component, it does not appear to be connecting to the LRM (oracle) db (through jdbc).
using sqlplus command we have confirmed connectivity from the host to DB.
LRM logs show repeated attempts to connect via jdbc, every 10 minutes.
at the 1 AM point, we see failed messages suggesting it could not connect to ICON or LRM DBs.

LRM has ICON DAP and LRM DAP connections.
LRM DAP has lrm section, role=main
ICON DAP has lrm section, role=icon

CLASSPATH is defined within Environment Variables.
LRM/LCA restarts have been completed.

any suggestions?

thanks.

[hsujdik]

Is your windows firewall disabled? Because it can be selective on which applications can use network resources... That could be one of the possibilities why sqlplus was able to connect to the db, while java wasn't

[PFCCWA]

hello
yes I have checked and status of firewall is off.

thanks.

[hsujdik]

Another thing to check: is Oracle jdbc driver JAR file on the classpath too?

[PFCCWA]

yes classpath is defined.

is there a method to test java specifically, or test lrm away from genesys.

[PFCCWA]

is this jar file version issue
cannot see it anywhere but is odjbc6.jar or odbc7.jar compatible?

[Timur Karimov]

Try configure jdbc-url option under the lrm section in LRM DAP to your DBMS requirements
Section: lrm
Option: jdbc-url
Value: jdbc:oracle:thin:@//HostName:1521/LRM_Service_Name

[PFCCWA]

hello

yes this is what I have done
it has also been confirmed that the is a connection between lrm and the lrm db - but there is a failed process at the nightly schedule.
in the logs there is a jdbc connecting message, every 10 minutes,
I am starting to wonder if this is a db user permission issue

thanks.

[Timur Karimov]

[quote author=PFCCWA link=topic=9395.msg42523#msg42523 date=1457025399]
but there is a failed process at the nightly schedule.
in the logs there is a jdbc connecting message, every 10 minutes,
[/quote]
could you please explain it with more details?

[PFCCWA]

here is extract from log

01:00:58.991 Standard LM_HOST LRM_PR GCTI-03-40101 com.genesyslab.lrm.scheduling.MiningTask LRM failed while performing stats gathering job. Error Message 'java.sql.SQLRecoverableException: IO Error: Got minus one from a read call'
01:00:58.991 Standard LM_HOST LRM_PR GCTI-03-40000 com.genesyslab.lrm.scheduling.MiningTask StackTrace: oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.genesyslab.lrm.db.JDBCConnector.reconnect(JDBCConnector.java:83)
com.genesyslab.lrm.db.JDBCConnector.<init>(JDBCConnector.java:46)
com.genesyslab.lrm.core.TableMerger.synchronizeAll(TableMerger.java:234)
com.genesyslab.lrm.core.Facade.syncData(Facade.java:100)
com.genesyslab.lrm.core.Facade.computeUsage(Facade.java:157)
com.genesyslab.lrm.core.Facade.facadeMainThrowable(Facade.java:227)
com.genesyslab.lrm.scheduling.MiningTask.run(MiningTask.java:34)
com.genesyslab.lrm.scheduling.Scheduler$1.run(Scheduler.java:68)
java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
java.util.concurrent.FutureTask.run(Unknown Source)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.lang.Thread.run(Unknown Source)
01:00:59.007 Debug LM_HOST LRM_PR GCTI-03-09900 com.genesyslab.lrm.LrmServer permit for task MiningTask released
01:30:59.064 Debug LM_HOST LRM_PR GCTI-03-09900 com.genesyslab.lrm.LrmServer permit for task PollingTask obtained
01:31:05.471 Standard LM_HOST LRM_PR GCTI-03-30105 com.genesyslab.lrm.core.Facade LRM starts collecting Agent and Place group membership information from Config Server

[Timur Karimov]

Looks like something wrong in you jdbc connection setup. check java verision , db server sid and port.

[hsujdik]

Hey PFCCWA! Some additional questions for you:

1. When you connected through SQL Plus, was it on the same machine as LRM is installed? Or was it a different machine? Same user as LRM to connect? Did you use TNS for that connection or specified the host/port/service manually?
2. Can you post how is your jdbc-url configured?
3. Can you post the contents of sqlnet.ora and tnslistener.ora files used by your database?
4. Can you post the contents of tnsnames.ora file of the machine you connected using SQL Plus?
5. Can you post the output of the following SQL statements?

SELECT name, value FROM v$parameter WHERE name = 'sessions';

SELECT PRIVILEGE
  FROM sys.dba_sys_privs
WHERE grantee = '<LRM_DB_USER>'
UNION
SELECT PRIVILEGE
  FROM dba_role_privs rp JOIN role_sys_privs rsp ON (rp.granted_role = rsp.role)
WHERE rp.grantee = '<LRM_DB_USER>'
ORDER BY 1;

Maybe those informations can give a better clue on what is happening...