Error executing get_logged_in_usernames in Mendix 7.1.1

0
Hi, I'm trying to run my first Mendix 7 app on our on-premise server. It appears to start ok but when I check status I get: INFO: The application process is running, the MxRuntime has status: running ERROR: Executing get_logged_in_user_names did not succeed: result: 1, message: An unhandled exception occurred!, caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//System.User[System.Session_User]","amount":-1,"depth":0,"offset":-1,"sort":{},"type":"RetrieveXPathAction"}', all database changes executed by this action were rolled back   Trying to access via the web using the ipaddress:port shows: {"result":-2,"message":"Use content type 'application/json' for requests to this application."}   Trying to use the url shows the below in the logfile: 2018-06-07 10:37:41.157 ERROR - M2EE: An error occurred while executing action 'get_logged_in_user_names'. 2018-06-07 10:37:41.157 ERROR - M2EE: com.mendix.m2ee.api.AdminException: An unhandled exception occurred!         at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:142) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//System.User[System.Session_User]","amount":-1,"depth":0,"offset":-1,"sort":{},"type":"RetrieveXPathAction"}', all database changes executed by this action were rolled back         at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:178) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//System.User[System.Session_User]","amount":-1,"depth":0,"offset":-1,"sort":{},"type":"RetrieveXPathAction"}', all database changes executed by this action were rolled back         at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"xpath":"//System.User[System.Session_User]","amount":-1,"depth":0,"offset":-1,"sort":{},"type":"RetrieveXPathAction"}', all database changes executed by this action were rolled back         at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:152) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: An exception has occurred for the following request(s):         InternalXPathTextGetRequest (depth = 0): //System.User[System.Session_User]         at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:49) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while retrieving data. (SQL State: 42883, Error Code: 0)         at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.getCorrectException(JdbcDataStore.java:1243) Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = boolean   Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.   Position: 611         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)     Thank you!
asked
1 answers
0

The issue was solved by upgrading the server to Mx 7.6.0 as stated by Tracy.

This answer was just placed here so the thread is marked as answered.

answered