Question Re: Error "Specified database not found" in Technology Q&A

Error "Specified database not found"

Former Member — Wed, 01 Feb 2012 14:25:18 GMT

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?

Re: Error "Specified database not found"

Former Member — Wed, 01 Feb 2012 14:31:54 GMT

How is the "mobiel-cmp" ODBC DSN defined?

Re: Error "Specified database not found"

regdomaratzki — Wed, 01 Feb 2012 14:37:02 GMT

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

Re: Error "Specified database not found"

johnsmirnios — Wed, 01 Feb 2012 14:42:22 GMT

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.

Re: Error "Specified database not found"

Former Member — Wed, 01 Feb 2012 14:43:13 GMT

It is defined as follows: UID=mobielcmp;PWD=xxx;DBN=Mobiel-CMP;ServerName=Mobiel-CMP;INT=NO

Re: Error "Specified database not found"

regdomaratzki — Wed, 01 Feb 2012 14:54:00 GMT

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.

Re: Error "Specified database not found"

Former Member — Wed, 01 Feb 2012 14:55:33 GMT

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".

Re: Error "Specified database not found"

johnsmirnios — Wed, 01 Feb 2012 15:16:21 GMT

Happy to help. No problem is too small and, besides, you revealed a problem with command line verification.

Re: Error "Specified database not found"

johnsmirnios — Wed, 01 Feb 2012 15:20:21 GMT

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.