In a datagrid I want to select only those entities that were created at midnight. So, I added this XPath constraint on the system attribe 'createdDate': [hours-from-dateTime(createdDate) = 0 and minutes-from-dateTime(createdDate) = 0] This however, will not work. The logs show the error: time zone "Custom" not recognized Any ideas why this might be? The documentation for these functions does not specify any problems with system attributes. stacktrace: Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (1/47) com.mendix.core.CoreException: Exception occurred in action '{"amount":20,"sort":["dB@79d7b3"],"formName":"LoftManagement.ApplicationStatistics","returnsCount":true,"offset":0,"type":"RetrieveXPathSchemaRawAction","xpath":"//LoftManagement.ApplicationStatistics[hours-from-dateTime(createdDate) = 0 and minutes-from-dateTime(createdDate) = 0]"}', all database changes executed by this action were rolled back Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (2/47) at com.mendix.core.actionmanagement.CoreAction.c(SourceFile:485) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (3/47) Caused by: d: An exception has occurred for the following request(s): Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (4/47) fk (depth = -1, amount = 20): //LoftManagement.ApplicationStatistics[hours-from-dateTime(createdDate) = 0 and minutes-from-dateTime(createdDate) = 0] Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (5/47) Caused by: d: Exception occurred while retrieving data. (SQL State: 22023, Error Code: 0) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (6/47) Caused by: org.postgresql.util.PSQLException: ERROR: time zone "Custom" not recognized Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (7/47) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (8/47) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (9/47) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (10/47) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (11/47) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (12/47) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (13/47) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (14/47) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (15/47) at w.a(SourceFile:322) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (16/47) at w.a(SourceFile:215) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (17/47) at w.a(SourceFile:165) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (18/47) at w.a(SourceFile:154) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (19/47) at n.a(SourceFile:43) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (20/47) at dq.a(SourceFile:200) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (21/47) at dq.a(SourceFile:158) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (22/47) at dq.a(SourceFile:86) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (23/47) at du.a(SourceFile:67) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (24/47) at l.a(SourceFile:45) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (25/47) at a.a(SourceFile:243) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (26/47) at gY.a(SourceFile:115) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (27/47) at gY.a(SourceFile:86) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (28/47) at gY.executeAction(SourceFile:27) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (29/47) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (30/47) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:434) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (31/47) at go.execute(SourceFile:302) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (32/47) at iD.a(SourceFile:306) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (33/47) at iD.a(SourceFile:235) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (34/47) at iD.processRequest(SourceFile:179) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (35/47) at iG.a(SourceFile:71) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (36/47) at com.mendix.core.MxRuntime.processRequest(SourceFile:842) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (37/47) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:43) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (38/47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (39/47) at org.eclipse.jetty.server.Server.handle(Server.java:334) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (40/47) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (41/47) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (42/47) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (43/47) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:209) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (44/47) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (45/47) at org.eclipse.jetty.server.nio.BlockingChannelConnector$ConnectorEndPoint.run(BlockingChannelConnector.java:187) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (46/47) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) Jan 20 13:35:27 127.0.0.1 cloud: ERROR - Connector: (47/47) at java.lang.Thread.run(Thread.java:662)
asked
Jouke Waleson
1 answers
1
What is the exact stacktrace? The timezone 'custom' is used when a certain user has no timezone set to his user account, then we can't really determine the timezone and just create one named 'custom' using the current offset that the client's browser is in.