I messed up

Classic Servoy
1

Tired and late at night i thought it a good time to move onto 3.5…
did i do a most recent backup … no !
upgrade went absolutely fine until i tried to open solutions
read the small print - runs only on anywhere 10
went to sybase and you probably quessed where this is going !!
sybase 10 only runs on intel macs…
do i have an intel mac. no. you guessed right !
de installed, downloaded clean copy of 3.1.6 to no avail
sybase central comes up with library dbput9-r not available ? and ignores me
an older copy servoy 3.1.4 runs after i shut down dbser9 and let the older copy restart anywhere
obviously servoy needs an installation instructions for idiots (and those lost in the fog of the terminology)

  1. do i need to re install anywhere 9 to get sybase central to work again
  2. is there anyway to get my more modern repository/solutions to run or have they been ‘upgraded’

any help appreciated and i will obviously not give up my day job…
:oops: :oops: :oops:

2

Couple of Q’s:
You upgraded to 3.5 and the upgrade went fine, untill you wanted to open a solution, right?

What happens when you try opening a solution? What kind of errors?

How did you upgrade? Installed on top of an existing installation or…? Please provide a detailed description of the steps you took.

For the record: 3.5 works fine on sybase IAnyWhere 9, but if you install a fresh environment of 3.5 we now bundle Sybase 10.

Paul

3

thanks for response

i upgraded using the servoy_installer.jnlp
which i got from the website download servoy

on trying to open the upgraded version it said it cannot set up server
then
org.apache.commons:dbcp.DbcpException:
java.sql.SQL.Exception:
JZ006:caughtIOException:
java.net:ConnectException

I then looked at sybase and saw anywhere10 would only work on intel macs
thinking i could not then use servoy 3.5
i used the uninstall that was downloaded with the 3.5 installer

so if i start afresh from this ‘deinstalled’ version i get
error/ Can’t connect to the repository server specified in the application preferences.
org.apache.commons.dbcp.DbcpException:
java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused
java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused

from then it just hangs
sybase central just says error/ dbput9.r could not be loaded etc

the activity moniter is not showing any running server connection

hope this helps -

thanks

4

I presume you mean “servoy_installer.jar” instead of “servoy_installer.jnlp”?

So, you say you downloaded the servoy_installer.jar from our website and ran that?

Did you install that installer into the same directory where you previously had Servoy 3.1.x installed?

Paul

5

i just installed from the servoy website download
servoy 3.5 (final) - where java present
which downloads servoy_installer.jnlp
and on double clicking on that it goes into an installer program

i didn’t change anything prior to the install so i assume i must have put it in the same directory
it did ask if it could overwrite something
to which i said yes - else i assume it was going to stop installing ?

i have tried to attach the servoy log to the post without success - it keeps saying file is empty - when its over 2 MBs (which is below limit of 3MB and .txt filetype)- i’m using safari so perhaps it does not like it

6

Mmm, you should not have installed 3.5 using the installer and then on top of an existing installation… But anyway, let’s try to fix it

I suggest the following:

  • download both a 3.1.x installer and a 3.5 installer
  • install 3.1.x into a new directory
  • start developer in the 3.1.x directory and close it again (to trigger first time init stuff) and don’t forget to shut down the DB
  • install 3.5 into another new directory
  • start developer in the 3.5 directory and close it again (to trigger first time init stuff) and don’t forget to shut down the DB

You should now have a working 3.1.x and a working 3.5 Servoy installation

Next step:

  • To setup 3.5 to work with Sybase 9, you need to copy the following folders from the 3.1.x to the 3.5 directorydatabase
    sybase_db- in the servoy.properties file in the 3.5 installation, you ned to change:
nativeStartupLauncher=sybase_db\\dbsrv10.exe|@sybase_db\\sybase.config

to

nativeStartupLauncher=sybase_db\\dbsrv9.exe|@sybase_db\\sybase.config

If all is correct, you should now be able to start your 3.5 Developer and it will start the Sybase IAnywhere 9 DB and all would work fine

Next step is rescue your solutions…

  • You will need to copy all the files from the database directory in the servoy folder that doesn’t work anymore to the database folder in the 3.5 installation.
  • Next you will need to include all the databases in the sybase.config file located in <servoy_root>/sybase. You will need to add all the databases that you want to get started in this file. Basically, it’s one line for each database in the <servoy_root>/database folder
  • Then you need to enter all the database config info into the servoy.properties file of the 3.5 installation. It will already contain a number or preinstalled databases like:
server.0.URL=jdbc\:sybase\:Tds\:localhost\:2638?ServiceName\=servoy_repository&CHARSET\=utf8
server.0.catalog=<none>
server.0.connectionValidationType=0
server.0.driver=com.sybase.jdbc3.jdbc.SybDriver
server.0.enabled=true
server.0.maxConnectionsActive=10
server.0.maxConnectionsIdle=10
server.0.maxPreparedStatementsIdle=100
server.0.password=encrypted\:URW11N2T77A\=
server.0.schema=<none>
server.0.serverName=repository_server

since I do not know how many databases you use and if there are any other databases than the standard databases we ship, you will have to figure that out for yourself.
After you added all the DB’s correctly, make sure you update the following entry in the servoy.properties file with the right number of databases: ```
ServerManager.numberOfServers=7


Now, if you have done all this and your database files did not get corrupted in the inittial upgrade, this should do the trick to getting you back up and running...

Paul
7

thanks paul
i will try all that tonight
and hopefully let you know
the successful outcome !!!

roger

8

hi
have accomplished your instructions
have a copy of 3.5 running on anywhere9
but it does not show up my 2 solutions
other standard solutions all run ok

it seemed to not like dbserv9.exe|@sybase etc in the properties file, changed to dbserve9|@sybase etc and worked fine

other than that i did as instructed but was a little unsure in the rescuing solutions instructions
“copy all the files from the database directory” by that i assumed you meant my specific db files and logs from the database folder
or did you mean ALL the folders and files in the servoy folder such as plugins, lafs, servoy_developer.jar etc etc

So near yet so far

9

hi
have accomplished your instructions
have a copy of 3.5 running on anywhere9
but it does not show up my 2 solutions
other standard solutions all run ok

it seemed to not like dbserv9.exe|@sybase etc in the properties file, changed to dbserv9|@sybase etc and worked fine

other than that i did as instructed but was a little unsure in the rescuing solutions instructions
“copy all the files from the database directory” by that i assumed you meant my specific db files and logs from the database folder
or did you mean ALL the folders and files in the servoy folder such as plugins, lafs, servoy_developer.jar etc etc

So near yet so far

10

other than that i did as instructed but was a little unsure in the rescuing solutions instructions
“copy all the files from the database directory” by that i assumed you meant my specific db files and logs from the database folder
or did you mean ALL the folders and files in the servoy folder such as plugins, lafs, servoy_developer.jar etc etc

I meant all database files from the database folder. If you only copied your own DB’s and not the servoy_repository database, it’s quite logical that you only see the standard solutions: solutions are stored in the servoy-repository DB, so if you haven’t copied that from the messed up servoy installation to the newly installed 3.5 installation, you will not find your solution in the 3.5 install…

So, once again:

  • Copy all database files from the messed up servoy installation to the new 3,5 installation (so the entire <servoy_root>/database directory)
  • Alter the sybase.config file to include all databases (which will basically mean adding your own databases to the list of DB’s allready in there)
  • Manually edit the servoy.properties file to include all needed connections (servers) to the databases.

Paul

11

peter
couldn’t get it to recognise my solutions or servers
so i restarted
set up the 3.5 to work with anywhere 9
reput in the servers on servoy properties, with correct no of servers
added dbs to config file
when this all ran with my new servers
ran my newest backup and exported solutions (v 3.1.4)
imported them into 3.5 version
all working, although not the latest stuff
but hey ho
thank you for your help peter
i would have otherwise ‘thrown my toys out of the pram’
i have sent a few thoughts to servoy support - i still have no idea how to change this to anywhere10 when i upgrade to the new imac ?!
many thanks
roger