Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
vinodhkumar8991 opened this issue Oct 22, 2022 · 0 comments
Open

Comments

@vinodhkumar8991
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant