Menu ▾ ▴

Symmetric installation error Oracle 8i

Help
Pablo Vidal
2012-04-26
2012-09-15

  • Pablo Vidal

    Pablo Vidal - 2012-04-26

    Hi there, I am having troubles installing Symmetric to sincronize databases
    Oracle to Postgres.

    When I execute "sym -v -p root.properties --auto-create" I have the following
    error:

    Log output will be written to ../logs/symmetric.log

    2012-04-26 17:17:12,177 INFO Option: name=verbose, value={}

    2012-04-26 17:17:12,189 INFO Option: name=properties, value={root.properties}

    2012-04-26 17:17:12,189 INFO Option: name=auto-create, value={}

    2012-04-26 17:17:17,975 INFO The DbDialect being used is
    org.jumpmind.symmetric.db.oracle.OracleDbDialect

    2012-04-26 17:17:19,247 INFO Initializing SymmetricDS database.

    2012-04-26 17:17:20,744 INFO There are SymmetricDS tables missing. They will
    be auto created.

    2012-04-26 17:17:20,745 INFO Checking if SymmetricDS tables need created or
    altered.

    2012-04-26 17:17:20,859 INFO There are SymmetricDS tables that needed altered.

    2012-04-26 17:17:22,702 INFO Done with auto update of SymmetricDS tables.

    2012-04-26 17:17:22,868 INFO Just installed sym_blob2clob

    2012-04-26 17:17:22,933 INFO Just installed sym_transaction_id

    2012-04-26 17:17:22,985 INFO Just installed sym_trigger_disabled

    2012-04-26 17:17:23,061 INFO Just installed sym_pkg_package

    2012-04-26 17:17:23,134 INFO Just installed sym_pkg_package body

    2012-04-26 17:17:23,188 INFO Just installed sym_wkt2geom

    An exception occurred. Please see the following for details:

    java.sql.SQLException: ORA-00933: SQL command not properly ended

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)

    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)

    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.jav
    a:1037)

    at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)

    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.jav
    a:1124)

    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)

    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatemen
    t.java:205)

    at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStat
    ement(JdbcTemplate.java:440)

    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)

    org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
    grammar ; nested exception is java.sql.SQLException: ORA-00933: SQL command
    not properly ended

    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate
    (SQLStateSQLExceptionTranslator.java:98)

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.tra
    nslate(AbstractFallbackSQLExceptionTranslator.java:72)

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.tra
    nslate(AbstractFallbackSQLExceptionTranslator.java:80)

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.tra
    nslate(AbstractFallbackSQLExceptionTranslator.java:80)

    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)

    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455)

    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:463)

    at org.jumpmind.symmetric.service.impl.NodeService.findIdentity(NodeService.ja
    va:306)

    at org.jumpmind.symmetric.service.impl.NodeService.findIdentity(NodeService.ja
    va:301)

    at org.jumpmind.symmetric.service.impl.NodeService.findIdentityNodeId(NodeServ
    ice.java:86)

    at org.jumpmind.symmetric.service.impl.ConfigurationService.getNodeChannels(Co
    nfigurationService.java:207)

    at org.jumpmind.symmetric.service.impl.ConfigurationService.autoConfigChannels
    (ConfigurationService.java:315)

    at org.jumpmind.symmetric.service.impl.ConfigurationService.autoConfigDatabase
    (ConfigurationService.java:303)

    at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmet
    ricEngine.java:357)

    at org.jumpmind.symmetric.SymmetricLauncher.autoCreateDatabase(SymmetricLaunch
    er.java:659)

    at org.jumpmind.symmetric.SymmetricLauncher.executeOptions(SymmetricLauncher.j
    ava:477)

    at
    org.jumpmind.symmetric.SymmetricLauncher.execute(SymmetricLauncher.java:185)

    at org.jumpmind.symmetric.SymmetricLauncher.main(SymmetricLauncher.java:165)

    Can anybody help me?

    Thanks

     

  • Chris Henson

    Chris Henson - 2012-05-07

    Can you run the SQL yourself? Maybe Oracle 8 doesn't like the extra spacing?

     select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url,
        c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type from
        sym_node c

        inner join sym_node_identity i on c.node_id =
        i.node_id
     

  • Willy

    Willy - 2012-07-02

    Hi,

    I have the same problem, i use symmetric-ds-2.5.13 , the problem is that
    Oracle 8i doesn't support inner join syntax.

    Is there any possibilities to create symmetric schema manually.

    Thanks for any help

    Willy

     

Log in to post a comment.