SAP Note 1749282 - DSO activation terminates with SQL error 129

Component : SAP HANA Database - SAP HANA BW Engine

Solution : https://service.sap.com/sap/support/notes/1749282 (SAP Service marketplace login required)

Summary :
DSO activation failure with SQL error 129 may lead to system log entries indicating a database error due to index name conflicts associated with change log views for DSOs. Errors may recur when attempting to repair CalcViews using RSDU_RECREATE_CHGLG_HDB. The root cause is the non-deletion of old CalcView versions before update, requiring an SQL DROP statement. Solutions are provided through updates in SAP support packages SAPKB73009 and SAPKB73105, with immediate correction instructions available for critical situations.

Key words :
subsequentsap_bw730730 731731 sap_basis730730 731731 740740  correction instructions correction instructionssoftware componentvalid fromvalid tonumbersap_bw7407401223619sap_basis7307301509722sap_basis7317311509723 support packages & patches support packagessoftware componentreleasesupport packagesap_basis731sapkb73105740sapkb74003 references, components han-db-eng-bw sap hana bw engine priority correction, medium priority category program error validity software componentfrom rel, customer component han-db sap hana database, report rsdu_recreate_chglg_hdb 1735198   regenerate calc view, support packages, correction instructions, solution program correction, sap hana-optimized dso, / __%pdfstyle%__font-size

Related Notes :

1846967Change log of SAP HANA-optimized DSO is inconsistent
1817381Enhancement of the report RSDU_RECREATE_CHGLG_HDB
1735198Regenerate calc view for an SAP HANA-optimized DSO