You will have to monitor ur sql server box it is most likely that the
box is running out of CPU or RAM.
regards
harry
This posting is provided "AS IS" with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm"
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.
> -----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.CURRENCY
CO
> DE,
>
A.DELPOSSIBLECASHDISC,A.DELUTILIZEDCASHDISC,A.DELCASHDISCDATE,A.DUEDAT
E,
>
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.PAYMM
ET
> HOD,
>
A.CASHPAYMENT,A.CONTROLNUM,A.DELIVERYMODE,A.POSTINGPROFILE,A.OFFSETREC
ID
> ,
> A.EUROTRIANGULATION,A.ORDERACCOUNT,A.CASHDISCCODE,A.PREPAYMENT,
> A.DEL_EXCHADJUSTMENTTOTAL,A.PAYMSPEC,A.CUSTEXCHADJUSTMENTREALIZED,
>
A.CUSTEXCHADJUSTMENTUNREALIZED,A.OCRLINE,A.PAYMMANLACKDATE,A.PAYMMANBA
TC
> H,
>
A.PAYMID,A.BILLOFEXCHANGEID,A.BILLOFEXCHANGESTATUS,A.BILLOFEXCHANGESEQ
NU
> M,
>
A.BANKREMITTANCEFILEID,A.COLLECTIONLETTERCODE,A.INVOICENUMBER,A.MODIFI
ED
> 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.
