could not read some pages of *.mdf file :/
2006/5/24, Bayliss, Barry <[EMAIL PROTECTED]>:
>
>
> 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
>
>
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
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.
