I am trying to run a build.xml with apache ant. All the targets are runing successfully until dbstop is hit. Whenever the target for dbstop is hit, it hangs. Task Manager shows both dbstop.exe and dbsrv16.exe processes running. However when I hit the same command for dbstop manually, it stops the server successfully. The command for dbstop being used is: dbstop -y -c dsn=<dsn name=""> What can I check to see what is blocking dbstop in the build.xml? asked 17 Jan '17, 04:35 rohinibasuu |
If the user in your data source has no DBA privilege, it can not stop a dbsrv16 with default settings. Check the documentation of the -gk dbsrv16 command line option. HTH answered 20 Jan '17, 12:27 Volker DB-TecKy Hi Volker, The user had dba privileges. When I was using the same dbstop command manually from command line, it was stopping the dbsrv16. If there was some issue with dba privileges, then shouldn't the server return some error messages? However, I uninstalled SQL Anywhere 16 and deleted all the related registry entries. Then again reinstalled SQL Anywhere16 and tried to run the build file. This time it went through. Thanks
(20 Jan '17, 23:33)
rohinibasuu
|
I guess you could add the "LOG=Debug.txt" connection parameter to the connection string in order to find out whether DBSTOP really does connect to the server.
Are you sure the DSN you are using when running DBSTOP manually is the same one in your build process (system DSN vs. user DSN...)?
Yeah, the DSN are the same for both the cases.
Here is the excerpt from the debug file. Shows that dbstop is connecting to the server.
After this, there's no entry in the log file.
Hm, then you might also add the -z option (in addition to -o console.log) to the database server command line to display debug messages on the server side...