Rosetta SP 8.1./HF 8.0.0.2. Parameters Related to Handling of CDATA in Descriptive and DNX Fields

Question

What are the configuration changes we need to do in Rosetta version 8.0.0.2/8.1 to start using new CDATA in Dublin core fields handling method? 

Answer

After installation of Service pack 8.1 or HotFix 8.0.0.2 do following:

1. make sure that the hidden general parameter strip_cdata_from_dc is set to false

• Check: from dps user 

sqlplus ${ORA_USER_PREFIX}ROS00/`get_ora_passwd ${ORA_USER_PREFIX}ROS00` << EOF select value from hfrgeneralparameter where name = 'strip_cdata_from_dc'; EOF

• Update: from dps user create update_gp.csh  and run by csh -f update_gp.csh

#!/bin/csh
sqlplus ${ORA_USER_PREFIX}ROS00/`get_ora_passwd ${ORA_USER_PREFIX}ROS00` << EOF
update hfrgeneralparameter set value = 'false' where name = 'strip_cdata_from_dc';
commit;
EOF
 

2. make sure that the new UI general parameter is set to true 

• Administration / General Parameters / general 

• Article last edited: 08-Jan-2024