|
I use the following command to start the consolidated database SQLAnywhere: dbsrv12 -n "Mobiel-CMP" -c "mobiel-cmp.db" It succeeds, the database server is started, showing this: SQL Anywhere Network Server Version 12.0.1.3457 Developer edition, not licensed for deployment. Copyright © 2001-2011, iAnywhere Solutions, Inc. Portions copyright © 1988-2011, Sybase, Inc. All rights reserved. Use of this software is governed by the Sybase License Agreement. Refer to http://www.sybase.com/softwarelicenses. Connection limit (licensed seats): 3 Processors detected: 1 Maximum number of physical processors the server will use: 1 This server is licensed to: Developer Edition Restricted Use Running Windows 2008R2 Build 7601 Service Pack 1 on X86_64 Server built for X86_64 processor architecture 3020K of memory used for caching Minimum cache size: 3020K, maximum cache size: 1883340K Using a maximum page size of 4096 bytes Multiprogramming level: minimum:1, current:20, maximum:80 Automatic tuning of multiprogramming level is enabled Database server started at Wed Feb 01 2012 20:09 Trying to start SharedMemory link ... SharedMemory link started successfully Trying to start TCPIP link ... Starting on port 2638 TCPIP link started successfully Now accepting requests When I start the Mobilink server with the following command: mlsrv12 -c "dsn=mobiel-cmp;uid=xxx;pwd=xxx" -x http(host=109.205.192.234;port=3306) -v -sl java (-cp "c:\Users\yanling.ch_expericom\Desktop\SQLAnywhere db\synchronization scripts" -jrepath "%SQLANY12%\Sun\jre160_x64") I get this error: I. 2012-02-01 20:18:37. This server is licensed to: I. 2012-02-01 20:18:37. Developer Edition I. 2012-02-01 20:18:37. Restricted Use I. 2012-02-01 20:18:37. Running Windows 2008R2 Build 7601 Service Pack 1 on X86_64 I. 2012-02-01 20:18:37. Server built for X86_64 processor architecture I. 2012-02-01 20:18:37. <Main> Option 1: -c I. 2012-02-01 20:18:37. <Main> Option 2: dsn=mobiel-cmp;uid=mobielcmp;pwd=******** I. 2012-02-01 20:18:37. <Main> Option 3: -x I. 2012-02-01 20:18:37. <Main> Option 4: http(host=109.205.192.234;port=3306) I. 2012-02-01 20:18:37. <Main> Option 5: -v I. 2012-02-01 20:18:37. <Main> Option 6: -sl I. 2012-02-01 20:18:37. <Main> Option 7: java I. 2012-02-01 20:18:37. <Main> Option 8: (-cp I. 2012-02-01 20:18:37. <Main> Option 9: c:\Users\yanling.ch_expericom\Desktop\SQLAnywhere db\synchronization scripts I. 2012-02-01 20:18:37. <Main> Option 10: -jrepath I. 2012-02-01 20:18:37. <Main> Option 11: C:\Program Files\SQL Anywhere 12\Sun\jre160_x64 I. 2012-02-01 20:18:37. <Main> Option 12: ) I. 2012-02-01 20:18:37. <Main> Verbose logging: show minimum detail I. 2012-02-01 20:18:37. <Main> Cache size: 52428800 bytes I. 2012-02-01 20:18:37. <Main> Download cache directory size: 10485760 bytes I. 2012-02-01 20:18:37. <Main> Local file for remote synchronization logs: 'mlsrv.mle' I. 2012-02-01 20:18:37. <Main> Individual database connections will be closed after synchronization errors I. 2012-02-01 20:18:37. <Main> Maximum number of BLOB bytes to compare: 4294967295 I. 2012-02-01 20:18:37. <Main> Maximum number of database connections: 5 I. 2012-02-01 20:18:37. <Main> Maximum number of deadlock retries: 10 I. 2012-02-01 20:18:37. <Main> Timeout for inactive database connections: 60 minutes I. 2012-02-01 20:18:37. <Main> Maximum delay between retries after deadlock: 30 seconds I. 2012-02-01 20:18:37. <Main> Rowset size: 10 I. 2012-02-01 20:18:37. <Main> Number of database worker threads: 5 I. 2012-02-01 20:18:37. <Main> Unknown users will be rejected (when there is no authenticate_user script) E. 2012-02-01 20:18:37. <Main> [-10002] Consolidated database server or ODBC error: ODBC: [Sybase][ODBC Driver] [SQL Anywhere]Specified database not found (ODBC State = 08001, Native error code = -83) E. 2012-02-01 20:18:39. <Main> [-10382] The MobiLink Server has failed to start How come the specified database cannot be found? |
|
The -c switch for dbsrv12 expects a numeric parameter (initial cache size) but you provided "mobiel-cmp.db". Notice in your server console log, no database was actually started. Normally, we report an error if you provide a non-numeric argument to '-c' but I think you managed to find an odd case where we don't. I'd hazard a guess that since your string starts with 'm', we think you are trying to start a 0m (zero megabyte) cache and then we default to the bare minimum cache size. Clearly, that should be fixed up but for now just correct your command line and you should be good to go. 1
Can you tell the Russ and I are MobiLink experts and John is a database engine expert? Both Russ and I missed the problem that John likely noticed instantly.
(01 Feb '12, 14:54)
Reg Domaratzki
Replies hidden
Thanks for pointing this out. I don't know what happens to me that I put -c before the database filename :S Now I successfully have started it just simply using: dbsrv12 "mobiel-cmp.db" Thanks and sorry for opening this thread for it's a "little problem".
(01 Feb '12, 14:55)
Yanny
Replies hidden
1
Happy to help. No problem is too small and, besides, you revealed a problem with command line verification.
(01 Feb '12, 15:16)
John Smirnios
Not quite instantly. I missed it at first and my mind went to 'where is the DSN definition?'. It was only while scrolling around looking for the DSN definition that I spotted the curious looking server command line.
(01 Feb '12, 15:20)
John Smirnios
|
How is the "mobiel-cmp" ODBC DSN defined?
Can you post the contents of the mobiel-cmp DSN? The following command line should return the information we are looking for :
If defined as a User DSN :
dbdsn -gu mobiel-cmp
If defined as a System DSN :
dbdsn -gs mobiel-cmp
It is defined as follows: UID=mobielcmp;PWD=xxx;DBN=Mobiel-CMP;ServerName=Mobiel-CMP;INT=NO