Assertion failed: 201200 (16.0.0.1324)

[Former Member]

Hey,

I'm trying to run this statement on a SA16 database:

ALTER TABLE dba.image_type 
ADD lu_pit timestamp DEFAULT current timestamp, 
ADD lu_user varchar(8) DEFAULT '', 
ADD cre_pit timestamp DEFAULT current timestamp, 
ADD cre_user varchar(8) DEFAULT '';


And I get this error:
Could not execute statement.
Internal database error *** ERROR *** Assertion failed: 201200
(16.0.0.1324)
Did not expect to continue row segment -- transaction
rolled back
SQLCODE=-301, ODBC 3 State="HY000"
Line 1, column 1
You can continue executing or stop.


The database was originally a SA9 database, unloaded and reloaded in SA16.
I've ran the Validate Database and it has come up clean.
Interestingly, if I separate the ADD statements it will run without error:
ALTER TABLE dba.image_type ADD lu_pit timestamp DEFAULT current timestamp;
ALTER TABLE dba.image_type ADD lu_user varchar(8) DEFAULT ''; 
ALTER TABLE dba.image_type ADD cre_pit timestamp DEFAULT current timestamp; 
ALTER TABLE dba.image_type ADD cre_user varchar(8) DEFAULT '';


I'm not sure what to do with this now? Any ideas?
Thanks,
Dan

[VolkerBarth · Accepted solution]

Please try the newest EBF/SP - 16.0.0.1324 is the original GA version, and AFAIK, there have been several fixes w.r.t. assertions, cf. this one:

    ================(Build #1982  - Engineering Case #767365)================

    Execution of an ALTER TABLE … ADD with multiple add clauses, each containing 
    a default value, may have caused server assertion failures. This has been 
    fixed.

Note: Access to the current EBFs in the SAP Marketplace will require a SAP support contract, AFAIK.

[Former Member · Accepted solution]

Updated to 16.0.0.2003 and have no problems now. Thanks.