How to flush the cache after modifying Data Dictionnary

wperaud

Hello,

I would like to know how to flush cache after making changes into the Data Dictionnary :

Ex :

- dm_document -> keywords : the text_label is "Keywords" (for nls_key = 'en')

- I look properties of a document and the label for the keywords is "Keywords"

- I run a DQL query, to set the text_label to "Keywords test"

ALTER TYPE dm_document MODIFY keywords (SET label_text = 'Keywords test') PUBLISH;

- Everything works fine, when I look into the dmi_dd_attr_info table

- On the screen, when I look on a document properties, the label is still "Keywords".

I have to restart my web server in order to see my changes.

Could anyone help me please ?

I've seen methods for the IDFSession class (flush, flushGlobalCache, etc.)

Is it a good way ?

Another question, about one of these methods : what is the server global cache ? (how to find its name ?)

I'm using :

Documentum 6.5

Tomcat 5.5

DFC

Java

Thank

Find more posts tagged with

Comments

DCTM_Guru

Using DA (or IAPI utility), execute the following API:

publish_dd,c (flush entire cache)

publish_dd,c,,dm_document (flush cache for dm_document type, there is extra comma after c for the locale)

wperaud

Thank you, but, is there a way to do so within the code ? (in java)

liaojiyong

IDfSession.publishDataDictionary(String locale,
        String typeName,
        String attributeName,
        boolean forcePublish)

wperaud

Than you.

Sorry but, as I'm a beginner... I wonder what is the difference between this way (idfSession.publish...) and the key word PUBLISH in the DQL query.

liaojiyong

In DQL Query PUBLISH publish dd immediately

and IDfSession.publishDataDictionary also publish dd immediately

different is dql publish dd is depend on the session's dd_locale ,

IDfSession.publishDataDictionary give your more options

wperaud

Thank you again

I made my application work.... almost...

Here is how I make it :

 iDfSession.getSessionConfig();IDfTypedObject conf = // Set the localization of the sessionlanguage = "en";conf.setString("// Build the query to update an object ----------// -- like ALTER TYPE objectType MODIFY keywords (SET label_text = 'Keywords test') PUBLISH; // Execute the query ----------------------------------  iDfSession.flush("ddcache", objectType);
session_locale", language);   objectType = "dm_document";

When I run this code (within a servlet), everything is fine... the first time.

Label text when I right-click > Properties on a document is updated with the right value.

But, when I run this, twice (or more), with a different label_text value, the value is updated into the dmi_dd_attr_info table, but at the screen (right click > properties ) The value is the old one (the one frome the first update), as if the flush didn't happen.

From time to time, when I keep trying executing this code, an error occures :

[DM_DATA_DICT_F_STORE_OVERRIDE_FAILED]fatal:  "Could not set the override_id while updating type dm_document."

I don't know where that could come from :

- no enought time for the server to flush the cache ? (I tried waiting a few minutes before retrying any DD change... )

- any IDFSession behavior I'm not

So I thought that using a transaction could be a good thing, but when I do so, an error occures :

[DM_DATA_DICT_E_COMMIT_EXTERNAL_TRANSACTION]error:

I look for a solution, and found this one :

http://www.dmdeveloper.com/articles/programming/messages/dmddict.e.html#head110

So I know I can't use transaction.

I'm really lost with the flush cache behavior

liaojiyong

at the screen (right click > properties ) The value is the old one-----

---

when you flush,you just flush dd from current session

and

on the screen app ,the session is not flush,so....

you should logout , and login again,

of course ,if you restart the app, the session is refresh

wperaud

Thank you again

I understand what you mean. It's logic since I use an iDfSession

But, this souldn't work at all, should it ?

Every first time, it works :

- I open a windows,

- check the properties (right-click > properties) (( ex : label_text = "test" ))

- close only the properties form

- run my code in order to update the DD (( ALTER value label_text = "test 2", PUBLISH and Flush))

- right-click > properties : everything is OK (( ex : label_text = "test 2 " ))

- close only the properties form

- run my code in order to update the DD (( ALTER value label_text = "test 3", PUBLISH and Flush))

- right-click > properties : everything is not OK (( ex : label_text = "test 3" into the dmi_dd_attr_info

at the screen : label_text = "test 2 " ))

I'm really curious about the fact that, it works the first time I update the attr info.

I also tried running my code a few times in order to make the DM_DATA_DICT_F_STORE_OVERRIDE_FAILED error occure.

When this happends, the next updating works, even at the screen.

How this error inpact the sessions ?

Because, when this error occures, people are not disconnected. And without having to logout and login again, they can see changes.

Is there a way to warn sessions to flush ? or something like that ?

lastnitescurry

I am curious... what is the feature you are trying to achieve? ... assuming you get past the data dictionary cache update problem... which I am 90% sure is not possible as this is how it is designed to work...

there maybe another way to achieve your requirement