cuba-platform / cuba

CUBA Platform is a high level framework for enterprise applications development
https://www.cuba-platform.com
Apache License 2.0
1.34k stars 219 forks source link

SQLSyntaxErrorException: ORA-00904: "DELETE_TS": invalid identifier #3289

Open vinodhkumar8991 opened 2 years ago

vinodhkumar8991 commented 2 years ago

Hi,

I having an issue after I opening the screen in a Cuba portal.

Despite of having the 'Delete_TS' in respective table column this error is occuring.

I've checked the logs for this issue in the cuba portal. In the log there call happening to a SQL query which I've never used in my project In that Query this Delete_Ts column in present. The query I'm mentioning below.

SELECT FROM (SELECT a., ROWNUM rnum FROM (SELECT ID AS a1, "ATTRIBUTE1" AS a2, "ATTRIBUTE2" AS a3, BU AS a4, DELETE_TS AS a5, DELETED_BY AS a6, DESCRIPTION AS a7, FLAG AS a8, LOGDATE AS a9, PLANID AS a10, RUNDATE AS a11, VERSION AS a12 FROM COST_PLANID_MASTER WHERE (DELETE_TS IS NULL)) a WHERE ROWNUM <= ?) WHERE rnum > ?

I don't understand from where this query coming from?

If having Idea about this issue. Your help is needful.