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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0015742

Openbravo ERP

A. Platform

public

2011-01-24 10:24

2011-01-27 16:43

Reporter

plujan

Assigned To

alostale

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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.

Additional Information