Reporting server won't start

system · January 21, 2014, 1:33pm

Hello there, I have a problem with my RS. When I try to start it with DB support, it just won’t start. In noDB_mode, it works perfectly. So, this has to be something with the database configuration. The database is created and provided by a MSQL Server 2005 Enterprise. I have made multiple changes in my configuration of the hibernate.remote.url. I have specified an instance, no instance, with name, with ip etc but no luck at all. It now looks like

jdbc:sqlserver://myServerName\myInstanceName:14733

. I have initialized the database with the sql scripts provided in the enterprise folder of my RS installation. My user is a dbOwner on the DB and what i get as an error in the RS.log is the following

15:20:21.354 Trace W2K8GEN02 GVP8_RS GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService PARTITIONING_ENABLED is false. Using configuration - [Ljava.lang.String;@be8c3e
15:20:22.430 Trace W2K8GEN02 GVP8_RS GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Building new Hibernate SessionFactory
15:20:38.343 Debug W2K8GEN02 GVP8_RS GCTI-153-09900 com.gvp.rpt.dao.SessionFactoryBean Closing opened DB session.
15:20:38.998 Trace W2K8GEN02 GVP8_RS GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean Supported JMS broker connections: UNENCRYPTED
15:20:38.998 Trace W2K8GEN02 GVP8_RS GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean JMS broker listening on: tcp://0.0.0.0:61616?transport.closeAsync=false
15:20:39.357 Trace W2K8GEN02 GVP8_RS GCTI-153-20007 com.gvp.rpt.service.DateComponentsPopulationJob DateComponents Population job run 
15:20:39.357 Trace W2K8GEN02 GVP8_RS GCTI-153-20000 com.gvp.rpt.service.DateComponentsPopulationJob Populating DateComponents from Tue Jan 01 00:00:00 EET 2013 until Thu Jan 01 00:00:00 EET 2015
15:20:55.113 Trace W2K8GEN02 GVP8_RS GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Closing Hibernate SessionFactory
15:20:55.113 Standard W2K8GEN02 GVP8_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 '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
15:20:55.113 Standard W2K8GEN02 GVP8_RS GCTI-153-30001 com.genesyslab.commons.lca.LCAManager Reporting Server is unable to change its runtime mode
15:20:55.113 Debug W2K8GEN02 GVP8_RS GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Unregistering RS SNMP AgentX Subagent
15:20:55.113 Debug W2K8GEN02 GVP8_RS GCTI-153-09900 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Stopping RS AgentX Subagent.
15:20:55.113 Trace W2K8GEN02 GVP8_RS GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped
15:20:55.113 Debug W2K8GEN02 GVP8_RS GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service
15:20:55.223 Debug W2K8GEN02 GVP8_RS GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context
15:20:55.223 Trace W2K8GEN02 GVP8_RS GCTI-153-04109 com.genesyslab.commons.log4j.LoggingManager Logging service stopped
15:20:55.223 Trace W2K8GEN02 GVP8_RS GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Message ServerPRIMARY - tcp://10.197.100.21:4343 successfully shut down.
15:20:55.223 Trace W2K8GEN02 GVP8_RS GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Configuration ServerPRIMARY - tcp://W2K3GEN01:2020 successfully shut down.

My RS is in version 8.1.502.67 and its a fresh install

system · January 21, 2014, 1:40pm

Ofcourse, here it is

[agentx]
connection_delay_sec = 60
max_connection_attempt = -1
trapfilterfile = RS_trapfilter.txt

[cdr]
call-timeout = 180
cdr-storage-batch-size = 500
db-maintenance-batch-size = 5
max-extended-rows = 10
max-page-count = 10
max-page-size = 100
media-service-cdrs.reduce = true

[dbmp]
rs.db.retention.cdr.default = 30
rs.db.retention.events.default = 7
rs.db.retention.latencies.daily.default = 90
rs.db.retention.latencies.hourly.default = 7
rs.db.retention.latencies.monthly.default = 1095
rs.db.retention.latencies.weekly.default = 364
rs.db.retention.operations.30min.default = 7
rs.db.retention.operations.5min.default = 1
rs.db.retention.operations.daily.default = 90
rs.db.retention.operations.hourly.default = 7
rs.db.retention.operations.monthly.default = 1095
rs.db.retention.operations.weekly.default = 364
rs.db.retention.sq.daily.default = 90
rs.db.retention.sq.failures.default = 365
rs.db.retention.sq.hourly.default = 7
rs.db.retention.sq.monthly.default = 365
rs.db.retention.sq.weekly.default = 180
rs.db.retention.var.30min.default = 7
rs.db.retention.var.5min.default = 1
rs.db.retention.var.daily.default = 90
rs.db.retention.var.hourly.default = 7
rs.db.retention.var.monthly.default = 1095
rs.db.retention.var.weekly.default = 364

[https]
https.certificate.algorithm = SunX509
https.client.authentication = none
https.connector.type = 2
https.keystore.path = ${user.home}/.keystore
https.keystore.type = JKS
https.protocol = TLS
https.random.algorithm = 
https.security.provider = 
password = 12D7EB663FF45563BECB0C3A4FAFD3A4

[https_key]
password = 12D7EB663FF45563BECB0C3A4FAFD3A4

[imdb]
imdb-max-cdr-queries = 3
imdb-query-lock-timeout = 1000

[latency]
threshold.asr_input_response = 2000|95
threshold.audio_fetch = 1000|95
threshold.call_answer = 2000|95
threshold.call_reject = 2000|95
threshold.cumulative_response = 2000|95
threshold.data_fetch = 2000|95
threshold.dtmf_input_response = 2000|95
threshold.grammar_fetch = 1000|95
threshold.inbound_first_prompt = 2000|95
threshold.initial_response = 4000|95
threshold.interprompt = 2000|95
threshold.java_script_execution = 50|99
threshold.java_script_fetch = 1000|95
threshold.mrcp_asr_session_establish = 100|95
threshold.mrcp_asr_set_params = 100|95
threshold.mrcp_asr_stop = 100|95
threshold.mrcp_define_grammar = 500|95
threshold.mrcp_recognize = 500|95
threshold.mrcp_speak = 100|95
threshold.mrcp_tts_session_establish = 100|95
threshold.mrcp_tts_set_params = 100|95
threshold.mrcp_tts_stop = 100|95
threshold.noinput_response = 2000|95
threshold.outbound_first_prompt = 2000|95
threshold.page_compile = 100|95
threshold.page_fetch = 1500|95
threshold.recording_response = 2000|95
threshold.transfer_response = 2000|95

[log]
all = C:/logs/RS,stdout
buffering = true
expire = 20
interaction = network
message_format = full
segment = 10000
standard = network
time_format = time
trace = network
verbose = all
x-server-trace-filter = org.*;net.*;edu.*;antlr.*;oracle.*;atomikos.*;com.microsoft.*;com.noelios.*;com.genesyslab.platform.*

[messaging]
activemq.backOffMultiplier = 2
activemq.connectionMode = 0
activemq.dataDirectory = C:\Program Files (x86)\GCTI\gvp\GVP8_RS\data\activemq
activemq.diskStoreUsageLimit = 256 gb
activemq.initialRedeliveryDelay = 1000
activemq.jmxPort = 1099
activemq.maxBackOffTime = 60000
activemq.memoryUsageLimit = 256 mb
activemq.tlsKeyStore = keystore.ks
activemq.tlsPort = 61617
activemq.useExponentialBackOff = true
activemq.useJmx = false
ciphers = TLS_RSA_WITH_AES_128_CBC_SHA
password = 3F54B4DDAD98B6EA912DA5282AFBF44E
port = 61616

[persistence]
hibernate.local.dbDirectory = C:\Program Files (x86)\GCTI\gvp\GVP8_RS\data\derby
hibernate.remote.database = GVP8_Reporting
hibernate.remote.dialect = org.hibernate.dialect.SQLServerDialect
hibernate.remote.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
hibernate.remote.url = jdbc:sqlserver://myServerName\InstanceName:14733
hibernate.remote.user = GVP8_Reporting
hibernate.show_sql = false
password = 9467A1EF630708970CB3D5FD9032C516
rs.histonly.enabled = false
rs.nodb.enabled = false
rs.partitioning.enabled = false
rs.partitioning.partitions-per-day = 6
rs.partitioning.upstream-partition-number = 1
rs.partitioning.upstream-start-time.enabled = true
rs.storage.upstream-serializer.watermark = 60000

[reporting]
binding.address = 
db.query.timeout.max = 60
hostname = 
password = 12D7EB663FF45563BECB0C3A4FAFD3A4
port = 8080
protocol = http
rs.query.limit.30min = 336
rs.query.limit.5min = 288
rs.query.limit.day = 92
rs.query.limit.hour = 168
rs.query.limit.month = 36
rs.query.limit.week = 53
rs.stylesheet-landing-page-enabled = true
rs.stylesheet-path = /static
rs.stylesheet-reporting-enabled = false
rs.summarization.buffer = 60
username = 

[schedule]
quartz.rs.calltimeout = 0 50 * * * ?
quartz.rs.datepopulate = 0 0 0 1 * ?
quartz.rs.dbMaintenancePeriod = 0 30 1 * * ?
quartz.rs.dbPartitioningPeriod = 0 0 0/1 * * ?
quartz.rs.or.counting = 0 0 0/1 * * ?
quartz.rs.summarization = 0 30 * * * ?
quartz.var.summarization = 300000

[snmp]
bulk.size = 50
polling.interval = 60
timeout = 30000

[sqa]
error.notification.threshold = 95
monitor.min.alert.number = 100
monitor.min.latency.warn.number = 100
service.quality.period = 900
stat.update.interval = 900

system · January 21, 2014, 1:49pm

No no, that is the port, I know its close to default 1433. Also, I believe that it has something to do with the JavaServerStarter file so I am pasting its info below

[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

system · January 21, 2014, 2:04pm

Yes, that is the file

16:01:32: Starting logging to file ...

16:01:32: Current working folder=C:\Program Files (x86)\GCTI\gvp\GVP8_RS

16:01:32: Starting application Java Server Starter...

16:01:32: Copyright (c) 2001-2009 Genesys Telecommunications Laboratories Inc.

16:01:32: Current date is 2014-01-21

16:01:32: Now will try to read the file C:\Program Files (x86)\GCTI\gvp\GVP8_RS\JavaServerStarter.ini

16:01:32: Reading options from section [Service]

16:01:32: 	AppTitle=VP Reporting Server

16:01:32: 	AppVersion=8.1.502.67

16:01:32: 	JVMPath=C:\Program Files (x86)\Java\jre6\bin\client\jvm.dll

16:01:32: 	MainClass=com/gvp/rpt/service/StandAloneReportingService

16:01:32: 	EventHandlerMethod=stopWinService

16:01:32: Reading args from section [JavaArgs]:

16:01:32: 	-Xmx1536M

16:01:32: 	-Xrs=YES

16:01:32: Arg <-Djava.class.path> does NOT exists - will read section [Djava.class.path]:

16:01:32: 	.\ems-rs.jar

16:01:32: 	.\mf-service.jar

16:01:32: 	.\rpt-core.jar

16:01:32: 	.\rpt-services.jar

16:01:32: 	.\libs\activemq-core.jar

16:01:32: 	.\libs\activemq-pool.jar

16:01:32: 	.\libs\antlr-2.7.6.jar

16:01:32: 	.\libs\asm-attrs.jar

16:01:32: 	.\libs\asm.jar

16:01:32: 	.\libs\cglib-2.1.3.jar

16:01:32: 	.\libs\com.noelios.restlet.ext.jetty.jar

16:01:32: 	.\libs\com.noelios.restlet.jar

16:01:32: 	.\libs\comappblock.jar

16:01:32: 	.\libs\commons-collections-3.1.jar

16:01:32: 	.\libs\commons-collections-3.2.1.jar

16:01:32: 	.\libs\commons-dbcp-1.2.2.jar

16:01:32: 	.\libs\commons-io-1.3.2.jar

16:01:32: 	.\libs\commons-lang-2.3.jar

16:01:32: 	.\libs\commons-logging.jar

16:01:32: 	.\libs\commons-pool-1.4.jar

16:01:32: 	.\libs\commons.jar

16:01:32: 	.\libs\concurrent.jar

16:01:32: 	.\libs\configurationprotocol.jar

16:01:32: 	.\libs\connection.jar

16:01:32: 	.\libs\dom4j-1.6.1.jar

16:01:32: 	.\libs\hibernate3.jar

16:01:32: 	.\libs\j2ee-management.jar

16:01:32: 	.\libs\javax.servlet.jar

16:01:32: 	.\libs\jaxb-api.jar

16:01:32: 	.\libs\jaxb-impl.jar

16:01:32: 	.\libs\jdbc2_0-stdext.jar

16:01:32: 	.\libs\jibx-run.jar

16:01:32: 	.\libs\jms.jar

16:01:32: 	.\libs\jta.jar

16:01:32: 	.\libs\kvlistbinding.jar

16:01:32: 	.\libs\kvlists.jar

16:01:32: 	.\libs\logging.jar

16:01:32: 	.\libs\warmstandbyappblock.jar

16:01:32: 	.\libs\managementprotocol.jar

16:01:32: 	.\libs\messagebrokerappblock.jar

16:01:32: 	.\libs\namespace.jar

16:01:32: 	.\libs\ojdbc14.jar

16:01:32: 	.\libs\org.json.jar

16:01:32: 	.\libs\org.mortbay.jetty.ajp.jar

16:01:32: 	.\libs\org.mortbay.jetty.https.jar

16:01:32: 	.\libs\org.mortbay.jetty.jar

16:01:32: 	.\libs\org.mortbay.jetty.util.jar

16:01:32: 	.\libs\org.restlet.jar

16:01:32: 	.\libs\protocol.jar

16:01:32: 	.\libs\protocolmanagerappblock.jar

16:01:32: 	.\libs\quartz-1.6.0.jar

16:01:32: 	.\libs\relaxngDatatype.jar

16:01:32: 	.\libs\reportingprotocol.jar

16:01:32: 	.\libs\slf4j-api.jar

16:01:32: 	.\libs\log4j-over-slf4j-1.5.11.jar

16:01:32: 	.\libs\jcl-over-slf4j-1.5.11.jar

16:01:32: 	.\libs\jul-to-slf4j-1.5.11.jar

16:01:32: 	.\libs\spring.jar

16:01:32: 	.\libs\sqljdbc.jar

16:01:32: 	.\libs\system.jar

16:01:32: 	.\libs\xbean-spring-3.6.jar

16:01:32: 	.\libs\xsdlib.jar

16:01:32: 	.\libs\snmp4j-1.11.1.jar

16:01:32: 	.\libs\snmp4j-agent-1.4.1.jar

16:01:32: 	.\libs\snmp4j-agentx-1.3.1a.jar

16:01:32: 	.\libs\log4j.jar

16:01:32: 	.\libs\netty-3.2.3.Final.jar

16:01:32: 	.\libs\org.osgi.core-4.1.0.jar

16:01:32: 	.\libs\kahadb-5.3.2.jar

16:01:32: Adding -Djava.class.path=-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

16:01:32: Application is starting as Windows Service with name: vpReportServer

16:01:32: Reading application startup parameters:

16:01:32: 	-Xmx1536m

16:01:32: 	-app

16:01:32: 	GVP8_RS

16:01:32: 	-host

16:01:32: 	W2K3GEN01

16:01:32: 	-port

16:01:32: 	2020

16:01:32: Setting service_synchronize_state = SCS_APP_STATUS_INITIALIZING

16:01:32: Loaded JVM library: C:\Program Files (x86)\Java\jre6\bin\client\jvm.dll

16:01:32: Created JVM instance: jvm_args.version = JNI_VERSION_1_2, ignoreUnrecognized = TRUE

16:01:32: Setting ConsoleCtrlHandler processing...

16:01:32: ***************************************************

16:01:32: *****   JVM was delegated control - running   *****

16:01:32: ***************************************************

16:02:14: Setting service_synchronize_state = SCS_APP_STATUS_RUNNING

16:02:15: Shutdown started, calling g_shutdown() ...

16:02:15: Starting application shutdown

16:02:15: Setting service_synchronize_state = SCS_APP_STATUS_STOP_PENDING

16:02:15: Error: JVM was not initialized or was already stopped

system · January 21, 2014, 2:26pm

This version is creating a client folder not a server one. Java version 6 update 19(x86) is proposed in order to get RS working. With x64 versions I had multiple problems.

system · January 21, 2014, 2:49pm

If I point it to the server/jvm.dll, it doesn’t create an RS log file

system · January 21, 2014, 3:11pm

Yes I believe that this is a Java issue too.. I have tried without the instance, but it did not make any difference.

cavagnaro · January 21, 2014, 5:29pm

Clarifying what Kubig tries to say:
Install Java in:

C:\JAVA (guess JDK, not only JRE) only, not Program Files.

Create JAVA_HOME system variable
Be sure you can call java.exe from a command prompt, if not add it to PATH environment variable.

Your Windows is 2008, right?
Is ReportingServer 32 or 64?

system · January 22, 2014, 7:12am

Thanks for the response cavagnaro. I have tried both only JRE and JDK, no luck. Currently i have only the JRE 6u19 installed. I am on win2008 x64 and RS is a 32bit installation. I have also created a JAVA_HOME environment variable and add my java\bin to the Path.

system · January 22, 2014, 10:59am

I am not sure I get the partitioning mode (which I have disabled in my installation). Can anyone explain what this does and when do I need it?

cavagnaro · January 22, 2014, 11:19am

Your SQL server has enabled the TCP/IP protocol for connections?
Can you connect from that server using Windows ODBC?

system · January 22, 2014, 11:25am

I have installed SQL Management Studio on the machine RS resides. Through that I have created the database and run the enterprise script to initialize it.

cavagnaro · January 22, 2014, 11:29am

Ok, but that doesn’t answer the question.
On your SQL Server try to enable the TCP/IP connection.

http://msdn.microsoft.com/en-us/library/bb909712(v=vs.90).aspx

Do the ODBC test, does it work?

system · January 22, 2014, 11:31am

Oh , I am sorry. Let me check it with the DBA.

Is this necessary? Because this instance is in production and carry other dbs as well and I see that if I do this, I need to restart also.

Additionally, I found cases that XA was not enabled and needed to be. Could this be the case?

cavagnaro · January 22, 2014, 11:51am

We are testing…try the ODBC test…
Why then not create a new instance for this service so you don’t mess up with the others?

system · January 22, 2014, 11:54am

You are right cavagnaro, I have requested an SQL server on my testing machine to have liberty on what I do without having to worry about restarts or anything else and my request was denied. I do not think that these guys will create an instance for me. I waited 4 days for an empty db :P..

cavagnaro · January 22, 2014, 11:56am

http://www.soapui.org/JDBC/testing-jdbc-databases.html
Try downloading this tool, so you will be able to test the JDBC connection and discard server or MSSQL configuration

system · January 22, 2014, 2:15pm

There was no choice in Genesys downloads. Two versions for windows 2008

VP Reporting Server	8.1.502.67	Windows 2003/2008	ENU	Hot Fix	8/6/2012	More	Download
VP Reporting Server	8.1.202.38	Windows 2003/2008	ENU	Hot Fix	23/8/2010	More	Download

I used the script under scripts/enterprise/mssql

system · January 23, 2014, 9:53am

Under which product? Genesys Voice Platform - VP Reporting Server does not produce such a list to me

cavagnaro · January 23, 2014, 11:42am

Media Server…Reporting Server…I’d have missed it too…