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


Read >java.lang.String<< object of length 10 to a parameter with JDBC type >>VARCHAR(5)<<"">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 ONE Support launchpad (Login required).

Search for additional results

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