Pages: 1

#1 2019-06-04 06:59:23

JohnDoe
Member
Registered: 2019-06-04

Problems Updating 3.0.3 > 3.0.7

Hello everyone!

I am running Reportserver via the Bitnamistack and I am having trouble updating to the current version 3.0.7.

I followed the instuctions outlined in https://reportserver.net/en/tutorials/upgrade-30/, but the update process fails when trying to run RS3.0-12-MySQL5_UPDATE.sql.
See reportserver.log below:

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.161-b12 (1.8)
VM Args: -Djava.util.logging.config.file=/opt/reportserverenterprise/apache-tomcat/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Xms512M -Xmx1536M -Drs.configdir=/opt/reportserverenterprise/apps/reportserver/reportserver-conf -Dfile.encoding=UTF8 -Djava.awt.headless=true -Djdk.tls.ephemeralDHKeySize=2048 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dignore.endorsed.dirs= -Dcatalina.base=/opt/reportserverenterprise/apache-tomcat -Dcatalina.home=/opt/reportserverenterprise/apache-tomcat -Djava.io.tmpdir=/opt/reportserverenterprise/apache-tomcat/temp
rs.configdir: /opt/reportserverenterprise/apps/reportserver/reportserver-conf (OK)

### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.MySQL5Dialect (OK)
hibernate.connection.driver_class: com.mysql.jdbc.Driver (OK)
hibernate.connection.url: jdbc:mysql://127.0.0.1:3307/bitnami_reportserver (OK)
hibernate.connection.username: bn_reportserver
hibernate.connection.password: **********
hibernate.default_schema: 

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

04-Jun-2019 08:24:37.009 INFO [localhost-startStop-1] net.datenwerke.rs.EnvironmentValidator.startup Validating database schema...
04-Jun-2019 08:24:39.222 INFO [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-11-MySQL5_UPDATE.sql
04-Jun-2019 08:24:39.307 INFO [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-12-MySQL5_UPDATE.sql
04-Jun-2019 08:24:40.600 SEVERE [localhost-startStop-1] net.datenwerke.rs.EnvironmentValidator.hibernateValidateSchema Schema-validation: missing column [cube] in table [RS_MONDRIAN_DATASOURCE_CFG]
04-Jun-2019 08:24:40.601 SEVERE [localhost-startStop-1] net.datenwerke.rs.ReportServerServiceConfig.getInjector ReportServer encountered an error while validating its environment. Startup interrupted. 
04-Jun-2019 08:29:04.256 SEVERE [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{entity_id}' at line 1 (n=313367, statement=rs_for: SELECT sched_execute_report_job_id from RS_SCHED_REP_EXEC_JOB_2_PROP where base_properties_id = ${entity_id})
04-Jun-2019 08:29:04.256 SEVERE [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{entity_id}' at line 1 (n=313366, statement=rs_for: SELECT next_val from RS_HIBERNATE_SEQUENCE)
04-Jun-2019 08:29:04.257 SEVERE [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{entity_id}' at line 1 (n=313365, statement=rs_for: SELECT ENTITY_ID, SUBSTRING(KEY_FIELD, 22,  LOCATE('_cond_id',  KEY_FIELD   ) - 22 ) as counter_id
 from RS_SCHED_BASE_PROPERTY WHERE KEY_FIELD LIKE '__schedule_condition_%_cond_id')
04-Jun-2019 08:29:04.257 WARNING [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.startup Error processing the schema update
 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{entity_id}' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
	at com.mysql.jdbc.Util.getInstance(Util.java:387)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
	at net.datenwerke.rs.EnvironmentValidator.processStatements(EnvironmentValidator.java:754)
	at net.datenwerke.rs.EnvironmentValidator.processStatements(EnvironmentValidator.java:770)
	at net.datenwerke.rs.EnvironmentValidator.processStatements(EnvironmentValidator.java:770)
	at net.datenwerke.rs.EnvironmentValidator.runSqlScript(EnvironmentValidator.java:708)
	at net.datenwerke.rs.EnvironmentValidator.doVersionUpdate(EnvironmentValidator.java:674)
	at net.datenwerke.rs.EnvironmentValidator.schemaupdate(EnvironmentValidator.java:484)
	at net.datenwerke.rs.EnvironmentValidator.startup(EnvironmentValidator.java:123)
	at net.datenwerke.rs.ReportServerServiceConfig.getInjector(ReportServerServiceConfig.java:221)
	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:4884)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5347)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:731)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1125)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1867)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)

04-Jun-2019 08:29:04.257 SEVERE [localhost-startStop-3] net.datenwerke.rs.ReportServerServiceConfig.getInjector ReportServer encountered an error while validating its environment. Startup interrupted.

Any ideas how to fix this?
I went and checked the table RS_MONDRIAN_DATASOURCE_CFG before updating, the column cube does exists in version 3.0.3, but somewhere down the road its name is changed to cube_name.

Thank you in advance for any advice you can give me!

David

Offline

#2 2019-06-04 07:02:21

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Problems Updating 3.0.3 > 3.0.7

Hi David,

which exact DB version are you using for the reportserver metadata ?

Regards,
Eduardo

Offline

#3 2019-06-04 07:25:38

JohnDoe
Member
Registered: 2019-06-04

Re: Problems Updating 3.0.3 > 3.0.7

Hi Eduardo,

I am running 10.1.32-MariaDB

Regards,
David

Offline

#4 2019-06-04 07:28:35

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Problems Updating 3.0.3 > 3.0.7

Hi David,

can you first try to upgrade to 3.0.6? Then try the upgrade 3.0.6 -> 3.0.7. You can download 3.0.6 from here:

https://reportserver.net/spp/download-r … 5-09-56-26

Regards,
Eduardo

Offline

#5 2019-06-04 07:39:59

JohnDoe
Member
Registered: 2019-06-04

Re: Problems Updating 3.0.3 > 3.0.7

Thanks a lot!
I will try this and report back here.

Regards,
David

Offline

#6 2019-06-04 07:48:57

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Problems Updating 3.0.3 > 3.0.7

Hi David,

a further question: did you try the upgrade process before and interrupted / repeated it somehow? I see in your logs the following:

Schema Version: RS3.0-9

04-Jun-2019 08:24:37.009 INFO [localhost-startStop-1] net.datenwerke.rs.EnvironmentValidator.startup Validating database schema...
04-Jun-2019 08:24:39.222 INFO [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-11-MySQL5_UPDATE.sql
04-Jun-2019 08:24:39.307 INFO [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-12-MySQL5_UPDATE.sql

So your original installation 3.0.3 has schema version 9. This is correct.
But then, the script RS3.0-11-MySQL5_UPDATE.sql is being executed. The schema version 10 script is being skipped somehow.

Please revert completely the DB to the 3.0.3 version and try again. You should see something similar as:

Schema Version: RS3.0-9

04-Jun-2019 08:24:37.009 INFO [localhost-startStop-1] net.datenwerke.rs.EnvironmentValidator.startup Validating database schema...
04-Jun-2019 08:24:39.221 INFO [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-10-MySQL5_UPDATE.sql
04-Jun-2019 08:24:39.222 INFO [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-11-MySQL5_UPDATE.sql
04-Jun-2019 08:24:39.307 INFO [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-12-MySQL5_UPDATE.sql

Of course, you can also try to upgrade 3.0.3 to 3.0.6 as I suggested before. In this case, you should see the same (the schema versions between 3.0.6 and 3.0.7 are the same: 12) :

Schema Version: RS3.0-9

04-Jun-2019 08:24:37.009 INFO [localhost-startStop-1] net.datenwerke.rs.EnvironmentValidator.startup Validating database schema...
04-Jun-2019 08:24:39.221 INFO [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-10-MySQL5_UPDATE.sql
04-Jun-2019 08:24:39.222 INFO [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-11-MySQL5_UPDATE.sql
04-Jun-2019 08:24:39.307 INFO [localhost-startStop-3] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-12-MySQL5_UPDATE.sql

Regards,
Eduardo

Offline

#7 2019-06-05 12:48:27

JohnDoe
Member
Registered: 2019-06-04

Re: Problems Updating 3.0.3 > 3.0.7

Hi Eduoardo,

I tried a few things, so it took me a while longer to respond.
First of all: skipping of version 10 was my fault, I just renamed the old reportserver folder in apache-tomcat/webapps, not deleted it. So Tomcat startet 2 instaces which of course collided. My bad.

Then I tried again the correct way using verions 3.0.7 and 3.0.6 you provided. Now it goes from version 10 to 11 to 12.
But when processing version12, both times the update fails, see the log with version 3.0.6 below (3.0.7 generates the same output):

Version: RS3.0.6-6007 2019-04-15-09-56-26
Code Version: 2019-03-22-11-07-48
Java Version: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.161-b12 (1.8)
VM Args: -Djava.util.logging.config.file=/opt/reportserverenterprise/apache-tomcat/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Xms512M -Xmx1536M -Drs.configdir=/opt/reportserverenterprise/apps/reportserver/reportserver-conf -Dfile.encoding=UTF8 -Djava.awt.headless=true -Djdk.tls.ephemeralDHKeySize=2048 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dignore.endorsed.dirs= -Dcatalina.base=/opt/reportserverenterprise/apache-tomcat -Dcatalina.home=/opt/reportserverenterprise/apache-tomcat -Djava.io.tmpdir=/opt/reportserverenterprise/apache-tomcat/temp
rs.configdir: /opt/reportserverenterprise/apps/reportserver/reportserver-conf (OK)

### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.MySQL5Dialect (OK)
hibernate.connection.driver_class: com.mysql.jdbc.Driver (OK)
hibernate.connection.url: jdbc:mysql://127.0.0.1:3307/bitnami_reportserver (OK)
hibernate.connection.username: bn_reportserver
hibernate.connection.password: **********
hibernate.default_schema: 

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

05-Jun-2019 14:28:12.640 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.schemaupdate Performing database update RS3.0-9 -> RS3.0-12
05-Jun-2019 14:28:12.640 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-10-MySQL5_UPDATE.sql
05-Jun-2019 14:28:14.439 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-11-MySQL5_UPDATE.sql
05-Jun-2019 14:28:14.532 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-12-MySQL5_UPDATE.sql
05-Jun-2019 14:32:37.066 SEVERE [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{entity_id}' at line 1 (n=313462, statement=rs_for: SELECT sched_execute_report_job_id from RS_SCHED_REP_EXEC_JOB_2_PROP where base_properties_id = ${entity_id})
05-Jun-2019 14:32:37.066 SEVERE [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{entity_id}' at line 1 (n=313461, statement=rs_for: SELECT next_val from RS_HIBERNATE_SEQUENCE)
05-Jun-2019 14:32:37.066 SEVERE [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{entity_id}' at line 1 (n=313460, statement=rs_for: SELECT ENTITY_ID, SUBSTRING(KEY_FIELD, 22,  LOCATE('_cond_id',  KEY_FIELD   ) - 22 ) as counter_id
 from RS_SCHED_BASE_PROPERTY WHERE KEY_FIELD LIKE '__schedule_condition_%_cond_id')
05-Jun-2019 14:32:37.066 WARNING [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.startup Error processing the schema update
 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{entity_id}' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
	at com.mysql.jdbc.Util.getInstance(Util.java:387)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
	at net.datenwerke.rs.EnvironmentValidator.processStatements(EnvironmentValidator.java:754)
	at net.datenwerke.rs.EnvironmentValidator.processStatements(EnvironmentValidator.java:770)
	at net.datenwerke.rs.EnvironmentValidator.processStatements(EnvironmentValidator.java:770)
	at net.datenwerke.rs.EnvironmentValidator.runSqlScript(EnvironmentValidator.java:708)
	at net.datenwerke.rs.EnvironmentValidator.doVersionUpdate(EnvironmentValidator.java:674)
	at net.datenwerke.rs.EnvironmentValidator.schemaupdate(EnvironmentValidator.java:484)
	at net.datenwerke.rs.EnvironmentValidator.startup(EnvironmentValidator.java:123)
	at net.datenwerke.rs.ReportServerServiceConfig.getInjector(ReportServerServiceConfig.java:221)
	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:4884)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5347)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:731)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1125)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1867)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)

05-Jun-2019 14:32:37.067 SEVERE [localhost-startStop-2] net.datenwerke.rs.ReportServerServiceConfig.getInjector ReportServer encountered an error while validating its environment. Startup interrupted.

Any ideas?

Thanks again for your help!

Regards,
David

Offline

#8 2019-06-05 13:57:33

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Problems Updating 3.0.3 > 3.0.7

Hi David,

did you have a previous installation before you had 3.0.3 ?
So did you have 3.0.2 or previous ? Did you perform at any time an upgrade to 3.0.3 ?

The first you can do is to upgrade to 3.0.5: it was my mistake to upgrade to 3.0.6 first, since the db versions between 3.0.6 and 3.0.7 are the same. So the last upgrade working in your case is to 3.0.5. Please upgrade to 3.0.5 first and make a backup of your database afterwards.

You can download 3.0.5 from here:
https://reportserver.net/spp/download-r … 0-10-32-54

Regards,
Eduardo

Offline

#9 2019-06-05 14:01:25

JohnDoe
Member
Registered: 2019-06-04

Re: Problems Updating 3.0.3 > 3.0.7

Hi Eduardo!

Thanks, I will try 3.0.5 tomorrow and report back to you.

3.0.3 was the first install I did, no previous versions have been in use and until now no upgrades have been performed.

Regards,
David

Offline

#10 2019-06-06 08:32:53

JohnDoe
Member
Registered: 2019-06-04

Re: Problems Updating 3.0.3 > 3.0.7

Hey Eduardo,

I tried installing 3.0.5 and it worked like a charm!

Schema Version: RS3.0-9

06-Jun-2019 09:57:52.442 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.schemaupdate Performing database update RS3.0-9 -> RS3.0-11
06-Jun-2019 09:57:52.443 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-10-MySQL5_UPDATE.sql
06-Jun-2019 09:57:54.274 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-11-MySQL5_UPDATE.sql
06-Jun-2019 09:57:54.373 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.startup Validating database schema...

ReportServer starts normally and everything works fine.
But when I try to update from 3.0.5 to 3.0.6, sadly the same error happens again:

Schema Version: RS3.0-11

06-Jun-2019 10:06:43.319 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.schemaupdate Performing database update RS3.0-11 -> RS3.0-12
06-Jun-2019 10:06:43.320 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-12-MySQL5_UPDATE.sql
06-Jun-2019 10:10:34.426 SEVERE [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{entity_id}' at line 1 (n=313518, statement=rs_for: SELECT sched_execute_report_job_id from RS_SCHED_REP_EXEC_JOB_2_PROP where base_properties_id = ${entity_id})
06-Jun-2019 10:10:34.426 SEVERE [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{entity_id}' at line 1 (n=313517, statement=rs_for: SELECT next_val from RS_HIBERNATE_SEQUENCE)
06-Jun-2019 10:10:34.426 SEVERE [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{entity_id}' at line 1 (n=313516, statement=rs_for: SELECT ENTITY_ID, SUBSTRING(KEY_FIELD, 22,  LOCATE('_cond_id',  KEY_FIELD   ) - 22 ) as counter_id
 from RS_SCHED_BASE_PROPERTY WHERE KEY_FIELD LIKE '__schedule_condition_%_cond_id')
06-Jun-2019 10:10:34.426 WARNING [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.startup Error processing the schema update
 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{entity_id}' at line 1

Maybe just doing a fresh install is a better way?

Regards,
David

Offline

#11 2019-06-06 08:52:08

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Problems Updating 3.0.3 > 3.0.7

Hi David,

thanks for the information.
Everything you describe is as I expected: 3.0.5 is the last version that can be upgraded with your configuration, so I wanted to first upgrade to this (3.0.5), then make a DB backup, so we can always return to 3.0.5, and then check why the upgrade 3.0.5 -> 3.0.6 is not working. So please just make a DB backup first.

Next, something seems to not to work with a part of the upgrade script to DB-version 12 in your case. You can find the upgrade script here: WEB-INF/lib/rs-schemaupdate-1.3.5.jar. You can open this with winrar and navigate here: net/datenwerke/rs/schemaupdate/resources/RS3.0/RS3.0-12/RS3.0-12-MySQL5_UPDATE.sql

I am currently taking a look at the script with MariaDB, I will update later when I find the problem. I have some ideas what may be going wrong.

Of course, if a fresh install is an option for you, you can do a fresh install. But as I said, let me check if I find the problem smile

Regards,
Eduardo

Offline

#12 2019-06-06 16:59:19

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Problems Updating 3.0.3 > 3.0.7

Hi David,

it seems to be a problem with the upper- and lower case. I changed ENTITY_ID to entity_id and it seems to work.

Please perform the following steps:
1. Backup your 3.0.5 database.
2. Replace the rs-schemaupdate-1.3.5.jar from your 3.0.6 download with the fixed file here: http://www2.datenwerke.net/rsupdate/rs- … -1.3.5.jar
3. Try the upgrade to 3.0.6 again. It should work now. The upgrade to 3.0.7 should also work.

Please confirm if the fix works in your case so we can replace the file in the official 3.0.6 and 3.0.7 downloads.

Regards,
Eduardo

Offline

#13 2019-06-07 07:26:33

JohnDoe
Member
Registered: 2019-06-04

Re: Problems Updating 3.0.3 > 3.0.7

Hi Eduardo,

I tried replacing the file and now 3.0.6 and afterwards 3.0.7 work flawlessly!

Schema Version: RS3.0-11

07-Jun-2019 09:02:01.486 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.schemaupdate Performing database update RS3.0-11 -> RS3.0-12
07-Jun-2019 09:02:01.487 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-12-MySQL5_UPDATE.sql
07-Jun-2019 09:05:55.107 INFO [localhost-startStop-2] net.datenwerke.rs.EnvironmentValidator.startup Validating database schema...

I did not try to update from 3.0.5 to 3.0.7 directly, but I guess it would work as well.

Thanks a lot for your quick and competent help!

Regards,
David

Offline

#14 2019-06-07 07:30:22

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Problems Updating 3.0.3 > 3.0.7

Hi David,

thank you also for your quick responses. Yes, the update 3.0.5 -> 3.0.7 will also work, and 3.0.3 -> 3.0.7 too smile
We will update the file in the 3.0.6 and 3.0.7 files and I will update here when this is done for completeness.

Regards,
Eduardo

Offline

#15 2019-06-11 11:07:39

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Problems Updating 3.0.3 > 3.0.7

Hi David,

we corrected the scripts in the binaries available for download.

Regards,
Eduardo

Offline

Pages: 1

Board footer

Powered by FluxBB