cannot start ASASERVICE on Win 2000 server

Classic Servoy
1

I have followed all of the instructions in the User Guide perfectly (i hope) and I get this error while trying to start the ASASERVICE:

“D:\Program Files\Servoy\sybase_db\sybase.config is not a valid database file”

the parameter value I used in the Configuration tab for ASASERVICE properties in Sybase Central is
“D:\Program Files\Servoy\sybase_db\sybase.config”
(includes quotes because of the space in Program Files.

If i use just sybase.config the error message is: "Could not open/read database file: sybase_db.

My config fiel looks like this:

-ti 0 -x tcpip{dobroadcast=no} -qs -qw -o sybase_db/sybase_log.txt
D:/Program Files/Servoy/database/servoy_repository.db
D:/Program Files/Servoy/database/user_data.db
D:/Program Files/Servoy/database/example.db
D:/Program Files/Servoy/database/log_data.db
D:/Program Files/Servoy/database/crm.db
D:/Program Files/Servoy/database/eScape_DATA.db
D:/Program Files/Servoy/database/Time_ver6.db

What am I missing?

2

Try this:

-ti 0 -x tcpip{dobroadcast=no} -qs -qw -o "D:/Program Files/sybase_db/sybase_log.txt" 
"D:/Program Files/Servoy/database/servoy_repository.db" 
"D:/Program Files/Servoy/database/user_data.db" 
"D:/Program Files/Servoy/database/example.db" 
"D:/Program Files/Servoy/database/log_data.db" 
"D:/Program Files/Servoy/database/crm.db" 
"D:/Program Files/Servoy/database/eScape_DATA.db" 
"D:/Program Files/Servoy/database/Time_ver6.db"
3

:( No. Same results.

4

Make sure there’s a @ infront of the filename (it looks like the Dev book is wrong on this):

http://forum.servoy.com/viewtopic.php?t … c&start=15

5

Stilll no luck. I tried:

-ti 0 -x tcpip{dobroadcast=no} -qs -qw -o @D:/PROGRA~1/sybase_db/sybase_log.txt
“D:/Program Files/Servoy/database/servoy_repository.db”
“D:/Program Files/Servoy/database/user_data.db”
“D:/Program Files/Servoy/database/example.db”
“D:/Program Files/Servoy/database/log_data.db”
“D:/Program Files/Servoy/database/crm.db”
“D:/Program Files/Servoy/database/eScape_DATA.db”
“D:/Program Files/Servoy/database/Time_ver6.db”

and

-ti 0 -x tcpip{dobroadcast=no} -qs -qw -o @“D:/Program Files/sybase_db/sybase_log.txt”
“D:/Program Files/Servoy/database/servoy_repository.db”
“D:/Program Files/Servoy/database/user_data.db”
“D:/Program Files/Servoy/database/example.db”
“D:/Program Files/Servoy/database/log_data.db”
“D:/Program Files/Servoy/database/crm.db”
“D:/Program Files/Servoy/database/eScape_DATA.db”
“D:/Program Files/Servoy/database/Time_ver6.db”

I don’t get the previous error, but now I get the following error:

Could not start the Adaptive Server Anywhere - ASASERVICE service on Local computer. The service did not return an error. This could be an internal Windows error or an internal service error. If the problem persists contact your system administrator.

:?

6

no, the @ does not go in that section, have a close look at this:

In Sybase Central in File name:

C:\Program Files\Servoy\sybase_db\dbsrv9.exe

(no quotes)
in Parameters (HERE IS WHERE THE @ GOES):

"@C:\Program Files\Servoy\sybase_db\sybase.config"

(INCLUDING the quotes)
change your sybase config file to look like this:

-ti 0 -x tcpip{dobroadcast=no} -qs -qw -o "C:/Program Files/Servoy/sybase_db/sybase_log.txt"
"C:/Program Files/Servoy/database/servoy_repository.db"
"C:/Program Files/Servoy/database/user_data.db"
"C:/Program Files/Servoy/database/example.db"
"C:/Program Files/Servoy/database/log_data.db"
"C:/Program Files/Servoy/database/crm.db"

NOTE: If you run iAnywhere as a service make sure to turn of the Startup launcher so that Servoy doesn’t launch a second copy of iAnywhere. Open Preferences from the edit many and delete the contents of the Startup Launcher field on the Designer tab.
NOTE2: If you create new databases don’t forget to restart the iAnywhere service after adding the new database to the sybase.config file.

7

No again. sybase_log.txt contains the following entries:

E. 07/27 08:49:37. Database cannot be started – “D:\Program Files\Servoy\database\user_data.db” unable to open transaction log
E. 07/27 08:49:37. Database cannot be started – user_data.log not expecting any operations in transaction log
E. 07/27 08:49:37. Database cannot be started – server must be upgraded to start “D:\Program Files\Servoy\database\Time_ver6.db” (capability 32 missing).

8

That is a different problem.
Sybase recently posted 9.0.1 on their website of ASA, Servoy still uses 9.0.0 because 9.0.1 is not available for all platforms. If you use 9.0.1 to create databases you can’t open them with 9.0.0. To fix upgrade all the .exe and .dll files in your sybase_db directory with their equivalents found in: C:\Program Files\Sybase\SQL Anywhere 9\win32

9

jaleman:
NOTE: If you run iAnywhere as a service make sure to turn of the Startup launcher so that Servoy doesn’t launch a second copy of iAnywhere. Open Preferences from the edit many and delete the contents of the Startup Launcher field on the Designer tab.

There is also a nativeStartupLauncher line pointing to dbsrv9.exe in the servoy.properties file. Why is this information in two places? Which takes precedence? Should that line be removed also?

10

Westy:

jaleman:
NOTE: If you run iAnywhere as a service make sure to turn of the Startup launcher so that Servoy doesn’t launch a second copy of iAnywhere. Open Preferences from the edit many and delete the contents of the Startup Launcher field on the Designer tab.

There is also a nativeStartupLauncher line pointing to dbsrv9.exe in the servoy.properties file. Why is this information in two places? Which takes precedence? Should that line be removed also?

The preferences panel writes the servoy.properties file. It is the same thing.

11

jaleman:
The preferences panel writes the servoy.properties file. It is the same thing.

When does it get written? I just tried changing the target application under Edit/Preferences/Designer/Startup launcher from dbsrv9.exe to dbeng9.exe (the personal server). I then exited both Servoy Developer and Sybase. Then I reopened and closed both again and the setting did not change in servoy.properties.

The setting in Edit/Preferences/Designer/Startup launcher did properly open dbeng9.exe, but it did not change the line within servoy.properties to point to dbeng9.exe.

12

Almost there! :)
I back-dated the dll’s and exe’s from sybase directory; but I still get the error. This time the log file contains the following:

I. 07/27 11:08:56. Note: Database file “D:\Program Files\Servoy\database\user_data.db” consists of 3 disk fragments
E. 07/27 11:09:01. Database cannot be started – user_data.log not expecting any operations in transaction log
E. 07/27 11:09:01. Database cannot be started – user_data.log not expecting any operations in transaction log

I’m assuming the first I message is not important, but the other messages appeared in the log before and were not resolved by back dating the dlls and exes.
:?:

13

delete the .log files.

14

Got it! Thanks for your help!