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's gravatar image

viswapsp
36111
accept rate: 11%

edited 12 Mar '14, 13:21


The above one is actually a solution as well. Ibrahim helped on it. and Thanks to him.

link

answered 12 Mar '14, 13:21

viswapsp's gravatar image

viswapsp
36111
accept rate: 11%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×2
×1
×1

Asked: 12 Mar '14, 13:17

Seen: 1,137 times

Last updated: 12 Mar '14, 13:21

Related questions


© Copyright Gerger 2017