Skip to Content
0
Former Member
Jun 14, 2005 at 08:36 AM

How to create sequence based (SERIAL) primary key?

24 Views

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?