Skip to Content
0

Calculate Column In HANA SQL View show error mismatch type

Nov 28, 2016 at 08:53 PM

334

avatar image

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)
SQL | view
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers