This discussion is archived
2 Replies Latest reply: Feb 20, 2013 8:02 AM by Srini VEERAVALLI RSS

Unable to create the DataWarehouse content in DAC 11G

990113 Newbie
Currently Being Moderated
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!
************

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points