Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: anoredis on January 21, 2014, 01:33:16 PM
-
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 [code]jdbc:sqlserver://myServerName\myInstanceName:14733[/code]. 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 [code]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.[/code]
My RS is in version 8.1.502.67 and its a fresh install
-
Ofcourse, here it is[code][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
[/code]
-
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
[code][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
[/code]
-
Yes, that is the file [code]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[/code]
-
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.
-
If I point it to the server/jvm.dll, it doesn't create an RS log file
-
Yes I believe that this is a Java issue too.. I have tried without the instance, but it did not make any difference.
-
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?
-
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.
-
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?
-
Your SQL server has enabled the TCP/IP protocol for connections?
Can you connect from that server using Windows ODBC?
-
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.
-
Ok, but that doesn't answer the question.
On your SQL Server try to enable the TCP/IP connection.
[url=http://msdn.microsoft.com/en-us/library/bb909712(v=vs.90).aspx]http://msdn.microsoft.com/en-us/library/bb909712(v=vs.90).aspx[/url]
Do the ODBC test, does it work?
-
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?
-
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?
-
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..
-
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
-
There was no choice in Genesys downloads. Two versions for windows 2008
[code]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[/code]
I used the script under scripts/enterprise/mssql
-
Under which product? Genesys Voice Platform - VP Reporting Server does not produce such a list to me
-
Media Server...Reporting Server...I'd have missed it too...
-
Kubig, don't reply to any of my posts again. Seriously now. That attitude is not acceptable. Go play it wise to somebody else.
-
hehe chill down...I know kubig can be difficult sometimes, even more than me lol, but I do understand him ;) Just trying to help on his way, only not the most friendly speaking to do sometimes as I also suffer from that bug hehe. Understand us ;)
So, how your tests went?
Let us know
-
Exactly, sometimes may be my topics seems little negative, but it is not true. I just try and help as best I can, but I sometimes wonder and may be little frustrated by the unwilligness to try solve problem. Trust me, that no one from my responses were against you or something negative agains anything,my english is not so good and in some cases it seems like negative response,while it is not true.
-
hehe don't think he is not trying to solve the issue Kubig ;) only he may not have the same experience as us. Deep breath and remember you 10 years ago ;)
Lets have this bitch dominated and solve the problem here
-
I have solved the problem. It had to do with the Database so I threw the ball to the DBA.
cav: Ok buddy, message received already. In order to have this post clean and less conflictive edited your post.
-
Can you please detail a little bit more on how the problem was solved? That will help future users who may need to query the forum.
-
I know that I cannot answer on your topics, but I am just wondering how did you solve the issue. It would be good to share with others - it is a good habit