Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: genecool on January 04, 2012, 11:31:12 AM

Title: [GVP 8] Problem with GVP Reporting Server
Post by: genecool on January 04, 2012, 11:31:12 AM

Hi,

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

[quote]
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
[/quote]

Have you any idea ?

Thanks

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: René on January 04, 2012, 12:01:02 PM

Hi,

Reporting Server cannot connect to database thus it shutdown itself.

[b]nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection[/b]

Check that parameters in 'persistence' section are correct.

R.

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: genecool on January 04, 2012, 01:45:10 PM

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?

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: cavagnaro on January 04, 2012, 02:37:42 PM

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

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: genecool on January 04, 2012, 05:45:10 PM

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 :

[quote]
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
[/quote]

... and nothing else !

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: ndongo on August 17, 2012, 09:29:32 AM

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

[quote]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[/quote]


Any idea please?

Thanks in advance

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: genecool on August 17, 2012, 09:32:00 AM

Check your Java version.

To solve this issue, I have downgrade my JRE.

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: ndongo on August 17, 2012, 02:33:56 PM

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

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: cavagnaro on August 17, 2012, 03:04:40 PM

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

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: genecool on August 17, 2012, 03:06:41 PM

Currently I use Java(TM) SE Runtime Environment build 1.6.0_27-b07

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: ndongo on August 22, 2012, 08:19:18 AM

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

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: Kubig on August 22, 2012, 08:51:58 AM

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.

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: ndongo on August 22, 2012, 09:17:30 AM

Hello,

My "JavaServerStarter" seems to be Ok, here is the content of the file.
[quote][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
[/quote]


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.

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: Kubig on August 22, 2012, 09:36:26 AM

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.

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: René on August 22, 2012, 09:49:27 AM

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.

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: ndongo on August 22, 2012, 10:53:22 AM

Hello

Here is the persitente section
[quote][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
[/quote]

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

[quote]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
[/quote]


When I set the "rs.partitiong.enabled" to disabled the doesn't start also and the logs are

[quote]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
[/quote]

Thanks in advance for ideas

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: René on August 22, 2012, 11:29:09 AM

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.

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: Kubig on August 22, 2012, 01:18:39 PM

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.

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: ndongo on August 23, 2012, 10:26:36 AM

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

[quote]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[/quote]


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

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: Kubig on August 23, 2012, 10:54:08 AM

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.

Title: Re: [GVP 8] Problem with GVP Reporting Server
Post by: ndongo on August 23, 2012, 12:27:39 PM

Thank you kubig, It is working now with your suggession, and others idea.

Here's my jdbc url

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL = TCP)(HOST = databaseserverhost)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME= databasename)))

We have also to configuring hibernate.remote.database option with the value blank. We must use CME to do this because with Administraor it is a mandatory option.

Thank you all for your help. It's Ok now