on 2014 Sep 10 12:09 PM
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
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
30 | |
9 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.