" /> Reporting server won't start - Genesys CTI User Forum

Author Topic: Reporting server won't start  (Read 81870 times)

anoredis

  • Guest
Reporting server won't start
« on: January 21, 2014, 01:33:16 PM »
Advertisement
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

anoredis

  • Guest
Re: Reporting server won't start
« Reply #1 on: January 21, 2014, 01:40:55 PM »
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]

Marked as best answer by on Today at 03:23:56 PM

anoredis

  • Guest
Re: Reporting server won't start
« Reply #2 on: January 21, 2014, 01:49:57 PM »
  • Undo Best Answer
  • 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]

    anoredis

    • Guest
    Re: Reporting server won't start
    « Reply #3 on: January 21, 2014, 02:04:05 PM »
    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]

    anoredis

    • Guest
    Re: Reporting server won't start
    « Reply #4 on: January 21, 2014, 02:26:35 PM »
    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.

    anoredis

    • Guest
    Re: Reporting server won't start
    « Reply #5 on: January 21, 2014, 02:49:49 PM »
    If I point it to the server/jvm.dll, it doesn't create an RS log file

    anoredis

    • Guest
    Re: Reporting server won't start
    « Reply #6 on: January 21, 2014, 03:11:55 PM »
    Yes I believe that this is a Java issue too.. I have tried without the instance, but it did not make any difference.

    Offline cavagnaro

    • Administrator
    • Hero Member
    • *****
    • Posts: 7641
    • Karma: 56330
    Re: Reporting server won't start
    « Reply #7 on: January 21, 2014, 05:29:17 PM »
    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?


    anoredis

    • Guest
    Re: Reporting server won't start
    « Reply #8 on: January 22, 2014, 07:12:23 AM »
    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.

    anoredis

    • Guest
    Re: Reporting server won't start
    « Reply #9 on: January 22, 2014, 10:59:11 AM »
    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?

    Offline cavagnaro

    • Administrator
    • Hero Member
    • *****
    • Posts: 7641
    • Karma: 56330
    Re: Reporting server won't start
    « Reply #10 on: January 22, 2014, 11:19:46 AM »
    Your SQL server has enabled the TCP/IP protocol for connections?
    Can you connect from that server using Windows ODBC?

    anoredis

    • Guest
    Re: Reporting server won't start
    « Reply #11 on: January 22, 2014, 11:25:33 AM »
    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.

    Offline cavagnaro

    • Administrator
    • Hero Member
    • *****
    • Posts: 7641
    • Karma: 56330
    Re: Reporting server won't start
    « Reply #12 on: January 22, 2014, 11:29:40 AM »
    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?

    anoredis

    • Guest
    Re: Reporting server won't start
    « Reply #13 on: January 22, 2014, 11:31:37 AM »
    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?
    « Last Edit: January 22, 2014, 11:41:25 AM by anoredis »

    Offline cavagnaro

    • Administrator
    • Hero Member
    • *****
    • Posts: 7641
    • Karma: 56330
    Re: Reporting server won't start
    « Reply #14 on: January 22, 2014, 11:51:29 AM »
    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?