Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-1541

PersistenceException when logging into camunda webapp (Oracle+Websphere)

    XMLWordPrintable

Details

    Description

      Environment:
      WAS 8.0.5, Java 6, IBM J9 2.6, AIX 6.1
      Oracle 11g, AIX 6.1, ojdbc6

      org.apache.ibatis.exceptions.PersistenceException:

          1. Error querying database. Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: Invalid column type: 1111
          2. The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Authorization.xml
          3. The error may involve defaultParameterMap
          4. The error occurred while setting parameters
          5. SQL: SELECT CASE WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 1 AND A.USER_ID_ = ? AND BITAND(A.PERMS_,?)=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = ? ) THEN 1 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 1 AND A.USER_ID_ = ? AND BITAND(A.PERMS_,?)=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = '') THEN 1 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 2 AND A.USER_ID_ = ? AND BITAND(A.PERMS_,?)Unable to render embedded object: File (=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = ? ) THEN 0 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 2 AND A.USER_ID_ = ? AND BITAND(A.PERMS_,?)) not found.=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = '') THEN 0 ELSE ( SELECT CASE WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 0 AND A.USER_ID_ = '' AND BITAND(A.PERMS_,?)=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = ? ) THEN 1 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 0 AND A.USER_ID_ = '' AND BITAND(A.PERMS_,?)=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = '') THEN 1 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 0 AND A.USER_ID_ = '' AND BITAND(A.PERMS_,?)Unable to render embedded object: File (=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = ? ) THEN 0 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 0 AND A.USER_ID_ = '*' AND BITAND(A.PERMS_,?)) not found.=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = '*') THEN 0 ELSE 0 END FROM DUAL ) END FROM DUAL
          6. Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: Invalid column type: 1111
            at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
            at org.camunda.bpm.engine.impl.db.DbSqlSession.selectBoolean(DbSqlSession.java:345)
            at org.camunda.bpm.engine.impl.persistence.entity.AuthorizationManager.isAuthorized(AuthorizationManager.java:117)
            at org.camunda.bpm.engine.impl.persistence.entity.AuthorizationManager.checkAuthorization(AuthorizationManager.java:100)
            at org.camunda.bpm.engine.impl.identity.db.DbReadOnlyIdentityServiceProvider.checkAuthorization(DbReadOnlyIdentityServiceProvider.java:118)
            at org.camunda.bpm.engine.impl.identity.db.DbReadOnlyIdentityServiceProvider.findUserById(DbReadOnlyIdentityServiceProvider.java:46)
            at org.camunda.bpm.engine.impl.identity.db.DbReadOnlyIdentityServiceProvider.checkPassword(DbReadOnlyIdentityServiceProvider.java:69)
            at org.camunda.bpm.engine.impl.cmd.CheckPassword.execute(CheckPassword.java:37)
            at org.camunda.bpm.engine.impl.cmd.CheckPassword.execute(CheckPassword.java:24)
            at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
            at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
            at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Issue Links

            Activity

              People

                Unassigned Unassigned
                meyer Daniel Meyer
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Salesforce