ReportServer Forum

Padma

Member

Registered: 2021-02-03

ReportServer with Postgres. ReportServer not loaded.

Hello Team,

yesterday we have restarted the VM. after we have start the apache Tomcat 8.5 server. server was started but unable to load the report server getting the below error. Could you please help on below issue.

6-Nov-2022 00:26:42.679 INFO [localhost-startStop-1] net.datenwerke.rs.EnvironmentValidator.startup

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

Version: RS3.3.0-6030 2020-09-25-11-16-41
Code Version: 2020-09-25-10-02-31
Java Version: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.351-b10 (1.8)
VM Args: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 8.5 -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 8.5 -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 8.5\temp -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Drs.configdir=C:\Program Files\reportserver -Dfile.encoding=UTF8 -Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 8.5\conf\logging.properties -Djs.license.directory=C:\Jaspersoft\jasperreports-server-cp-7.8.0 exit abort -Xms512m -Xmx1600m
rs.configdir: C:\Program Files\reportserver (OK)

### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.PostgreSQLDialect (OK)
hibernate.connection.driver_class: org.postgresql.Driver (OK)
hibernate.connection.url: jdbc:postgresql://usdr16s31/reportserver (OK)
hibernate.connection.username: reportserver
hibernate.connection.password: **********
hibernate.default_schema: public

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

26-Nov-2022 00:26:42.752 INFO [localhost-startStop-1] net.datenwerke.rs.EnvironmentValidator.startup Validating database schema...
26-Nov-2022 00:26:53.073 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure try to bind: net.datenwerke.rs.saiku.server.rest.resources.AdminResource
26-Nov-2022 00:26:53.073 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure done binding: net.datenwerke.rs.saiku.server.rest.resources.AdminResource
26-Nov-2022 00:26:53.073 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure try to bind: net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource2
26-Nov-2022 00:26:53.073 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure done binding: net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource2
26-Nov-2022 00:26:53.074 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure try to bind: net.datenwerke.rs.saiku.server.rest.resources.DataSourceResource
26-Nov-2022 00:26:53.074 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure done binding: net.datenwerke.rs.saiku.server.rest.resources.DataSourceResource
26-Nov-2022 00:26:53.074 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure try to bind: net.datenwerke.rs.saiku.server.rest.resources.ExporterResource
26-Nov-2022 00:26:53.074 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure done binding: net.datenwerke.rs.saiku.server.rest.resources.ExporterResource
26-Nov-2022 00:26:53.074 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure try to bind: net.datenwerke.rs.saiku.server.rest.resources.FilterRepositoryResource
26-Nov-2022 00:26:53.074 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure done binding: net.datenwerke.rs.saiku.server.rest.resources.FilterRepositoryResource
26-Nov-2022 00:26:53.074 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure try to bind: net.datenwerke.rs.saiku.server.rest.resources.InfoResource
26-Nov-2022 00:26:53.074 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure done binding: net.datenwerke.rs.saiku.server.rest.resources.InfoResource
26-Nov-2022 00:26:53.074 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure try to bind: net.datenwerke.rs.saiku.server.rest.resources.License
26-Nov-2022 00:26:53.075 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure done binding: net.datenwerke.rs.saiku.server.rest.resources.License
26-Nov-2022 00:26:53.075 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure try to bind: net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource
26-Nov-2022 00:26:53.075 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure done binding: net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource
26-Nov-2022 00:26:53.075 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure try to bind: net.datenwerke.rs.saiku.server.rest.resources.Query2Resource
26-Nov-2022 00:26:53.075 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure done binding: net.datenwerke.rs.saiku.server.rest.resources.Query2Resource
26-Nov-2022 00:26:53.075 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure try to bind: net.datenwerke.rs.saiku.server.rest.resources.SessionResource
26-Nov-2022 00:26:53.075 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure done binding: net.datenwerke.rs.saiku.server.rest.resources.SessionResource
26-Nov-2022 00:26:53.075 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure try to bind: net.datenwerke.rs.saiku.server.rest.resources.SaikuI18nResource
26-Nov-2022 00:26:53.076 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure done binding: net.datenwerke.rs.saiku.server.rest.resources.SaikuI18nResource
26-Nov-2022 00:26:53.076 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure try to bind: net.datenwerke.rs.saiku.server.rest.resources.StatisticsResource
26-Nov-2022 00:26:53.076 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.server.rest.SaikuRestModule.configure done binding: net.datenwerke.rs.saiku.server.rest.resources.StatisticsResource
26-Nov-2022 00:26:53.329 INFO [localhost-startStop-1] net.datenwerke.rsenterprise.main.service.RsEnterpriseModule.configureServlets SAP Crystal libraries not present
26-Nov-2022 00:26:57.865 WARNING [localhost-startStop-1] net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl.getConfigFailsafe Configfile scheduler/scheduler.cf could not be loaded. Default values are in effect.
26-Nov-2022 00:26:57.870 WARNING [localhost-startStop-1] net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl.getConfigFailsafe Configfile exportfilemd/pdfexport.cf could not be loaded. Default values are in effect.
26-Nov-2022 00:26:57.871 WARNING [localhost-startStop-1] net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl.getConfigFailsafe Configfile exportfilemd/pdfexport.cf could not be loaded. Default values are in effect.
26-Nov-2022 00:26:58.104 INFO [localhost-startStop-1] net.datenwerke.rs.saiku.service.saiku.ThinQueryServiceImpl.<init> loaded thinqueryservice
26-Nov-2022 00:26:58.449 INFO [localhost-startStop-1] net.datenwerke.rs.core.service.i18ntools.RemoteMessageServiceImpl.<init> Loading messages...
26-Nov-2022 00:27:05.110 INFO [localhost-startStop-1] net.datenwerke.rs.core.service.i18ntools.RemoteMessageServiceImpl.<init> Available locales: de, hi, lo, pt, lt, hr, lv, hu, zh-CN, hy, uk, id, mk, mn, af, uz, ms, el, mt, en, is, it, my, es, et, eu, vi, ja, ne, ro, nl, no, be, fi, ru, bg, keys, bn, fr, jw, bs, ka, si, sk, sl, ga, gd, ca, sq, sr, kk, km, sv, ko, zh-TW, ta, cs, th, lb, tl, pl, da, tr
26-Nov-2022 00:27:10.232 SEVERE [Thread-11] net.datenwerke.gf.service.lateinit.LateInitStartup$1.run Error in LateInitHook
    net.datenwerke.security.service.crypto.pbe.exception.PbeException: Could not encrypt plaintext
        at net.datenwerke.security.service.crypto.pbe.encrypt.EncryptionServiceImpl.encrypt(EncryptionServiceImpl.java:139)
        at net.datenwerke.security.service.crypto.pbe.encrypt.EncryptionServiceImpl.encrypt(EncryptionServiceImpl.java:115)
        at net.datenwerke.rs.base.service.datasources.definitions.DatabaseDatasource.setPassword(DatabaseDatasource.java:139)
        at net.datenwerke.rs.installation.InstallBaseDataTask.installDatasource(InstallBaseDataTask.java:139)
        at net.datenwerke.rs.installation.InstallBaseDataTask.executeOnFirstRun(InstallBaseDataTask.java:69)
        at net.datenwerke.rs.installation.ReportServerInstallationServiceImpl.runAdditionalDbInstallTasks(ReportServerInstallationServiceImpl.java:50)
        at net.datenwerke.rs.installation.ReportServerInstallationServiceImpl.install(ReportServerInstallationServiceImpl.java:29)
        at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:58)
        at net.datenwerke.rs.installation.RsInstallStartup$1.initialize(RsInstallStartup.java:25)
        at net.datenwerke.gf.service.lateinit.LateInitStartup$1.run(LateInitStartup.java:62)
        at java.lang.Thread.run(Unknown Source)
    Caused by: java.security.NoSuchAlgorithmException: Cannot find any provider supporting AES/CBC/ISO7816-4Padding
        at javax.crypto.Cipher.getInstance(Cipher.java:543)
        at net.datenwerke.security.service.crypto.pbe.encrypt.EncryptionServiceImpl.encrypt(EncryptionServiceImpl.java:128)
        ... 10 more
26-Nov-2022 00:28:38.141 WARNING [http-nio-8080-exec-1] net.datenwerke.rs.configservice.service.configservice.ConfigServiceImpl.getConfigFailsafe Configfile ui/ui.cf could not be loaded. Default values are in effect.
26-Nov-2022 00:28:38.265 WARNING [http-nio-8080-exec-4] net.datenwerke.rsenterprise.theme.service.EnterpriseThemeServiceImpl.getXmlConfig Configfile ui/theme.cf could not be loaded. Default values are in effect.
26-Nov-2022 01:02:43.681 WARNING [http-nio-8080-exec-8] net.datenwerke.rsenterprise.theme.service.EnterpriseThemeServiceImpl.getXmlConfig Configfile ui/theme.cf could not be loaded. Default values are in effect.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: ReportServer with Postgres. ReportServer not loaded.

Hi Padma,

something must have changed in your environment/configuration/installation, if it worked previously and now it stopped to work. Did you change something? Are you using the same reportserver.properties file ? Did you perform a software upgrade?

Regards,
Eduardo