How to overcome "Failure getting record lock on a record from table"?
<p>I am running a query using <code>OpenQuery</code> and getting a peculiar error.</p>

<p>This is my query:</p>

<pre class="lang-sql prettyprint-override"><code>select * from OpenQuery("CAPITAOC",'SELECT per.*
    FROM pub."re-tenancy" AS t 
       INNER JOIN pub."re-tncy-person" AS per
       ON t."tncy-sys-ref" = per."tncy-sys-ref" 
       INNER JOIN pub."re-tncy-place" AS place
       ON t."tncy-sys-ref" = place."tncy-sys-ref"
    WHERE t."tncy-status" = ''CUR'' and place."place-ref"=''GALL01000009''') 
</code></pre>

<p>This is the error message:</p>

<blockquote>
  <p>OLE DB provider "MSDASQL" for linked server "CAPITAOC" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Failure getting record lock on a record from table PUB.RE-TNCY-PERSON.".
  OLE DB provider "MSDASQL" for linked server "CAPITAOC" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Error in row.".
  Msg 7330, Level 16, State 2, Line 1
  Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "CAPITAOC".</p>
</blockquote>

<p>How do I read this data?</p>