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

[Snehankita]

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:

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

[jmuiruri]

<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

[Snehankita]

Hi Joe,

Thanks for the response.

I checked the database and found the following:

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