Installation fail in Windows - Can not complete registring XSD


#1

Hi Gerger and Team,

i’m try install gitora in Windows but always receive the same error:
Started registring XSD
12:11:41 WARN - Can not complete registring XSD: ORA-31084: error while creating table “GITORA”.“root2650_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:196)
com.bui.installer.tasks.EngineInstallTask.installEngine(EngineInstallTask.java:151)
com.bui.installer.tasks.EngineInstallTask.execute(EngineInstallTask.java:73)
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:262)
org.jdesktop.swingworker.SwingWorker.run(SwingWorker.java:315)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
java.lang.Thread.run(Thread.java:745)

12:11:41 INFO - Finished registring XSD

I used sys user with all permissions in installation process.

¿Can someone help me?

System information details:
Oracle Database 11g Enterprise Edition
11.2.0.1.0 64bit

Best regards,
Vitor


#2

The same happens on my end. And now the DB is in hung state. I cannot connect to it. Also the ora service will not start anymore.


#3

Hi Marcel,

This exception is not an showstopper for Gitora installer. Installer can proceed in spite of it. Therefore, there has to be something else which prevents installer from successful completion.

I am not sure what is going on the service not being able to start issue. There is nothing unorthodox under the hood in Gitora which may cause database fail to restart. Gitora contains plsql packages and schema level triggers to run. Nevertheless, it may be caused by a hanging session which refuses to to be killed. I would suggest a reboot if database shutdown immediate or shutdown abort doesn’t work.

Kind Regards,
Serdar