cancel
Showing results for 
Search instead for 
Did you mean: 

Assertion failed: 201200 (16.0.0.1324)

Former Member
4,334

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

Accepted Solutions (1)

Accepted Solutions (1)

VolkerBarth
Contributor

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
0 Kudos

Updated to 16.0.0.2003 and have no problems now. Thanks.

Answers (0)