java.lang.IllegalArgumentException: given string [SELECT count(*) FROM foo_foo WHERE stubValue1=49.277965 AND stubValue2=-123.110181 AND stubDate='2014-03-21' AND stubHour=19 AND stubHourOrdinal=0;] is not a valid quoted or unquoted identifier at org.springframework.cassandra.core.cql.CqlIdentifier.setIdentifier(CqlIdentifier.java:126) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:106) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:89) at org.springframework.cassandra.core.cql.CqlIdentifier.cqlId(CqlIdentifier.java:44)

Spring JIRA | Colin McQueen | 3 years ago
  1. 0

    I found an issue with the exists method call, in the code in the CQLTemplate for the count method the parameter says tableName but the value is a CQL statement. Here's the stacktrace that I got: {code} java.lang.IllegalArgumentException: given string [SELECT count(*) FROM foo_foo WHERE stubValue1=49.277965 AND stubValue2=-123.110181 AND stubDate='2014-03-21' AND stubHour=19 AND stubHourOrdinal=0;] is not a valid quoted or unquoted identifier at org.springframework.cassandra.core.cql.CqlIdentifier.setIdentifier(CqlIdentifier.java:126) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:106) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:89) at org.springframework.cassandra.core.cql.CqlIdentifier.cqlId(CqlIdentifier.java:44) at org.springframework.cassandra.core.CqlTemplate.count(CqlTemplate.java:1120) at org.springframework.data.cassandra.core.CassandraTemplate.exists(CassandraTemplate.java:120) at org.springframework.data.cassandra.repository.support.SimpleCassandraRepository.exists(SimpleCassandraRepository.java:74) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:358) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:343) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy660.exists(Unknown Source) {code}

    Spring JIRA | 3 years ago | Colin McQueen
    java.lang.IllegalArgumentException: given string [SELECT count(*) FROM foo_foo WHERE stubValue1=49.277965 AND stubValue2=-123.110181 AND stubDate='2014-03-21' AND stubHour=19 AND stubHourOrdinal=0;] is not a valid quoted or unquoted identifier at org.springframework.cassandra.core.cql.CqlIdentifier.setIdentifier(CqlIdentifier.java:126) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:106) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:89) at org.springframework.cassandra.core.cql.CqlIdentifier.cqlId(CqlIdentifier.java:44)
  2. 0

    I found an issue with the exists method call, in the code in the CQLTemplate for the count method the parameter says tableName but the value is a CQL statement. Here's the stacktrace that I got: {code} java.lang.IllegalArgumentException: given string [SELECT count(*) FROM foo_foo WHERE stubValue1=49.277965 AND stubValue2=-123.110181 AND stubDate='2014-03-21' AND stubHour=19 AND stubHourOrdinal=0;] is not a valid quoted or unquoted identifier at org.springframework.cassandra.core.cql.CqlIdentifier.setIdentifier(CqlIdentifier.java:126) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:106) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:89) at org.springframework.cassandra.core.cql.CqlIdentifier.cqlId(CqlIdentifier.java:44) at org.springframework.cassandra.core.CqlTemplate.count(CqlTemplate.java:1120) at org.springframework.data.cassandra.core.CassandraTemplate.exists(CassandraTemplate.java:120) at org.springframework.data.cassandra.repository.support.SimpleCassandraRepository.exists(SimpleCassandraRepository.java:74) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:358) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:343) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy660.exists(Unknown Source) {code}

    Spring JIRA | 3 years ago | Colin McQueen
    java.lang.IllegalArgumentException: given string [SELECT count(*) FROM foo_foo WHERE stubValue1=49.277965 AND stubValue2=-123.110181 AND stubDate='2014-03-21' AND stubHour=19 AND stubHourOrdinal=0;] is not a valid quoted or unquoted identifier at org.springframework.cassandra.core.cql.CqlIdentifier.setIdentifier(CqlIdentifier.java:126) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:106) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:89) at org.springframework.cassandra.core.cql.CqlIdentifier.cqlId(CqlIdentifier.java:44)
  3. 0

    GitHub comment 1106#164009956

    GitHub | 12 months ago | MaPePeR
    java.lang.IllegalArgumentException: Invalid Item with itemName = StopGap:stopgap [16:03:17] [Server thread/INFO] [STDERR/ProjectE]: [java.lang.Throwable$WrappedPrintStream:println:-1]: at moze_intel.projecte.emc.NormalizedSimpleStack$NSSItem.<init>(NormalizedSimpleStack.java:115) [16:03:17] [Server thread/INFO] [STDERR/ProjectE]: [java.lang.Throwable$WrappedPrintStream:println:-1]: at moze_intel.projecte.emc.NormalizedSimpleStack$NSSItem.<init>(NormalizedSimpleStack.java:109) [16:03:17] [Server thread/INFO] [STDERR/ProjectE]: [java.lang.Throwable$WrappedPrintStream:println:-1]: at moze_intel.projecte.emc.NormalizedSimpleStack.getFor(NormalizedSimpleStack.java:25) [16:03:17] [Server thread/INFO] [STDERR/ProjectE]: [java.lang.Throwable$WrappedPrintStream:println:-1]: at moze_intel.projecte.emc.NormalizedSimpleStack.getFor(NormalizedSimpleStack.java:56) [16:03:17] [Server thread/INFO] [STDERR/ProjectE]: [java.lang.Throwable$WrappedPrintStream:println:-1]: at moze_intel.projecte.emc.NormalizedSimpleStack.getFor(NormalizedSimpleStack.java:50) [16:03:17] [Server thread/INFO] [STDERR/ProjectE]: [java.lang.Throwable$WrappedPrintStream:println:-1]: at moze_intel.projecte.emc.NormalizedSimpleStack.getFor(NormalizedSimpleStack.java:63) [16:03:17] [Server thread/INFO] [STDERR/ProjectE]: [java.lang.Throwable$WrappedPrintStream:println:-1]: at moze_intel.projecte.emc.mappers.CraftingMapper.addMappings(CraftingMapper.java:44) [16:03:17] [Server thread/INFO] [STDERR/ProjectE]: [java.lang.Throwable$WrappedPrintStream:println:-1]: at moze_intel.projecte.emc.EMCMapper.map(EMCMapper.java:98) ``` StopGap is the problem here. It registers its items/blocks in a weird way. EDIT: This is fixed with 2.0.6 of StopGap, though! This is also in the log and an indicator for what is causing problems: ``` [16:04:21] [Client thread/DEBUG] [INpureCullingEngine/]: StopGap:stopgap:BlockFlint has a bad registry name! Attempting to parse and reassemble correctly... [16:04:21] [Client thread/DEBUG] [INpureCullingEngine/]: Parsed bad name into: modid: StopGap, name: stopgap:BlockFlint. If this is not correct please report it as a bug! [16:04:21] [Client thread/WARN] [INpureCullingEngine/]: The mod StopGap is registering items or blocks with bad registry names. Names should not contain multiple colons as it breaks the ability to do reverse-lookups through FML. Please tell whoever made this mod that this should be changed! [16:04:21] [Client thread/DEBUG] [INpureCullingEngine/]: StopGap:stopgap:ingotRed has a bad registry name! Attempting to parse and reassemble correctly... [16:04:21] [Client thread/DEBUG] [INpureCullingEngine/]: Parsed bad name into: modid: StopGap, name: stopgap:ingotRed. If this is not correct please report it as a bug! [15:56:05] [Client thread/TRACE] [StopGap/StopGap]: Sending event FMLPreInitializationEvent to mod StopGap *************************************** Illegal extra prefix stopgap for name stopgap:BlockFlint, invalid registry invocation/invalid name?
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Monitor visibilty tab can generate QuerySyntaxException (postgres database resource)

    https://bugzilla.redhat.com/bugzilla/ | 9 years ago | Jay Shaughnessy
    java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [ SELECT oob.schedule.id,count(*) FROM org.rhq.core.domain.measurement.oob.MeasurementOutOfBounds oob WHERE oob.occurred BETWEEN :begin AND :end AND oob.schedule.id IN ( ) GROUP BY oob.schedule.id] at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:616)
  6. 0

    ImageJ - .lif files on Imagej error

    nabble.com | 1 year ago
    java.lang.IllegalArgumentException: 0 must not be null and positive. at > ome.xml.model.primitives.PositiveInteger.<init>(PositiveInteger.java:56)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.IllegalArgumentException

      given string [SELECT count(*) FROM foo_foo WHERE stubValue1=49.277965 AND stubValue2=-123.110181 AND stubDate='2014-03-21' AND stubHour=19 AND stubHourOrdinal=0;] is not a valid quoted or unquoted identifier at org.springframework.cassandra.core.cql.CqlIdentifier.setIdentifier(CqlIdentifier.java:126) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:106) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:89) at org.springframework.cassandra.core.cql.CqlIdentifier.cqlId(CqlIdentifier.java:44)

      at org.springframework.cassandra.core.CqlTemplate.count()
    2. Spring CQL
      CqlTemplate.count
      1. org.springframework.cassandra.core.CqlTemplate.count(CqlTemplate.java:1120)
      1 frame
    3. Spring Data Cassandra - Core
      SimpleCassandraRepository.exists
      1. org.springframework.data.cassandra.core.CassandraTemplate.exists(CassandraTemplate.java:120)
      2. org.springframework.data.cassandra.repository.support.SimpleCassandraRepository.exists(SimpleCassandraRepository.java:74)
      2 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    5. Spring Data Core
      RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke
      1. org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:358)
      2. org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:343)
      2 frames
    6. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    7. com.sun.proxy
      $Proxy660.exists
      1. com.sun.proxy.$Proxy660.exists(Unknown Source)
      1 frame