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
101●1●3●53
accept rate:
10%