cancel
Showing results for 
Search instead for 
Did you mean: 

Calculate Column In HANA SQL View show error mismatch type

jose1234_
Newcomer
0 Kudos

HI, everyone, i have a problem, a need to create a SQL SCRIPT, but the system always show me the following error:

Message : Repository: Encountered an error in repository runtime extension;Model inconsistency. Deploy Calculation View: SQL: transaction rolled back by an internal error: return type mismatch: Attribute name "ZCM_MM_RECLAMOx100PACIENTES" different from Attribute name: "ZCM_MM_RECLAMOX100PACIENTES" : line 4 col 4 (at pos 274)

I know that the column must to have same data type, so i wrote the following SQL:

The two calculated mesures in yellow are the only ones that show me the error, if i delete of the sql and hana script the view run correctly.

and the definition for both is that:

I dont know what i am doing wrong, in this view.

Best Regard.

Accepted Solutions (0)

Answers (0)