Issue: DTP load from DSO to DSO failing with error “An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RAISING clause” message.
Analysis: After database migration from Oracle to HANA we encountered the DTP was failing with the above error message.
We have found that the semantic grouping was not maintained due to which the above error message occured.
Solution: We set the semantic grouping for the key fields of the target at DTP level. After that we repeated the DTP job.