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
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.