TEXT read can be very slow in Landmark ladb.log

 0 Replies
 0 Subscribed to this topic
 32 Subscribed to this forum
Sort:
Author
Messages
Mark Larochelle
Basic Member Send Private Message
Posts: 9
Basic Member

Since upgrading to Landmark/LTM 11 a few years ago, the ladb.log constantly fills up with messages like this:

*** Begin Database Error Message *** 2022-01-16T10:51:16.46-05 tenant 'GEN', data area 'lawtaprd', program 'ControllerServlet', user 'Anonymous'

java.lang.Exception: WARNING: CODE ISSUE Repositioning TEXT read can be very slow. Class(JobPosting) Field(PositionDescription) positioned at (0) repositioning to (65536)     at com.lawson.lajavarts.dbi.DBIField$DBIReader.positionTo(DBIField.java:624)     at com.lawson.lajavarts.dbi.DBIField.getSubstring(DBIField.java:2014)     at com.lawson.rdtech.opf.PShadow.getClobSubstring(PShadow.java:7624)     at com.lawson.rdtech.opf.PLobObjectLocator.getSubstring(PLobObjectLocator.java:293)     at com.lawson.rdtech.type.CLOBObject.getSubstring(CLOBObject.java:113)     at com.lawson.rdtech.framework.AbstractBusinessTask.getClobSubstring(AbstractBusinessTask.java:1496)     at com.lawson.rdtech.gridadapter.ldt.GridContainer.getClobSubstring(GridContainer.java:1806)     at com.lawson.rdtech.gridadapter.ldt.IServiceImpl.getClobSubstring(IServiceImpl.java:3333)     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)     at java.lang.reflect.Method.invoke(Method.java:498)     at com.lawson.grid.proxy.ProxyServerImpl$ProxyRequestThread.invoke(ProxyServerImpl.java:3246)     at com.lawson.grid.proxy.ProxyServerImpl$ProxyRequestThread.processRequest(ProxyServerImpl.java:2978)     at com.lawson.grid.proxy.ProxyServerImpl$ProxyRequestThread.runThread(ProxyServerImpl.java:2901)     at com.lawson.grid.util.thread.PooledThread.run(PooledThread.java:135)     at java.lang.Thread.run(Thread.java:748)

*** End Database Error Message ***

 

Is anyone else dealing with this?  Thanks,

 

Mark Larochelle State of NH ERP Technical Lead.