Jan’s instructions from the Apr 13, 2004 8:19 pm post fixed it for me. When I restart my PC Sybase Adaptive Server Anywhere now automatically runs as a Service and serves my Servoy files. The Client from a guest PC now opens my solution in 10 seconds. Very nice!
The first time I tried the latest instructions, I thought they were not going to work. I had gone right by that first path that the wizard automatically enters thinking it was the same as the one provided by Jan. Of course it was not. Once I fixed that it worked fine. My only remaining question is how to set the dependency within the Servoy Application Server Service so that it is dependent upon the Sybase ASA Service starting first. That option appears to always be grayed out so I cannot change it. In my case it does not seem to matter because the Sybase ASA Service starts first anyway. However, I would still like to know how to set that dependency.
One other question, what does “Allow service to interact with desktop” mean? I left it checked, but I am not sure why. Oops, never mind. I just found the answer in the Help file. It states: “Select this option if you want to display the server window by clicking an icon on your desktop.” I assume this just means a shortcut to the Windows “Services”, for which I had already placed a shortcut on my desktop. The wizard does not appear to have placed any other icon on my desktop.
Only if I want to make a service from Sybase Central, this goes wrong!
De services is made and when I run it (under services) I get the the error.
This appears to be a problem on some Windows 2000 Server installations where the operating system gets confused by it’s own spaces in filenames. (Did you know Microsoft has a patent on long filenames and still they can’t make it work right?). For those having problems use the short filenames with no spaces. For example:
Westy:
One other question, what does “Allow service to interact with desktop” mean? I left it checked, but I am not sure why. Oops, never mind. I just found the answer in the Help file. It states: “Select this option if you want to display the server window by clicking an icon on your desktop.” I assume this just means a shortcut to the Windows “Services”, for which I had already placed a shortcut on my desktop. The wizard does not appear to have placed any other icon on my desktop.
I think they reference to the icon in the Taskbar.
Following the above instructions I have Sybase running as a Service. However, the installation did not have Servoy running as a service, so I reinstalled using the servoy_installer.jar by checking the pack to install as a service and unchecking all the other packs.
Now when I try to open Servoy as a service I get a “Error: 1067 The process terminated unexpectedly.”
With regard to running Servoy as a service, I should have mentioned that our installation is to a directory other than Servoy.
Does this mean we need to add a parameter to the Servoy service, like we had to do for the Sybase service? If so, what is the syntax for such a parameter?
Westy:
Following the above instructions I have Sybase running as a Service. However, the installation did not have Servoy running as a service, so I reinstalled using the servoy_installer.jar by checking the pack to install as a service and unchecking all the other packs.
Now when I try to open Servoy as a service I get a “Error: 1067 The process terminated unexpectedly.”
What could be causing this error?
I’ve seen that error if you have older versions of Java installed on the same machine. Can you try removing all Java versions and installing a clean JDK 1.4.2 ?
We just tried installing j2sdk-1_4_2_03-windows-i586-p.exe on another local PC in or office and are getting the same error.
When I go to java.sun.com I see that they show a download named “J2SE_v_1.4.2_04_SDK with Netbeans 3.6 Bundle”. Should we have our customer download that version?
Also, how can I unstall the Servoy Application Server Service without uninstalling everything else. I tried double-clicking the uninstall_windows_service.bat file that is located in the Service folder, but that does not appear to do anything.
Do not use the netbeans bundle, it doesn’t work properly (we also state this on our download page).
Here’s what our docs say about uninstalling the service:
(Servoy Server manual page 85)
C:\Program Files\Servoy\service\Wrapper.exe -r C:\Program
Files\Servoy\service\wrapper.conf
What do you get if you type java -version on a command prompt?
Providence1:
Can the proper procedures listed in this thread, along with trouble shooting tips, be listed in the Servoy Server manual?
PLEASE!
The information posted in this thread is included in both the current
printed editions of the Servoy Application Server Administrator’s Guide
and the Servoy Developer Edition Volume 1: User’s Guide; the Online
Help Navigator; and the corresponding downloadable PDF files.
Servoy Application Server Administrator’s Guide
Installing a Database as a Service pages 31 - 46
Servoy Developer Edition Volume 1: User’s Guide
Installing a Database as a Service pages 463 - 478
Online Help Navigator
-Open Servoy Developer.
-Choose Help > Help (F1).
-Open the Search tab (Click once).
-Type “service” in the search criteria box.
-Doubleclick on the desired topic from the Topics list below.
Downloadable PDF file
-Open the appropriate PDF file.
-Choose Edit > Search (or press the Search tool in the toolbar).
-Type “service” in the search criteria box.
-Press the “Search” button.
-Click once on the desired item from the Search Results list.
Adaptive Server Anywhere 9.0.2.2451
Windows XP Service Pack 2
Java 1.5.0_10-b03
Sybase Central - Asaservice start:
It appears the window “Adaptive Server Anywhere Network Database Server Usage”, close window.
It appears the window “Sybase Central”: The service ‘ASASERVICE’ has generated an unknown error.
Sybase central:
Configuration: C:\Archivos de programa\Servoy\sybase_db\dbsrv9.exe
Parameters: @C:\Archivos de programa\Servoy\sybase_db\sybase.config
sybase.config:
-ti 0 -x tcpip{dobroadcast=no} -qs -qw -o “C:/Archivos de programa/Servoy/sybase_db/sybase_log.txt”
“C:/Archivos de programa/Servoy/database/servoy_repository.db”
“C:/Archivos de programa/Servoy/database/user_data.db”
“C:/Archivos de programa/Servoy/database/example.db”
“C:/Archivos de programa/Servoy/database/log_data.db”
“C:/Archivos de programa/Servoy/database/udm.db”
“C:/Archivos de programa/Servoy/database/pdf_forms.db”
I. 12/01 19:32:46. Running on Windows XP Build 2600 Service Pack 2
I. 12/01 19:32:48. Performance warning: Database file “C:\Archivos de programa\Servoy\database\example.db” consists of 117 disk fragments
I. 12/01 19:32:48. Performance warning: Database file “C:\Archivos de programa\Servoy\database\udm.db” consists of 4 disk fragments
I. 12/01 19:32:48. Performance warning: Database file “C:\Archivos de programa\Servoy\database\servoy_repository.db” consists of 3 disk fragments
I. 12/01 19:32:48. Performance warning: Database file “C:\Archivos de programa\Servoy\database\log_data.db” consists of 3 disk fragments
I. 12/01 19:32:56. Database server started at Fri Dec 01 2006 19:32
I. 12/01 19:32:56. Trying to start SharedMemory link …
I. 12/01 19:32:56. SharedMemory link started successfully
I. 12/01 19:32:56. Trying to start TCPIP link …
I. 12/01 19:32:56. Starting on port 2638
I. 12/01 19:32:57. TCPIP link started successfully
I. 12/01 19:32:57. Now accepting requests
I. 12/01 19:38:44. Connection terminated abnormally; client socket shut down
I. 12/01 19:42:37. Connection terminated abnormally; client socket shut down
I. 12/01 19:50:55. Connection terminated abnormally; client socket shut down
I. 12/01 19:54:13. Connection terminated abnormally; client socket shut down
I. 12/01 21:15:02. Running on Windows XP Build 2600 Service Pack 2
I. 12/01 21:15:04. Performance warning: Database file “C:\Archivos de programa\Servoy\database\example.db” consists of 117 disk fragments
I. 12/01 21:15:04. Performance warning: Database file “C:\Archivos de programa\Servoy\database\udm.db” consists of 4 disk fragments
I. 12/01 21:15:04. Performance warning: Database file “C:\Archivos de programa\Servoy\database\servoy_repository.db” consists of 12 disk fragments
I. 12/01 21:15:04. Performance warning: Database file “C:\Archivos de programa\Servoy\database\log_data.db” consists of 3 disk fragments
I. 12/01 21:15:04. Performance warning: Database file “C:\Archivos de programa\Servoy\database\pdf_forms.db” consists of 4 disk fragments
I. 12/01 21:15:15. Database server started at Fri Dec 01 2006 21:15
I. 12/01 21:15:15. Trying to start SharedMemory link …
I. 12/01 21:15:15. SharedMemory link started successfully
I. 12/01 21:15:15. Trying to start TCPIP link …
I. 12/01 21:15:16. Starting on port 2638
I. 12/01 21:15:16. TCPIP link started successfully
I. 12/01 21:15:16. Now accepting requests
I. 12/01 21:20:01. Connection terminated abnormally; client socket shut down
02/12/2006 13:06:15 ASA9.0 ASANYs_ASASERVICE: Could not start server
02/12/2006 13:06:13 ASA9.0 ASANYs_ASASERVICE: Service able to access Desktop
02/12/2006 13:06:13 ASA9.0 ASANYs_ASASERVICE: Starting service ASASNYs_ASASERVICE
In case it can help, before it had formed it with Mysql as repository and had worked well. Java, Servoy and SYBASE have become to install, MySQL has not been desintall
suggests that there is something going on at the O.S. or
network level that’s forcing the socket closed. My bet is
that the Sybse SQL Anywhere database is not closing
these sockets.
I wonder if there are any permissions/account differences
with respect to the MySQL service and the Sybase
SQL Anywhere service?!
Are you able to start the database and connect to it by
starting it from the command line?