Skip to Content
avatar image
Former Member

Calculate Column In HANA SQL View show error mismatch type

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.

sql.jpg (77.1 kB)
sin-titulo.png (14.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers