3788959 - Activation of .hdbdd CDS fails with 'Failed to read CDS catalog content via procedure'

After creating or modifying a HANA CDS view (ie, .hdbdd file), the activation failed with below error

[00:00:00] File /<path>/<filename>.hdbdd saved successfully.
[00:00:00] Error while activating /<path>/<filename>.hdbdd:[:.hdbdd] exception 1000000: Failed to read CDS catalog content via procedure

Checked indexserver trace, found below error messages:

[<TID>]{<PID>}[<Thread>/<SessionID>] YYYY-MM-DD HH:MM:SS.ssssss e cds ConnectionImpl.cpp(00468) : SQLException in ResultSetHandle.getNClob(): fatal error
[<TID>]{<PID>}[<Thread>/<SessionID>] YYYY-MM-DD HH:MM:SS.ssssss e cds TableRowBuffer.cpp(00730) : Failed to call built-in dev procedure CDS_CATALOG_READ_DEV: CALL SYS.CDS_CATALOG_READ_DEV(?, ?, #ARTIFACT_NAMES_<HASH>)
[<TID>]{<PID>}[<Thread>/<SessionID>] YYYY-MM-DD HH:MM:SS.ssssss e cds TableRowBuffer.cpp(00731) : Exception: fatal error
[<TID>]{<PID>}[<Thread>/<SessionID>] YYYY-MM-DD HH:MM:SS.ssssss e cds CdsActivator.cpp(00127) : Unexpected exception in CdsActivator.activate: exception 1: no.1000000 (cds/catalog/impl/db/tableAccess/TableRowBuffer.cpp:732) TID: <TID>
Failed to read CDS catalog content via procedure
exception throw location:
0: 0x00007f71bb2fd09f in cds::TableRowBuffer::fillViaDevProcedure
1: 0x00007f71bb1e4979 in cds::CatalogContentGeneratorImpl::process
2: 0x00007f71c4872e69 in cds::CdsActivator::handleCatalogUpdates
3: 0x00007f71c4873b63 in cds::CdsActivator::activate
4: 0x00007f72004105f9 in repo::CdsRuntime::generate
5: 0x00007f71f9795f55 in repo::Activator::activateObjectsInternalFast2
......

• SAP HANA Platform Edition
• SAP Web-based Workbench Editor

cds, hdbdd, activation failure, exception 1000000, failed to read cds catalog content via procedure, SYS.CDS_CATALOG_READ_DEV, _SYS_RT.CDS_SOURCE_CODE, hana xs classic, repository activation, 40136, unicode, comment, catalog read, cds activator , KBA , HAN-AS-RPO , SAP HANA Repository , Problem