ReportServer Forum

itatwork

Member

Registered: 2019-12-11

Upgrade Download Quelle

Hallo Support-Team,

wir sind Enterprise-Kunde und möchten von Version 3.1.0-6016 auf 3.4.0 upgraden.

In der aktuellen Upgrade-Anleitung gibt es den Punkt "Download ReportServer 3.4.0".
https://reportserver.net/en/tutorials/upgrade-30/

Wo genau bekomme ich die Upgrade-Dateien (Link)?

Ich habe nur die Möglichkeit gefunden die Demo 3.4.0 runterzuladen, wo ich mich erneut registrieren muss.

Vielen Dank im voraus.
Gruß
Christoph

Riese & Müller GmbH

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Upgrade Download Quelle

Hallo Christoph,

Du findest direkte Links zu allen Versionen im Support Portal, im "Solutions"-Bereich.

Wir haben heute eine 3.4.0-6033 -Patch Version veröffentlicht. Ich schicke Dir den Link zusätzlich per Email.

Viele Grüße
Eduardo

itatwork

Member

Registered: 2019-12-11

Re: Upgrade Download Quelle

Danke, Eduardo.

Gruß
Christoph

itatwork

Member

Registered: 2019-12-11

Re: Upgrade Download Quelle

Nach dem Neustart vom Tomcat mit dem Update, bekomme ich die Fehlermeldung mit der DB. Gibt es einen fix dafür?
Das Update ist von 3.1.0 auf 3.4.0.

11-Mar-2021 16:09:39.230 SEVERE [main] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: ERROR: column "show_execute_button" is of type boolean but expression is of type integer
  Hint: You will need to rewrite or cast the expression.
  Position: 61 (n=3, statement=UPDATE                   RS_DADGET_REPORT                                SET                             show_execute_button             = 0)
11-Mar-2021 16:09:39.230 WARNING [main] net.datenwerke.rs.EnvironmentValidator.startup Error processing the schema update
        org.postgresql.util.PSQLException: ERROR: column "show_execute_button" is of type boolean but expression is of type integer
  Hint: You will need to rewrite or cast the expression.
  Position: 61
                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2533)
                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2268)
                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:313)
                at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
                at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
                at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:159)
                at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:148)
                at net.datenwerke.rs.EnvironmentValidator.processStatements(EnvironmentValidator.java:784)
                at net.datenwerke.rs.EnvironmentValidator.runSqlScript(EnvironmentValidator.java:701)
                at net.datenwerke.rs.EnvironmentValidator.doVersionUpdate(EnvironmentValidator.java:667)
                at net.datenwerke.rs.EnvironmentValidator.schemaupdate(EnvironmentValidator.java:477)
                at net.datenwerke.rs.EnvironmentValidator.startup(EnvironmentValidator.java:123)
                at net.datenwerke.rs.ReportServerServiceConfig.getInjector(ReportServerServiceConfig.java:231)
                at com.google.inject.servlet.GuiceServletContextListener.contextInitialized(GuiceServletContextListener.java:45)
                at net.datenwerke.gf.DwGwtFrameworkBase.contextInitialized(DwGwtFrameworkBase.java:57)
                at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4685)
                at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5146)
                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
                at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717)
                at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690)
                at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
                at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1133)
                at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1867)
                at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
                at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
                at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:118)
                at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1045)
                at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:429)
                at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576)
                at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309)
                at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
                at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423)
                at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366)
                at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936)
                at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
                at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
                at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
                at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
                at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
                at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
                at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
                at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
                at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930)
                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
                at org.apache.catalina.startup.Catalina.start(Catalina.java:633)
                at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
                at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                at java.base/java.lang.reflect.Method.invoke(Method.java:567)
                at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:343)
                at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:478)
11-Mar-2021 16:09:39.232 SEVERE [main] net.datenwerke.rs.ReportServerServiceConfig.getInjector ReportServer encountered an error while validating its environment. Startup interrupted.
11-Mar-2021 16:09:39.897 SEVERE [main] org.apache.catalina.session.StandardManager.startInternal Exception loading sessions from persistent storage
        java.io.StreamCorruptedException: invalid type code: 00
                at java.base/java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1622)
                at java.base/java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:2355)
                at java.base/java.io.ObjectInputStream.defaultReadObject(ObjectInputStream.java:566)
                at java.base/java.lang.Throwable.readObject(Throwable.java:906)
                at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
                at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                at java.base/java.lang.reflect.Method.invoke(Method.java:567)
                at java.base/java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:1160)
                at java.base/java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:2216)
                at java.base/java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:2087)
                at java.base/java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1594)
                at java.base/java.io.ObjectInputStream.readObject(ObjectInputStream.java:430)
                at org.apache.catalina.session.StandardSession.doReadObject(StandardSession.java:1554)
                at org.apache.catalina.session.StandardSession.readObjectData(StandardSession.java:1048)
                at org.apache.catalina.session.StandardManager.doLoad(StandardManager.java:218)
                at org.apache.catalina.session.StandardManager.load(StandardManager.java:162)
                at org.apache.catalina.session.StandardManager.startInternal(StandardManager.java:354)
                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
                at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5163)
                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
                at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717)
                at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690)
                at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
                at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1133)
                at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1867)
                at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
                at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
                at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:118)
                at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1045)
                at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:429)
                at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576)
                at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309)
                at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
                at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423)
                at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366)
                at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936)
                at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
                at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
                at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
                at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
                at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
                at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
                at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
                at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
                at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930)
                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
                at org.apache.catalina.startup.Catalina.start(Catalina.java:633)
                at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
                at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                at java.base/java.lang.reflect.Method.invoke(Method.java:567)
                at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:343)
                at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:478)
11-Mar-2021 16:12:34.508 INFO [main] net.datenwerke.rs.EnvironmentValidator.startup

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Upgrade Download Quelle

Hallo itatwork,

danke für die Meldung. Wir schauen uns das im Ticket RS-4768 an und schreiben hier wenn wir mehr Infos dazu haben (heute).
Bitte spiel Dein DB-Backup wieder ein, so dass die DB der alten Version entspricht.

Viele Grüße
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Upgrade Download Quelle

Hallo Christoph,

wir haben heute 3.4.0-6034 veröffentlicht. Hier sollte das Problem behoben sein. Nach der Einspielung des alten DB-Backups kannst Du gerne noch einmal upgraden.

Viele Grüße
Eduardo

itatwork

Member

Registered: 2019-12-11

Re: Upgrade Download Quelle

Hallo Eduardo,

nach der Installation von 3.4.0-6034 kommt folgender Fehler:

19-Mar-2021 14:51:56.082 INFO [main] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-18-PostgreSQL_UPDATE.sql
19-Mar-2021 14:51:56.240 SEVERE [main] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: ERROR: syntax error at or near "$"
  Position: 119 (n=5, statement=rs_for:     SELECT        id                 AS     REP_SCHED_ENTITY_ID                                           
                FROM         RS_SCHED_EXECUTE_REPORT_JOB
                WHERE         report_id     =     ${REP_ID})
19-Mar-2021 14:51:56.241 SEVERE [main] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: ERROR: syntax error at or near "$"
  Position: 119 (n=5, statement=rs_for:            SELECT           id             AS     REP_ID
                            , NAME_FIELD     AS     REP_NAME
                            , description     AS     REP_DESCRIPTION
                FROM        RS_REPORT)
19-Mar-2021 14:51:56.242 WARNING [main] net.datenwerke.rs.EnvironmentValidator.startup Error processing the schema update
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "$"
  Position: 119
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2533)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2268)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:313)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:159)
        at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:109)
        at net.datenwerke.rs.EnvironmentValidator.processStatements(EnvironmentValidator.java:747)
        at net.datenwerke.rs.EnvironmentValidator.processStatements(EnvironmentValidator.java:765)
        at net.datenwerke.rs.EnvironmentValidator.runSqlScript(EnvironmentValidator.java:701)
        at net.datenwerke.rs.EnvironmentValidator.doVersionUpdate(EnvironmentValidator.java:667)
        at net.datenwerke.rs.EnvironmentValidator.schemaupdate(EnvironmentValidator.java:477)
        at net.datenwerke.rs.EnvironmentValidator.startup(EnvironmentValidator.java:123)
        at net.datenwerke.rs.ReportServerServiceConfig.getInjector(ReportServerServiceConfig.java:231)
        at com.google.inject.servlet.GuiceServletContextListener.contextInitialized(GuiceServletContextListener.java:45)
        at net.datenwerke.gf.DwGwtFrameworkBase.contextInitialized(DwGwtFrameworkBase.java:57)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4685)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5146)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1133)
        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1867)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
        at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:118)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1045)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:429)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309)
        at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
        at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423)
        at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366)
        at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936)
        at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
        at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
        at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
        at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
        at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
        at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:633)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:567)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:343)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:478)
19-Mar-2021 14:51:56.243 SEVERE [main] net.datenwerke.rs.ReportServerServiceConfig.getInjector ReportServer encountered an error while validating its environment. Startup interrupted.

Gruß
Christoph

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Upgrade Download Quelle

Hallo Christoph,

ich schaue mir das an, ich denke das hat mit Groß- und Kleinschreibung zu tun (im Upgrade-Skript).

Viele Grüße
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Upgrade Download Quelle

Hallo Christoph,

wir haben heute 3.4.0-6035 veröffentlicht. Hier sollte das Problem behoben sein. Nach der Einspielung des alten DB-Backups kannst Du gerne noch einmal upgraden.

Viele Grüße
Eduardo

itatwork

Member

Registered: 2019-12-11

Re: Upgrade Download Quelle

Hallo Eduardo,

das Update hat jetzt funktioniert.

Gruß
Christoph