Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015739Openbravo ERPA. Platformpublic2011-01-24 10:242011-05-16 13:53
Reporterplujan 
Assigned Toalostale 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015739: In Oracle, I get an error when disabling Heartbeat
DescriptionWhen 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 ReproduceIn 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 SolutionIt 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
TagsRegression QA
Relationships
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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-01-24 10:24plujanNew Issue
2011-01-24 10:24plujanAssigned To => alostale
2011-01-24 10:24plujanModules => Core
2011-01-24 10:24plujanOBNetwork customer => No
2011-01-24 10:25plujanTag Attached: Regression QA
2011-01-24 10:25plujanRelationship addedrelated to 0015115
2011-01-24 11:14alostaleStatusnew => scheduled
2011-01-24 11:14alostalefix_in_branch => pi
2011-01-24 12:36hgbotCheckin
2011-01-24 12:36hgbotNote Added: 0033819
2011-01-24 12:36hgbotStatusscheduled => resolved
2011-01-24 12:36hgbotResolutionopen => fixed
2011-01-24 12:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e81caae0b0065e808d2077f28108dd0b6198e4f5 [^]
2011-01-27 16:38hgbotCheckin
2011-01-27 16:38hgbotNote Added: 0033923
2011-05-16 13:53iperdomoStatusresolved => closed
2018-02-09 10:58alostaleRelationship addedrelated to 0036829

Notes
(0033819)
hgbot   
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   
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
---