Tech Tip : nhDiscoverPolicy -import command does not import policies exported by nhDiscoverPolicy -export

Document created by arvind_sugurr Employee on Jul 30, 2015Last modified by SamCreek on Dec 17, 2016
Version 2Show Document
  • View in full screen mode

Product :- ehealth 6.3.2

 

Problem Description

When customer exports policies using nhDiscoverPolicy -export two files are created i.e.

DiscoverPolicy.xml

DiscoverPolicyParams.xml

When we try to import the policies using nhDiscoverPolicy -import command  onto a different server after placing the two files under $NH_HOME/tmp we see the following error.

nhDiscoverPolicy -import

oracle.xml.sql.OracleXMLSQLException: 6-byte UTF8 encoding not supported.

at oracle.xml.sql.dml.OracleXMLSave.saveXML(OracleXMLSave.java:2557)

at oracle.xml.sql.dml.OracleXMLSave.insertXML(OracleXMLSave.java:1497)

at OracleXML.Put_XML(OracleXML.java:483)

at OracleXML.ExecutePutXML(OracleXML.java:398)

at OracleXML.main(OracleXML.java:185)

 

successfully inserted 952 rows into NH_DISCOVER_POLICY_PARAMS

That "successfully" is not correct, the policies wont be imported.

 

Cause

The XML Parser does not support 6-byte UTF8 encoding scheme. It is also possible that invalid UTF8 characters were misinterpreted as 6-byte UTF8 encoding.

 

Solution

a) Open the DiscoverPolicy.xml using a Notepad ++ 

b) Go to Encoding

c) Select Encode in UTF-8

d) Try the Import again you should see

successfully inserted 45 rows into NH_DISCOVER_POLICY

successfully inserted 947 rows into NH_DISCOVER_POLICY_PARAMS

1 person found this helpful

Attachments

    Outcomes