Question

domain_sys.get_tranlsated_values return different result from primary and standby database


Badge +3

This is IFS9. We have a primary database and standby data with oracle data guard 

We have created custom field called subline and recently added a few additional values in red circle. 

When we ran the following query in following

SELECT domain_sys.get_translated_values('SubLine','en') FROM dual;

The Primary database return the correct value with the 

But the standby database return the old values. 

 

We have checked the database table in both Primary and Standby.  It return the complete set of data value. 

SELECT * FROM CUSTOM_FIELD_ENUM_VALUES WHERE lu='SubLine' ORDER BY seq_no;

 

Any idea?


2 replies

Userlevel 3
Badge +8

Could it be a caching problem on your secondary?

Userlevel 6
Badge +14

Try refreshing all the caches including language cache. Sometimes this could be due to caching issues as above answer mentioned

Reply