Ieva,
It is my understanding that the data in the table you were examining has
changed. The process you use to examine the data has not placed a lock
on the table.
In this case you are examining a transactions table, and data has either
been modified, inserted or deleted.
Barry.
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Ieva Romancike
Sent: Tuesday, 23 May 2006 6:18 PM
To: [email protected]
Subject: [development-axapta] Could not continue scan with NOLOCK due to
data movement.
Hi all,
I have a problem when reading data from CustTrans.
When I try to view Customer Transactions form, I get error:
Cannot select a record in Customer transactions (CustTrans). Voucher: ,
.The
SQL database has issued an error.
SQL error description: [Microsoft][ODBC SQL Server Driver][SQL
Server]Could
not continue scan with NOLOCK due to data movement.
SQL statement: SELECT
A.ACCOUNTNUM,A.TRANSDATE,A.VOUCHER,A.INVOICE,A.TXT,
A.AMOUNTCUR,A.SETTLEAMOUNTCUR,A.AMOUNTMST,A.SETTLEAMOUNTMST,A.CURRENCYCO
DE,
A.DELPOSSIBLECASHDISC,A.DELUTILIZEDCASHDISC,A.DELCASHDISCDATE,A.DUEDATE,
A.LASTSETTLEVOUCHER,A.LASTSETTLEDATE,A.CLOSED,A.TRANSTYPE,A.APPROVEDBY,
A.APPROVED,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.EXCHADJUSTMENT,
A.DOCUMENTNUM,A.DOCUMENTDATE,A.LASTEXCHADJ,A.CORRECT,A.SETTLEMENT,
A.DEL_OPENTRANS,A.INTEREST,A.COLLECTIONLETTER,A.POSTINGPROFILECLOSE,
A.FROMACCOUNT,A.TOACCOUNT,A.DELOPEN,A.PAYMMODE,A.PAYMREFERENCE,A.PAYMMET
HOD,
A.CASHPAYMENT,A.CONTROLNUM,A.DELIVERYMODE,A.POSTINGPROFILE,A.OFFSETRECID
,
A.EUROTRIANGULATION,A.ORDERACCOUNT,A.CASHDISCCODE,A.PREPAYMENT,
A.DEL_EXCHADJUSTMENTTOTAL,A.PAYMSPEC,A.CUSTEXCHADJUSTMENTREALIZED,
A.CUSTEXCHADJUSTMENTUNREALIZED,A.OCRLINE,A.PAYMMANLACKDATE,A.PAYMMANBATC
H,
A.PAYMID,A.BILLOFEXCHANGEID,A.BILLOFEXCHANGESTATUS,A.BILLOFEXCHANGESEQNU
M,
A.BANKREMITTANCEFILEID,A.COLLECTIONLETTERCODE,A.INVOICENUMBER,A.MODIFIED
DATE
,A.MODIFIEDTIME,A.MODIFIEDBY,A.MODIFIEDTRANSACTIONID,A.CREATEDDATE,
A.CREATEDTIME,A.CREATEDBY,A.CREATEDTRANSACTIONID,A.RECID FROM CUSTTRANS
A
WHERE ((DATAAREAID=?) AND (ACCOUNTNUM=?)) ORDER BY A.DATAAREAID DESC,
A.ACCOUNTNUM DESC,A.TRANSDATE DESC OPTION(FAST 1)
This problem occurs only with some costomers!
Can anybody tell me how to solve this problem, please?.. And why does it
occur?..
Regards,
Ieva Romancike
[Non-text portions of this message have been removed]
Yahoo! Groups Links
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
