Installation failed ORA-01792: maximum number of columns in a table or view is 1000


#1

GITORA installation failed with below error:

10:37:45 INFO - Checking errors completed
10:37:45 INFO - Started registring XSD
10:38:41 WARN - Can not complete registring XSD: ORA-31084: error while creating table “GITORA”.“root1165_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)
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:197)
com.bui.installer.tasks.EngineInstallTask.installEngine(EngineInstallTask.java:152)
com.bui.installer.tasks.EngineInstallTask.execute(EngineInstallTask.java:74)
com.bui.installer.gui.panels.InstallationPanel$3.doInBackground(InstallationPanel.java:194)
org.jdesktop.swingworker.SwingWorker$1.call(SwingWorker.java:276)
java.util.concurrent.FutureTask.run(FutureTask.java:266)
org.jdesktop.swingworker.SwingWorker.run(SwingWorker.java:315)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)

10:38:41 INFO - Finished registring XSD
10:38:41 INFO - ----------------------------------
10:38:41 INFO - Importing java files into database
10:38:41 INFO - File: C:\Users\ausan\AppData\Local\Temp\Formspider4378680543049024454tmp\poi-3.2-FINAL-20081019.jar
10:38:43 WARN - Can not complete importing java objects: IO Error: Connection reset
oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1055)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4719)
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1064)
com.bui.installer.util.JavaDBImporter.importJar(JavaDBImporter.java:254)
com.bui.installer.util.JavaDBImporter.importFile(JavaDBImporter.java:164)
com.bui.installer.util.JavaDBImporter.(JavaDBImporter.java:101)
com.bui.installer.tasks.EngineInstallTask.importJavaObjects(EngineInstallTask.java:234)
com.bui.installer.tasks.EngineInstallTask.installEngine(EngineInstallTask.java:155)
com.bui.installer.tasks.EngineInstallTask.execute(EngineInstallTask.java:74)
com.bui.installer.gui.panels.InstallationPanel$3.doInBackground(InstallationPanel.java:194)
org.jdesktop.swingworker.SwingWorker$1.call(SwingWorker.java:276)
java.util.concurrent.FutureTask.run(FutureTask.java:266)
org.jdesktop.swingworker.SwingWorker.run(SwingWorker.java:315)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)
Caused by:
java.net.SocketInputStream.read(SocketInputStream.java:210)
java.net.SocketInputStream.read(SocketInputStream.java:141)
oracle.net.ns.Packet.receive(Packet.java:300)
oracle.net.ns.DataPacket.receive(DataPacket.java:106)
oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:315)
oracle.net.ns.NetInputStream.read(NetInputStream.java:260)
oracle.net.ns.NetInputStream.read(NetInputStream.java:185)
oracle.net.ns.NetInputStream.read(NetInputStream.java:102)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)
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.executeUpdate(OraclePreparedStatement.java:3665)
oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4719)
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1064)
com.bui.installer.util.JavaDBImporter.importJar(JavaDBImporter.java:254)
com.bui.installer.util.JavaDBImporter.importFile(JavaDBImporter.java:164)
com.bui.installer.util.JavaDBImporter.(JavaDBImporter.java:101)
com.bui.installer.tasks.EngineInstallTask.importJavaObjects(EngineInstallTask.java:234)
com.bui.installer.tasks.EngineInstallTask.installEngine(EngineInstallTask.java:155)
com.bui.installer.tasks.EngineInstallTask.execute(EngineInstallTask.java:74)
com.bui.installer.gui.panels.InstallationPanel$3.doInBackground(InstallationPanel.java:194)
org.jdesktop.swingworker.SwingWorker$1.call(SwingWorker.java:276)
java.util.concurrent.FutureTask.run(FutureTask.java:266)
org.jdesktop.swingworker.SwingWorker.run(SwingWorker.java:315)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)

10:38:43 INFO - ----------------------------------
10:38:43 INFO - Executing postInstall scripts
10:38:43 INFO - C:\Users\ausan\AppData\Local\Temp\Formspider4378680543049024454tmp\engine_db\postInstall.sql
10:38:43 INFO - engine install fail debug
10:38:43 INFO - INSTALLATION FAILED
10:38:43 INFO - Exception stack trace:
Closed Connection
oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:3407)
oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:3382)
com.bui.installer.util.SQLScriptRunner.executeLine(SQLScriptRunner.java:135)
com.bui.installer.util.SQLScriptRunner.execute(SQLScriptRunner.java:71)
com.bui.installer.tasks.EngineInstallTask.handlePostInstallation(EngineInstallTask.java:262)
com.bui.installer.tasks.EngineInstallTask.installEngine(EngineInstallTask.java:163)
com.bui.installer.tasks.EngineInstallTask.execute(EngineInstallTask.java:74)
com.bui.installer.gui.panels.InstallationPanel$3.doInBackground(InstallationPanel.java:194)
org.jdesktop.swingworker.SwingWorker$1.call(SwingWorker.java:276)
java.util.concurrent.FutureTask.run(FutureTask.java:266)
org.jdesktop.swingworker.SwingWorker.run(SwingWorker.java:315)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)

10:38:43 INFO - Rolling back changes
10:38:49 INFO - Roll back finished

The worst thing is that now I cannot login to the Oracle DB. Oracle 11g R2. Can you please assist?


#2

@Serdar @yalimgerger could you perhaps assist with the installation?


#3

Hi Marcel,

Please try to install Gitora into your Users home directory. For example, C:\Users\ausan\Gitora3 would be an good option.

Kind Regards
Serdar