SQL Exception using RTCi
Hi there,
Just installed RTCi for the first time. Pretty default installation. System meets the needs of the system requirements.
All working fine, except, something appears to be wrong with quering de jazz-user-database. When openening the User-management-tab in the jazz-admin-interface nothing happens. That is, nothing happens in the user-interface. Searching a user even does not work.
When viewing the serverlog the next error appears:
00000029 SystemOut O 09:18:43,150 ERROR sqlTxLogger - Exception preparing SQL: select t1.ITEM_ID, t1.NAME_COL from JAZZ.RPSTRCNTR8 t1 where ((upper(t1.NAME_COL) like upper(cast(? as varchar(32000))) or upper(t1.EMAIL_ADDRESS) like upper(cast(? as varchar(32000))) or upper(t1.USER_ID) like upper(cast(? as varchar(32000)))) and (t1.ARCHIVED = 0) and (t1.USER_ID <> 'ADMIN') and (t1.USER_ID <> 'GUEST') and (t1.USER_ID <> 'unassigned')) order by t1.NAME_COL asc 00000029 SystemOut O 09:18:43,516 WARN sqlExceptionLogger - Syntax error or access rule violation SQL: select t1.ITEM_ID, t1.NAME_COL from JAZZ.RPSTRCNTR8 t1 where ((upper(t1.NAME_COL) like upper(cast(? as varchar(32000))) or upper(t1.EMAIL_ADDRESS) like upper(cast(? as varchar(32000))) or upper(t1.USER_ID) like upper(cast(? as varchar(32000)))) and (t1.ARCHIVED = 0) and (t1.USER_ID <> 'ADMIN') and (t1.USER_ID <> 'GUEST') and (t1.USER_ID <> 'unassigned')) order by t1.NAME_COL asc SQL Exception #1 SQL Message: CAST from DF0002 to *N not supported. SQL State: 42846 Error Code: -461 java.sql.SQLException: CAST from DF0002 to *N not supported. at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650) at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621) at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1518) at com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java:185) at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1903) at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1726) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.ConnectionStatWrapper.prepareStatement(ConnectionStatWrapper.java:272) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.ConnectionErrLogWrapper.prepareStatement(ConnectionErrLogWrapper.java:334) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.ConnectionLeakWrapper.prepareStatement(ConnectionLeakWrapper.java:223) at com.ibm.team.repository.service.internal.dataaccess.FetchRows.<init>(FetchRows.java:131) at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils$1.<init>(MediatorUtils.java:40) at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils.fetchData(MediatorUtils.java:40)
etc
Anyone familiair with this problem???
Just installed RTCi for the first time. Pretty default installation. System meets the needs of the system requirements.
All working fine, except, something appears to be wrong with quering de jazz-user-database. When openening the User-management-tab in the jazz-admin-interface nothing happens. That is, nothing happens in the user-interface. Searching a user even does not work.
When viewing the serverlog the next error appears:
00000029 SystemOut O 09:18:43,150 ERROR sqlTxLogger - Exception preparing SQL: select t1.ITEM_ID, t1.NAME_COL from JAZZ.RPSTRCNTR8 t1 where ((upper(t1.NAME_COL) like upper(cast(? as varchar(32000))) or upper(t1.EMAIL_ADDRESS) like upper(cast(? as varchar(32000))) or upper(t1.USER_ID) like upper(cast(? as varchar(32000)))) and (t1.ARCHIVED = 0) and (t1.USER_ID <> 'ADMIN') and (t1.USER_ID <> 'GUEST') and (t1.USER_ID <> 'unassigned')) order by t1.NAME_COL asc 00000029 SystemOut O 09:18:43,516 WARN sqlExceptionLogger - Syntax error or access rule violation SQL: select t1.ITEM_ID, t1.NAME_COL from JAZZ.RPSTRCNTR8 t1 where ((upper(t1.NAME_COL) like upper(cast(? as varchar(32000))) or upper(t1.EMAIL_ADDRESS) like upper(cast(? as varchar(32000))) or upper(t1.USER_ID) like upper(cast(? as varchar(32000)))) and (t1.ARCHIVED = 0) and (t1.USER_ID <> 'ADMIN') and (t1.USER_ID <> 'GUEST') and (t1.USER_ID <> 'unassigned')) order by t1.NAME_COL asc SQL Exception #1 SQL Message: CAST from DF0002 to *N not supported. SQL State: 42846 Error Code: -461 java.sql.SQLException: CAST from DF0002 to *N not supported. at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650) at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621) at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1518) at com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java:185) at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1903) at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1726) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.ConnectionStatWrapper.prepareStatement(ConnectionStatWrapper.java:272) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.ConnectionErrLogWrapper.prepareStatement(ConnectionErrLogWrapper.java:334) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.ConnectionLeakWrapper.prepareStatement(ConnectionLeakWrapper.java:223) at com.ibm.team.repository.service.internal.dataaccess.FetchRows.<init>(FetchRows.java:131) at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils$1.<init>(MediatorUtils.java:40) at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils.fetchData(MediatorUtils.java:40)
etc
Anyone familiair with this problem???
One answer
Hi Guus,
Do you have all the required PTFs? Here is the list of required PTFs for V5R4 and V6R1 and the JVM on those platforms:
IBM i 5.4
SI31547 for product 5722JC1 (IBM Toolbox for Java)
SI32280 for product 5722SS1 (IBM i)
IBM i 6.1
SI31554 for product 5761JC1 (IBM Toolbox for Java)
SI31976 for product 5761SS1 (IBM i)
IBM J2SE 5.0 32-bit JVM with the applicable Group PTF applied:
IBM i 5.4
SF99291 for product 5722JV1
IBM i 6.1
SF99562 for product 5761JV1
Note that there is a problem with the Client Access License Management page, but the Active Users and Archived Users should be available with those PTFs installed.
Do you have all the required PTFs? Here is the list of required PTFs for V5R4 and V6R1 and the JVM on those platforms:
IBM i 5.4
SI31547 for product 5722JC1 (IBM Toolbox for Java)
SI32280 for product 5722SS1 (IBM i)
IBM i 6.1
SI31554 for product 5761JC1 (IBM Toolbox for Java)
SI31976 for product 5761SS1 (IBM i)
IBM J2SE 5.0 32-bit JVM with the applicable Group PTF applied:
IBM i 5.4
SF99291 for product 5722JV1
IBM i 6.1
SF99562 for product 5761JV1
Note that there is a problem with the Client Access License Management page, but the Active Users and Archived Users should be available with those PTFs installed.
Hi there,
Just installed RTCi for the first time. Pretty default installation. System meets the needs of the system requirements.
All working fine, except, something appears to be wrong with quering de jazz-user-database. When openening the User-management-tab in the jazz-admin-interface nothing happens. That is, nothing happens in the user-interface. Searching a user even does not work.
When viewing the serverlog the next error appears:
00000029 SystemOut O 09:18:43,150 ERROR sqlTxLogger - Exception preparing SQL: select t1.ITEM_ID, t1.NAME_COL from JAZZ.RPSTRCNTR8 t1 where ((upper(t1.NAME_COL) like upper(cast(? as varchar(32000))) or upper(t1.EMAIL_ADDRESS) like upper(cast(? as varchar(32000))) or upper(t1.USER_ID) like upper(cast(? as varchar(32000)))) and (t1.ARCHIVED = 0) and (t1.USER_ID <> 'ADMIN') and (t1.USER_ID <> 'GUEST') and (t1.USER_ID <> 'unassigned')) order by t1.NAME_COL asc 00000029 SystemOut O 09:18:43,516 WARN sqlExceptionLogger - Syntax error or access rule violation SQL: select t1.ITEM_ID, t1.NAME_COL from JAZZ.RPSTRCNTR8 t1 where ((upper(t1.NAME_COL) like upper(cast(? as varchar(32000))) or upper(t1.EMAIL_ADDRESS) like upper(cast(? as varchar(32000))) or upper(t1.USER_ID) like upper(cast(? as varchar(32000)))) and (t1.ARCHIVED = 0) and (t1.USER_ID <> 'ADMIN') and (t1.USER_ID <> 'GUEST') and (t1.USER_ID <> 'unassigned')) order by t1.NAME_COL asc SQL Exception #1 SQL Message: CAST from DF0002 to *N not supported. SQL State: 42846 Error Code: -461 java.sql.SQLException: CAST from DF0002 to *N not supported. at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650) at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621) at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1518) at com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java:185) at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1903) at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1726) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.ConnectionStatWrapper.prepareStatement(ConnectionStatWrapper.java:272) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.ConnectionErrLogWrapper.prepareStatement(ConnectionErrLogWrapper.java:334) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.ConnectionLeakWrapper.prepareStatement(ConnectionLeakWrapper.java:223) at com.ibm.team.repository.service.internal.dataaccess.FetchRows.<init>(FetchRows.java:131) at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils$1.<init>(MediatorUtils.java:40) at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils.fetchData(MediatorUtils.java:40)
etc
Anyone familiair with this problem???