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

 
2
1
0

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!

  1. Fabio Fumi

    Any idea about the reason for this error?

CommentAdd your comment...

4 answers

  1.  
    2
    1
    0

    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?

    1. Anders

      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

    2. Fabio Fumi

      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.

    3. Ali Hosseini

      I Have This Problem...

    CommentAdd your comment...
  2.  
    1
    0
    -1

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

    Thanks

      CommentAdd your comment...
    1.  
      1
      0
      -1
    2.  
      0
      -1
      -2

      Try going thru these steps at

       

        CommentAdd your comment...