INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Jobs from Indeed

Problem upgrading custom databank under Linux

Problem upgrading custom databank under Linux

(OP)
Hi--

I have some backup databank (.dbf) files from a WinXP MimerSQL 9.3 installation which I am trying to use with MimerSQL 10.1.3A (MimerSQL-10.1.3A-14965.x86_64.rpm) under CentOS 7.3.1611. These backup files were generated under Mimer with commands like:

CREATE BACKUP IN 'logdb.dbf' FOR DATABANK logdb;

I can successfully upgrade the standard databank files: sysdb93.dbf, transdb.dbf, sqldb.dbf, and logdb.dbf using either the automatic upgrade with the Mimer Administrator program under Windows 7 (64-bit), which appears to use sdbgenw.exe under the hood, or with the "sdbgen -u" command under Linux.

The problem comes with an additional user-created databank file. Although I can upgrade it to Mimer 10.1 using the Windows utility, I cannot do so under Linux. The output I get under Linux is:

"
Mimer Database Upgrade
Version 10.1.3A

This program upgrades a Mimer database from version 8, 9, or 10.0 to
version 10.1 format. The Mimer database to upgrade is looked up in the sysdb8,
sysdb9, sysdb92, sysdb93, or sysdb100 file in the appointed directory.

Note! The upgrade is an irreversible process, i.e. after the upgrade the
database can only be used by a version 10.1 database server.

Upgrade of old system databanks for database MyDatabase
Generating Version 10.1 System databank
Creating SYSTEM tables
Move of data from old system databank
Creating INFORMATION_SCHEMA schema
Creating ODBC/JDBC system views
Creating MIMER system views
Creating INFO_SCHEM schema
Creating FIPS_DOCUMENTATION schema
Creating COLLATIONS
Creating GIS user defined types
Upgrade of user databanks
Databank CUSTOM
not upgraded due to MIMER error: -16161
Filename:
custom.dbf
Re-create index tables with descending column
Rebuilding precompiled statements
Creating templates for tables and routines

Upgrade complete
NOTE! Not all databanks upgraded
"

This is a problem because I have a lot of backup databases that I would like to upgrade. I'd like to automate the process under Linux rather than have to click my way through the process under Windows.

Does anyone know what might be going on with this custom backup file that prevents it from upgrading under Linux? The -16161 error seems to be the only clue and unfortunately that does not turn up anything on Google, nor does the general upgrade problem I am having.

Thanks for any help!

Regards

Chris

RE: Problem upgrading custom databank under Linux

The error code -16161 means "Databank disk space exhausted".

RE: Problem upgrading custom databank under Linux

(OP)
JarlH, thank you for your response! That is very helpful.

The machine where I am performing this conversion *does* have limited disk space. Certainly not enough to hold a second copy of the databank file if a temporary copy were made during the conversion. I will try again on a machine with more space and let you know how it goes.

RE: Problem upgrading custom databank under Linux

(OP)
Yup insufficient disk space was the problem. Thanks, JarlH, you are a lifesaver!

RE: Problem upgrading custom databank under Linux

Great to hear that it worked out for you.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close