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

qadvietnam

Member
Hi all,

My env:
- Win7 32bit
- OE 11.2SP1

I have copy a database from "empty" with procopy create utility.
Now i want to start the database. I tried to start the database but i got the error as follows:

"OpenEdge Release 11.2.1 as of Mon Apr 29 00:44:33 EDT 2013
ERROR: Unable to locate database <database> <DBMan005>"

peBsMfQ.png


Now I can start of each DB by:
- proenv>proserve <mfgdatabase>
- proenv>proserve <hlpdatabase>
- proenv>proserve <admdatabase>


And I Can run "mpro" utility also
wh5C8Aa.png


I already search on knowlegebase and know that it related with conmgr.properties file but now I do not know how can I re-config this file.

Could anyone pls help me how can I fix this issue?

Thanks
QAD Vietnam
 
You can either edit the %DLC%\properties\conmgr.properties file manually or use OpenEdge management to do so. The OpenEdge Exploder ( which is a snap-in to the the Microsoft management console does not work on Windows 7 ).

Note: Whenever you edit the file manually, to be sure the changes get picked up by the admin server, I would re-start the admin server.

Heavy Regards, RealHeavyDude.
 
Hi,
below 2 logs file when I start and stop database, if you want to show diffirent pls tell me.

Here is dbstart.log
C:\qdt>REM Script to start database server.

C:\qdt>REM tokens:

C:\qdt>REM &DLC = Progress Directory

C:\qdt>REM &LOOP-DB-START = start of database loop

C:\qdt>REM &LOOP-DB-END = end of database loop

C:\qdt>REM &START-SERVER = command line to start current DB in database loop

C:\qdt>SET DLC=C:\mfgpro\Progress\OpenEdge

C:\qdt>SET PATH=C:\Users\vinhnl\AppData\Local\Temp\pdk-vinhnl-3812\;;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Java\jdk1.6.0_31\bin;C:\mfgpro\tomcat\bin;C:\mfgpro\Progress\OpenEdge\bin;C:\mfgpro\Progress\OpenEdge

C:\qdt>SET PROMSGS=C:\mfgpro\Progress\OpenEdge\promsgs

C:\qdt>SET PROTERMCAP=C:\mfgpro\Progress\OpenEdge\protermcap

C:\qdt>find "ha-qxevent" C:\mfgpro\Progress\OpenEdge\properties\conmgr.properties 1>NUL

C:\qdt>if 1 == 0 call C:\mfgpro\Progress\OpenEdge\bin\dbman -port 20931 -database ha-qxevents -start

C:\qdt>call C:\mfgpro\Progress\OpenEdge\bin\dbman -port 20931 -database ha-mfgprod -start
OpenEdge Release 11.2.1 as of Mon Apr 29 19:26:32 EDT 2013

Database <ha-mfgprod>, configuration <ha-mfgprod> starting...
Database <ha-mfgprod>, configuration <ha-mfgprod> started (DBMan028)

Database <ha-mfgprod> agent: Not Running

Database <ha-mfgprod> auxiliary processes:
AI Writer: Not Running
APW: None running
BI Writer: Not Running
Watchdog: Not Running

OpenEdge Release 11.2.1 as of Mon Apr 29 19:26:32 EDT 2013

Database <ha-admprod>, configuration <ha-admprod> starting...
Database <ha-admprod>, configuration <ha-admprod> started (DBMan028)

Database <ha-admprod> agent: Not Running

Database <ha-admprod> auxiliary processes:
AI Writer: Not Running
APW: None running
BI Writer: Not Running
Watchdog: Not Running

OpenEdge Release 11.2.1 as of Mon Apr 29 19:26:32 EDT 2013

Database <ha-hlpprod>, configuration <ha-hlpprod> starting...
Database <ha-hlpprod>, configuration <ha-hlpprod> started (DBMan028)

Database <ha-hlpprod> agent: Not Running

Database <ha-hlpprod> auxiliary processes:
AI Writer: Not Running
APW: None running
BI Writer: Not Running
Watchdog: Not Running

Press any key to continue . . .


dbstop.log
C:\qdt>REM file: stop.wtp

C:\qdt>REM Script to stop database servers.

C:\qdt>REM tokens:

C:\qdt>REM &DLC = Progress Directory

C:\qdt>REM &LOOP-DB-START = start of database loop

C:\qdt>REM &LOOP-DB-END = end of database loop

C:\qdt>REM &STOP-SERVER = command line to shutdown current DB in database loop

C:\qdt>SET DLC=C:\mfgpro\Progress\OpenEdge

C:\qdt>SET PATH=C:\Users\vinhnl\AppData\Local\Temp\pdk-vinhnl-3812\;;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Java\jdk1.6.0_31\bin;C:\mfgpro\tomcat\bin;C:\mfgpro\Progress\OpenEdge\bin;C:\mfgpro\Progress\OpenEdge

C:\qdt>SET PROMSGS=C:\mfgpro\Progress\OpenEdge\promsgs

C:\qdt>SET PROTERMCAP=C:\mfgpro\Progress\OpenEdge\protermcap

C:\qdt>find "ha-qxevent" C:\mfgpro\Progress\OpenEdge\properties\conmgr.properties 1>NUL

C:\qdt>if 1 == 0 call C:\mfgpro\Progress\OpenEdge\bin\dbman -port 20931 -database ha-qxevents -stop

C:\qdt>call C:\mfgpro\Progress\OpenEdge\bin\dbman -port 20931 -database ha-mfgprod -stop
OpenEdge Release 11.2.1 as of Mon Apr 29 19:26:32 EDT 2013

Database <ha-mfgprod> is not running (DBMan024)


Error Processing Database. Database: ha-mfgprod

OpenEdge Release 11.2.1 as of Mon Apr 29 19:26:32 EDT 2013

Database <ha-admprod> is not running (DBMan024)


Error Processing Database. Database: ha-admprod

OpenEdge Release 11.2.1 as of Mon Apr 29 19:26:32 EDT 2013

Database <ha-hlpprod> is not running (DBMan024)


Error Processing Database. Database: ha-hlpprod
 
Sorry - that's not what I asked for. Which database is not staring properly? Go to the physical location of the database in the file system and get the <dbname>.log from there and look and see what errors are at the bottom of it to explain why the db isn't starting properly.
 
Sorry - that's not what I asked for. Which database is not staring properly? Go to the physical location of the database in the file system and get the <dbname>.log from there and look and see what errors are at the bottom of it to explain why the db isn't starting properly.

Here it is, pls revier for me
proenv>c:\mfgpro\Progress\OpenEdge\bin\dbman c:\qadapps\db\ha-mfgprod -start
OpenEdge Release 11.2.1 as of Mon Apr 29 19:26:32 EDT 2013

ERROR: Unable to locate database <c:\qadapps\db\ha-mfgprod> (DBMan005)

proenv>c:\mfgpro\Progress\OpenEdge\bin\dbman c:\qadapps\db\ha-hlpprod -start
OpenEdge Release 11.2.1 as of Mon Apr 29 19:26:32 EDT 2013

ERROR: Unable to locate database <c:\qadapps\db\ha-hlpprod> (DBMan005)

proenv>c:\mfgpro\Progress\OpenEdge\bin\dbman c:\qadapps\db\ha-admprod -start
OpenEdge Release 11.2.1 as of Mon Apr 29 19:26:32 EDT 2013

ERROR: Unable to locate database <c:\qadapps\db\ha-admprod> (DBMan005)

proenv>
 
This is still not what I am asking for. But it's closer. Is there a database called ha-hlpprod in c:\qadapps\db\ ?
 
This is still not what I am asking for. But it's closer. Is there a database called ha-hlpprod in c:\qadapps\db\ ?

Pls see
proenv>


proenv>dir *.db
Volume in drive C has no label.
Volume Serial Number is 62EA-2D4E

Directory of c:\qadapps\db

01/24/2014 12:57 AM 655,360 admempty.db
01/24/2014 12:24 PM 655,360 admprod.db
01/24/2014 12:23 PM 655,360 ha-admprod.db
01/24/2014 12:23 PM 655,360 ha-hlpprod.db
01/24/2014 12:23 PM 32,768 ha-mfgprod.db
01/24/2014 12:57 AM 655,360 hlpempty.db
01/24/2014 12:24 PM 655,360 hlpprod.db
01/24/2014 12:51 AM 32,768 mfgempty.db
01/24/2014 12:24 PM 32,768 mfgprod.db
01/24/2014 12:56 AM 655,360 srcempty.db
10 File(s) 4,685,824 bytes
0 Dir(s) 22,326,726,656 bytes free

proenv>
 
what about c:\mfgpro\Progress\OpenEdge\bin\dbman -start ha-mfgprod ?

Just remembering that the location of the db should be set in the conmgr.properties so dbman doesn't need it. I use proserve hence my dullness. Sorry.
 
what about c:\mfgpro\Progress\OpenEdge\bin\dbman -start ha-mfgprod ?

Just remembering that the location of the db should be set in the conmgr.properties so dbman doesn't need it. I use proserve hence my dullness. Sorry.

Let try your advices

proenv>
proenv>c:\mfgpro\Progress\OpenEdge\bin\dbman -start ha-mfgprod
OpenEdge Release 11.2.1 as of Mon Apr 29 19:26:32 EDT 2013

Database <ha-mfgprod>, configuration <ha-mfgprod> starting...
ERROR: Database <ha-mfgprod> failed to start (DBMan022)


Error Processing Database. Database: ha-mfgprod

proenv>
 
Back
Top