# repository\_server not available

**URL:** <https://forum.servoy.com/t/repository-server-not-available/809>\
**Category:** Classic Servoy\
**Created:** [December 4, 2003, 12:27am UTC](https://forum.servoy.com/t/repository-server-not-available/809 "2003-12-04T00:27:14Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![bstaud](https://avatars.discourse-cdn.com/v4/letter/b/d9b06d/32.png) [@bstaud](https://forum.servoy.com/u/bstaud)\
**Post date:** [December 4, 2003, 12:27am UTC](https://forum.servoy.com/t/repository-server-not-available/809/1 "2003-12-04T00:27:14Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [December 4, 2003, 6:55pm UTC](https://forum.servoy.com/t/repository-server-not-available/809/2 "2003-12-04T18:55:48Z")

</div>

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](http://servoy.com) and include a short description and/or a link to this post.

---

<div class="post-metadata">

**Author:** ![bstaud](https://avatars.discourse-cdn.com/v4/letter/b/d9b06d/32.png) [@bstaud](https://forum.servoy.com/u/bstaud)\
**Post date:** [December 11, 2003, 7:16am UTC](https://forum.servoy.com/t/repository-server-not-available/809/3 "2003-12-11T07:16:33Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\
**Post date:** [December 11, 2003, 7:46am UTC](https://forum.servoy.com/t/repository-server-not-available/809/4 "2003-12-11T07:46:34Z")

</div>

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

ALWAYS ![:!:]( "Exclamation") 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:]( "Wink")

---

<div class="post-metadata">

**Author:** ![admin](https://avatars.discourse-cdn.com/v4/letter/a/3ec8ea/32.png) [@admin](https://forum.servoy.com/u/admin)\
**Post date:** [December 11, 2003, 3:06pm UTC](https://forum.servoy.com/t/repository-server-not-available/809/5 "2003-12-11T15:06:30Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![bstaud](https://avatars.discourse-cdn.com/v4/letter/b/d9b06d/32.png) [@bstaud](https://forum.servoy.com/u/bstaud)\
**Post date:** [December 20, 2003, 6:07pm UTC](https://forum.servoy.com/t/repository-server-not-available/809/6 "2003-12-20T18:07:38Z")

</div>

I am happy to report that Open Base, [support@openbase.com](mailto:support@openbase.com),  
has quickly changed Open Base to accept “ADD” or “ADD COLUMN” or “COLUMN” in the ALTER TABLE syntax.