Skip to Content
author's profile photo Former Member
Former Member

How to create sequence based (SERIAL) primary key?

Does anybody know any workaround to modify dictionary table outside Web Dynpro?

I specify default column value in SQL Studio:

ALTER TABLE PB_ORGANIZATION COLUMN ORG_ID ADD DEFAULT SERIAL(1)

Everything is OK, but when I try to insert values in modified table from Web Dinpro EJB application I get the error:

com.sap.engine.services.ejb.exceptions.
BaseReliableNoSuchEntityException: The entity does not 
exist in the database. Its value in the cache has to be
refreshed.

It seems WebAS keeps some metadata, generated by Web Dynpro, and manual changes in a database table put it out of sync with this metadata.

I need serial primary keys in my project. Is it possible to solve the above problem?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2005 at 08:40 AM

    Could you please post the SQL query also ! 😊

    Are you getting this error in SQL studio ?

    Regards, Anilkumar

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I'll better send You entire application. It has Web Service frontend (PhoneBook) which can be used for testing. Method createOrganization() throws the exception.

      No, this error appears in EJB application only.

      BTW, I have even made attempt to replace <default-value>0</default-value> by <default-value>SERIAL(1)</default-value> but it didn't help.

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.