Thread View: bit.listserv.powerh-l
1 messages
1 total messages
Started by techrator
Mon, 12 Sep 2005 14:35
Data Access error in QTP.
Author: techrator
Date: Mon, 12 Sep 2005 14:35
Date: Mon, 12 Sep 2005 14:35
68 lines
3336 bytes
3336 bytes
I get the below error when executing a QTP>
Run: PPSUP17
Request: PROD-ID-DETL-ADD
Executing request PROD-ID-DETL-ADD ...
------------------------------------------------------------------------------
-
Data access error.
[1]
File: PID1
Linkitem: PROD-ID-KEY 100026865
Linkitem: PRIM-PARENT-KEY 100026864
Linkitem: PROD-NAME-14
Action Taken: Run terminated.
------------------------------------------------------------------------------
-
File: PID1
Linkitem: PROD-ID-KEY 100026865
Linkitem: PRIM-PARENT-KEY 100026864
Linkitem: PROD-NAME-14
------------------------------------------------------------------------------
-
Records read:
PPSTRN-170 42
Transactions processed: 1
Records processed: Added Updated Unchanged
Deleted
PID1 0 0 0
0
Finished.
The QTP code that I am running is :
;*******************************************************************
;* ADD RECORDS TO THE PROD-ID-DETL *
;*******************************************************************
REQUEST PROD-ID-DETL-ADD &
ON EDIT ERRORS REPORT
ACCESS PPSTRN-170
SELECT PPSTRN-170 IF RCD-ID = "170" AND &
; PRIM-PARENT-ID <> 0 AND &
TYPE-CHG-TRANS = "1"
EDIT PROD-ID OF PPSTRN-170 &
LOOKUP NOTON PROD-ID-AUTO &
VIA PROD-ID-KEY &
USING ASCII(PROD-ID OF PPSTRN-170,9) + &
" "
OUTPUT PROD-ID-DETL ADD &
ALIAS PID1
ITEM PRIM-PARENT-KEY FINAL ASCII(PRIM-PARENT-ID,9) + " "
Any help on this will be of great help. If possible, Please email me
directly.
Thanks,
Techrator.
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads