Error using api_datasource.importfromfile with filetype XLS

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.

error importfromfile

asked 22 Apr '13, 12:27

Michiel A
516●2●18●52
accept rate: 13%

One Answer:

oldest newest most voted

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 Sand... ♦♦
1.5k●5
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

community wiki

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

learn more about Markdown

Tags:

error ×44
importfromfile ×3