DAC 11g Generate Upgrade Statements For Data Warehouse Tables Fails For Teradata Target with Error "Could not read the single column statistics column names for table: table_name properly" (Doc ID 1917680.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.4 and later
Information in this document applies to any platform.

Symptoms

OBIA 7.9.6.x with DAC 11g and Teradata 14.10 Database:

DAC 11g Generate upgrade statements for Data Warehouse Tables fails when using Teradata V14.x as the target. 

This error can happen either when using:


File upgradewtables_sql.log contain errors:


MESSAGE:::Could not read the single column statistics column names for table: table_name properly!
EXCEPTION CLASS::: com.siebel.analytics.etl.sqlgen.schema.teradata.TeradataSchemaUpgradeFailedException

com.siebel.analytics.etl.sqlgen.schema.teradata.TargetSchemaReader.getTeradataTableSingleColumnStatNames(TargetSchemaReader.java:168)
com.siebel.analytics.etl.sqlgen.schema.teradata.TeradataSchemaUpgradeHelper.generateUpgradeDDL(TeradataSchemaUpgradeHelper.java:553)
com.siebel.analytics.etl.sqlgen.schema.teradata.TeradataSchemaUpgradeHelper.partitionExistingTableListByConflict(TeradataSchemaUpgradeHelper.java:373)
com.siebel.analytics.etl.sqlgen.schema.teradata.TeradataSchemaUpgradeHelper.fire(TeradataSchemaUpgradeHelper.java:134)
com.siebel.etl.gui.configurator.UpgradeWSQLCommand.upgradeDWSchemaForTeradata(UpgradeWSQLCommand.java:79)
com.siebel.etl.gui.configurator.UpgradeWSQLCommand.execute(UpgradeWSQLCommand.java:55)
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)

::: CAUSE :::
MESSAGE :::DataWarehouse:SELECT COLUMNNAME FROM DBC.COLUMNSTATS WHERE DATABASENAME = 'schemaname' AND TABLENAME = 'table_name' AND FIELDSTATISTICS IS NOT NULL
[Teradata Database] [TeraJDBC 14.10.00.26] [Error 3807] [SQLState 42S02] Object 'DBC.COLUMNSTATS' does not exist.
EXCEPTION CLASS::: com.siebel.etl.database.IllegalSQLQueryException


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms