Hi Formspider team,

I get the following error when using api_datasource.importfromfile trying to import an XLS file:

ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275 ORA-06512: at "SYS.DBMS_LOB", line 533 ORA-06512: at "FSR_SYS.BDF_DBOBJECTACCESS_MNG", line 5052 ORA-29540: class ConvertExcelToDataXML does not exist

The procedure i had used to work prior to 1.3.

Any idea what is causing this?

Thanks, Michiel A.

asked 22 Apr '13, 12:27

Michiel%20A's gravatar image

Michiel A
5161541
accept rate: 13%


Hi Michiel,

This error occurs since some java files used during XLS import are not loaded in your database. It seems like there is an error in our v1.3 installer regarding this issue, we will fix it as soon as possible.

In the meantime, you can download necessary jar and class files from the following link and load them manually: http://theformspider.com/download/poi.zip

To load:

  • Extract the downloaded "poi.zip" file into a directory of your choice (e.g. "C:\poi").
  • Execute the following command from the OS command line to load the "poi-3.2-FINAL-20081019.jar" file:
    loadjava -user [dbuser]/[password] -resolve "C:\poi\poi-3.2-FINAL-20081019.jar"
    Here, you have to use the name of the formspider schema (which is "formspider" by default) and its password as the [dbuser] and [password] values.
  • Execute the same command for the "ConvertExcelToDataXML.class" file:
    loadjava -user [dbuser]/[password] -resolve "C:\poi\ConvertExcelToDataXML.class"

Hope this helps,
Ibrahim

link

answered 24 Apr '13, 06:37

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5
accept rate: 25%

Thanks, it is working again.

Michiel

(24 Apr '13, 08:21) Michiel A

This problem is fixed in version 1.3.2

Best,
Ibrahim

(02 May '13, 10:37) Ibrahim Sand... ♦♦
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:

×43
×3

Asked: 22 Apr '13, 12:27

Seen: 1,220 times

Last updated: 02 May '13, 10:37


© Copyright Gerger 2017