Hi formspider team,

I was trying to install formspider on Oracle database express edition and I am getting the following success message in the installion log almost at the end. I am installing it on ubuntu 64 bit:

20:59:29 INFO        - Recompiling FORMSPIDER181
20:59:39 INFO        - Recompile completed
20:59:39 INFO        - IDE Server is succesfully installed
20:59:39 INFO        - ----------------------------------
20:59:39 INFO        - Tomcat Version: Apache Tomcat/6.0.29
20:59:39 INFO        - Started deploying formspider
20:59:39 INFO        - Started building deployment file in temp directory
20:59:40 INFO        - Extracting Formspider Middletier application 
20:59:40 INFO        - Configuring context file
20:59:40 INFO        - Engine resource name is formspider_ds
20:59:41 INFO        - Initializing war task
20:59:41 INFO        - War destination is "/tmp/Formspider3476646990748504945tmp/formspider.war"
20:59:44 INFO        - Deployment file is succesfully built.
20:59:44 INFO        - Initializing deploy task
20:59:44 INFO        - Tomcat manager URL is "http://localhost:8081/manager"
20:59:44 INFO        - Deployment path is "/formspider"
20:59:44 INFO        - War path is "/tmp/Formspider3476646990748504945tmp/formspider.war"
20:59:46 INFO        - formspider is succesfully deployed

However, when I import srdemo and run it I get the following error:

ORA-01435: user does not exist
ORA-06550: line 2, column 3:
PLS-00201: identifier 'SRDEMO.BDF_SCRIPTEXECUTER' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

On further checking the installation log I found the following error:

20:52:40 INFO - /tmp/Formspider3476646990748504945tmp/engine_db/view.sql 20:52:45 INFO - Schema FORMSPIDER181 has 92 invalid objects:

and again :

20:55:09 INFO        - Checking errors
20:55:09 INFO        - Checking errors completed
20:55:09 INFO        - Started registring XSD
20:55:41 WARN        - Can not complete registring XSD: ORA-31084: error while creating table "FORMSPIDER181"."root1351_TAB" for element "root"
ORA-02320: failure in creating storage table for nested table column "XMLDATA"."panel"."xyLayout"."cell"
ORA-01792: maximum number of columns in a table or view is 1000
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 72
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 33
ORA-06512: at line 1

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

Please let me know how can I solve this. I would like to test formspider on Oracle xe.

With regards.

George

asked 27 Dec '14, 12:30

grajan777's gravatar image

grajan777
1011231
accept rate: 10%


Hi George,

The XSD registration issue is a problem which can be ignored. If there is not an invalid object in your Formspider schema, you should be able to use Formspider despite this problem.

The problem seems to be related with your SRDEMO installation. Please drop the entire SRDEMO schema and retry to create it using the scripts.

If the problem continues, we will investigate it further.

Best Regards,
Ibrahim

link

answered 29 Dec '14, 09:58

Ibrahim%20Sandalli's gravatar image

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

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:

×15
×2

Asked: 27 Dec '14, 12:30

Seen: 1,316 times

Last updated: 29 Dec '14, 09:58


© Copyright Gerger 2017