Application Lifecycle Conductor

  • 1.  SQL error while importing definitions

    Posted Jun 16, 2016 08:58 AM

    ALC 3.0 Server on Linux, Oracle database 11g, Client on Windows 10.

    Clean install.

    SQL error occurs while importing definitions:

     

    An unexpected error has been detected.  If the problem persists, please contact the System Administrator for assistance. purescm.vegas.engine.exceptions.DataOperationException: Error updating database: StatementCallback; uncategorized SQLException for SQL [create or replace synonym rpt_Project_1000 for vegas.rpt_Project_1000]; SQL state [72000]; error code [1471]; ORA-01471: cannot create a synonym with same name as object

    ; nested exception is java.sql.SQLException: ORA-01471: cannot create a synonym with same name as object

     

    Any suggestions how to fix this?



  • 2.  Re: SQL error while importing definitions
    Best Answer

    Posted Aug 26, 2016 08:47 AM

    Richard was installing with Oracle Express edition for a test system.  He has subsequently switched to SQL Server database and those errors no longer occur.