Database copy.Error Database cannot be opened. (598)

laugue

New Member
Hi,

OS : HPUX 10.20
Database : Progress 7.3E16

I have created a new empty mfgpro test database with the following description file :

d /mfgdata/mfgt/mfgt.d1 f 500000
d /mfgdata/mfgt/mfgt.d2 f 500000
d /mfgdata/mfgt/mfgt.d3 f 500000
d /mfgdata/mfgt/mfgt.d4 f 500000
d /mfgdata/mfgt/mfgt.d5 f 500000
d /mfgdata/mfgt/mfgt.d6 f 500000
d /mfgdata/mfgt/mfgt.d7 f 500000
d /mfgdata/mfgt/mfgt.d8 f 500000
d /mfgdata/mfgt/mfgt.d9 f 500000
d /mfgdata/mfgt/mfgt.d10 f 500000
d /mfgdata/mfgt/mfgt.d11 f 500000
d /mfgdata/mfgt/mfgt.d12 f 500000
d /mfgdata/mfgt/mfgt.d13 f 500000
d /mfgdata/mfgt/mfgt.d14 f 500000
d /mfgdata/mfgt/mfgt.d15 f 500000
d /mfgdata/mfgt/mfgt.d16 f 500000
d /mfgdata/mfgt/mfgt.d17 f 500000
d /mfgdata/mfgt/mfgt.d18 f 500000
d /mfgdata/mfgt/mfgt.d19
b /mfgdata/mfgt/mfgt.b1 f 200000
b /mfgdata/mfgt/mfgt.b2

mfgt folder is a link in /mfgdata :

/mfgdata#ll
total 12
lrwxrwxrwx 1 root sys 11 Oct 23 2001 leam -> /disk1/leam
lrwxrwxrwx 1 root sys 12 Oct 12 2001 leat -> /disk11/leat
lrwxrwxrwx 1 root sys 11 Oct 23 2001 mfgm -> /disk2/mfgm
lrwxrwxrwx 1 root sys 12 Oct 12 2001 mfgt -> /disk11/mfgt
lrwxrwxrwx 1 root sys 11 Oct 23 2001 smem -> /disk1/smem
lrwxrwxrwx 1 root sys 12 Oct 12 2001 smet -> /disk11/smet

When I try to make a copy of the production mfgpro database (mfgm) to the test database with the following command :

procopy /mfgdata/mfgm/mfgm /mfgdata/mfgt/mfgt


I have got this message :

/mfgdata/mfgt/mfgt.db is a copy of /disk11/mfgt/mfgt.db. Database cannot be opened. (598)

Can someone help me. Thanks.

Laurent.
 

RealHeavyDude

Well-Known Member
The error message is indicating that

  • either the structure description which is stored in binary form in the .db file of the source database is not correct
  • or you probably are working with symbolic links.
Did you check that you can open the source database?

Regards, RealHeavyDude.
 

RealHeavyDude

Well-Known Member
As far as I can see, the problem is because you did not specify the absolute path in the procopy operation. You need to specify the absolute path, that means /mfgdata is a symbol which points to /disk11.

Symbols and links are not supported for procopy operations and in general you should avoid them when administering the database.

HTH, RealHeavyDude.
 

RealHeavyDude

Well-Known Member
The .db file of the database contains the structure information in binary form which is used by everything that accesses the database to get a hold on all files of which the database consists. Additionally, when you create a database usually you would use a structure description file in ascii format. This file is just used to update/maintain/repair the structure information in the .db file.

That means: If you move one or more files that belong to the database to different locations with OS commands then the structure information in the .db file is not valid anymore. Therefore you need to correct, repair it. The only way you can do this is to have a correct structure description file in ascii form at hand and use it with prostrct repair.

BTW, from the questions you ask I'll take it that you would greatly benefit in taking a training or hire a experienced consultant to help you. I think Tom will be happy to make you an offer. Just kidding, of course.

Heavy Regards, RealHeavyDude.
 

laugue

New Member
Thanks a lot for your explanation.
The problem was with the prorepair command.
I have typed the following command : prostrct repair /mfgdata/mfgt/mfgt /mfgdata/mfgt/mfgt.st (with full path of the test database)

Now it works. I can work with my new test database.

Bye.

Thanks.

Laurent.
 
Top