I can't use appId as attribute of entity

Support
#1

I am using cuba 6.9.4.

I create an entity and add an attribute named appId. The table is created with app_id.

When I persist an entity, cuba throws

Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: APP_ID

When I open the entity-browse ui, cuba throws

Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: A2

BTW, the part of this sql is : SELECT LIMIT ? ? ID AS a1, APP_ID AS a2,

#2

Hello @peace0phmind

Could you check whether a table has this attribute or not? Have you updated your database after field creation?

I’ve successfully created and updated an entity with appId attribute:

image

Regards,
Daniil