SAP Knowledge Base Article - Preview

2676102 - BPM system throws error "Cannot assign a >>java.lang.String<< object of length 10 to a parameter with JDBC type >>VARCHAR(5)<<"

Symptom

You are running a BPM system and you notice BPM process instances/tasks are running fine while following error throw out repeatedly in defaultTrace.*.trc log regarding DB table GLX_RRH_TEXT_CACHE, and you do not know which action trigger it.
--------------------------------------
2.0�#2018 07 02 09:24:15:016#+0800#Error#com.sap.bpem.index.impl.IndexManagerBean#
com.sap.BPM.him_im.000054#BC-BMT-BPM-DSK#sap.com/tc~bpem~index~ear#C0000A78882B8F150000000500005C47#558448551000000004#sap.com/tc~bpem~index~ear#com.sap.bpem.index.impl.IndexManagerBean#<xxxxxx>#50686#JTA Transaction : 1256243#7B7103575F6C11E8B41F00505683572C#7b7103575f6c11e8b41f00505683572c#A1E689567D9611E89BBF000021493FA8#1#Thread[HTTP Worker [@1394659135],5,Dedicated_Application_Thread]#Plain##
Exception occured while executing the weak seacrh query.
[EXCEPTION]
com.sap.bpem.base.template.TemplateException: BPM.him_base.051337: An error occured while executing the command. BPM.him_base.051328: An error occured while creating the prepared statement and assigning parameters to it. Failed to set the parameter 1 of the statement >>SELECT wt5.TIMEZONE,wt5.SHORTTEXT,wt5.LONGTEXT,wt5.LOCALE,wt5.TEXT_ID,wt5.CONTAINER_ID FROM GLX_RRH_TEXT_CACHE as wt5 WHERE wt5.LOCALE = ? AND wt5.TIMEZONE = ? AND wt5.CONTAINER_ID in (?,?)<<: Cannot assign a >>java.lang.String<< object of length 10 to a parameter with JDBC type >>VARCHAR(5)<<.
......
Caused by: com.sap.bpem.base.command.CommandException: BPM.him_base.051328: An error occured while creating the prepared statement and assigning parameters to it. Failed to set the parameter 1 of the statement >>SELECT wt5.TIMEZONE,wt5.SHORTTEXT,wt5.LONGTEXT,wt5.LOCALE,wt5.TEXT_ID,wt5.CONTAINER_ID FROM GLX_RRH_TEXT_CACHE as wt5 WHERE wt5.LOCALE = ? AND wt5.TIMEZONE = ? AND wt5.CONTAINER_ID in (?,?)<<: Cannot assign a >>java.lang.String<< object of length 10 to a parameter with JDBC type >>VARCHAR(5)<<.
......
Caused by: com.sap.sql.log.OpenSQLException: Failed to set the parameter 1 of the statement >>SELECT wt5.TIMEZONE,wt5.SHORTTEXT,wt5.LONGTEXT,wt5.LOCALE,wt5.TEXT_ID,wt5.CONTAINER_ID FROM GLX_RRH_TEXT_CACHE as wt5 WHERE wt5.LOCALE = ? AND wt5.TIMEZONE = ? AND wt5.CONTAINER_ID in (?,?)<<: Cannot assign a >>java.lang.String<< object of length 10 to a parameter with JDBC type >>VARCHAR(5)<<.
......
Caused by: com.sap.sql.check.ValueCheckerException: Cannot assign a >>java.lang.String<< object of length 10 to a parameter with JDBC type >>VARCHAR(5)<<.
at com.sap.sql.jdbc.common.dispatch.AbstractHostvariableSetter.createStetterException(AbstractHostvariableSetter.java:37)
at com.sap.sql.jdbc.common.dispatch.AbstractHostvariableSetter.checkLength(AbstractHostvariableSetter.java:310)
at com.sap.sql.jdbc.common.dispatch.VarcharHostVariable.setString(VarcharHostVariable.java:34)
at com.sap.sql.jdbc.common.dispatch.SetterDispatcherImpl.setString(SetterDispatcherImpl.java:215)
at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:596)
... 167 more
--------------------------------------


>java.lang.String<< object of length 10 to a parameter with JDBC type >>VARCHAR(5)<<""> Read more...

Environment

SAP NetWeaver Java 7.1x onwards version

Product

SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

language, com.sap.bpem.uwlconn.provider.BPEMUWLConnProviderServlet, GLX_RRH_TEXT_CACHE, LOCALE, occured, seacrh query, , KBA , BC-BMT-BPM-DSK , Process Desk , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.