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
Tracy Corson
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.