" /> [GVP 8] Problem with GVP Reporting Server - Genesys CTI User Forum
« previous next »
Pages: 1 [2]   Go Down

Author Topic: [GVP 8] Problem with GVP Reporting Server  (Read 16441 times)

Offline ndongo

  • Newbie
  • *
  • Posts: 8
  • Karma: 0
Re: [GVP 8] Problem with GVP Reporting Server
« Reply #15 on: August 22, 2012, 10:53:22 AM »
Advertisement
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
Logged

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Re: [GVP 8] Problem with GVP Reporting Server
« Reply #16 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.
Logged

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2755
  • Karma: 44
Re: [GVP 8] Problem with GVP Reporting Server
« Reply #17 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.
Logged

Offline ndongo

  • Newbie
  • *
  • Posts: 8
  • Karma: 0
Re: [GVP 8] Problem with GVP Reporting Server
« Reply #18 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
Logged

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2755
  • Karma: 44
Re: [GVP 8] Problem with GVP Reporting Server
« Reply #19 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.
« Last Edit: August 23, 2012, 11:20:13 AM by Kubig »
Logged

Offline ndongo

  • Newbie
  • *
  • Posts: 8
  • Karma: 0
Re: [GVP 8] Problem with GVP Reporting Server
« Reply #20 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
Logged
Pages: 1 [2]   Go Up
« previous next »