org.molgenis.data.MolgenisDataException: Attribute [id] query value is of type [String] instead of [Integer]

GitHub | fdlk | 6 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Filtering on xref with INT id fails

    GitHub | 6 months ago | fdlk
    org.molgenis.data.MolgenisDataException: Attribute [id] query value is of type [String] instead of [Integer]

    Root Cause Analysis

    1. org.molgenis.data.MolgenisDataException

      Attribute [id] query value is of type [String] instead of [Integer]

      at org.molgenis.data.postgresql.PostgreSqlUtils.getPostgreSqlQueryValue()
    2. org.molgenis.data
      DataServiceImpl$$FastClassBySpringCGLIB$$2e5f77dc.invoke
      1. org.molgenis.data.postgresql.PostgreSqlUtils.getPostgreSqlQueryValue(PostgreSqlUtils.java:192)[molgenis-data-postgresql-2.0.0-SNAPSHOT.jar:na]
      2. org.molgenis.data.postgresql.PostgreSqlQueryGenerator.getSqlWhere(PostgreSqlQueryGenerator.java:575)[molgenis-data-postgresql-2.0.0-SNAPSHOT.jar:na]
      3. org.molgenis.data.postgresql.PostgreSqlQueryGenerator.getSqlCount(PostgreSqlQueryGenerator.java:370)[molgenis-data-postgresql-2.0.0-SNAPSHOT.jar:na]
      4. org.molgenis.data.postgresql.PostgreSqlRepository.count(PostgreSqlRepository.java:139)[molgenis-data-postgresql-2.0.0-SNAPSHOT.jar:na]
      5. org.molgenis.data.AbstractRepositoryDecorator.count(AbstractRepositoryDecorator.java:67)[molgenis-data-2.0.0-SNAPSHOT.jar:na]
      6. org.molgenis.data.AbstractRepositoryDecorator.count(AbstractRepositoryDecorator.java:67)[molgenis-data-2.0.0-SNAPSHOT.jar:na]
      7. org.molgenis.data.elasticsearch.IndexedRepositoryDecorator.count(IndexedRepositoryDecorator.java:231)[molgenis-data-elasticsearch-2.0.0-SNAPSHOT.jar:na]
      8. org.molgenis.data.AbstractRepositoryDecorator.count(AbstractRepositoryDecorator.java:67)[molgenis-data-2.0.0-SNAPSHOT.jar:na]
      9. org.molgenis.data.EntityReferenceResolverDecorator.count(EntityReferenceResolverDecorator.java:67)[molgenis-data-2.0.0-SNAPSHOT.jar:na]
      10. org.molgenis.data.listeners.EntityListenerRepositoryDecorator.count(EntityListenerRepositoryDecorator.java:86)[molgenis-data-2.0.0-SNAPSHOT.jar:na]
      11. org.molgenis.data.validation.RepositoryValidationDecorator.count(RepositoryValidationDecorator.java:138)[molgenis-data-validation-2.0.0-SNAPSHOT.jar:na]
      12. org.molgenis.data.AutoValueRepositoryDecorator.count(AutoValueRepositoryDecorator.java:117)[molgenis-data-2.0.0-SNAPSHOT.jar:na]
      13. org.molgenis.data.RepositorySecurityDecorator.count(RepositorySecurityDecorator.java:76)[molgenis-data-2.0.0-SNAPSHOT.jar:na]
      14. org.molgenis.data.support.DataServiceImpl.count(DataServiceImpl.java:61)[molgenis-data-2.0.0-SNAPSHOT.jar:na]
      15. org.molgenis.data.support.DataServiceImpl$$FastClassBySpringCGLIB$$2e5f77dc.invoke(<generated>)[spring-core-4.1.8.RELEASE.jar:na]
      15 frames
    3. Spring Core
      MethodProxy.invoke
      1. org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)[spring-core-4.1.8.RELEASE.jar:4.1.8.RELEASE]
      1 frame
    4. Spring AOP
      CglibAopProxy$DynamicAdvisedInterceptor.intercept
      1. org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:649)[spring-aop-4.1.8.RELEASE.jar:4.1.8.RELEASE]
      1 frame
    5. org.molgenis.data
      RestControllerV2.retrieveEntityCollection
      1. org.molgenis.data.support.DataServiceImpl$$EnhancerBySpringCGLIB$$4cb2cc46.count(<generated>)[spring-core-4.1.8.RELEASE.jar:na]
      2. org.molgenis.data.rest.v2.RestControllerV2.createEntityCollectionResponse(RestControllerV2.java:602)[molgenis-data-rest-2.0.0-SNAPSHOT.jar:na]
      3. org.molgenis.data.rest.v2.RestControllerV2.retrieveEntityCollection(RestControllerV2.java:223)[molgenis-data-rest-2.0.0-SNAPSHOT.jar:na]
      3 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_91]
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[na:1.8.0_91]
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.8.0_91]
      4. java.lang.reflect.Method.invoke(Method.java:498)[na:1.8.0_91]
      4 frames
    7. Spring
      InvocableHandlerMethod.invokeForRequest
      1. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)[spring-web-4.1.8.RELEASE.jar:4.1.8.RELEASE]
      2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)[spring-web-4.1.8.RELEASE.jar:4.1.8.RELEASE]
      2 frames
    8. Spring MVC
      FrameworkServlet.doGet
      1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)[spring-webmvc-4.1.8.RELEASE.jar:4.1.8.RELEASE]
      2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:775)[spring-webmvc-4.1.8.RELEASE.jar:4.1.8.RELEASE]
      3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705)[spring-webmvc-4.1.8.RELEASE.jar:4.1.8.RELEASE]
      4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)[spring-webmvc-4.1.8.RELEASE.jar:4.1.8.RELEASE]
      5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)[spring-webmvc-4.1.8.RELEASE.jar:4.1.8.RELEASE]
      6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)[spring-webmvc-4.1.8.RELEASE.jar:4.1.8.RELEASE]
      7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)[spring-webmvc-4.1.8.RELEASE.jar:4.1.8.RELEASE]
      8. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:858)[spring-webmvc-4.1.8.RELEASE.jar:4.1.8.RELEASE]
      8 frames