org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND A0.MBR_ID = '4161901639') AND A0.MBR_TYP_CD = 'P'' at line 1

Kuali JIRA | Samuel Wong | 4 years ago
  1. 0

    Unable to inactivate Person. Throwing an exception in the post processing of the doc. *RoleDaoOjb.getRolePrincipalsForPrincipalIdAndRoleIds() should check for empty collection.* {code} aught exception while handling route status change org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND A0.MBR_ID = '4161901639') AND A0.MBR_TYP_CD = 'P'' at line 1 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193) at org.kuali.rice.kim.impl.role.RoleDaoOjb.getRolePrincipalsForPrincipalIdAndRoleIds(RoleDaoOjb.java:95) at org.kuali.rice.kim.impl.role.RoleServiceBase.getRoleMemberBoList(RoleServiceBase.java:143) at org.kuali.rice.kim.impl.role.RoleServiceBase.getStoredRolePrincipalsForPrincipalIdAndRoleIds(RoleServiceBase.java:161) at org.kuali.rice.kim.impl.role.RoleInternalServiceImpl.inactivatePrincipalRoleMemberships(RoleInternalServiceImpl.java:112) at org.kuali.rice.kim.impl.role.RoleInternalServiceImpl.principalInactivated(RoleInternalServiceImpl.java:42) at org.kuali.rice.kim.service.impl.UiDocumentServiceImpl.saveEntityPerson(UiDocumentServiceImpl.java:263) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) {code}

    Kuali JIRA | 4 years ago | Samuel Wong
    org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND A0.MBR_ID = '4161901639') AND A0.MBR_TYP_CD = 'P'' at line 1
  2. 0

    Unable to inactivate Person. Throwing an exception in the post processing of the doc. *RoleDaoOjb.getRolePrincipalsForPrincipalIdAndRoleIds() should check for empty collection.* {code} aught exception while handling route status change org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND A0.MBR_ID = '4161901639') AND A0.MBR_TYP_CD = 'P'' at line 1 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193) at org.kuali.rice.kim.impl.role.RoleDaoOjb.getRolePrincipalsForPrincipalIdAndRoleIds(RoleDaoOjb.java:95) at org.kuali.rice.kim.impl.role.RoleServiceBase.getRoleMemberBoList(RoleServiceBase.java:143) at org.kuali.rice.kim.impl.role.RoleServiceBase.getStoredRolePrincipalsForPrincipalIdAndRoleIds(RoleServiceBase.java:161) at org.kuali.rice.kim.impl.role.RoleInternalServiceImpl.inactivatePrincipalRoleMemberships(RoleInternalServiceImpl.java:112) at org.kuali.rice.kim.impl.role.RoleInternalServiceImpl.principalInactivated(RoleInternalServiceImpl.java:42) at org.kuali.rice.kim.service.impl.UiDocumentServiceImpl.saveEntityPerson(UiDocumentServiceImpl.java:263) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) {code}

    Kuali JIRA | 4 years ago | Samuel Wong
    org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND A0.MBR_ID = '4161901639') AND A0.MBR_TYP_CD = 'P'' at line 1
  3. 0

    The following lookups fail when running on Oracle. CalendarEntries Earn Code Group Daily Overtime Rule Timesheet Initiate Account Chart Object Code Organization Project Code Sub Account Sub Object Code Clock Log Time Block Time Block History ******************Stack Trace-Only shown when not in production***************** org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00920: invalid relational operator at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193) at org.kuali.rice.krad.dao.impl.LookupDaoOjb.executeSearch(LookupDaoOjb.java:178) at org.kuali.rice.krad.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:71) at org.kuali.rice.krad.dao.proxy.LookupDaoProxy.findCollectionBySearchHelper(LookupDaoProxy.java:120) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy85.findCollectionBySearchHelper(Unknown Source) at org.kuali.rice.krad.service.impl.LookupServiceImpl.findCollectionBySearchHelper(LookupServiceImpl.java:59) at org.kuali.rice.kns.lookup.KualiLookupableHelperServiceImpl.getSearchResultsHelper(KualiLookupableHelperServiceImpl.java:361) at org.kuali.rice.kns.lookup.KualiLookupableHelperServiceImpl.getSearchResults(KualiLookupableHelperServiceImpl.java:60) at org.kuali.rice.kns.lookup.AbstractLookupableHelperServiceImpl.performLookup(AbstractLookupableHelperServiceImpl.java:1100) at sun.reflect.GeneratedMethodAccessor427.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) at $Proxy95.performLookup(Unknown Source) at org.kuali.rice.kns.lookup.KualiLookupableImpl.performLookup(KualiLookupableImpl.java:307)

    Kuali JIRA | 4 years ago | Kristina Taylor
    org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00920: invalid relational operator
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    The following lookups fail when running on Oracle. CalendarEntries Earn Code Group Daily Overtime Rule Timesheet Initiate Account Chart Object Code Organization Project Code Sub Account Sub Object Code Clock Log Time Block Time Block History ******************Stack Trace-Only shown when not in production***************** org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00920: invalid relational operator at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193) at org.kuali.rice.krad.dao.impl.LookupDaoOjb.executeSearch(LookupDaoOjb.java:178) at org.kuali.rice.krad.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:71) at org.kuali.rice.krad.dao.proxy.LookupDaoProxy.findCollectionBySearchHelper(LookupDaoProxy.java:120) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy85.findCollectionBySearchHelper(Unknown Source) at org.kuali.rice.krad.service.impl.LookupServiceImpl.findCollectionBySearchHelper(LookupServiceImpl.java:59) at org.kuali.rice.kns.lookup.KualiLookupableHelperServiceImpl.getSearchResultsHelper(KualiLookupableHelperServiceImpl.java:361) at org.kuali.rice.kns.lookup.KualiLookupableHelperServiceImpl.getSearchResults(KualiLookupableHelperServiceImpl.java:60) at org.kuali.rice.kns.lookup.AbstractLookupableHelperServiceImpl.performLookup(AbstractLookupableHelperServiceImpl.java:1100) at sun.reflect.GeneratedMethodAccessor427.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) at $Proxy95.performLookup(Unknown Source) at org.kuali.rice.kns.lookup.KualiLookupableImpl.performLookup(KualiLookupableImpl.java:307)

    Kuali JIRA | 4 years ago | Kristina Taylor
    org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00920: invalid relational operator
  6. 0

    org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'A0.ALLOW_NEGATIVE_ACC_BALANCE' in 'field list' at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193) at org.kuali.rice.kns.dao.impl.LookupDaoOjb.executeSearch(LookupDaoOjb.java:164) at org.kuali.rice.kns.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:77) at org.kuali.rice.kns.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:63) at org.kuali.rice.kns.dao.proxy.LookupDaoProxy.findCollectionBySearchHelper(LookupDaoProxy.java:117) at sun.reflect.GeneratedMethodAccessor461.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) ...

    Kuali JIRA | 5 years ago | Mindi Balmer
    org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'A0.ALLOW_NEGATIVE_ACC_BALANCE' in 'field list'

    1 unregistered visitors
    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. org.springframework.jdbc.BadSqlGrammarException

      OJB operation; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND A0.MBR_ID = '4161901639') AND A0.MBR_TYP_CD = 'P'' at line 1

      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate()
    2. Spring Framework
      AbstractFallbackSQLExceptionTranslator.translate
      1. org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
      2. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      2 frames
    3. org.springmodules.orm
      PersistenceBrokerTemplate.getCollectionByQuery
      1. org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107)
      2. org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89)
      3. org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144)
      4. org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162)
      5. org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193)
      5 frames
    4. org.kuali.rice
      UiDocumentServiceImpl.saveEntityPerson
      1. org.kuali.rice.kim.impl.role.RoleDaoOjb.getRolePrincipalsForPrincipalIdAndRoleIds(RoleDaoOjb.java:95)
      2. org.kuali.rice.kim.impl.role.RoleServiceBase.getRoleMemberBoList(RoleServiceBase.java:143)
      3. org.kuali.rice.kim.impl.role.RoleServiceBase.getStoredRolePrincipalsForPrincipalIdAndRoleIds(RoleServiceBase.java:161)
      4. org.kuali.rice.kim.impl.role.RoleInternalServiceImpl.inactivatePrincipalRoleMemberships(RoleInternalServiceImpl.java:112)
      5. org.kuali.rice.kim.impl.role.RoleInternalServiceImpl.principalInactivated(RoleInternalServiceImpl.java:42)
      6. org.kuali.rice.kim.service.impl.UiDocumentServiceImpl.saveEntityPerson(UiDocumentServiceImpl.java:263)
      6 frames
    5. Java RT
      NativeMethodAccessorImpl.invoke0
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      1 frame