Kbase P133582: OpenEdge Management dbmigrate script fails when migrating a large trend database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/24/2008 |
|
Status: Unverified
SYMPTOM(s):
OpenEdge Management dbmigrate script fails when migrating a large trend database.
The system cannot find the path specified.
Error restoring the database d:\31abackup into d:\tmp\tempdb: 1.
Error restoring the database <backup_file> into <restore_dir>: <Ret_code>.
FACT(s) (Environment):
Running the dbmigrate script.
All Supported Operating Systems
Fathom Management 3.x
CAUSE:
Bug# OE00172193
CAUSE:
The dbmigrate script restores a backup of the original database into a previously created empty directory. This is good, however there is no way to provide a database structure file to the prorest command. Therefore if a database extent hits 2gb when restoring then the dbmigrate utility will fail.
The dbmigrate script also checks to ensure that the directory to restore into is empty prior to restoring, if it's not then the dbmigrate script intentionally stops. Because of this you can't just place an st file into the directory where the database is restored to.
FIX:
Workaround steps:
1. Edit the <fathom_install>\perl\scripts\dbmigrate.pl file and remove or comment-out the section that checks that the directories are empty. This section is titled:
#
# Check that the DUMP_FILES_WRKDIR and the SOURCE_DBWRKDIR are empty as they should be.
#
2. Create a database structure file and call it fathom31a.st. Place it into the empty directory that you specify during the dbmigrate script. Make sure that the structure file contents contain the correct paths to this empty directory and has an appropriate structure. Maybe copy it from your 3.1A trend database and change the paths within.
3. Although not part of fixing this specific problem, another step that you will likely encounter is that the index rebuild will fail if the index sort file hits 2gb. Therefore you should create a multi-volume sort file for index rebuilds. This file should be placed into the new 3.1C trend database directory with the name fathom.srt. This is because an index rebuild is automatically run after the binary dump files have been loaded.