Database version 10.2B05 to Progress on version 10.2B04

V

vokeeffe

New Member
Hey,

I'm having trouble running a database that was copied from a server running 10.2B05 to another server thats on OpenEdge version 10.2B04.

I get the error Database is the wrong version.

Is there anything i can do to resolve this without upgrading the version of Progress from 10.2B04 to 10.2B05?

The versions are so close that i hoped the DB would just work after the OS copy.

Vinny
 
When do you get the message: When you start the database or when you try to connect with a client?

You should try to avoid an OS copy because then it is solely your responsibility to copy all files of which the database consists - which might not be such an easy task when the database is spread over several file systems and contains a large number of files. Instead I would use probkup and prorest - which might also solve you version compatibility issue.

Heavy Regards, RealHeavyDude.
 
what OS did you copy from and to ? Was it different ?

Another option is you copied the database while it was running and brought over the <dbname>.lk file. You try to access the database and it is not running, but the lk file is causing grief.
 
I got the message a number of times. firstly when i tried to run a prostrct repair on the DB structure file.
 
I'm pretty sure that database was NOT running when i performed the OS Copy. As for the from and to details...

I used FileZilla to copy the Data files from a HP-UX server to a file share on a Windows 2003 server. Then I used fileZilla to put those files onto a Linux RedHat Server (VMware.)

I'm confident that the Database was not running and that i got all of the files (based on looking in the database.st file it seems so anyway)

I've been able to perform this type of crude 'restore' job in the past successfully so it's not totally new territory for me.

The message from the prostrct repair seems to indicate that the version of the Database is to new (wrong version) for Pro (which i take to be the version of progress.) Initially i though they were on the same version but as it happens, the version of OpenEdge on the HP-UX (the source of the data files) is 10.2B05 but the version on Linux RedHat server is only 10.2B04.

would you like more details?

I suppose fundamentally my question is... can data files that were running on 10.2B05 be hosted on a system running 10.2B04... I'm thinking 'no' at this point.

Would it work with a proper probkup command? I haven't got alot of disk space remaining on poor old HP-UX server. Can probkup be set to save backup file to a remote/networked disk? i.e. the Windows File Server i can use.

Regards,
Vinny
 
HP uses a different endian value than windows and linux. We get that error when we forget and copy databases from HP to Linux instead of running a dump and load.

You mention you have used this before - I'm not sure how you have ever copied a database from HP to Linux and got it to work, I could see the database starting if you copied between Linux and Windows, but not HP.
 
Sorry to have mislead... when I've done this in the past it was from Linux to Linux. This is my first time copying from HP-UX.

I never would've figured out without your help. I will test the Dump and load option instead of OS Copy and revert. Thanks for you help.
 
Copying the database or a backup between different OS platforms is not supported. I think there is an open enhancement request that Progress should support platform independent backup files. You can do it and you might even be able to start the database and run the application for a period of time until you will find out that you are hosed (Linux to Windows and vice versa) because of the internal database corruption. I can tell you that because I was hired to solve database issues on a production system and it turned out that the switched platforms from Windows to Linux a year ago and had to find out the hard way that this approach is not supported. In the end they wound up dumping the data from the corrupted database trying to fix all issues that they were aware of - not to speak of the ones they were not aware of at that time and that surfaced over time.

The only supported way to bring a database from one OS platform to another is dump and load, either binary or ASCII.

Heavy Regards, RealHeavyDude.
 
Thanks again RealHeavyDude,

So if do a DB dump from HP-UX (version 10.2B05) and then transfer the file using FileZilla (Binary Mode) to Linux (version 10.2B04) and then load it should work?

I will try and revert.

Vinny
 
You must log in or register to reply here.
Back
Top