Question Re: SAP Information Steward Task Failing - "Invalid colum... in Technology Q&A

SAP Information Steward Task Failing - "Invalid column name 'IS_GEN_SOURCE_ROWID' " Error

Snehankita — Tue, 01 Jul 2025 09:46:03 GMT

Hi,

We are facing an issue with a task in SAP Information Steward.

Error :

error message for operation <SQLExecute>: <[Microsoft][ODBC Driver 17 for SQL Server][SQL
Server]Invalid column name 'IS_GEN_SOURCE_ROWID'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Could not use view or function 'CMD007C_D_P4821T5004_FD' because of
binding errors.

Observation:

The column 'IS_GEN_SOURCE_ROWID' is missing in prod which matches the error
Interestingly, the same column is also missing in INTEG, but the task runs fine there without errors.

Re: SAP Information Steward Task Failing - "Invalid colum...

jmuiruri — Wed, 02 Jul 2025 08:33:08 GMT

<TABLE_ALIAS>_FD does not contain IS_GEN_SOURCE_ROWID. This column is found in <TABLE_ALIAS>_SOURCE, TABLE_ALIAS_SR, TABLE_ALIAS_FR.

Extract details from failed data tables and views

You should try Deleting inconsistent source data in Data Insight

Regards,

Joe

Re: SAP Information Steward Task Failing - "Invalid colum...

Snehankita — Wed, 02 Jul 2025 15:28:38 GMT

Hi Joe,

Thanks for the response.

I checked the database and found the following:

The column IS_GEN_SOURCE_ROWID is present in the <TABLE_ALIAS>_SOURCE table.
However, this column is missing in <TABLE_ALIAS>_FR, and I couldn't locate the <TABLE_ALIAS>_SR table in the database.
Also, the " Delete Failed Data and Run " option is greyed out/ not available.