View Incident Report

Serious

Reported By: Chris Erdal
Reported On: 1/16/2007
For: Version 4.25 Build 3

# 2295 Altering a Table and Adding Required Columns Without Default Values Can Cause 9494 Error

I have been re-working my soon-to-be-released database with Context Database Designer, and made the mistake of adding a group of NOT NULL fields to an already-populated table without giving a default value.

Context DBDesigner (quite correctly) supplied the following piece of SQL. But when run this gives the rather inappropriate error:

DBISAM Engine Error # 9494 Too many BLOBs opened in table ‘54280’.

I've added DEFAULT '_' after NOT NULL and all is well.

ALTER TABLE "Locations" 
ADD "locAcc1" CHAR(4) AT 17 NOT NULL,
ADD "locAcc2" CHAR(4) AT 18 NOT NULL,
ADD "locAcc3" CHAR(4) AT 19 NOT NULL,
ADD "locAcc4" CHAR(4) AT 20 NOT NULL;

Resolution

Fixed Problem on 3/25/2007 in version 4.25 build 4

Products Affected

DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap