On Thursday, November 11, 2021 at 12:12:36 AM UTC+5:30, Randall wrote:
On Wednesday, November 10, 2021 at 6:19:45 a.m. UTC-5, indra...@gmail.com wrote:
Hello Group,
Can you please help as we are getting the below DB error when it is trying to read the Ordre file . This error is continuously coming in a test server in an application test system due to which we are not able to proceed further. Some languages is in
Danish.
2021-11-08 15:50 VHS LOG BROWSER FOR SYSTEM ØDAISY Position: END Environment: ACT After: - - : : Process:
Search Text: * Prompts: 0000
First message date: 2021-11-02 Last message date: 2021-11-02
14:39:43 $Y76M ØDAISY.$Y76M:4284362393 - ACS4500 + %1511, UC.00
14:39:43 $Y76M Advarsel: Fatal-fejl (9999) i ACU2300 med Aktion BESTIL 14:39:43 $Y76M ACS4500: Fejl i oprettelse af ordre-ngl: CU1076898400000001 14:39:43 $Y76M TMF-ERROR: 0075 I ABORTTRANSACTION
15:07:53 $Z3QG ACS4400: Annulering ikke foretaget. Ukendt ordrenr: 10417329
15:52:10 $Y6NX ØDAISY.$Y6NX:4284208025 - *** Run-time Error 186 *** 15:52:10 $Y6NX ØDAISY.$Y6NX:4284208025 - READ operation failed with error 75
15:52:10 $Y6NX ØDAISY.$Y6NX:4284208025 - File ORDRE-FILE = ØDAISY.$TEST02.ACDB0TDB.C08ORDRE, I-O
15:52:10 $Y6NX ØDAISY.$Y6NX:4284208025 - From STD-ACCESS-ORDRE + %2201, UC.00
15:52:10 $Y6NX ØDAISY.$Y6NX:4284208025 - ACU2300 + %27517, UC.00
15:52:10 $Y6NX ØDAISY.$Y6NX:4284208025 - ACS4500 + %1511, UC.00
15:52:10 $Y6NX Advarsel: Fatal-fejl (9999) i ACU2300 med Aktion BESTIL 15:52:10 $Y6NX ACS4500: Fejl i oprettelse af ordre-ngl: OI0005551900000002 15:52:10 $Y6NX TMF-ERROR: 0075 I ABORTTRANSACTION
Automatic screen update is performed
F2=Change Search Criteria F4=Prompt Browser F5=Refresh Count F9=Print F10=Env Detail F14=VHS Profile F15=Help SF16=Exit
---------------------------------------------------------
On further debugging we found that TMF error 75 is generated when it tries to read the file – ORDRE . As per logic, ACC-GUARDIAN-ERROR is set with error code as 75 shown in blue
INSPECT STEP IN
061,01,01052 $Z46X #ACU2300.#3370(ACU2300)
*#3370 MOVE "ORDRE" TO ZPG-LAST-FILE-ACCESSED
-$Z46X(STEP IN)-so
#3366
#3367
#3368 ACCESS-ORDRE.
#3369
*#3370 MOVE "ORDRE" TO ZPG-LAST-FILE-ACCESSED
#3371
#3372 CALL STD-ACCESS-ORDRE
#3373 USING STD-ACCESS-INTERFACE
#3374 ORDRE-FILE
#3375 ON EXCEPTION
-$Z46X-step 1 v
INSPECT STEP
061,01,01052 $Z46X #ACU2300.#3372(ACU2300)
*#3372 CALL STD-ACCESS-ORDRE
-$Z46X(STEP 1 V)-
\DAISY.$Z46X:4302493593 - *** Run-time Error 186 *** \DAISY.$Z46X:4302493593 - READ operation failed with error 75 \DAISY.$Z46X:4302493593 - File ORDRE-FILE = \DAISY.$TEST02.ACDB0TDB.C08ORDRE, I-
\DAISY.$Z46X:4302493593 - O
\DAISY.$Z46X:4302493593 - From STD-ACCESS-ORDRE + %2201, UC.00 \DAISY.$Z46X:4302493593 - ACU2300 + %30544, UC.00
\DAISY.$Z46X:4302493593 - ACS4500 + %1511, UC.00
INSPECT STEP
061,01,01052 $Z46X #ACU2300.#3381(ACU2300)
*#3381 IF ACC-GUARDIAN-ERROR OF STD-ACCESS-INTERFACE
-$Z46X(STEP 1 V)-so
#3377 SET ACC-GUARDIAN-ERROR OF STD-ACCESS-INTERFACE TO TRUE
#3378 MOVE 29 TO ERROR-CODE OF STD-ACCESS-INTERFACE
#3379 END-CALL
#3380
*#3381 IF ACC-GUARDIAN-ERROR OF STD-ACCESS-INTERFACE
#3382 MOVE ERROR-CODE OF STD-ACCESS-INTERFACE
#3383 TO GUARDIAN-FEJL-KODE OF GW-REQ-SERV-HEADER
#3384 .
#3385
#3386
-$Z46X-step 1 v
INSPECT STEP
061,01,01052 $Z46X #ACU2300.#3382(ACU2300)
*#3382 MOVE ERROR-CODE OF STD-ACCESS-INTERFACE
-$Z46X(STEP 1 V)-d STD-ACCESS-INTERFACE
STD-ACCESS-INTERFACE =
REPLY-CODE = 9999
FUNCTION-CODE = 11
ERROR-CODE = 75
FIL-TIMEOUT = 15
TOTAL-ALTKEY-GENERIC = "0 :CU1076918300000000
"
-$Z46X-
d ACC-GUARDIAN-ERROR OF STD-ACCESS-INTERFACE STD-ACCESS-INTERFACE.REPLY-CODE.ACC-GUARDIAN-ERROR = T
-$Z46X-d ERROR-CODE OF STD-ACCESS-INTERFACE STD-ACCESS-INTERFACE.ERROR-CODE = 75
-$Z46X-
-------------------------------------
Please help .... what can be the issue or any clue.
Thanks & Regards,
Indranil
Does your application sit with an active TMF transaction at all times? The ABORTTRANSACTION at 14:39:43 will take you out of a TMF transaction context, so the next read will fail with an error 75 (no transaction) unless you start another one. On the
surface, this looks like an application logic error. Remember that transactions are generally passed from client program to server, so the transaction may be gone from the client, and is gone from the server on the next request.
Randall
Hello Randall,
Thank you for your reply and suggestions.
We are working according your suggestion, but, still no way found.
Will give you update.
Regards,
Indranil
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)