Jun 25, 2024 5:18:59 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [dispatcherServlet] in context with path threw exception [Request processing failed; nested exception is org.adempiere.exceptions.DBException: ERROR: operator does not exist: character varying = integer
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 2849
SQL: SELECT
d446.*
, (SELECT
ARRAY[AD_User.AD_User_ID::text, NULLIF (TRIM(AD_User.Name), ‘’), AD_User.Description,AD_User.IsActive, NULL]
FROM AD_User
WHERE AD_User.AD_User_ID=d446.UpdatedBy) AS UpdatedBy$Display
, (SELECT
ARRAY[AD_User.AD_User_ID::text, NULLIF (TRIM(AD_User.Name), ‘’), AD_User.Description,AD_User.IsActive, NULL]
FROM AD_User
WHERE AD_User.AD_User_ID=d446.CreatedBy) AS CreatedBy$Display
, (SELECT
ARRAY[AD_Client.AD_Client_ID::text, NULLIF (TRIM(AD_Client.Name), ‘’), AD_Client.Description,AD_Client.IsActive, NULL]
FROM AD_Client
WHERE AD_Client.AD_Client_ID=d446.AD_Client_ID) AS AD_Client_ID$Display
, (SELECT
ARRAY[AD_Org.AD_Org_ID::text, NULLIF (TRIM(AD_Org.Name), ‘’), AD_Org.Description,AD_Org.IsActive, NULL]
FROM AD_Org
WHERE AD_Org.AD_Org_ID=d446.AD_Org_ID) AS AD_Org_ID$Display
, (SELECT
ARRAY[AD_Element.AD_Element_ID::text, AD_Element_Trl.Name, AD_Element_Trl.Description,AD_Element.IsActive, NULL]
FROM AD_Element INNER JOIN AD_Element_TRL ON (AD_Element.AD_Element_ID=AD_Element_Trl.AD_Element_ID AND AD_Element_Trl.AD_Language=‘en_US’)
WHERE AD_Element.AD_Element_ID=d446.AD_Element_ID) AS AD_Element_ID$Display
, (SELECT
ARRAY[AD_Language.AD_Language::text, NULLIF (TRIM(AD_Language.Name), ‘’), NULL,AD_Language.IsActive, NULL]
FROM AD_Language
WHERE AD_Language.AD_Language=d446.AD_Language) AS AD_Language$Display
FROM (SELECT
AD_Element_Trl.Help_Customized AS Help_Customized
, AD_Element_Trl.IsUseCustomization AS IsUseCustomization
, AD_Element_Trl.WEBUI_NameNewBreadcrumb AS WEBUI_NameNewBreadcrumb
, AD_Element_Trl.WEBUI_NameNew AS WEBUI_NameNew
, AD_Element_Trl.WEBUI_NameBrowse AS WEBUI_NameBrowse
, AD_Element_Trl.UpdatedBy AS UpdatedBy
, (select columnname from AD_Element e where e.AD_Element_ID = AD_Element_Trl.AD_Element_ID) AS ColumnName
, AD_Element_Trl.CommitWarning AS CommitWarning
, AD_Element_Trl.Created AS Created
, AD_Element_Trl.CreatedBy AS CreatedBy
, AD_Element_Trl.Updated AS Updated
, AD_Element_Trl.Description_Customized AS Description_Customized
, AD_Element_Trl.Name_Customized AS Name_Customized
, AD_Element_Trl.AD_Client_ID AS AD_Client_ID
, AD_Element_Trl.AD_Org_ID AS AD_Org_ID
, AD_Element_Trl.AD_Element_ID AS AD_Element_ID
, AD_Element_Trl.AD_Language AS AD_Language
, AD_Element_Trl.IsActive AS IsActive
, AD_Element_Trl.IsTranslated AS IsTranslated
, AD_Element_Trl.Name AS Name
, AD_Element_Trl.PrintName AS PrintName
, AD_Element_Trl.Description AS Description
, AD_Element_Trl.Help AS Help
, AD_Element_Trl.PO_Name AS PO_Name
, AD_Element_Trl.PO_PrintName AS PO_PrintName
, AD_Element_Trl.PO_Description AS PO_Description
, AD_Element_Trl.PO_Help AS PO_Help
FROM AD_Element_Trl WHERE
/* security-client / AD_Element_Trl.AD_Client_ID=0
/ security-org / AND AD_Element_Trl.AD_Org_ID=0) d446
WHERE / parent link */ AD_Language=?
ORDER BY (d446.Name) ASC NULLS LAST, (SELECT
AD_Element_Trl.Name
FROM AD_Element INNER JOIN AD_Element_TRL ON (AD_Element.AD_Element_ID=AD_Element_Trl.AD_Element_ID AND AD_Element_Trl.AD_Language=‘en_US’)
WHERE AD_Element.AD_Element_ID=d446.AD_Element_ID) ASC NULLS LAST, (SELECT
NULLIF (TRIM(AD_Language.Name), ‘’)
FROM AD_Language
WHERE AD_Language.AD_Language=d446.AD_Language) ASC NULLS LAST
SQL params: [192]] with root cause
org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 2849
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)
at org.adempiere.sql.impl.CPreparedStatementProxy.executeQuery(CPreparedStatementProxy.java:92)
at de.metas.ui.web.window.model.sql.SqlDocumentsRepository.retriveDocuments(SqlDocumentsRepository.java:177)
at de.metas.ui.web.window.model.sql.SqlDocumentsRepository.retrieveDocuments(SqlDocumentsRepository.java:141)
at de.metas.ui.web.window.model.DocumentQuery$Builder.retriveDocuments(DocumentQuery.java:204)
at de.metas.ui.web.window.model.HighVolumeReadWriteIncludedDocumentsCollection.getDocuments(HighVolumeReadWriteIncludedDocumentsCollection.java:177)
at de.metas.ui.web.window.model.Document.getIncludedDocuments(Document.java:1571)
at de.metas.ui.web.window.controller.WindowRestController.lambda$getData$4(WindowRestController.java:335)
at de.metas.ui.web.window.model.DocumentCollection.forRootDocumentReadonly(DocumentCollection.java:235)
at de.metas.ui.web.window.controller.WindowRestController.getData(WindowRestController.java:327)
at de.metas.ui.web.window.controller.WindowRestController.getIncludedTabRows(WindowRestController.java:266)
at sun.reflect.GeneratedMethodAccessor328.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1060)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:962)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:626)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at de.metas.ui.web.config.WebConfig$1.doFilter(WebConfig.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at de.metas.ui.web.CORSFilter.doFilter(CORSFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at de.metas.ui.web.config.ServletLoggingFilter.doFilter(ServletLoggingFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:141)
at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:82)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)