Question ERROR: Unable to locate database <database> <DBMan005>

[qadvietnam]

Here is my conmgr.properties file aslo

#
# Connection Manager Properties File
#
%% Merged Juniper Properties File: Jan 24, 2014
%% version 1.1
%% Jan 24, 2014 1:01:43 AM

[configuration.ha-admempty.ha-admempty]
afterimageprocess=false
beforeimagebuffers=25
beforeimagedelaywrites=5
blocksindatabasebuffers=50000
collationtable=basic
database=ha-admempty
displayname=ha-admempty
internalcodepage=utf-8
locktableentries=50000
logcharacterset=utf-8
monitored=false
semaphoresets=20
servergroups=ha-admempty.ha-admempty.qadadm

[configuration.ha-admprod.ha-admprod]
afterimageprocess=false
beforeimagebuffers=25
beforeimagedelaywrites=5
blocksindatabasebuffers=50000
collationtable=basic
database=ha-admprod
displayname=ha-admprod
internalcodepage=utf-8
locktableentries=50000
logcharacterset=utf-8
maxusers=50
monitored=false
semaphoresets=20
servergroups=ha-admprod.ha-admprod.qadadm

[configuration.ha-hlpempty.ha-hlpempty]
afterimageprocess=false
beforeimagebuffers=25
beforeimagedelaywrites=5
blocksindatabasebuffers=50000
collationtable=basic
database=ha-hlpempty
displayname=ha-hlpempty
internalcodepage=utf-8
locktableentries=50000
logcharacterset=utf-8
monitored=false
semaphoresets=20
servergroups=ha-hlpempty.ha-hlpempty.qadhelp

[configuration.ha-hlpprod.ha-hlpprod]
afterimageprocess=false
beforeimagebuffers=25
beforeimagedelaywrites=5
blocksindatabasebuffers=50000
collationtable=basic
database=ha-hlpprod
displayname=ha-hlpprod
internalcodepage=utf-8
locktableentries=50000
logcharacterset=utf-8
monitored=false
semaphoresets=20
servergroups=ha-hlpprod.ha-hlpprod.qadhelp

[configuration.ha-mfgempty.ha-mfgempty]
afterimageprocess=false
beforeimagebuffers=25
beforeimagedelaywrites=5
blocksindatabasebuffers=50000
collationtable=basic
database=ha-mfgempty
displayname=ha-mfgempty
internalcodepage=utf-8
locktableentries=50000
logcharacterset=utf-8
monitored=false
semaphoresets=20
servergroups=ha-mfgempty.ha-mfgempty.qaddb

[configuration.ha-mfgprod.ha-mfgprod]
afterimageprocess=false
beforeimagebuffers=25
beforeimagedelaywrites=5
blocksindatabasebuffers=50000
collationtable=basic
database=ha-mfgprod
displayname=ha-mfgprod
internalcodepage=utf-8
locktableentries=50000
logcharacterset=utf-8
maxusers=50
monitored=false
semaphoresets=20
servergroups=ha-mfgprod.ha-mfgprod.qaddb

[configuration.ha-srcempty.ha-srcempty]
afterimageprocess=false
beforeimagebuffers=25
beforeimagedelaywrites=5
blocksindatabasebuffers=50000
collationtable=basic
database=ha-srcempty
displayname=ha-srcempty
internalcodepage=utf-8
locktableentries=50000
logcharacterset=utf-8
monitored=false
semaphoresets=20
servergroups=ha-srcempty.ha-srcempty.srcode

[configuration.ha-admempty.ha-admempty]
beforeimagebuffers=25
beforeimagedelaywrites=5
blocksindatabasebuffers=50000
collationtable=basic
database=ha-admempty
displayname=ha-admempty
internalcodepage=utf-8
locktableentries=50000
logcharacterset=utf-8
semaphoresets=20
servergroups=ha-admempty.ha-admempty.qadadm

[configuration.ha-hlpempty.ha-hlpempty]
beforeimagebuffers=25
beforeimagedelaywrites=5
blocksindatabasebuffers=50000
collationtable=basic
database=ha-hlpempty
displayname=ha-hlpempty
internalcodepage=utf-8
locktableentries=50000
logcharacterset=utf-8
semaphoresets=20
servergroups=ha-hlpempty.ha-hlpempty.qadhelp

[configuration.ha-mfgempty.ha-mfgempty]
beforeimagebuffers=25
beforeimagedelaywrites=5
blocksindatabasebuffers=50000
collationtable=basic
database=ha-mfgempty
displayname=ha-mfgempty
internalcodepage=utf-8
locktableentries=50000
logcharacterset=utf-8
semaphoresets=20
servergroups=ha-mfgempty.ha-mfgempty.qaddb

[configuration.ha-mfgprod.ha-mfgprod]
beforeimagebuffers=25
beforeimagedelaywrites=5
blocksindatabasebuffers=50000
collationtable=basic
database=ha-mfgprod
displayname=ha-mfgprod
internalcodepage=utf-8
locktableentries=50000
logcharacterset=utf-8
maxusers=50
semaphoresets=20
servergroups=ha-mfgprod.ha-mfgprod.qaddb

[configuration.ha-srcempty.ha-srcempty]
beforeimagebuffers=25
beforeimagedelaywrites=5
blocksindatabasebuffers=50000
collationtable=basic
database=ha-srcempty
displayname=ha-srcempty
internalcodepage=utf-8
locktableentries=50000
logcharacterset=utf-8
semaphoresets=20
servergroups=ha-srcempty.ha-srcempty.srcode

[database.ha-admempty]
autostart=false
configurations=ha-admempty.ha-admempty
databasename=c:\qadapps\db\admempty
defaultconfiguration=ha-admempty.ha-admempty
displayname=ha-admempty

[database.ha-admprod]
autostart=false
configurations=ha-admprod.ha-admprod
databasename=c:\qadapps\db\admprod
defaultconfiguration=ha-admprod.ha-admprod
displayname=ha-admprod

[database.ha-hlpempty]
autostart=false
configurations=ha-hlpempty.ha-hlpempty
databasename=c:\qadapps\db\hlpempty
defaultconfiguration=ha-hlpempty.ha-hlpempty
displayname=ha-hlpempty

[database.ha-hlpprod]
autostart=false
configurations=ha-hlpprod.ha-hlpprod
databasename=c:\qadapps\db\hlpprod
defaultconfiguration=ha-hlpprod.ha-hlpprod
displayname=ha-hlpprod

[database.ha-mfgempty]
autostart=false
configurations=ha-mfgempty.ha-mfgempty
databasename=c:\qadapps\db\mfgempty
defaultconfiguration=ha-mfgempty.ha-mfgempty
displayname=ha-mfgempty

[database.ha-mfgprod]
autostart=false
configurations=ha-mfgprod.ha-mfgprod
databasename=c:\qadapps\db\mfgprod
defaultconfiguration=ha-mfgprod.ha-mfgprod
displayname=ha-mfgprod

[database.ha-srcempty]
autostart=false
configurations=ha-srcempty.ha-srcempty
databasename=c:\qadapps\db\srcempty
defaultconfiguration=ha-srcempty.ha-srcempty
displayname=ha-srcempty

[database.ha-admempty]
configurations=ha-admempty.ha-admempty
databasename=c:\qadapps\db\admempty
defaultconfiguration=ha-admempty.ha-admempty
displayname=ha-admempty

[database.ha-hlpempty]
configurations=ha-hlpempty.ha-hlpempty
databasename=c:\qadapps\db\hlpempty
defaultconfiguration=ha-hlpempty.ha-hlpempty
displayname=ha-hlpempty

[database.ha-mfgempty]
configurations=ha-mfgempty.ha-mfgempty
databasename=c:\qadapps\db\mfgempty
defaultconfiguration=ha-mfgempty.ha-mfgempty
displayname=ha-mfgempty

[database.ha-mfgprod]
configurations=ha-mfgprod.ha-mfgprod
databasename=c:\qadapps\db\mfgprod
defaultconfiguration=ha-mfgprod.ha-mfgprod
displayname=ha-mfgprod

[database.ha-srcempty]
configurations=ha-srcempty.ha-srcempty
databasename=c:\qadapps\db\srcempty
defaultconfiguration=ha-srcempty.ha-srcempty
displayname=ha-srcempty

[environment]

[servergroup.ha-admempty.ha-admempty.qadadm]
configuration=ha-admempty.ha-admempty
displayname=qadadm
networkclientsupport=true
port=0

[servergroup.ha-admprod.ha-admprod.qadadm]
configuration=ha-admprod.ha-admprod
displayname=qadadm
networkclientsupport=true
port=0

[servergroup.ha-hlpempty.ha-hlpempty.qadhelp]
configuration=ha-hlpempty.ha-hlpempty
displayname=qadhelp
networkclientsupport=true
port=0

[servergroup.ha-hlpprod.ha-hlpprod.qadhelp]
configuration=ha-hlpprod.ha-hlpprod
displayname=qadhelp
networkclientsupport=true
port=0

[servergroup.ha-mfgempty.ha-mfgempty.qaddb]
configuration=ha-mfgempty.ha-mfgempty
displayname=qaddb
networkclientsupport=true
port=0

[servergroup.ha-mfgprod.ha-mfgprod.qaddb]
configuration=ha-mfgprod.ha-mfgprod
displayname=qaddb
networkclientsupport=true
port=0

[servergroup.ha-srcempty.ha-srcempty.srcode]
configuration=ha-srcempty.ha-srcempty
displayname=srcode
networkclientsupport=true
port=0

[servergroup.ha-admempty.ha-admempty.qadadm]
configuration=ha-admempty.ha-admempty
displayname=qadadm
networkclientsupport=true
port=0

[servergroup.ha-hlpempty.ha-hlpempty.qadhelp]
configuration=ha-hlpempty.ha-hlpempty
displayname=qadhelp
networkclientsupport=true
port=0

[servergroup.ha-mfgempty.ha-mfgempty.qaddb]
configuration=ha-mfgempty.ha-mfgempty
displayname=qaddb
networkclientsupport=true
port=0

[servergroup.ha-mfgprod.ha-mfgprod.qaddb]
configuration=ha-mfgprod.ha-mfgprod
displayname=qaddb
networkclientsupport=true
port=0

[servergroup.ha-srcempty.ha-srcempty.srcode]
configuration=ha-srcempty.ha-srcempty
displayname=srcode
networkclientsupport=true
port=0
# host=localhost # -H
# initialservers=0 # n/a
# maxclientsperserver=0 # -Ma (calculated value)
# maxdynamicport=0 # -maxport (5000 for NT; 2000 for UNIX)
# messagebuffersize=350 # -Mm (4gl only)
# minclientsperserver=1 # -Mi
# mindynamicport=3000 # -minport (3000 for NT; 1025 for UNIX)
# networkclientsupport=true # false for self-service
# numberofservers=0 # -Mpb
# port=0 # -S ; Must be non-zero
# # when networkclientsupport=true
# prosqltrc=nnnnnnnnnnn # turn on various levels of SQL tracing
# reportinginterval=1 # -rpint (4gl only)
# serverexe=<4gl server location> # _mprosrv (4gl only)
# type=both # n/a

I am still waiting for your expert advice
Thanks
QAD Vietnam

 

[RealHeavyDude]

The error data dbman returns just tells you that the database could not have been started. It does not tell anything as to why it could not have been started.

From my experience I would say that these are the most prominent reasons as to the why:

1. The path to the database is not specified correct in the conmngr.properties: For example, the value for databasename=c:\qadapps\db\mfgprod is invalid.
2. You did not specifiy -S ( IP port or service name ) in the conmngr.properties. That means that you can start the database but it is started without any network capabilities. That means that, even though it started successfully, the admin service ( dbman so to speak ) never knows: Your configuration always show zero for the port. I guess that's the reason.
3. You did specify the port but it is already occupied by another process.

If you really want to know why, you need to have a look in the database log file ( don't confuse dbman with the database, dbman is only a utility to configure, start and stop databases with the admin service - so called managed databases ). The log file of the database resides in the same folder where the .db file resides and has an extension of .lg.

Heavy Regards, RealHeavyDude.