SAP Knowledge Base Article - Preview

2063188 - ORA-00904: "ABLE_NAME":invalid identifier when importing table from Oracle 9i Data Insight Connection - SAP Information Steward 4.2

Symptom

When attempting to retrieve Metadata from a data profiling connection the following error is encountered:

<ORA-00904:"ABLE_NAME": invalid identifier>.
The SQL submitted is < select table_name table_name, comments,
table_type from all_tab_comments where owner = 'ADM'
UNION
select synonym_name table_name, NULL, 'SYNONYM' from all_synonyms a,
all_objects b where a.table_name = b.object_name and a.table_owner =
b.owner and b.object_type IN ('TABLE', 'VIEW', 'MATERIALIZED VIEW') and
a.owner = 'ADM' and a.table_owner = 'ADM' and DB_LINK IS NULL order by
able_name asc>."

 


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.1 SP3
  • SAP Data Services 4.2 SP2
  • SAP Information Steward 4.2 SP2

Product

SAP BusinessObjects Business Intelligence platform 4.1 ; SAP Data Services 4.2 ; SAP Information Steward 4.2

Keywords

KBA , EIM-IS-DI , Information Steward - Data Insight , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.