Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: a989597 on October 16, 2018, 07:33:55 AM

Title: Problem with GVP Reporting Server (8.5)
Post by: a989597 on October 16, 2018, 07:33:55 AM

Hi,

I encounter a problem with Reporting Server which wants not start

JAVA VERSION is 1.7.0_79
MSSQL VERSION is MS SQL Server 2016 Standard

I installed rs application on Windows and also installed on Linux,but appeared the same situation.


[quote]

2018-10-16T15:17:20.795 Trace genesyscim.bt.com.tw RS GCTI-153-04100 com.genesyslab.commons.log4j.LoggingManager Logging service started
2018-10-16T15:17:20.811 Trace genesyscim.bt.com.tw RS GCTI-153-04500 com.genesyslab.commons.ConnectionManagementService Connecting to Message Server 'Message Server' at host '172.17.24.47', port 5150
2018-10-16T15:17:20.811 Trace genesyscim.bt.com.tw RS GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Successfully obtained configuration from configuration server.
2018-10-16T15:17:20.827 Trace genesyscim.bt.com.tw RS GCTI-153-20050 com.gvp.rpt.snmp.agentx.subagent.RSSubagent No AgentX Master Agent found in Application Connections
2018-10-16T15:17:20.827 Trace genesyscim.bt.com.tw RS GCTI-153-20043 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Starting SNMP AgentX Subagent
2018-10-16T15:17:20.827 Trace genesyscim.bt.com.tw RS GCTI-153-20044 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Exit SNMP AgentX Subagent
2018-10-16T15:17:20.905 Standard genesyscim.bt.com.tw RS GCTI-153-04503 com.genesyslab.commons.ConnectionManagementService Connected to CFGMessageServer 'CFGMessageServer' at host '172.17.24.47', port 5150
2018-10-16T15:17:20.920 Trace genesyscim.bt.com.tw RS GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Creating HTTP connector on: 8088
2018-10-16T15:17:20.936 Trace genesyscim.bt.com.tw RS GCTI-153-04500 com.genesyslab.commons.lca.LCAManager Connecting to Local Control Agent 'LCA' at host 'localhost', port 4999
2018-10-16T15:17:20.936 Standard genesyscim.bt.com.tw RS GCTI-153-05061 com.gvp.rpt.service.StandAloneReportingService Initialization completed
2018-10-16T15:17:20.936 Standard genesyscim.bt.com.tw RS GCTI-153-04503 com.genesyslab.commons.lca.LCAManager Connected to Local Control Agent 'LCA' at host 'localhost', port 4999
2018-10-16T15:17:20.952 Trace genesyscim.bt.com.tw RS GCTI-153-20001 com.genesyslab.commons.lca.LCAManager  Reporting Server initializing in 'standalone' mode
2018-10-16T15:17:20.952 Trace genesyscim.bt.com.tw RS GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService PARTITIONING_ENABLED is false. Using configuration - [Ljava.lang.String;@54b07eeb
2018-10-16T15:17:23.358 Trace genesyscim.bt.com.tw RS GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Building new Hibernate SessionFactory
2018-10-16T15:17:25.639 Trace genesyscim.bt.com.tw RS GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean Supported JMS broker connections: UNENCRYPTED
2018-10-16T15:17:25.639 Trace genesyscim.bt.com.tw RS GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean JMS broker listening on: tcp://0.0.0.0:61616?transport.closeAsync=false
2018-10-16T15:17:25.998 Standard genesyscim.bt.com.tw RS GCTI-153-40000 com.gvp.rpt.dao.jdbc.interceptor.StatelessTxnInterceptor Failed to store a batch. Rolling back... org.hibernate.exception.SQLGrammarException: could not execute query
2018-10-16T15:17:27.998 Trace genesyscim.bt.com.tw RS GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Closing Hibernate SessionFactory
2018-10-16T15:17:27.998 Standard genesyscim.bt.com.tw RS 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 'cdrCountingJob' defined in class path resource [quartz.config.xml]: Cannot resolve reference to bean 'cdrCountingService' while setting bean property 'targetObject'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'cdrCountingService' defined in class path resource [ems-rs-withDB.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'helper' threw exception; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
2018-10-16T15:17:27.998 Standard genesyscim.bt.com.tw RS GCTI-153-30001 com.genesyslab.commons.lca.LCAManager Reporting Server is unable to change its runtime mode
2018-10-16T15:17:27.998 Trace genesyscim.bt.com.tw RS GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped
2018-10-16T15:17:28.201 Trace genesyscim.bt.com.tw RS GCTI-153-04109 com.genesyslab.commons.log4j.LoggingManager Logging service stopped
2018-10-16T15:17:28.201 Trace genesyscim.bt.com.tw RS GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Message ServerPRIMARY - tcp://172.17.24.47:5150 successfully shut down.
2018-10-16T15:17:28.201 Trace genesyscim.bt.com.tw RS GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Configuration ServerPRIMARY - tcp://linux6.bt.com.tw:2020 successfully shut down.
2018-10-16T15:17:28.217 Standard genesyscim.bt.com.tw RS GCTI-153-04505 com.genesyslab.commons.lca.LCAManager Disconnected from Local Control Agent 'LCA'
2018-10-16T15:17:28.217 Standard genesyscim.bt.com.tw RS GCTI-153-05063 com.gvp.rpt.service.StandAloneReportingService Normal termination
2018-10-16T15:17:28.733 Interaction genesyscim.bt.com.tw RS GCTI-153-30000 com.genesyslab.commons.lca.LCAManager Unexpected JVM shutdown detected. Application will attempt to terminate gracefully
2018-10-16T15:17:28.733 Trace genesyscim.bt.com.tw RS GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped

[/quote]

Title: Re: Problem with GVP Reporting Server (8.5)
Post by: Kubig on October 16, 2018, 09:00:10 AM

It seems the database has not been initialized properly. Check your DBSchema for reporting server and also the JDBC configuration

Title: Re: Problem with GVP Reporting Server (8.5)
Post by: a989597 on October 17, 2018, 04:15:52 AM

Hey,

I could not explain why I restart OS and removed application then reinstall rs by step,it can start up...... :(

Thank u :D

Title: Re: Problem with GVP Reporting Server (8.5)
Post by: cavagnaro on October 17, 2018, 01:24:24 PM

Maybe a library wasn't registered correctly or some stuck process....Windows is windows

Enviado de meu E6633 usando o Tapatalk