0027792: Extend the log client msg column for larger strings, change its type to text

Description

See the log below captured from a test run:
Caused by: java.sql.BatchUpdateException: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296)
    at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216)
    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
    ... 50 more
2014-10-07 16:00:08,369 [TP-Processor2] ERROR org.openbravo.mobile.core.process.JSONRowConverter - Error in JSON process
org.codehaus.jettison.json.JSONException: class org.openbravo.mobile.core.utils.LogClientLoader: Could not execute JDBC batch update
    at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:42)
    at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:154)
    at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:77)
    at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:48)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:449)
    at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:92)
    at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:52)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)

Steps To Reproduce

Proposed Solution

Change the client log msg column to text

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0030650

new

Retail

Several issues with LogClient functionality

Notes
(0083857) plujan (manager) 2016-02-02 15:58	Assigning the issue to Retail team since it as been marked as unassigned

(0101865) shuehner (administrator) 2018-01-22 20:24	This is indirectly fixed by issue https://issues.openbravo.com/view.php?id=30652 [^] which removes the trigger for this issue. The underlying issue in hibernate has been reported apart in this new issue as the bug is more generic and is not restricted to logclient (but was just discovered there): https://issues.openbravo.com/view.php?id=37702 [^]

Issue History
Date Modified	Username	Field	Change
2014-10-07 18:56	mtaal	New Issue
2014-10-07 18:56	mtaal	Assigned To	=> mtaal
2014-10-07 18:56	mtaal	Triggers an Emergency Pack	=> No
2014-12-08 11:50	mtaal	Target Version	RR15Q1 => RR15Q2
2015-03-30 20:14	marvintm	Target Version	RR15Q2 => RR15Q3
2015-06-15 18:16	marvintm	Target Version	RR15Q3 => RR15Q4
2015-09-11 11:06	mtaal	Relationship added	blocks 0030650
2015-09-11 11:08	mtaal	Assigned To	mtaal =>
2015-09-11 11:08	mtaal	Target Version	RR15Q4 =>
2016-02-02 15:57	plujan	Assigned To	=> Retail
2016-02-02 15:58	plujan	Note Added: 0083857
2018-01-22 20:24	shuehner	Note Added: 0101865
2018-01-22 20:24	shuehner	Status	new => closed
2018-01-22 20:24	shuehner	Resolution	open => out of date