It's all about the answers!

Ask a question

SQL Exception using RTCi


Guus Weisscher (322) | asked Jan 27 '09, 6:37 a.m.
retagged Jun 23 '12, 5:32 p.m. by Arne Bister (2.6k12832)
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???

One answer



permanent link
Kushal Munir (126103) | answered Jan 27 '09, 10:08 a.m.
JAZZ DEVELOPER
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.

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???

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.