Hi, I’m totally new to Servoy and am running into trouble installing Servoy Developer onto a Solaris system. The intention is to use this as a server where we will deploy Servoy applications to and run them over the web.
This is all in development at the moment - we’re just trying to get something functional.
So, I installed Servoy 3.5.6 onto my Windows PC no problem and have been running the sample CRM application and been poking around the code etc etc.
I installed Servoy 3.5.6 onto Solaris without any problem either - so far so good.
I try to start the Servoy developer on Solaris and it complains with the following message…
com.servoy.j2db.persistence.RepositoryException: Could not find repository server: ‘repository_server’
I then tried running the ‘servoy_server.sh’ script thinking that needed to be run first ( ./servoy_server.sh ) - that returned a 1 code ( echo $? )
I checked the server.log file and saw these messages …
Exception in thread “main” com.servoy.j2db.persistence.RepositoryException: Could not find repository server: ‘repository_server’
at com.servoy.j2db.persistence.ServerManager.getRepositoryServer(Unknown Source)
at com.servoy.j2db.server.ApplicationServer.main(Unknown Source)
So, it seems my repository server is messed up - what am I looking for to help diagnose this ?
Thanks in advance
Ok an update…
I followed the instructions in 4.6.7 of the Developer Manual.
I created a DB Server entry and set it to point to a database on the same Solaris system, I then restarted Servoy developer - same error as before.
So I went back into the Edit > Preferences and into the DB Server tab and checked the entries - everything looks ok. I press the OK button and get an error ‘Cannot setup server’ - I click Details>> and get the following…
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified
Hmmm… I seem to recall something like having to set NLS33 or some such environment variable… looking into this now…
I tried setting the following environment variables and have seen no difference…
export ORA_NLS10=/u01/apps/oracle/product/v102e/nls/data
export NLS_LANG=AMERICAN_AMERICA.US7ASCII
I even tried ORA_NLS33 (but that’s for Oracle 8/9 and the database I’m trying to use is Oracle10gR2). I am the DBA for the database so I’ve setup a user in the database called ‘servoy’, given him sufficient privileges to alter session, create tables, etc etc.
I traced the session on the server and found the following statement in the trace file - this statement is invalid and responsible for the ORA-12705 error…
…
ALTER SESSION SET TIME_ZONE=‘-6:00’ NLS_LANGUAGE=‘null’ NLS_TERRITORY=‘null’
…
I set the NLS_LANGUAGE and NLS_TERRITORY environment variables (to AMERICAN and AMERICA, respectively) then tried running Servoy Developer, selected Edit > Preferences, picked my database connection, selected OK on that dialog as before and still get the same error as before.
I traced that session and tried again and see in the trace file the same invalid ALTER SESSION… command as before. Seems like setting the environment variables has no impact.
I’m stumped now - any suggestions ??
I discovered that the ‘locale.default’ value in the ‘servoy.properties’ was whacked. It was set to ‘sq,AL,’ - so I set it to ‘en,US,’ launched Servoy developer then to Edit > Preferences, then to DB Servers, double-clicked my entry, clicked OK and it successfully connected!!
I still can’t get the ‘respository server’ working, however.
When I run Servoy Developer I get a message ‘Can’t setup the repository server specified in the application preferences’. Maybe I need to setup a DB Server entry for ‘repository_server’ ??
Yep, had to setup a ‘repository_server’ - once I did this I was rolling. I had to click on ‘check repository’ to successfully set it up.
I exported my little test app from my Windows PC, ftp’d it to the Solaris system, imported it (setup a DBServer to match first) and ran it successfully.