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
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.
SAP Knowledge Base Article - Preview