Analytics Software

Hello,
I am trying to generate a master repository using repcreate, on a oracle 9i db. The
repcreate utility fails:

DBMS Error during Repository Installation

java.sql.SQLException: ORA-00907: missing right parenthesis.

ava.sql.SQLException: ORA-00907: missing right parenthesis

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1846)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1771)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2361)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java)
at com.sunopsis.dwg.xml.DwgXmlSession.execute(DwgXmlSession.java)
at com.sunopsis.l.a.b.a(b.java)
at com.sunopsis.l.a.b.a(b.java)
at com.sunopsis.wizards.MasterRepositoryWizard.d(MasterRepositoryWizard.java)
at com.sunopsis.wizards.MasterRepositoryWizard.f(MasterRepositoryWizard.java)
at com.sunopsis.wizards.MasterRepositoryWizard.a(MasterRepositoryWizard.java)
at com.sunopsis.wizards.MasterRepositoryWizard.a(MasterRepositoryWizard.java)
at com.sunopsis.wizards.MasterRepositoryWizard$IvjEventHandler.actionPerformed(MasterRepositoryWizard.java)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

On the table:
CREATE TABLE SNP_ACTION (
I_TXT_DESC NUMBER(10) NULL,
LAST_USER VARCHAR2(35 CHAR) NULL,
I_ACTION NUMBER(10) NOT NULL,
FIRST_DATE DATE NULL,
ACTION_NAME VARCHAR2(35 CHAR) NOT NULL,
ACTION_TYPE NUMBER(10) NOT NULL,
I_GRP_ACTION NUMBER(10) NULL,
FIRST_USER VARCHAR2(35 CHAR) NULL,
LAST_DATE DATE NULL
)

Kind regards,
Frans.