2 Replies Latest reply: Feb 20, 2013 10:02 AM by Srini VEERAVALLI RSS

    Unable to create the DataWarehouse content in DAC 11G

    990113
      Hi Ali,

      I am trying to create the Datwarehouse tables using the ETL configuration option in DAC 11G and it is throwing the below error.

      Could you pls check this and let me know how to resolve it. Thank you.

      ************
      69 SEVERE Tue Feb 19 15:25:56 GMT 2013 MESSAGE:::
      ---------------------------------------------
      Table Name : W_PSFT_GLHIER_FLAT_DH_TMP
      Column Name: TENANT_ID.
      _**The column properties that are different :[statistics]**_
      ---------------------------------------------

      EXCEPTION CLASS::: com.siebel.analytics.etl.sqlgen.disambiguator.TableDescriptorDisambiguatorException

      com.siebel.analytics.etl.sqlgen.disambiguator.TableColumnBeanDisambiguator.diambiguate(TableColumnBeanDisambiguator.java:92)
      com.siebel.analytics.etl.sqlgen.SqlGenDisambiguated.populateMasterMap(SqlGenDisambiguated.java:454)
      com.siebel.analytics.etl.sqlgen.SqlGenDisambiguated.prepareMasterTDMap(SqlGenDisambiguated.java:219)
      com.siebel.analytics.etl.sqlgen.SqlGenDisambiguated.generateOracleSqlFile(SqlGenDisambiguated.java:548)
      com.siebel.analytics.etl.sqlgen.SqlGenDisambiguated.generateSqlFileForAllTables(SqlGenDisambiguated.java:666)
      com.siebel.analytics.etl.sqlgen.SqlGenDisambiguated.generateDatabaseSpecificSqlFile(SqlGenDisambiguated.java:700)
      com.siebel.analytics.etl.sqlgen.CreateDWSchema.createDWSchemaForApplications(CreateDWSchema.java:92)
      com.siebel.etl.gui.configurator.CreateWSQLCommand.createDWSchema(CreateWSQLCommand.java:124)
      com.siebel.etl.gui.configurator.CreateWSQLCommand.execute(CreateWSQLCommand.java:61)
      com.siebel.etl.gui.configurator.StatusForm$TaskExecutor.runAllTasks(StatusForm.java:347)
      com.siebel.etl.gui.configurator.StatusForm$TaskExecutor.run(StatusForm.java:277)
      java.lang.Thread.run(Unknown Source)
      70 SEVERE Tue Feb 19 15:25:56 GMT 2013 MESSAGE:::Discrepencies have been found on some table column definitions!
      EXCEPTION CLASS::: java.lang.RuntimeException

      com.siebel.analytics.etl.sqlgen.SqlGenDisambiguated.populateMasterMap(SqlGenDisambiguated.java:472)
      com.siebel.analytics.etl.sqlgen.SqlGenDisambiguated.prepareMasterTDMap(SqlGenDisambiguated.java:219)
      com.siebel.analytics.etl.sqlgen.SqlGenDisambiguated.generateOracleSqlFile(SqlGenDisambiguated.java:548)
      com.siebel.analytics.etl.sqlgen.SqlGenDisambiguated.generateSqlFileForAllTables(SqlGenDisambiguated.java:666)
      com.siebel.analytics.etl.sqlgen.SqlGenDisambiguated.generateDatabaseSpecificSqlFile(SqlGenDisambiguated.java:700)
      com.siebel.analytics.etl.sqlgen.CreateDWSchema.createDWSchemaForApplications(CreateDWSchema.java:92)
      com.siebel.etl.gui.configurator.CreateWSQLCommand.createDWSchema(CreateWSQLCommand.java:124)
      com.siebel.etl.gui.configurator.CreateWSQLCommand.execute(CreateWSQLCommand.java:61)
      com.siebel.etl.gui.configurator.StatusForm$TaskExecutor.runAllTasks(StatusForm.java:347)
      com.siebel.etl.gui.configurator.StatusForm$TaskExecutor.run(StatusForm.java:277)
      java.lang.Thread.run(Unknown Source)
      71 SEVERE Tue Feb 19 15:25:56 GMT 2013 java.lang.RuntimeException: Discrepencies have been found on some table column definitions!
      72 SEVERE Tue Feb 19 15:25:56 GMT 2013 java.lang.RuntimeException: Discrepencies have been found on some table column definitions!
      73 SEVERE Tue Feb 19 15:25:56 GMT 2013 FAILURE!
      ************