[GVP 8] Problem with GVP Reporting Server

genecool · January 4, 2012, 11:31am

Hi,

I encounter a problem with Reporting Server which wants not start :

12:15:36.470 Trace GVPReportingServer ReportingServer GCTI-153-04100 com.genesyslab.commons.log4j.LoggingManager Logging service started 12:15:36.482 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionSettingProcessor Connection Settings listener for 'Message Server'processing configuration update 12:15:36.482 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService Starting Warm Standby service for CFGMessageServer at Message ServerPRIMARY - tcp://192.168.10.65:5051 12:15:36.482 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService request to establish automatic primary/backup reconnect procedure accepted on connection with:CFGMessageServer at Message ServerPRIMARY - tcp://192.168.10.65:5051 12:15:36.482 Trace GVPReportingServer ReportingServer GCTI-153-04500 com.genesyslab.commons.ConnectionManagementService Connecting to Message Server 'Message Server' at host '192.168.10.65', port 5051 12:15:36.482 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Successfully obtained configuration from configuration server. 12:15:36.497 Standard GVPReportingServer ReportingServer GCTI-153-04503 com.genesyslab.commons.ConnectionManagementService Connected to CFGMessageServer 'CFGMessageServer' at host '192.168.10.65', port 5051 12:15:36.497 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService start of fireServerContacted() 12:15:36.532 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Creating HTTP connector on: 8080 12:15:36.575 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.lca.LCAManager activate JVM shutdown hook 12:15:36.575 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is initiated 12:15:36.575 Trace GVPReportingServer ReportingServer GCTI-153-04500 com.genesyslab.commons.lca.LCAManager Connecting to Local Control Agent 'LCA' at host 'localhost', port 4999 12:15:36.575 Standard GVPReportingServer ReportingServer GCTI-153-05061 com.gvp.rpt.service.StandAloneReportingService Initialization completed 12:15:36.579 Standard GVPReportingServer ReportingServer GCTI-153-04503 com.genesyslab.commons.lca.LCAManager Connected to Local Control Agent 'LCA' at host 'localhost', port 4999 12:15:36.583 Trace GVPReportingServer ReportingServer GCTI-153-20001 com.genesyslab.commons.lca.LCAManager Reporting Server initializing in 'standalone' mode 12:15:36.583 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService PARTITIONING_ENABLED is false. Using configuration - [Ljava.lang.String;@1627c16 12:15:37.462 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Building new Hibernate SessionFactory 12:15:38.431 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.dao.SessionFactoryBean Closing opened DB session. 12:15:38.790 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean Supported JMS broker connections: UNENCRYPTED 12:15:38.790 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean JMS broker listening on: tcp://0.0.0.0:61616?transport.closeAsync=false 12:15:39.235 Trace GVPReportingServer ReportingServer GCTI-153-20007 com.gvp.rpt.service.DateComponentsPopulationJob DateComponents Population job run 12:15:39.235 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.DateComponentsPopulationJob Populating DateComponents from Sat Jan 01 00:00:00 CET 2011 until Tue Jan 01 00:00:00 CET 2013 12:15:40.798 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Closing Hibernate SessionFactory [b]12:15:40.802 Standard GVPReportingServer ReportingServer GCTI-153-50000 com.gvp.rpt.service.StandAloneReportingService Unable to start RS application context, shutting down. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'callSummaryLoggingJob' defined in class path resource [quartz.config.xml]: Cannot resolve reference to bean 'callSummaryLoggingService' while setting bean property 'targetObject'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'datePopulateService' defined in class path resource [ems-rs-withDB.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection [/b]12:15:40.802 Standard GVPReportingServer ReportingServer GCTI-153-30001 com.genesyslab.commons.lca.LCAManager Reporting Server is unable to change its runtime mode 12:15:40.802 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service 12:15:40.903 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context 12:15:40.903 Trace GVPReportingServer ReportingServer GCTI-153-04109 com.genesyslab.commons.log4j.LoggingManager Logging service stopped 12:15:40.903 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Message ServerPRIMARY - tcp://192.168.10.65:5051 successfully shut down. 12:15:40.903 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Configuration ServerPRIMARY - tcp://FwkServer:2020 successfully shut down. 12:15:40.907 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed 12:15:40.907 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is completed. 12:15:40.907 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Shutdown of LCAManager is completed. 12:15:40.907 Standard GVPReportingServer ReportingServer GCTI-153-05063 com.gvp.rpt.service.StandAloneReportingService Normal termination 12:15:40.907 Standard GVPReportingServer ReportingServer GCTI-153-04505 com.genesyslab.commons.lca.LCAManager Disconnected from Local Control Agent 'LCA' 12:15:41.009 Interaction GVPReportingServer ReportingServer GCTI-153-30000 com.genesyslab.commons.lca.LCAManager Unexpected JVM shutdown detected. Application will attempt to terminate gracefully 12:15:41.009 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service 12:15:41.009 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context 12:15:41.009 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed

Have you any idea ?

Thanks

Rene · January 4, 2012, 12:01pm

Hi,

Reporting Server cannot connect to database thus it shutdown itself.

nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection

Check that parameters in ‘persistence’ section are correct.

R.

genecool · January 4, 2012, 1:45pm

Thank you for your response however, I have already check database connection parameters into ‘persistence’ section.

My particularity is that I have a SQL instance. Do you know how to specify it in the settings?

cavagnaro · January 4, 2012, 2:37pm

If using MSSQL: The instance have a TCP Port, right? If not enable it on the MSSQL server settings.
Then on your connection chain the server name should be “server:port” and then it will recognize the instance automatically. Usually MSSQL uses port 1433 as the standard for the default instance but each instance can have its own TCP port, then the client will connect directly to this.
Regards

genecool · January 4, 2012, 5:45pm

Ok, so, I had an error in my jdbc string connection.

After having corrected it, I still have an error.

Indeed, Reporting Server initializes indefinitely…

Logs are the following :

18:37:08.702 Trace GVPReportingServer ReportingServer GCTI-153-04100 com.genesyslab.commons.log4j.LoggingManager Logging service started 18:37:08.710 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionSettingProcessor Connection Settings listener for 'Message Server'processing configuration update 18:37:08.714 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService Starting Warm Standby service for CFGMessageServer at Message ServerPRIMARY - tcp://192.168.10.65:5051 18:37:08.714 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService request to establish automatic primary/backup reconnect procedure accepted on connection with:CFGMessageServer at Message ServerPRIMARY - tcp://192.168.10.65:5051 18:37:08.714 Trace GVPReportingServer ReportingServer GCTI-153-04500 com.genesyslab.commons.ConnectionManagementService Connecting to Message Server 'Message Server' at host '192.168.10.65', port 5051 18:37:08.714 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Successfully obtained configuration from configuration server. 18:37:08.734 Standard GVPReportingServer ReportingServer GCTI-153-04503 com.genesyslab.commons.ConnectionManagementService Connected to CFGMessageServer 'CFGMessageServer' at host '192.168.10.65', port 5051 18:37:08.734 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService start of fireServerContacted() 18:37:08.765 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Creating HTTP connector on: 8080 18:37:08.804 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.lca.LCAManager activate JVM shutdown hook 18:37:08.804 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is initiated 18:37:08.804 Trace GVPReportingServer ReportingServer GCTI-153-04500 com.genesyslab.commons.lca.LCAManager Connecting to Local Control Agent 'LCA' at host 'localhost', port 4999 18:37:08.804 Standard GVPReportingServer ReportingServer GCTI-153-05061 com.gvp.rpt.service.StandAloneReportingService Initialization completed 18:37:08.812 Standard GVPReportingServer ReportingServer GCTI-153-04503 com.genesyslab.commons.lca.LCAManager Connected to Local Control Agent 'LCA' at host 'localhost', port 4999 18:37:08.812 Trace GVPReportingServer ReportingServer GCTI-153-20001 com.genesyslab.commons.lca.LCAManager Reporting Server initializing in 'standalone' mode 18:37:08.812 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService PARTITIONING_ENABLED is false. Using configuration - [Ljava.lang.String;@29f93b 18:37:09.683 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Building new Hibernate SessionFactory

… and nothing else !

ndongo · August 17, 2012, 9:29am

Hello,

I have similar problem with my Reporting Server.
The release is 8.1.502.67. All Genesys prerequises have been correctly setted.
My database is Oracle 11g RAC with partitionning feature.
The probleme is, I cannot start the RS in DB mode and have a JDBC exception like “Cannot open connection”.
I have tried all JDBC url to connect the DB but everytime I encounter the same error.

Here’s the log message

18:07:59.142 Trace HOSTRS RS_Dev_OSWin GCTI-153-04100 com.genesyslab.commons.log4j.LoggingManager Logging service started 18:07:59.160 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionSettingProcessor Connection Settings listener for 'Message Server'processing configuration update 18:07:59.161 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService Starting Warm Standby service for CFGMessageServer at Message ServerPRIMARY - tcp://xxx.xxx.xxx.xxx:4335 18:07:59.162 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService request to establish automatic primary/backup reconnect procedure accepted on connection with:CFGMessageServer at Message ServerPRIMARY - tcp://xxx.xxx.xxx.xxx:4335 18:07:59.162 Trace HOSTRS RS_Dev_OSWin GCTI-153-04500 com.genesyslab.commons.ConnectionManagementService Connecting to Message Server 'Message Server' at host 'xxx.xxx.xxx.xxx', port 4335 18:07:59.167 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Successfully obtained configuration from configuration server. 18:07:59.192 Trace HOSTRS RS_Dev_OSWin GCTI-153-20050 com.gvp.rpt.snmp.agentx.subagent.RSSubagent No AgentX Master Agent found in Application Connections 18:07:59.193 Trace HOSTRS RS_Dev_OSWin GCTI-153-20043 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Starting SNMP AgentX Subagent 18:07:59.209 Standard HOSTRS RS_Dev_OSWin GCTI-153-04503 com.genesyslab.commons.ConnectionManagementService Connected to CFGMessageServer 'CFGMessageServer' at host 'xxx.xxx.xxx.xxx', port 4335 18:07:59.246 Trace HOSTRS RS_Dev_OSWin GCTI-153-20044 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Exit SNMP AgentX Subagent 18:07:59.329 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Creating HTTP connector on: 8080 18:07:59.409 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager activate JVM shutdown hook 18:07:59.410 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is initiated 18:07:59.410 Trace HOSTRS RS_Dev_OSWin GCTI-153-04500 com.genesyslab.commons.lca.LCAManager Connecting to Local Control Agent 'LCA' at host 'localhost', port 4999 18:07:59.411 Standard HOSTRS RS_Dev_OSWin GCTI-153-05061 com.gvp.rpt.service.StandAloneReportingService Initialization completed 18:07:59.424 Standard HOSTRS RS_Dev_OSWin GCTI-153-04503 com.genesyslab.commons.lca.LCAManager Connected to Local Control Agent 'LCA' at host 'localhost', port 4999 18:07:59.427 Trace HOSTRS RS_Dev_OSWin GCTI-153-20001 com.genesyslab.commons.lca.LCAManager Reporting Server initializing in 'standalone' mode 18:07:59.428 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService PARTITIONING_ENABLED is true. Using configuration - [Ljava.lang.String;@13816e0 18:08:01.946 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Building new Hibernate SessionFactory 18:08:04.627 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.dao.SessionFactoryBean Closing opened DB session. 18:08:06.046 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean Supported JMS broker connections: UNENCRYPTED 18:08:06.047 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean JMS broker listening on: tcp://0.0.0.0:61616?transport.closeAsync=false 18:08:06.488 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.partitioning.PartitionMaintenanceJob Partitioning Job INIT STARTED 1344269286488 18:08:06.544 Standard HOSTRS RS_Dev_OSWin GCTI-153-40000 com.gvp.rpt.partitioning.PartitionMaintenanceJob Failed to archive - RMCallDetailRecord org.hibernate.exception.GenericJDBCException: Cannot open connection 18:08:08.067 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Closing Hibernate SessionFactory 18:08:08.071 Standard HOSTRS RS_Dev_OSWin GCTI-153-40000 com.gvp.rpt.service.StandAloneReportingService Unable to start RS application context, shutting down. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'partitioningService' defined in class path resource [partitioning.config.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection 18:08:08.073 Standard HOSTRS RS_Dev_OSWin GCTI-153-30001 com.genesyslab.commons.lca.LCAManager Reporting Server is unable to change its runtime mode 18:08:08.073 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Unregistering RS SNMP AgentX Subagent 18:08:08.074 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Stopping RS AgentX Subagent. 18:08:08.076 Trace HOSTRS RS_Dev_OSWin GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped 18:08:08.076 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service 18:08:08.182 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context 18:08:08.187 Trace HOSTRS RS_Dev_OSWin GCTI-153-04109 com.genesyslab.commons.log4j.LoggingManager Logging service stopped 18:08:08.200 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Message ServerPRIMARY - tcp://xxx.xxx.xxx.xxx:4335 successfully shut down. 18:08:08.204 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Configuration ServerPRIMARY - tcp://confservhost:4320 successfully shut down. 18:08:08.205 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed 18:08:08.207 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is completed. 18:08:08.211 Standard HOSTRS RS_Dev_OSWin GCTI-153-04505 com.genesyslab.commons.lca.LCAManager Disconnected from Local Control Agent 'LCA' 18:08:08.214 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Shutdown of LCAManager is completed. 18:08:08.214 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager LCA Protocol channel listener removed. 18:08:08.214 Standard HOSTRS RS_Dev_OSWin GCTI-153-05063 com.gvp.rpt.service.StandAloneReportingService Normal termination 18:08:08.320 Interaction HOSTRS RS_Dev_OSWin GCTI-153-30000 com.genesyslab.commons.lca.LCAManager Unexpected JVM shutdown detected. Application will attempt to terminate gracefully 18:08:08.320 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Unregistering RS SNMP AgentX Subagent 18:08:08.321 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Stopping RS AgentX Subagent. 18:08:08.325 Trace HOSTRS RS_Dev_OSWin GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped 18:08:08.325 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service 18:08:08.326 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context 18:08:08.326 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed

Any idea please?

Thanks in advance

genecool · August 17, 2012, 9:32am

Check your Java version.

To solve this issue, I have downgrade my JRE.

ndongo · August 17, 2012, 2:33pm

Thanks for your feedback,

I am currently using the jdk1.6.0_31. Do you reminber which version you used to solve the issue?

Thanks in advance

cavagnaro · August 17, 2012, 3:04pm

Install according to the documentation…it is specified there.
Get another Java test tool and try to do an ODBC connection on that way.
Message is clear, your connection settings are wrong. Oracle can be very specific.
Also validate the Oracle version is supported just in case if you haven’t done it already

genecool · August 17, 2012, 3:06pm

Currently I use Java™ SE Runtime Environment build 1.6.0_27-b07

ndongo · August 22, 2012, 8:19am

Hello,

In the 81gvp_dep.pdf they talk about Sun JRE 6.19, Update 5,.
I have found in oracle website only JRE 1.60_19 and have installed it. However, the problem is exactly the same that in the log I have previously posted.

I don’t no if JRE 1.60_19 is the same thing that Sun JRE 6.19, Update 5? If not could some give me where I can find the right Java version?

Also, do you know an easy tool to test the JDBC connection? My DBMS is Oracle RAC 11g. Genesys tells that it is compatible with the RS 8.1.502.67 I am using.

Thanks in advance for your help

Kubig · August 22, 2012, 8:51am

I use java version 1.6.0_32 and all works fine. Make sure that you have got correctly filled file “JavaServerStarter”,which is in install directory of GVP-RS and section “persistence” on GVP-RS application object in CME(or GA) - in this section you can set jdbc url,db passwd,etc.

ndongo · August 22, 2012, 9:17am

Hello,

My “JavaServerStarter” seems to be Ok, here is the content of the file.

[Service] AppTitle="VP Reporting Server" AppVersion=8.1.502.67
JVMPath=C:\Program Files (x86)\Java\jre6\bin\client\jvm.dll

MainClass=com/gvp/rpt/service/StandAloneReportingService

EventHandlerMethod=stopWinService

[JavaArgs]
-Xmx1536M
-Xrs=YES

[Djava.class.path]
.\ems-rs.jar
.\mf-service.jar
.\rpt-core.jar
.\rpt-services.jar
.\libs\activemq-core.jar
.\libs\activemq-pool.jar
.\libs\antlr-2.7.6.jar
.\libs\asm-attrs.jar
.\libs\asm.jar
.\libs\cglib-2.1.3.jar
.\libs\com.noelios.restlet.ext.jetty.jar
.\libs\com.noelios.restlet.jar
.\libs\comappblock.jar
.\libs\commons-collections-3.1.jar
.\libs\commons-collections-3.2.1.jar
.\libs\commons-dbcp-1.2.2.jar
.\libs\commons-io-1.3.2.jar
.\libs\commons-lang-2.3.jar
.\libs\commons-logging.jar
.\libs\commons-pool-1.4.jar
.\libs\commons.jar
.\libs\concurrent.jar
.\libs\configurationprotocol.jar
.\libs\connection.jar
.\libs\dom4j-1.6.1.jar
.\libs\hibernate3.jar
.\libs\j2ee-management.jar
.\libs\javax.servlet.jar
.\libs\jaxb-api.jar
.\libs\jaxb-impl.jar
.\libs\jdbc2_0-stdext.jar
.\libs\jibx-run.jar
.\libs\jms.jar
.\libs\jta.jar
.\libs\kvlistbinding.jar
.\libs\kvlists.jar
.\libs\logging.jar
.\libs\warmstandbyappblock.jar
.\libs\managementprotocol.jar
.\libs\messagebrokerappblock.jar
.\libs\namespace.jar
.\libs\ojdbc14.jar
.\libs\org.json.jar
.\libs\org.mortbay.jetty.ajp.jar
.\libs\org.mortbay.jetty.https.jar
.\libs\org.mortbay.jetty.jar
.\libs\org.mortbay.jetty.util.jar
.\libs\org.restlet.jar
.\libs\protocol.jar
.\libs\protocolmanagerappblock.jar
.\libs\quartz-1.6.0.jar
.\libs\relaxngDatatype.jar
.\libs\reportingprotocol.jar
.\libs\slf4j-api.jar
.\libs\log4j-over-slf4j-1.5.11.jar
.\libs\jcl-over-slf4j-1.5.11.jar
.\libs\jul-to-slf4j-1.5.11.jar
.\libs\spring.jar
.\libs\sqljdbc.jar
.\libs\system.jar
.\libs\xbean-spring-3.6.jar
.\libs\xsdlib.jar
.\libs\snmp4j-1.11.1.jar
.\libs\snmp4j-agent-1.4.1.jar
.\libs\snmp4j-agentx-1.3.1a.jar
.\libs\log4j.jar
.\libs\netty-3.2.3.Final.jar
.\libs\org.osgi.core-4.1.0.jar
.\libs\kahadb-5.3.2.jar

Also my RS starts and works correctly when I am in No DB mode (working without DataBase). I mean when the option rs.nodb.enabled = Enable ‘No DB’ Mode.

I have checked the parameters to connect to the DB (in the persistence section), with SQL Developer I connect correctly the DB. But the RS is unable to open a JDBC connection to the database when I am in DB mode. That’s why I am asking of there is an easy tool in order to test a JDBC connection to an Oracle DB

Thanks in advance for ideas.

Kubig · August 22, 2012, 9:36am

Are you sure that the “persistent” section is configured correctly?

hibernate.remote.database = <DB_NAME>
password = <DB_PASSWORD>
hibernate.remote.url = jdbc:…
hibernate.remote.user= <DB_USERNAME>

If yes,could you please try to set option “rs.partitiong.enabled” to false and try to start RS and check log - if the error is in settings,the cause will be same,but the error message will be different.

Rene · August 22, 2012, 9:49am

Hi,

Can you post here your [persistence] section? Feel free to change names and/or IP addresses for security reasons.

What type and version of database you have?

R.

ndongo · August 22, 2012, 10:53am

Hello

Here is the persitente section

[persistence] hibernate.remote.dialect = org.hibernate.dialect.Oracle10gDialect hibernate.remote.driver = oracle.jdbc.driver.OracleDriver hibernate.remote.url = jdbc:oracle:thin:@dbserver_host:1521 hibernate.remote.database = DBName hibernate.remote.user = dbusername password = password hibernate.show_sql = false rs.partitioning.enabled = true rs.partitioning.partitions-per-day = 6 rs.partitioning.upstream-start-time.enabled = true rs.partitioning.upstream-partition-number = 1 rs.storage.upstream-serializer.watermark = 60000 rs.nodb.enabled = false rs.histonly.enabled = false hibernate.local.dbDirectory = E:\GCTI\GVP\RS_Dev_OSWin\data\derby

We are using an Oracle RAC 11g in one node and mutualized database. The DB is in OS Linux version 2.6.18-238.9.1.el5. Regarding the Oracle version, I don’t know if the following option in persistente section is correct
hibernate.remote.dialect = org.hibernate.dialect.Oracle10gDialect

Here are the logs when partitioning is enabled with the default partitioning settings

APPLICATION NAME: RS_DEV_OSWIN APPLICATION TYPE: 153 APPLICATION HOST (CONFIG SPEC): HOSTRS APPLICATION ID: 412 TIMEZONE DISPALY NAME: HEURE D'EUROPE CENTRALE TIMEZONE UTC OFFSET: 02:00:00 UTC TIME: 2012-08-22T09:04:16.082 LOCAL TIME: 2012-08-22T11:04:16.082 UTC START TIME: 2012-08-22T09:03:46.104 RUNNING TIME (DDD:HH:MM:SS): 000:00:00:29 MEMORY USAGE (BYTES): 48178880 HOST INFO: WINDOWS SERVER 2008 R2 JAVA VERSION: 1.6.0_19 FILE: E:\LOGS\GCTI_LOGS\GVP_RS\RS_DPJ_.20120822_110416_074.LOG VERSION: 8.1.502.67
11:04:16.090 Trace HOSTRS RS_Dev_OSWin GCTI-153-04100 com.genesyslab.commons.log4j.LoggingManager Logging service started
11:04:16.119 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionSettingProcessor Connection Settings listener for 'Message Server’processing configuration update
11:04:16.121 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService Starting Warm Standby service for CFGMessageServer at Message ServerPRIMARY - tcp://25.388.895.554:3035
11:04:16.121 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService request to establish automatic primary/backup reconnect procedure accepted on connection with:CFGMessageServer at Message ServerPRIMARY - tcp://25.388.895.554:3035
11:04:16.122 Trace HOSTRS RS_Dev_OSWin GCTI-153-04500 com.genesyslab.commons.ConnectionManagementService Connecting to Message Server ‘Message Server’ at host ‘25.388.895.554’, port 3035
11:04:16.141 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Successfully obtained configuration from configuration server.
11:04:16.174 Trace HOSTRS RS_Dev_OSWin GCTI-153-20050 com.gvp.rpt.snmp.agentx.subagent.RSSubagent No AgentX Master Agent found in Application Connections
11:04:16.174 Trace HOSTRS RS_Dev_OSWin GCTI-153-20043 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Starting SNMP AgentX Subagent
11:04:16.190 Standard HOSTRS RS_Dev_OSWin GCTI-153-04503 com.genesyslab.commons.ConnectionManagementService Connected to CFGMessageServer ‘CFGMessageServer’ at host ‘25.388.895.554’, port 3035
11:04:16.235 Trace HOSTRS RS_Dev_OSWin GCTI-153-20044 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Exit SNMP AgentX Subagent
11:04:16.331 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Creating HTTP connector on: 8080
11:04:16.420 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager activate JVM shutdown hook
11:04:16.421 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is initiated
11:04:16.421 Trace HOSTRS RS_Dev_OSWin GCTI-153-04500 com.genesyslab.commons.lca.LCAManager Connecting to Local Control Agent ‘LCA’ at host ‘localhost’, port 4999
11:04:16.422 Standard HOSTRS RS_Dev_OSWin GCTI-153-05061 com.gvp.rpt.service.StandAloneReportingService Initialization completed
11:04:16.443 Standard HOSTRS RS_Dev_OSWin GCTI-153-04503 com.genesyslab.commons.lca.LCAManager Connected to Local Control Agent ‘LCA’ at host ‘localhost’, port 4999
11:04:16.448 Trace HOSTRS RS_Dev_OSWin GCTI-153-20001 com.genesyslab.commons.lca.LCAManager Reporting Server initializing in ‘standalone’ mode
11:04:16.449 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService PARTITIONING_ENABLED is true. Using configuration - [Ljava.lang.String;@508be
11:04:18.992 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Building new Hibernate SessionFactory
11:04:21.795 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.dao.SessionFactoryBean Closing opened DB session.
11:04:23.366 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean Supported JMS broker connections: UNENCRYPTED
11:04:23.366 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean JMS broker listening on: tcp://0.0.0.0:61616?transport.closeAsync=false
11:04:23.868 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.partitioning.PartitionMaintenanceJob Partitioning Job INIT STARTED 1345626263868
11:04:23.934 Standard HOSTRS RS_Dev_OSWin GCTI-153-40000 com.gvp.rpt.partitioning.PartitionMaintenanceJob Failed to archive - RMCallDetailRecord org.hibernate.exception.GenericJDBCException: Cannot open connection
11:04:25.393 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Closing Hibernate SessionFactory
11:04:25.395 Standard HOSTRS RS_Dev_OSWin GCTI-153-40000 com.gvp.rpt.service.StandAloneReportingService Unable to start RS application context, shutting down. org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘partitioningService’ defined in class path resource [partitioning.config.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
11:04:25.397 Standard HOSTRS RS_Dev_OSWin GCTI-153-30001 com.genesyslab.commons.lca.LCAManager Reporting Server is unable to change its runtime mode
11:04:25.398 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Unregistering RS SNMP AgentX Subagent
11:04:25.399 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Stopping RS AgentX Subagent.
11:04:25.400 Trace HOSTRS RS_Dev_OSWin GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped
11:04:25.401 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service
11:04:25.505 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context
11:04:25.506 Trace HOSTRS RS_Dev_OSWin GCTI-153-04109 com.genesyslab.commons.log4j.LoggingManager Logging service stopped
11:04:25.513 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Message ServerPRIMARY - tcp://25.388.895.554:3035 successfully shut down.
11:04:25.516 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Configuration ServerPRIMARY - tcp://confserverhost:4320 successfully shut down.
11:04:25.517 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed
11:04:25.518 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is completed.
11:04:25.521 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Shutdown of LCAManager is completed.
11:04:25.521 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager LCA Protocol channel listener removed.
11:04:25.522 Standard HOSTRS RS_Dev_OSWin GCTI-153-05063 com.gvp.rpt.service.StandAloneReportingService Normal termination
11:04:25.634 Interaction HOSTRS RS_Dev_OSWin GCTI-153-30000 com.genesyslab.commons.lca.LCAManager Unexpected JVM shutdown detected. Application will attempt to terminate gracefully
11:04:25.635 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Unregistering RS SNMP AgentX Subagent
11:04:25.635 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Stopping RS AgentX Subagent.
11:04:25.637 Trace HOSTRS RS_Dev_OSWin GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped
11:04:25.638 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service
11:04:25.640 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context
11:04:25.641 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed

When I set the “rs.partitiong.enabled” to disabled the doesn’t start also and the logs are

APPLICATION NAME: RS_DEV_OSWIN APPLICATION TYPE: 153 APPLICATION HOST (CONFIG SPEC): HOSTRS APPLICATION ID: 412 TIMEZONE DISPALY NAME: HEURE D'EUROPE CENTRALE TIMEZONE UTC OFFSET: 02:00:00 UTC TIME: 2012-08-22T10:46:40.980 LOCAL TIME: 2012-08-22T12:46:40.980 UTC START TIME: 2012-08-22T10:46:06.919 RUNNING TIME (DDD:HH:MM:SS): 000:00:00:34 MEMORY USAGE (BYTES): 40296544 HOST INFO: WINDOWS SERVER 2008 R2 JAVA VERSION: 1.6.0_19 FILE: E:\LOGS\GCTI_LOGS\GVP_RS\RS_DPJ_.20120822_124640_970.LOG VERSION: 8.1.502.67
12:46:40.989 Trace HOSTRS RS_Dev_OSWin GCTI-153-04100 com.genesyslab.commons.log4j.LoggingManager Logging service started
12:46:41.069 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionSettingProcessor Connection Settings listener for 'Message Server’processing configuration update
12:46:41.071 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService Starting Warm Standby service for CFGMessageServer at Message ServerPRIMARY - tcp://25.388.895.554:3035
12:46:41.072 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService request to establish automatic primary/backup reconnect procedure accepted on connection with:CFGMessageServer at Message ServerPRIMARY - tcp://25.388.895.554:3035
12:46:41.072 Trace HOSTRS RS_Dev_OSWin GCTI-153-04500 com.genesyslab.commons.ConnectionManagementService Connecting to Message Server ‘Message Server’ at host ‘25.388.895.554’, port 3035
12:46:41.077 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Successfully obtained configuration from configuration server.
12:46:41.116 Trace HOSTRS RS_Dev_OSWin GCTI-153-20050 com.gvp.rpt.snmp.agentx.subagent.RSSubagent No AgentX Master Agent found in Application Connections
12:46:41.117 Trace HOSTRS RS_Dev_OSWin GCTI-153-20043 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Starting SNMP AgentX Subagent
12:46:41.149 Standard HOSTRS RS_Dev_OSWin GCTI-153-04503 com.genesyslab.commons.ConnectionManagementService Connected to CFGMessageServer ‘CFGMessageServer’ at host ‘25.388.895.554’, port 3035
12:46:41.184 Trace HOSTRS RS_Dev_OSWin GCTI-153-20044 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Exit SNMP AgentX Subagent
12:46:41.276 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Creating HTTP connector on: 8080
12:46:41.396 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager activate JVM shutdown hook
12:46:41.396 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is initiated
12:46:41.397 Trace HOSTRS RS_Dev_OSWin GCTI-153-04500 com.genesyslab.commons.lca.LCAManager Connecting to Local Control Agent ‘LCA’ at host ‘localhost’, port 4999
12:46:41.398 Standard HOSTRS RS_Dev_OSWin GCTI-153-05061 com.gvp.rpt.service.StandAloneReportingService Initialization completed
12:46:41.415 Standard HOSTRS RS_Dev_OSWin GCTI-153-04503 com.genesyslab.commons.lca.LCAManager Connected to Local Control Agent ‘LCA’ at host ‘localhost’, port 4999
12:46:41.421 Trace HOSTRS RS_Dev_OSWin GCTI-153-20001 com.genesyslab.commons.lca.LCAManager Reporting Server initializing in ‘standalone’ mode
12:46:41.422 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService PARTITIONING_ENABLED is false. Using configuration - [Ljava.lang.String;@152b6f5
12:46:44.113 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Building new Hibernate SessionFactory
12:46:46.836 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.dao.SessionFactoryBean Closing opened DB session.
12:46:48.576 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean Supported JMS broker connections: UNENCRYPTED
12:46:48.577 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean JMS broker listening on: tcp://0.0.0.0:61616?transport.closeAsync=false
12:46:49.118 Trace HOSTRS RS_Dev_OSWin GCTI-153-20007 com.gvp.rpt.service.DateComponentsPopulationJob DateComponents Population job run
12:46:49.124 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.DateComponentsPopulationJob Populating DateComponents from Mon Aug 01 00:00:00 CEST 2011 until Thu Aug 01 00:00:00 CEST 2013
12:46:50.601 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Closing Hibernate SessionFactory
12:46:50.604 Standard HOSTRS RS_Dev_OSWin GCTI-153-40000 com.gvp.rpt.service.StandAloneReportingService Unable to start RS application context, shutting down. org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘callSummaryLoggingJob’ defined in class path resource [quartz.config.xml]: Cannot resolve reference to bean ‘callSummaryLoggingService’ while setting bean property ‘targetObject’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘datePopulateService’ defined in class path resource [ems-rs-withDB.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
12:46:50.605 Standard HOSTRS RS_Dev_OSWin GCTI-153-30001 com.genesyslab.commons.lca.LCAManager Reporting Server is unable to change its runtime mode
12:46:50.607 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Unregistering RS SNMP AgentX Subagent
12:46:50.607 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Stopping RS AgentX Subagent.
12:46:50.609 Trace HOSTRS RS_Dev_OSWin GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped
12:46:50.610 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service
12:46:50.613 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context
12:46:50.614 Trace HOSTRS RS_Dev_OSWin GCTI-153-04109 com.genesyslab.commons.log4j.LoggingManager Logging service stopped
12:46:50.618 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Message ServerPRIMARY - tcp://25.388.895.554:3035 successfully shut down.
12:46:50.621 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Configuration ServerPRIMARY - tcp://confserverhost:4320 successfully shut down.
12:46:50.621 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed
12:46:50.623 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is completed.
12:46:50.625 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Shutdown of LCAManager is completed.
12:46:50.626 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager LCA Protocol channel listener removed.
12:46:50.626 Standard HOSTRS RS_Dev_OSWin GCTI-153-05063 com.gvp.rpt.service.StandAloneReportingService Normal termination
12:46:50.741 Interaction HOSTRS RS_Dev_OSWin GCTI-153-30000 com.genesyslab.commons.lca.LCAManager Unexpected JVM shutdown detected. Application will attempt to terminate gracefully
12:46:50.744 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Unregistering RS SNMP AgentX Subagent
12:46:50.744 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Stopping RS AgentX Subagent.
12:46:50.745 Trace HOSTRS RS_Dev_OSWin GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped
12:46:50.745 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service
12:46:50.745 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context
12:46:50.746 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed

Thanks in advance for ideas

Rene · August 22, 2012, 11:29am

Hi,

I don’t think it will help but please let ‘hibernate.remote.database’ empty as it is not used for Oracle.

Have you tested JDBC connection using SQL Developer from the host where GVP RS runs?

R.

Kubig · August 22, 2012, 1:18pm

I guess,that is the problem with jdbc settings,ie settings of persistent section on Annex tab of GVP-RS app object in CME.Logs indicate that at least.

ndongo · August 23, 2012, 10:26am

Hello,

I have installed Oracle SQL devloper on the host where I have the RS.
I have tried a JDBC connection with url : jdbc:oracle:thin:@dbserver_host:1521, it doesn’t work. Then I add the DB name, like this jdbc url : jdbc:oracle:thin:@dbserver_host:1521/DBName
and I successfully connect to RS DB with the Oracle SQL Developper.

Then, I use this right JDBC url in the persistente option “hibernate.remote.url” of the RS. The RS cannot start (the right jdbc URL doesn’t work with the RS). The logs and errors still the same

APPLICATION NAME: RS_DEV_OSWIN APPLICATION TYPE: 153 APPLICATION HOST (CONFIG SPEC): HOSTRS APPLICATION ID: 412 TIMEZONE DISPALY NAME: HEURE D'EUROPE CENTRALE TIMEZONE UTC OFFSET: 02:00:00 UTC TIME: 2012-08-22T15:16:16.974 LOCAL TIME: 2012-08-22T17:16:16.974 UTC START TIME: 2012-08-22T15:15:47.587 RUNNING TIME (DDD:HH:MM:SS): 000:00:00:29 MEMORY USAGE (BYTES): 40283432 HOST INFO: WINDOWS SERVER 2008 R2 JAVA VERSION: 1.6.0_19 FILE: E:\LOGS\GCTI_LOGS\GVP_RS\RS_DPJ_.20120822_171616_967.LOG VERSION: 8.1.502.67
17:16:16.981 Trace HOSTRS RS_Dev_OSWin GCTI-153-04100 com.genesyslab.commons.log4j.LoggingManager Logging service started
17:16:16.999 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionSettingProcessor Connection Settings listener for 'Message Server’processing configuration update
17:16:17.000 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService Starting Warm Standby service for CFGMessageServer at Message ServerPRIMARY - tcp://xx.xxx.xxx.xxx:4335
17:16:17.001 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService request to establish automatic primary/backup reconnect procedure accepted on connection with:CFGMessageServer at Message ServerPRIMARY - tcp://xx.xxx.xxx.xxx:4335
17:16:17.001 Trace HOSTRS RS_Dev_OSWin GCTI-153-04500 com.genesyslab.commons.ConnectionManagementService Connecting to Message Server ‘Message Server’ at host ‘xx.xxx.xxx.xxx’, port 4335
17:16:17.012 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Successfully obtained configuration from configuration server.
17:16:17.048 Trace HOSTRS RS_Dev_OSWin GCTI-153-20050 com.gvp.rpt.snmp.agentx.subagent.RSSubagent No AgentX Master Agent found in Application Connections
17:16:17.050 Trace HOSTRS RS_Dev_OSWin GCTI-153-20043 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Starting SNMP AgentX Subagent
17:16:17.064 Standard HOSTRS RS_Dev_OSWin GCTI-153-04503 com.genesyslab.commons.ConnectionManagementService Connected to CFGMessageServer ‘CFGMessageServer’ at host ‘xx.xxx.xxx.xxx’, port 4335
17:16:17.104 Trace HOSTRS RS_Dev_OSWin GCTI-153-20044 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Exit SNMP AgentX Subagent
17:16:17.197 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Creating HTTP connector on: 8080
17:16:17.283 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager activate JVM shutdown hook
17:16:17.284 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is initiated
17:16:17.284 Trace HOSTRS RS_Dev_OSWin GCTI-153-04500 com.genesyslab.commons.lca.LCAManager Connecting to Local Control Agent ‘LCA’ at host ‘localhost’, port 4999
17:16:17.286 Standard HOSTRS RS_Dev_OSWin GCTI-153-05061 com.gvp.rpt.service.StandAloneReportingService Initialization completed
17:16:17.304 Standard HOSTRS RS_Dev_OSWin GCTI-153-04503 com.genesyslab.commons.lca.LCAManager Connected to Local Control Agent ‘LCA’ at host ‘localhost’, port 4999
17:16:17.312 Trace HOSTRS RS_Dev_OSWin GCTI-153-20001 com.genesyslab.commons.lca.LCAManager Reporting Server initializing in ‘standalone’ mode
17:16:17.312 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService PARTITIONING_ENABLED is true. Using configuration - [Ljava.lang.String;@a8a81c
17:16:19.999 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Building new Hibernate SessionFactory
17:16:22.919 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.dao.SessionFactoryBean Closing opened DB session.
17:16:24.550 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean Supported JMS broker connections: UNENCRYPTED
17:16:24.551 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean JMS broker listening on: tcp://0.0.0.0:61616?transport.closeAsync=false
17:16:25.032 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.partitioning.PartitionMaintenanceJob Partitioning Job INIT STARTED 1345648585031
17:16:25.090 Standard HOSTRS RS_Dev_OSWin GCTI-153-40000 com.gvp.rpt.partitioning.PartitionMaintenanceJob Failed to archive - RMCallDetailRecord org.hibernate.exception.GenericJDBCException: Cannot open connection
17:16:26.580 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Closing Hibernate SessionFactory
17:16:26.583 Standard HOSTRS RS_Dev_OSWin GCTI-153-40000 com.gvp.rpt.service.StandAloneReportingService Unable to start RS application context, shutting down. org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘partitioningService’ defined in class path resource [partitioning.config.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
17:16:26.584 Standard HOSTRS RS_Dev_OSWin GCTI-153-30001 com.genesyslab.commons.lca.LCAManager Reporting Server is unable to change its runtime mode
17:16:26.585 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Unregistering RS SNMP AgentX Subagent
17:16:26.585 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Stopping RS AgentX Subagent.
17:16:26.587 Trace HOSTRS RS_Dev_OSWin GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped
17:16:26.588 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service
17:16:26.590 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context
17:16:26.591 Trace HOSTRS RS_Dev_OSWin GCTI-153-04109 com.genesyslab.commons.log4j.LoggingManager Logging service stopped
17:16:26.595 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Message ServerPRIMARY - tcp://xx.xxx.xxx.xxx:4335 successfully shut down.
17:16:26.597 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Configuration ServerPRIMARY - tcp://confservhost:4320 successfully shut down.
17:16:26.597 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed
17:16:26.599 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is completed.
17:16:26.601 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Shutdown of LCAManager is completed.
17:16:26.601 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager LCA Protocol channel listener removed.
17:16:26.601 Standard HOSTRS RS_Dev_OSWin GCTI-153-05063 com.gvp.rpt.service.StandAloneReportingService Normal termination
17:16:26.711 Interaction HOSTRS RS_Dev_OSWin GCTI-153-30000 com.genesyslab.commons.lca.LCAManager Unexpected JVM shutdown detected. Application will attempt to terminate gracefully
17:16:26.712 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Unregistering RS SNMP AgentX Subagent
17:16:26.712 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Stopping RS AgentX Subagent.
17:16:26.713 Trace HOSTRS RS_Dev_OSWin GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped
17:16:26.713 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service
17:16:26.714 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context
17:16:26.714 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed

I am wondering if it is not a problem of compatibility.

Is it possible to use RS on Windows Server R2 2008 and connect to a mutualized databse Oracle 11g RAC?

The version of java I am using (jre 1.6.0_19) is validated as compatible.

Thanks in advance for ideas

Kubig · August 23, 2012, 10:54am

To connect VP Reporting server to two Oracle boxes need set this string (as one line) in hibernate.remote.url attrbute of VP Reporting server application via Genesys Administrator and put appropriate ip_addresses/service_name in it:

jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=ON)(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT=1521))(ADDRESS=(PROTOCOL = TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(LOAD_BALANCE=OFF)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME = orcl))))

Therefore, ensure the hibernate.remote.url option is properly configured for use with Oracle RAC by configuring the hibernate.remote.database option with the value blank.