Thu, 24 Sep 2026
Login

ERROR 30 - ORA-00904: "APPDEFINIT0_"."META": invalid identifier

Confluence User - 30 Jun, 2016

Following the procedure described in

Running Joget Workflow with Oracle 11g

I managed to restart and login (admin) to the Joget server, but the app page just hangs forever in 'loading apps'.

I found in the server logs this error:

ERROR 30 Jun 2016 12:14:03 org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ORA-00904: "APPDEFINIT0_"."META": invalid identifier
ERROR 30 Jun 2016 12:14:03 org.joget.commons.spring.web.CustomDelegatingFilterProxy - Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Anyone can help here?

Thanks!

oracle;ora-00904

7

Confluence User •
02 Jul, 2016 •
confluenceUser •
•
confluenceUser •

Try going thru these steps at

 

Confluence User •
04 Jul, 2016 •
confluenceUser •
•
confluenceUser •

Thanks Bastiana for the suggestion.

Still, same error is there after auto-setup too:

2016-07-04 17:32:19,249: Profile init complete: XE
2016-07-04 17:32:19,265: ===== Database Setup Complete =====
2016-07-04 17:32:23,674: ORA-00904: "APPDEFINIT0_"."META": invalid identifier

... why?

Any idea?

Confluence User •
11 Jul, 2016 •
confluenceUser •
•
confluenceUser •

It seems like your Oracle schema user does not have the necessary permissions to ALTER the db tables. You might want to try the exact GRANT commands as described in https://dev.joget.org/community/display/KBv5/Running+Joget+Workflow+with+Oracle+11g

Confluence User •
11 Jul, 2016 •
confluenceUser •
•
confluenceUser •

Thanks Anders, but I performd the three grants beforehand and indeed the DB setup script succeeded. The ORA-00904 error is not during setup, but as soon as Joget tries to access the app center pages.

Confluence User •
08 Apr, 2017 •
confluenceUser •
•
confluenceUser •

I Have This Problem...

Confluence User •
08 Apr, 2017 •
confluenceUser •
•
confluenceUser •

https://dev.joget.org/community/questions/26773737/connect-oracle-to-joget-error

Confluence User •
03 May, 2017 •
confluenceUser •
•
confluenceUser •

Solved! After Ali Hosseini suggestion: adding column META varchar2(2000) to APP_APP table.

Thanks

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
is Oracle 19c supported in custom database configuration?
How to populate text field using the Bean Shell Load Binder?
integration with oracle 11g error
Do not Create Table For WorkFlow?
Integration with Oracle 12c || tables not auto created
Connect Oracle To Joget => Error
Integrating with Oracle PL/SQL
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print