0015739: In Oracle, I get an error when disabling Heartbeat

Description

When Smoke Test is executed in an Oracle context, the disabling does not succeed. An error is shown:
@CODE=1461@ORA-01461: can bind a LONG value only for insert into a LONG column

Steps To Reproduce

In a context with the following list of modules and heartbeat enable, try to disable it:
b3e0edee 04:21:29 [ajp-8009-5] INFO org.openbravo.erpCommon.ad_process.HeartbeatProcess - Heartbeat sending: 'orgNum=12&timeUsage=0.10800&dbVersion=11.2.0.1.0&osVersion=2.6.32-305-ec2&codeRevision=e495f2011ea5&javaVersion=1.6.0_20&loginsMoth=17&lastLogin=24-01-2011&clientNum=4&instanceNo=2799&obpsId=b3e0edee&proxyPort=&dbIdentifier=63a1267e&db=ORACLE&systemIdentifier=55ae3e37-fd7d-46d5-aaae-d8036069fb61&isproxyrequired=N&enabledCustomQuery=Y&firstLogin=23-01-2011&usageAudit=true&webserver=Apache&modules=%5B%5B%220%22%2C%223.0.9992%22%2C%22Y%22%2C%22Core%22%2C%22498%22%5D%2C%5B%22A918E3331C404B889D69AA9BFAFB23AC%22%2C%223.0.9992%22%2C%22Y%22%2C%22Advanced+Payables+and+Receivables+Mngmt%22%2C%220%22%5D%2C%5B%22AE382A667952451DBC0A058B8B58DC26%22%2C%221.0.2%22%2C%22Y%22%2C%22Advanced+Payables+and+Receivables+-+Spanish+Translation%22%2C%220%22%5D%2C%5B%228C82088A5FD5467AE040007F01011957%22%2C%221.0.2%22%2C%22Y%22%2C%22Alerts%3A+Accounting+for+APR%22%2C%220%22%5D%2C%5B%22C70732EA90A14EC0916078B85CC33D2D%22%2C%221.1.9992%22%2C%22Y%22%2C%22JBoss+Weld%22%2C%220%22%5D%2C%5B%229BA0836A3CD74EE4AB48753A47211BCC%22%2C%222.1.9992%22%2C%22Y%22%2C%22User+Interface+Application%22%2C%220%22%5D%2C%5B%22D393BE6F22BB44B7B728259B34FC795A%22%2C%221.0.9992%22%2C%22Y%22%2C%22HTML+Widget%22%2C%220%22%5D%2C%5B%224B828F4D03264080AA1D2057B13F613C%22%2C%222.1.9992%22%2C%22Y%22%2C%22User+Interface+Client+Kernel%22%2C%220%22%5D%2C%5B%222758CD25B2704AF6BBAD10365FC82C06%22%2C%222.1.9992%22%2C%22Y%22%2C%22Workspace+& Widgets","0"],["0A060B2AF1974E8EAA8DB61388E9AECC","1.0.9992","Y","Query\/List Widget","0"],["2A5EE903D7974AC298C0504FBC4501A7","3.0.9992","Y","Payment Report","0"],["509767E831EA4B39B4839A4EC4A28628","1.1.7","Y","Initial Data Load","0"],["03C3539E821343A4BF33DF63366B8B38","1.0.5","Y","Chart of accounts: PGC 2007 General","0"],["166A27B4B3A143808FB087A96D6D564A","1.0.3","Y","Chart of accounts: PGC 2007 PYMEs","0"],["273F7C5547F94524B2955DD8479B5470","1.2.24","Y","Taxes: configuration for Spain (Impuestos para España)","0"],["8BD1FE82CCEE42C28585BCDB465FAD1D","1.0.20","Y","Translation: Spanish-Spain (es_ES) español-España","0"],["FB7C1C4CF1AB405693D8AF28A0B4AA53","1.1.1","Y","Localization pack Spain (España) for APR","0"],["9E1AE8B0F21B43189F24B6F6A7604932","1.0.3","Y","Initial Data Load Extension for APRM","0"],["E40D2ACAE3634243B06F178456FBE14A","1.0.1","Y","CIF and NIF validator","0"],["109C0BBA336D49F7AC5BD4B5D75D33D8","1.0.0","Y","Validador de CIF y NIF","0"],["006239EBD30946549F68C39A55396012","1.0.3","Y","3 digits ISO country codes","0"],["19BF10F39699483AA7F095501B8E2679","1.0.2","Y","European Union countries","0"],["E04A56BB5A934F12810DE870C78CEB37","1.1.1","Y","Validador de número de cuenta financiera","0"],["DB3FB5E4B81444F7858098FE3C431794","0.0.11","Y","Spanish Tax Module Improvements","0"],["054DCE3C07C147ADBE75A415BAA7A908","0.0.5","Y","Módulo de Impuestos para España mejorado","0"],["3A3A943684D64DEF9EC39F588A656848","1.0.2","Y","Orders Awaiting Delivery","0"],["A44B9BA75C354D8FB2E3F7D6EB6BFDC4","2.1.9992","Y","JSON Datasource","0"],["F8D1B3ECB3474E8DA5C216473C840DF1","2.0.9992","Y","JSON REST Webservice","0"],["AA849E7431DF47BF89540F8918BA58E3","1.0.5","Y","Provincias de España","0"],["5EB4F15C80684ACA904756BDC12ADBE5","2.1.9992","Y","User Interface Selector","0"],["96998CBC42744B3DBEE28AC8095C9335","2.0.0","Y","2.50 to 3.00 Compatibility Skin","0"],["EC356CEE3D46416CA1EBEEB9AB82EDB9","8.1.9992","Y","Smartclient","0"],["0138E7A89B5E4DC3932462252801FFBC","3.0.9992","Y","Openbravo 3.0","0"],["883B5872CA0548F9AF2BBBE7D2DDFA61","3.0.9992","Y","Standard Roles","0"],["7E48CDD73B7E493A8BED4F7253E7C989","2.1.9992","Y","Openbravo 3.0 Framework","0"]]=&maxUsers=1&servletContainer=&os=Linux&servletContainerVersion=&rejectedLoginsDueConcUsers=0&macId=f3d785a4&webserverVersion=2.2.14&numRegisteredUsers=24&proxyServer=&isheartbeatactive=Y&instancePurpose=T&obVersion=3.0.9992CI&totalLogins=17&avgUsers=1.000&obInstallMode=From+Sources&antVersion=1.7.1&beatType=D&'
b3e0edee 04:21:29 [ajp-8009-5] ERROR org.openbravo.scheduling.ProcessRunData - SQL error in query: UPDATE AD_Process_Run SET Updated = NOW(), UpdatedBy = ?, Status = ?, End_Time = NOW(), Runtime = ?, Log = ? WHERE AD_Process_Run_ID = ?

You will get the error message:
Exception:java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

Proposed Solution

It is related to issue 0015115 with one extra problem. 4000 bytes are 4000 characters if and only if non UTF8 characters. Any UTF8 char uses two bytes.
So, in a worst case scenario, 4000 bytes are 2000 chars.

Tags

Regression QA

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0015115	closed	alostale	Disabling heartbeat is not working under some circunstances in 3.0 RC2
depends on	backport	0015742	closed	alostale	In Oracle, I get an error when disabling Heartbeat
related to	defect	0036829	closed	dmiguelez	In Monitor Tab on Process Request Window, it should be possible to see a large Log

Notes
(0033819) hgbot (developer) 2011-01-24 12:36	Repository: erp/devel/pi Changeset: e81caae0b0065e808d2077f28108dd0b6198e4f5 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Mon Jan 24 12:34:13 2011 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/e81caae0b0065e808d2077f28108dd0b6198e4f5 [^] fixed bug 15739: In Oracle, I get an error when disabling Heartbeat Changed log column from varchar2(4000 byte) to CLOB in this way there is no size restrictions. Removed log truncation done for issue 0015115, as now is no longer needed. --- M src-db/database/model/tables/AD_PROCESS_RUN.xml M src/org/openbravo/scheduling/ProcessRunner.java ---

(0033923) hgbot (developer) 2011-01-27 16:38	Repository: erp/devel/pi Changeset: 75335421281cfe910594e2caaf92e1b4e9820b22 Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Thu Jan 27 16:37:16 2011 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/75335421281cfe910594e2caaf92e1b4e9820b22 [^] Issue 15739: Add testcase to cover insertion of non-latin1 chars into clob i.e. 'ñ' which uses two bytes in utf-8 encoding. --- M src-test/org/openbravo/test/dal/IssuesTest.java ---

Issue History
Date Modified	Username	Field	Change
2011-01-24 10:24	plujan	New Issue
2011-01-24 10:24	plujan	Assigned To	=> alostale
2011-01-24 10:24	plujan	Modules	=> Core
2011-01-24 10:25	plujan	Tag Attached: Regression QA
2011-01-24 10:25	plujan	Relationship added	related to 0015115
2011-01-24 11:14	alostale	Status	new => scheduled
2011-01-24 11:14	alostale	fix_in_branch	=> pi
2011-01-24 12:36	hgbot	Checkin
2011-01-24 12:36	hgbot	Note Added: 0033819
2011-01-24 12:36	hgbot	Status	scheduled => resolved
2011-01-24 12:36	hgbot	Resolution	open => fixed
2011-01-24 12:36	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/e81caae0b0065e808d2077f28108dd0b6198e4f5 [^]
2011-01-27 16:38	hgbot	Checkin
2011-01-27 16:38	hgbot	Note Added: 0033923
2011-05-16 13:53	iperdomo	Status	resolved => closed
2018-02-09 10:58	alostale	Relationship added	related to 0036829