Subject | Re: [IBO] E_Record_Not_Located_For_Update error |
---|---|
Author | Jason Wharton |
Post date | 2001-06-25T19:37:27Z |
You have turned SearchedEdits to false. If you set this to true it will use
either the primary key or the db key to resolve the update.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
either the primary key or the db key to resolve the update.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
----- Original Message -----
From: <rsaeger.edv@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, June 23, 2001 12:09 AM
Subject: Re: [IBO] E_Record_Not_Located_For_Update error
> --- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> > The SQL monitor may reveal some helpful hints.
>
> Jason,
>
> this is the monitor output:
>
> /*---
> COMMIT
> TR_HANDLE = 15539408
>
> SECONDS = 0,031
> ----*/
> /*---
> PREPARE STATEMENT
> TR_HANDLE = 15539808
> STMT_HANDLE = 15539480
>
> SELECT RDB$DB_KEY
> , TARAZ
> , TAGAZ
> , BEZPAUSE
> , ZULSS
> , ZULNS
> , GUTSCHNS
> , ZULUEB1
> , ZULUEB2
> , STDAT1
> , STDSA1
> , ZULSO
> , ZULF1
> , ZULF2
> , JAHRRS
> , MONAZ
> , ZUL19
> FROM TARIF
> WHERE TARIF.RDB$DB_KEY=? /* BIND_0 */
> FOR UPDATE
>
> PLAN (TARIF INDEX ())
>
> FIELDS = [ Version 1 SQLd 17 SQLn 17
> TARIF.DB_KEY = DB_KEY $8000000001000000
> TARIF.TARAZ = 6
> TARIF.TAGAZ = 7
> TARIF.BEZPAUSE = 0,25
> TARIF.ZULSS = 5
> TARIF.ZULNS = 20
> TARIF.GUTSCHNS = 0,2667
> TARIF.ZULUEB1 = 25
> TARIF.ZULUEB2 = 50
> TARIF.STDAT1 = 2
> TARIF.STDSA1 = 4
> TARIF.ZULSO = 50
> TARIF.ZULF1 = 100
> TARIF.ZULF2 = 200
> TARIF.JAHRRS = 0
> TARIF.MONAZ = 0
> TARIF.ZUL19 = 0 ]
> ----*/
> /*---
> PREPARE STATEMENT
> TR_HANDLE = 15539808
> STMT_HANDLE = 15539276
>
> UPDATE TARIF
> SET TARAZ = ? /* TARAZ */
> , TAGAZ = ? /* TAGAZ */
> , BEZPAUSE = ? /* BEZPAUSE */
> , ZULSS = ? /* ZULSS */
> , ZULNS = ? /* ZULNS */
> , GUTSCHNS = ? /* GUTSCHNS */
> , ZULUEB1 = ? /* ZULUEB1 */
> , ZULUEB2 = ? /* ZULUEB2 */
> , STDAT1 = ? /* STDAT1 */
> , STDSA1 = ? /* STDSA1 */
> , ZULSO = ? /* ZULSO */
> , ZULF1 = ? /* ZULF1 */
> , ZULF2 = ? /* ZULF2 */
> , JAHRRS = ? /* JAHRRS */
> , MONAZ = ? /* MONAZ */
> , ZUL19 = ? /* ZUL19 */
> WHERE CURRENT OF C1340626429044393 <<<<<<<<<<<<<<<<<
>
> PLAN (TARIF INDEX ())
>
> FIELDS = [ Version 1 SQLd 0 SQLn 0 ]
> ----*/
> /*---
> EXECUTE STATEMENT
> TR_HANDLE = 15539808
> STMT_HANDLE = 15539276
> PARAMS = [ Version 1 SQLd 16 SQLn 16
> TARIF.TARAZ = 8
> TARIF.TAGAZ = 7
> TARIF.BEZPAUSE = 0,25
> TARIF.ZULSS = 5
> TARIF.ZULNS = 20
> TARIF.GUTSCHNS = 0,2667
> TARIF.ZULUEB1 = 25
> TARIF.ZULUEB2 = 50
> TARIF.STDAT1 = 2
> TARIF.STDSA1 = 4
> TARIF.ZULSO = 50
> TARIF.ZULF1 = 100
> TARIF.ZULF2 = 200
> TARIF.JAHRRS = 0
> TARIF.MONAZ = 0
> TARIF.ZUL19 = 0 ]
>
> ERRCODE = 335544336
> ----*/
> /*---
> INTERPRETE BUFFER =
>
> SECONDS = 0,025
>
> ERRCODE = 8
> ----*/
> /*---
> INTERPRETE BUFFER = deadlock
>
> ERRCODE = 39
> ----*/
> /*---
> INTERPRETE BUFFER = update conflicts with concurrent update
>
> ERRCODE = -1
> ----*/
>
> Look at the line I marked with <<<<<<<<<<<<<<<<<.
> What does it mean?
> And what should I do to avoid it?
>
> Thanks
> Richard
>
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>