3632998 - prep_pre_check/dbchk_pre message: cannot find either column "sid" or the user-defined function or aggregate "<sid>" - sap NetWeaver products

Symptom

Error in the phase PREP_PRE_CHECK/DBCHK_PRE during the Software Update Manager (SUM) process.
Following error messages arise while executing SUM Phase: PREP_PRE_CHECK/DBCHK_PRE

---------------------------------------------------------------------------------------------------
Repeat Phase
Severe error(s) occurred in phase PREP_PRE_CHECK/DBCHK_PRE!

Last generated error message:
1 error during parallel execution of processes
Check summary log 'PHASE_DBCHK.ELG' for details!

'PHASE_DBCHK.ELG' log:

'MSSCHECKMISMATCH.LOG':

3 ETQ398XSQL: @ErrorSeverity,
3 ETQ398XSQL: @ErrorState
3 ETQ398XSQL: );
3 ETQ398XSQL: end catch
4 ETQ010 Date & Time: yyyymmddhhmmss
1EETQ008 Error message: dbrc = 99: 'all DB errors, except for ...'
1EETQ009XDB code 50000
1EETQ009XCDS view inconsistency. Check note 3149065.
1EETQ009XObject:[<sid>].[DEMO_CDS_CRRCONV] Message:Cannot find either column
1EETQ009X"<sid>" or the user-defined function or aggregate
1EETQ009X"<sid>.CURRENCY_CONVERSION", or the name is ambiguous.
---------------------------------------------------------------------------------------------------

" - sap NetWeaver products"> Read more...

Environment

SAP S/4HANA conversion from 'SAP NetWeaver 7.5/Microsoft SQL Server' to 'S/4HANA 2023'.

Product

SAP NetWeaver all versions

Keywords

prep_pre_check, dbchk_pre, sum process, error message, column erl, user-defined function, aggregate erl, sql server, sap products, cds view inconsistency, swpm, recreate gtts, force execution, ddl sources, system conversion, sap s/4hana, sap ecc, software update manager. , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.