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

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0015739

closed

alostale

In Oracle, I get an error when disabling Heartbeat

Notes
(0033824) hgbot (developer) 2011-01-24 15:09	Repository: erp/stable/2.50 Changeset: bdddf706ef62ab3434600c8b7abd0b16069e8d7d Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Mon Jan 24 12:36:49 2011 +0100 URL: http://code.openbravo.com/erp/stable/2.50/rev/bdddf706ef62ab3434600c8b7abd0b16069e8d7d [^] fixed bug 15742: In Oracle, I get an error when disabling Heartbeat --- M src-db/database/model/tables/AD_PROCESS_RUN.xml M src/org/openbravo/scheduling/ProcessRunner.java ---

(0033924) shuehner (administrator) 2011-01-27 16:43	Reviewed and testcase added to cover inserting long strings which use multiple-bytes in utf-8 encoding with clobs. Reported functionality defect not extra tested as already covered by smoketest (which was failing because of the issue this fix covers, and is not failing anymore).

Issue History
Date Modified	Username	Field	Change
2011-01-24 11:14	alostale	Type	defect => backport
2011-01-24 11:14	alostale	fix_in_branch	=> 2.50
2011-01-24 15:09	hgbot	Checkin
2011-01-24 15:09	hgbot	Note Added: 0033824
2011-01-24 15:09	hgbot	Status	scheduled => resolved
2011-01-24 15:09	hgbot	Resolution	open => fixed
2011-01-24 15:09	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.50/rev/bdddf706ef62ab3434600c8b7abd0b16069e8d7d [^]
2011-01-27 16:43	shuehner	Note Added: 0033924
2011-01-27 16:43	shuehner	Status	resolved => closed