repository_server not available

Questions and answers for all installation-related topics for Servoy products

repository_server not available

Postby bstaud » Thu Dec 04, 2003 2:27 am

The repository_server WAS available and working
until I installed Servoy 1.2
I did put the OpenBase driver jar into the drivers folder.
The Server config was not changed.
Now the repository_server cannot be found.
What Now?

Servoy 1.2, OpenBase 8.0 OS X 10.3


DIAGNOSTIC PROCESS:
DO UNTIL (you give up?)
BEGIN
....ServoyDeveloper : Preferences :
....Tab: DBServers
....Doubleclick: repository_server
....Examine Server Config
........Maybe do trial and error in case something has changed

ASIDE: I believe this window should have a means for
verifying that the connection is available (or not) right then.
But nooooo, you have to
....Click OK
....Click OK
....Restart Servoy, and see the message
........"Cannot find recent repository (version) on current server connection, do you want to create/upgrade?

ASIDE: The Cancel button is the safer option and should be the default.
ASIDE: At this point you should be taken to the DBServers page
directly.

....Click Cancel
....Error: Cannot create repository:
....Click OK

....By now you know something is wrong with the connection or something.

....Return to BEGIN
END DIAGNOSTIC PROCESS
bstaud
 
Posts: 6
Joined: Sat May 31, 2003 2:24 am
Location: Grass Valley, CA

Postby Jan Aleman » Thu Dec 04, 2003 8:55 pm

Did you get those errors after only placing the openbase jdbc driver? That is very, very strange. Can you send your servoy.properties file to support at servoy.com and include a short description and/or a link to this post.
Jan Aleman
Servoy
Jan Aleman
 
Posts: 2083
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

repository_server not found

Postby bstaud » Thu Dec 11, 2003 9:16 am

Environment: Servoy 1.2 OpenBase 8 OS X 10.3.1

Support's review of my properties file resulted in only the standard diagnostic checks.

A. I did not change to an Openbase database, I already have/had a working Openbase repository_server database before the upgrade to 1.2.

B. The Openbase repository_server database has always been up and working:
it can be jdbc accessed by other tools such as Aqua Data Desk,
which do connect by TCP/IP.

C. From the above, I believe that I do not have to, nor do I want
to, re-create my repository tables, do I? That would be like starting over.

D. I used your proposed command
jdbc:openbase://<12.25.184.102:20223/repository_server
on two different machines with Servoy installed, and the complaint I got, was an immediate error message:

>> java.sql.SQLException: Can not connect to the openexec at
>> '12.25.108.102:20223'
>>
The Server Config did not, previous to R1.2,2 require the explicit port number.
In Openbase the port choices are defaulted to -AUTOMATIC- so I get what I get.
So using my old config,
jdbc:openbase://<12.25.184.102/repository_server
I got to the message:
Cannot find recent repository(version) on current server
connection, do you want to create/upgrade? You might want to
backup your database first before continuing.

How do I know which it will do -- create or upgrade? It makes a difference.

Well, I thought maybe it will "upgrade" even though it says it cannot find it.
So I clicked "OK". That resulted in the following error:

java.sql.SQLException: SQL ERROR - [position 28, near 'add' in '_solutions add
activeSolu'] alter table command expected but not found.
SQL: alter table servoy_solutions add activeSolutionUpdateSeq int

Now what?

Bill
bstaud
 
Posts: 6
Joined: Sat May 31, 2003 2:24 am
Location: Grass Valley, CA

Postby Harjo » Thu Dec 11, 2003 9:46 am

I do not know the answer, but I can give you a tip!

ALWAYS :!: make a backup of your complete Servoy-directory + databases, before upgrading!! So you can fall-back on what you have.

There can be all kind of (non-Servoy-related) reasons or cases that can happen. powerfailure when you upgrade, etc..etc..
It is the oldest advice, since there are computers, but still a very often used one. :wink:
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Postby admin » Thu Dec 11, 2003 5:06 pm

The problem is being caused by the repository upgrade that has to be performed to upgrade from 1.1 to 1.2.
OpenBase does, as we understand now, support the "alter table servoy_solutions add activeSolutionUpdateSeq int" syntax.
The easies solution right now would be if OpenBase implemented that statement (most if not all SQL databases do) the workaround for the time being:
-go back to 1.1 and export all solutions -delete all servoy_ tables in the repository database -install 1.2 which will perform a clean init of the repository

In all cases: make a backup of your Servoy directory and sql database before performing the action.
admin
Site Admin
 
Posts: 72
Joined: Wed Apr 23, 2003 4:29 pm

repository_server not available

Postby bstaud » Sat Dec 20, 2003 8:07 pm

I am happy to report that Open Base, support@openbase.com,
has quickly changed Open Base to accept "ADD" or "ADD COLUMN" or "COLUMN" in the ALTER TABLE syntax.
bstaud
 
Posts: 6
Joined: Sat May 31, 2003 2:24 am
Location: Grass Valley, CA


Return to Installation

Who is online

Users browsing this forum: No registered users and 5 guests