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

[qadvietnam]

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

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

And I Can run "mpro" utility also

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

 

[RealHeavyDude]

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.

 

[qadvietnam]

Try, but it get diffirent error msg

 

[Cringer]

That all looks fine to me. What do the DB logs say?

 

[qadvietnam]

That all looks fine to me. What do the DB logs say?

Sorry, which one logs file do you want to see? dbstart or conmgr.properties file?

 

[Cringer]

The logs from the db that you feel is not starting and giving errors.

 

[RealHeavyDude]

Each database has a log file with the extension .lg located in the same folder where your .db file resides. That's what he meant - I guess.

 

[Cringer]

Yep thanks for clarifying RHD.

 

[qadvietnam]

Okie pls wait for me a while, I will update some logs files as you mention

Thanks
QAD Vietnam

 

[qadvietnam]

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

 

[Cringer]

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.

 

[qadvietnam]

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>

 

[Cringer]

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

 

[qadvietnam]

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>

 

[Cringer]

Is it something as simple as needing to put "" around c:\qadapps\db\ha-mfgprod?

 

[qadvietnam]

Is it something as simple as needing to put "" around c:\qadapps\db\ha-mfgprod?

Sorry, I do not understand you means.
Can you advice me clear?
Thanks
QAD Vietnam

 

[Cringer]

Can you try:
c:\mfgpro\Progress\OpenEdge\bin\dbman -start c:\qadapps\db\ha-mfgprod

 

[qadvietnam]

Can you try:
c:\mfgpro\Progress\OpenEdge\bin\dbman -start c:\qadapps\db\ha-mfgprod

Thanks for quick support
The same error msg

 

[Cringer]

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.

 

[qadvietnam]

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>