ReportServer Forum

azeemdin

Member

Registered: 2014-05-22

ReportServer3 with Oracle

Hi,
I have created schema using provided script on my oracle database [reportserver-RS3.0.1-5834-schema-Oracle_CREATE.sql]. But while starting the tomcat server I am getting multiple errors regarding [EnvironmentValidator] related to column type e.g.

09:17:03.168 INFO  n.datenwerke.rs.EnvironmentValidator - Validating database schema...
09:17:08.805 ERROR n.datenwerke.rs.EnvironmentValidator - Schema-validation: wrong column type encountered in column [expression] in table [RS_COMPUTED_COLUMN]; found [clob (Types#CLOB)], but expecting [long (Types#LONGVARCHAR)]
09:17:08.807 ERROR n.d.rs.ReportServerServiceConfig - ReportServer encountered an error while validating its environment. Startup interrupted.

Now I have tried to change the datatype from CLOB to LONG for some of the tables, but above mentioned table contains two columns with CLOB data type and EnvironmentValidator requires both to be of type LONG which is I believe not possible and getting [ORA-01754], if I try to do so. Kindly advise any solution in this regard if possible.

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: ReportServer3 with Oracle

Hi,

could you post the entire log output during startup?

Regards,
Arno

azeemdin

Member

Registered: 2014-05-22

Re: ReportServer3 with Oracle

03-Apr-2016 09:14:37.488 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.0.32
03-Apr-2016 09:14:37.490 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Feb 2 2016 19:34:53 UTC
03-Apr-2016 09:14:37.490 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.0.32.0
03-Apr-2016 09:14:37.491 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
03-Apr-2016 09:14:37.491 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            2.6.32-431.29.2.el6.x86_64
03-Apr-2016 09:14:37.491 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
03-Apr-2016 09:14:37.491 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /mypath/java/jdk1.7.0_79/jre
03-Apr-2016 09:14:37.491 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.7.0_79-b15
03-Apr-2016 09:14:37.491 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
03-Apr-2016 09:14:37.491 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /mypath/reportserver/apache-tomcat-8.0.32
03-Apr-2016 09:14:37.492 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /mypath/reportserver/apache-tomcat-8.0.32
03-Apr-2016 09:14:37.492 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/mypath/reportserver/apache-tomcat-8.0.32/conf/logging.properties
03-Apr-2016 09:14:37.492 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
03-Apr-2016 09:14:37.492 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1548M
03-Apr-2016 09:14:37.493 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxPermSize=512M
03-Apr-2016 09:14:37.493 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=UTF8
03-Apr-2016 09:14:37.493 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.endorsed.dirs=/mypath/reportserver/apache-tomcat-8.0.32/endorsed
03-Apr-2016 09:14:37.493 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/mypath/reportserver/apache-tomcat-8.0.32
03-Apr-2016 09:14:37.493 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/mypath/reportserver/apache-tomcat-8.0.32
03-Apr-2016 09:14:37.493 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/mypath/reportserver/apache-tomcat-8.0.32/temp
03-Apr-2016 09:14:37.494 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
03-Apr-2016 09:14:37.688 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8586"]
03-Apr-2016 09:14:37.712 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
03-Apr-2016 09:14:37.715 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 812 ms
03-Apr-2016 09:14:37.747 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
03-Apr-2016 09:14:37.748 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.0.32
03-Apr-2016 09:14:37.761 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory /mypath/reportserver/apache-tomcat-8.0.32/webapps/reportserver
03-Apr-2016 09:14:52.438 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
09:14:59.086 INFO  n.datenwerke.rs.EnvironmentValidator -




  _____                       _    _____
 |  __ \                     | |  / ____|
 | |__) |___ _ __   ___  _ __| |_| (___   ___ _ ____   _____ _ __
 |  _  // _ \ '_ \ / _ \| '__| __|\___ \ / _ \ '__\ \ / / _ \ '__|
 | | \ \  __/ |_) | (_) | |  | |_ ____) |  __/ |   \ V /  __/ |
 |_|  \_\___| .__/ \___/|_|   \__|_____/ \___|_|    \_/ \___|_|
            | |
            |_|

Version: RS3.0.1-5834 2016-03-24-23-46-15
Code Version: 2016-03-24-23-46-15
VM Args: -Djava.util.logging.config.file=/mypath/reportserver/apache-tomcat-8.0.32/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Xmx1548M -XX:MaxPermSize=512M -Dfile.encoding=UTF8 -Djava.endorsed.dirs=/mypath/reportserver/apache-tomcat-8.0.32/endorsed -Dcatalina.base=/mypath/reportserver/apache-tomcat-8.0.32 -Dcatalina.home=/mypath/reportserver/apache-tomcat-8.0.32 -Djava.io.tmpdir=/mypath/reportserver/apache-tomcat-8.0.32/temp
rs.configdir: Not Configured

### DB Config ###
hibernate.dialect: org.hibernate.dialect.Oracle10gDialect (OK)
hibernate.connection.driver_class: oracle.jdbc.driver.OracleDriver (OK)
hibernate.connection.url: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=srvcname))) (OK)
hibernate.connection.username: myuser
hibernate.connection.password: ********
hibernate.default_schema:

Connection Test: OK
Schema Version:

09:14:59.332 INFO  n.datenwerke.rs.EnvironmentValidator - Validating database schema...
09:15:04.808 ERROR n.datenwerke.rs.EnvironmentValidator - Schema-validation: wrong column type encountered in column [expression] in table [RS_COMPUTED_COLUMN]; found [clob (Types#CLOB)], but expecting [long (Types#LONGVARCHAR)]
09:15:04.810 ERROR n.d.rs.ReportServerServiceConfig - ReportServer encountered an error while validating its environment. Startup interrupted.
03-Apr-2016 09:15:05.196 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory /mypath/reportserver/apache-tomcat-8.0.32/webapps/reportserver has finished in 27,436 ms
03-Apr-2016 09:15:05.200 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8586"]
03-Apr-2016 09:15:05.207 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 27491 ms

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: ReportServer3 with Oracle

The problem is probably the wrong hibernate dialect in your persistence configuration. Could you try

net.datenwerke.rs.utils.hibernate.Oracle10gDialect

Cheers,
Arno

azeemdin

Member

Registered: 2014-05-22

Re: ReportServer3 with Oracle

My bad , I have updated the configuration, it is working fine now.

Thanks a lot for your quick support.

Rishabh

Member

Registered: 2016-07-01

Re: ReportServer3 with Oracle

Getting below error while setting up report server for first time.

I am using report server 3.0.2, oracle dB and tomcat 8.
It's able to setup connection but could not able to Validate schema.

### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.Oracle10gDialect (OK)
hibernate.connection.driver_class: oracle.jdbc.driver.OracleDriver (OK)
hibernate.connection.url: jdbc:oracle:thin:@stomcqadb4.va.neustar.com:2115:omsds
dev (OK)
hibernate.connection.username: report_server
hibernate.connection.password: *******
hibernate.default_schema: omsdsdev
Connection Test: OK
Schema Version: RS3.0-8
14:19:01.779 INFO  n.datenwerke.rs.EnvironmentValidator - Validating database sc
hema...
14:19:06.890 ERROR n.datenwerke.rs.EnvironmentValidator - Schema-validation: mis
sing table [RS_ACE]
14:19:06.893 ERROR n.d.rs.ReportServerServiceConfig - ReportServer encountered a
n error while validating its environment. Startup interrupted.

Please suggest what I am doing wrong.

Last edited by Rishabh (2016-07-01 20:56:31)

Thomas Davies

datenwerke

Registered: 2016-05-18

Re: ReportServer3 with Oracle

Did you run the DDL script to set up the ReportServer tables? The DDL scripts are located in the ddl directory.

Best Regards,
Thomas