Skip to Content

When Altering table, I receive a 7008, and after that a 7074 when trying open the table afterward.

I need to modify some tables. Simple changes, in one case convert an integer to a date (the last update it got entered wrong. All rows are blank or this field), change an integer to autoinc, or, add some memo columns.

However, after I run the code, via SQL or in ARC, I get a 7008, cannot open table error. After that, the table cannot be opened from the dictionary as I get a 7074, Table ID doesn't match the dictionary. However, I can open the table directly, as if it were a free table now?

How can I fix this? If I need to open a support ticket, my question is how do I open a support ticket?

Edit: Also to note, in an attempt to get the data back in the table, I renamed and free the actual data, then let the table get auto created. I can edit the auto-created table without having problems, but if I put data into the table, then edit, I get this error. (I need to do it after, to preserve autoinc values. Also there is another table that won't play nicely with reinserting because of RI rules.)

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 13, 2019 at 09:40 PM

    I tried to reproduce this with a new data dictionary and new table. I created two columns, both integers, saved, and disconnected. I then reconnected, changed the datatypes to autoinc and date, saved and disconnected again. On connecting a third time, I had no problem accessing the table.

    Can you provide more details? Where you using ADT or DBF tables? Remote or Local connection? Anything else special about the table, like a FTS index or many indexes?

    To open a support case, go to https://launchpad.support.sap.com. You will need to log in with an S-user id, or a name or email address if you have set this up. If you do not have valid credentials, you should contact your Sales Representative, or you could go to https://support.sap.com/en/contact-us/cic.html and click on "Learn More" under User Management. If you don't see what you need, click on "Contact Us" and select "Non-Technical Assistance". From there you can contact the Customer Interaction Center via chat, phone or email.

    Once you have access to the launchpad, you need to create a system. Click on "License Keys". This brings you to "Systems" page. Click on the "+" to create a new system. Under Product, start typing "SAP Advantage Database Server" until the selection shows up. Select this and proceed through the wizard. You will see:

    License keys are not issued here for this product version. The system will be added
    or updated without a license key so that you can use it e.g. to open incidents.

    Fill in the required information and press Generate to create/update the system.

    If you have license key query for this version please open a support incident to component XX-SER-LIKEY.

    Click on the Home button and click on "Report an Incident". You will be required to perform a seach before you can create an incident, although you can request an Expert Chat or Schedule an Expert right away.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.