OBIA 11g: ODI Filter Does Not Use Source DataStore In SDE_PSFT_DomainGeneral_EthnicGroup.W_DOMAIN_MEMBER_GS_SQ (Doc ID 2093252.1)

Last updated on FEBRUARY 01, 2016

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.8.1 version, DataWarehouse

The ODI filter does not use Source DataStore in SDE_PSFT_DomainGeneral_EthnicGroup.W_DOMAIN_MEMBER_GS_SQ

The delivered interface object has mapping errors:


Interface validation report:
  error OBJECT: Filter attached to Source DataStore PSXLATITEMLANG,"RUN_FULL_INC...",
  MESSAGE: Filter does not use any source column and cannot be attached to a source datastore.
 Filter full statement: RUN_FULL_INCREMENTAL("#IS_INCREMENTAL", 1=1,
RUN_REPLICATED_TRANSACTIONAL('#IS_SDS_DEPLOYED', 1=1, PSXLATITEMLANG.CDC$_SRC_LAST_UPDATE_DATE > TO_DATE_VAR('#LAST_EXTRACT_DATE'))
)

Target Datastore - SQ_ETHNIC_GROUP, CHANGED_ON_DT

Additional information: Right click on the orphan filter object, select Data... results in the error below:

oracle.odi.core.exception.OdiRuntimeException: oracle.odi.interfaces.data.OdiConnectionNotFoundException: ODI-15631: Connection information is not available.
at oracle.odi.interfaces.data.impl.OdiInterfaceDataAccessHelperWithSnpObjects$1.doAction(OdiInterfaceDataAccessHelperWithSnpObjects.java:672)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.interfaces.data.impl.OdiInterfaceDataAccessHelperWithSnpObjects.prepareSQLStatement(OdiInterfaceDataAccessHelperWithSnpObjects.java:125)
...
All other filters are successful in returning correct data.

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