Hi Team, I have just done the first install of FormSpider using a Virtual Windows 7 Ultimate machine running Oracle 11gXE. The first installation run to completed and reported no errors; however, once completed I could not log into anything, not the IDE or the TomCat Admin page. I thought I did something wrong so I uninstalled and re-installed; this time during the installation when it asks you for the Formspider schema password and tablespace name it popped up a warning saying the SYSTEM tablespace did not have enough room left it in and that the install may fail; I let the install run and again no errors were reported but just like the first installation I was not able to log into anything. Does the installation create any objects that are owned by SYS that are left behind when you do the uninstall? Do you know of any reason why I would not be able to log into anything once complete? Note: On the first installation I used the standard XE tablespace called USERS, for the 2nd install I created a 500mb tablespace called FORMSPIDER. Many thanks, Craig. |
I did find the following in the installation log... 14:58:06 WARN - Can not complete registring XSD: ORA-31084: error while creating table "FORMSPIDER"."root1252_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-02310: exceeded maximum number of allowable columns in table 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) oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204) oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1034) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685) oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4694) oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1088) com.bui.installer.tasks.EngineInstallTask.registerXsd(EngineInstallTask.java:199) com.bui.installer.tasks.EngineInstallTask.installEngine(EngineInstallTask.java:154) com.bui.installer.tasks.EngineInstallTask.execute(EngineInstallTask.java:77) com.bui.installer.gui.panels.InstallationPanel$3.doInBackground(InstallationPanel.java:194) org.jdesktop.swingworker.SwingWorker$1.call(SwingWorker.java:276) java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) java.util.concurrent.FutureTask.run(Unknown Source) org.jdesktop.swingworker.SwingWorker.run(SwingWorker.java:315) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.lang.Thread.run(Unknown Source) |
Formspider doesn't use the SYSTEM table space. However, there are two instances where Formspider uses the SYSTEM table space.
Hope this helps. Yalim |
Hi Craig, You can ignore the XSD error. It is not a big deal. |
Hi Yalim, Thanks for your response; it seems that the installation is checking for free space in SYSTEM at the start of the installation since it reports on a lack of space available to complete the install regardless of what tablespace you select. Do you know any reason why I would not be able to connect to the IDE or Tomcat after the install completes? Thanks, Craig. |
Could you increase my karma please so I can upload a screenshot? Thanks, Craig it's done...
(25 Apr '13, 11:24)
formspider ♦♦
|