While trying to install SRDEMO on my machine, I have encountered the following
-------------------
All Formspider Objects are not loaded successfully: ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00216: invalid character 195 (0xC3)
Error at line 13999
-------------------
The issue is with something related to character set. On my machine the char set is
NLS_CHARACTERSET US7ASCII
Ibrahim helped me with the solution and I am just pasting that here. (Thanks to him)
Solution Details :
1. I have received a file reload_SRDEMO_application.sql from Ibrahim. Here are its contents.
-----------------
set sqlbl on
/
declare
v_oracleDirectory_tx varchar2(255) := 'F:\Downloads\SRDEMO_Installation_Scripts\SRDEMO_Installation_Scripts';
v_applicationName_tx varchar2(255) := 'SRDEMO';
v_xmlFileName_tx varchar2(255) := 'SRDEMO.xml';
v_cl clob;
v_file bfile;
v_destoffset number:=1;
v_srcoffset number:=1;
v_warning number:=0;
v_context number:=0;
v_objectRecord_tt bdf_etl.tt_importObjects;
begin
bdf_application_api.applicationdelete(in_application_oid=>bdf_application_qry.getid(v_applicationName_tx), in_cascade_yn=>'Y');
dbms_lob.createtemporary(v_cl,true);
v_file := BFILENAME(v_oracleDirectory_tx, v_xmlFileName_tx);
dbms_lob.open(v_file, dbms_lob.lob_readonly);
dbms_lob.loadclobfromfile(v_cl, v_file, DBMS_LOB.LOBMAXSIZE , v_destoffset, v_srcoffset, nls_charset_id('AL32UTF8'), v_context, v_warning);
dbms_lob.close(v_file);
bdf_etl.load(in_bdf_xml=>xmltype(v_cl),
in_importOption_cd =>'AsNewApplication',
in_projectOption_cd=>bdf_constant_etl.etlcreateOrReplace,
in_applicationOption_cd=>bdf_constant_etl.etlcreateOrReplace,
in_importObjects_tt=>v_objectRecord_tt);
commit;
end;
/
a. On the Oracle Server machine I have created a directory "/opt/home/oracle/srdemo" and copied the files to this directory namely - reload_SRDEMO_application.sql, and SRDEMO.xml
b. Modified below line in the SQL file to match "OracleDirectory" that I am going to create in the next steps.
v_oracleDirectory_tx varchar2(255) := 'DIR_TEMP1';
c. On the server change to that directory
cd /opt/home/oracle/srdemo
d. Login to SQLPlus on the Oracle server with an account that has DBA credentials.
e. Created an "oracle directory" called DIR_TEMP1
CREATE OR REPLACE DIRECTORY DIR_TEMP1 AS '/opt/home/oracle/srdemo';
f. GRANT ALL ON DIRECTORY DIR_TEMP1 TO PUBLIC;
g. ALTER SESSION SET CURRENT_SCHEMA=formspider;
h. Executed the sql script
SQL> @reload_SRDEMO_application.sql
Now I see the application SRDEMO available from the Formspider tool. :)
i. dropped the temporary oracle_directory.
SQL> drop directory dir_temp1;
j. dropped the two files from the server
rm reload_SRDEMO_application.sql SRDEMO.xml
asked
12 Mar '14, 13:17
viswapsp
36●1●4●17
accept rate:
11%