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

asked 10 Sep '14, 11:09

hurricane766's gravatar image

hurricane766
21113
accept rate: 0%


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.

permanent link

answered 10 Sep '14, 11:20

Volker%20Barth's gravatar image

Volker Barth
30.6k305455662
accept rate: 32%

edited 10 Sep '14, 11:50

Updated to 16.0.0.2003 and have no problems now. Thanks.

(11 Sep '14, 13:45) hurricane766
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×201
×31
×7

question asked: 10 Sep '14, 11:09

question was seen: 1,739 times

last updated: 11 Sep '14, 13:45