ReportServer Forum

mugoyal

Member

Registered: 2018-06-29

Installation failed with Schema validation

Hi Team,

My Installation of linux version RS3.0.3-6002-2017-12-09-12-26-19-reportserver-ce failed with below error.

Connection Test: OK
Schema Version: RS3.0-9

23:05:21.293 INFO  n.datenwerke.rs.EnvironmentValidator - Validating database schema...
23:05:24.601 ERROR n.datenwerke.rs.EnvironmentValidator - Schema-validation: missing table [RS_ACE]
23:05:24.602 ERROR n.d.rs.ReportServerServiceConfig - ReportServer encountered an error while validating its environment. Startup interrupted.
Jun 29, 2018 11:05:24 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 6007 ms
Jun 29, 2018 11:05:24 PM org.apache.catalina.core.StandardServer await
SEVERE: StandardServer.await: create[localhost:30006]:

I am running new installation with Oracle DB.
i have properly executed CREATE DDL present in ddl/ directory.

Thanks
Mukesh

Last edited by mugoyal (2018-07-01 04:11:43)

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Installation failed with Schema validation

Hi Mukesh,

if you take a look at the oracle create-DB script, the first line is:

create table RS_ACE (
        ENTITY_ID number(19,0) not null,
        accesstype number(10,0) not null,
        n number(10,0) not null,
        ENTITY_VERSION number(10,0),
        acl_id number(19,0) not null,
        folk_id number(19,0),
        primary key (ENTITY_ID)
    );

so the table is present in your installation if you executed this script.

Please make sure that your persistence.properties file point to the same database where you executed your DDL script.

Take a look at this tutorials: https://reportserver.net/en/tutorials/i … -practice/ (linux) and https://reportserver.net/en/tutorials/i … n-windows/ (windows).

You can also install the bitnami version for testing. This is the most easy to install.

Regards,
Eduardo

mugoyal

Member

Registered: 2018-06-29

Re: Installation failed with Schema validation

Hi Eduardo,

I verified the table are in correct database. And also ReportServer is also able to connect to it , as per logs shown in catalina.out below.

But the issue still persist. :(

INFO: validateJarFile(/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/webapps/RS/WEB-INF/lib/servlet-api-2.4.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
15:12:56.405 INFO  n.datenwerke.rs.EnvironmentValidator -




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

Version: RS3.0.3-6002 2017-12-09-12-26-19
Code Version: 2017-12-08-10-49-15
Java Version: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.31-b07 (1.8)
VM Args: -Djava.util.logging.config.file=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/conf/logging.properties -Djava.awt.headless=true -Xmx4g -XX:+UseConcMarkSweepGC -Dfile.encoding=UTF8 -Drs.configdir=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/webapps/RS/WEB-INF/classes/ -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/endorsed -Dcatalina.base=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat -Dcatalina.home=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat -Djava.io.tmpdir=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/temp
rs.configdir: Not Configured

### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.OracleDialect (OK)
hibernate.connection.driver_class: oracle.jdbc.driver.OracleDriver (OK)
hibernate.connection.url: jdbc:oracle:thin:@ilcecmm013:1521:CMMABP1 (OK)
hibernate.connection.username: CMMDB45
hibernate.connection.password: *******
hibernate.default_schema: CMMABP1

Connection Test: OK
Schema Version: RS3.0-9

15:12:56.420 INFO  n.datenwerke.rs.EnvironmentValidator - Validating database schema...
15:12:59.745 ERROR n.datenwerke.rs.EnvironmentValidator - Schema-validation: missing table [RS_ACE]
15:12:59.746 ERROR n.d.rs.ReportServerServiceConfig - ReportServer encountered an error while validating its environment. Startup interrupted.
Jul 01, 2018 3:12:59 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 6441 ms

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Installation failed with Schema validation

We will continue here: https://forum.reportserver.net/viewtopic.php?pid=4618
Please do not create duplicate threads.

Regards,
Eduardo