# NAT3009 Last transaction backed out of database 15. Subcode 3 **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Adabas, Natural, NaturalONE\ **Created:** [September 27, 2024, 3:27pm UTC](https://techcommunity.softwareag.com/t/nat3009-last-transaction-backed-out-of-database-15-subcode-3/300956 "2024-09-27T15:27:38Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Imnacho2000](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/imnacho2000/32/31777_2.png) [@Imnacho2000](https://techcommunity.softwareag.com/u/Imnacho2000)\ **Post date:** [September 27, 2024, 3:27pm UTC](https://techcommunity.softwareag.com/t/nat3009-last-transaction-backed-out-of-database-15-subcode-3/300956/1 "2024-09-27T15:27:38Z")
### Hi everyone i’m junior on this and i have this error but i’cant fix until now, the program is very simple it’s this: ```auto R1. READ MULTI-FETCH 10 TEST1 WITH DESCRIPTOR-TEST1 = TEST-D TO TEST-H /* TEST1 HAVE AROUND 14 MILLION RECORDS */ ADD 1 TO READS-RECORDS IF READS-RECORDS > 50 /*I TRY TO PUT THIS FOR FIX BUT NOT WORK */ GET TEST1 *ISN(R1.) END TRANSACTION RESET READS-RECORDS END-IF FIND (1) TEST2 WITH DESCRIPTOR-TEST2 = TEST-DATE IF NO RECORD FOUND ESCAPE BOTTOM (005) END-NOREC IF TEST2.MAIL = ' ' ESCAPE BOTTOM (005) END-IF /* MOVE RECORDS HERE FOR THE FILE-OUT */ END-FIND WRITE WORK FILE 1 FILE-OUT END-READ ``` ### Well and this running for around 2-3hs maybe and he give error: NAT3009 Last transaction backed out of database 15. Subcode 3. ### I think i’ts for the massive cant of records that have the file ‘TEST1’ but idk, i try put the end transaction despite doesn’t exist any update or similar but also don’t work, i read too much threads about this in the forum but nothing… ### Any solution it’s welcome here, sorry again for my ignorance, kind regards. ---
**Author:** ![Eugene.Miklovich](https://avatars.discourse-cdn.com/v4/letter/e/ce73a5/32.png) [@Eugene.Miklovich](https://techcommunity.softwareag.com/u/Eugene.Miklovich)\ **Post date:** [September 27, 2024, 5:08pm UTC](https://techcommunity.softwareag.com/t/nat3009-last-transaction-backed-out-of-database-15-subcode-3/300956/2 "2024-09-27T17:08:04Z")
Subcode 3 is a non activity timeout. Are files TEST1, TEST2 and your FUSER file all on the same database, i.e. 15? You may be timing out on 1 database but active on another. Eugene (Gene) Miklovich ADABAS/NATURAL Systems Support and DBA Cell: 916-202-7047 Normal Hours: 8am-4pm E.T. Please call or text if assistance needed outside these hours. ---
**Author:** ![Imnacho2000](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/imnacho2000/32/31777_2.png) [@Imnacho2000](https://techcommunity.softwareag.com/u/Imnacho2000)\ **Post date:** [September 27, 2024, 5:35pm UTC](https://techcommunity.softwareag.com/t/nat3009-last-transaction-backed-out-of-database-15-subcode-3/300956/4 "2024-09-27T17:35:29Z")
in the case ‘activity timeout’ is it because there is no ‘commit’ to the file? or what? and yes, both are in the same database ---
**Author:** ![wolfgang.winter](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/wolfgang.winter/32/17954_2.png) [@wolfgang.winter](https://techcommunity.softwareag.com/u/wolfgang.winter)\ **Post date:** [September 27, 2024, 7:01pm UTC](https://techcommunity.softwareag.com/t/nat3009-last-transaction-backed-out-of-database-15-subcode-3/300956/5 "2024-09-27T19:01:46Z")
This just doesn’t make sense at all. Rsp 9 Subcode 3 means “The transaction non-activity time limit (TNAE, TNAX, or TNAA) has been exceeded.”. No, this does not mean “no commit on the file”, this means “no ADABAS calls at all within the time limit”. Which exact line does the error message point to ? Even for a file with 14 million records an execution time of 2-3 hours doesn’t sound reasonable. You specify line numbers instead of labels on your escape statements, what is (005) ? If (005) equals to R1 then your logic doesn’t look right, why would you drop out of the READ loop ? Is there another loop statement, like a REPEAT or another READ surrounding this ? ---
**Author:** ![Imnacho2000](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/imnacho2000/32/31777_2.png) [@Imnacho2000](https://techcommunity.softwareag.com/u/Imnacho2000)\ **Post date:** [September 30, 2024, 4:48pm UTC](https://techcommunity.softwareag.com/t/nat3009-last-transaction-backed-out-of-database-15-subcode-3/300956/6 "2024-09-30T16:48:30Z")
do ESCAPE BOTTOM at FIND line because i need evaluate all of the occurrences, or how to do that?.. ---
**Author:** ![Eugene.Miklovich](https://avatars.discourse-cdn.com/v4/letter/e/ce73a5/32.png) [@Eugene.Miklovich](https://techcommunity.softwareag.com/u/Eugene.Miklovich)\ **Post date:** [October 1, 2024, 5:25pm UTC](https://techcommunity.softwareag.com/t/nat3009-last-transaction-backed-out-of-database-15-subcode-3/300956/7 "2024-10-01T17:25:54Z")
Recommend you always label loops with “R1.” or similar and then ESCAPE LOOP (R1.). If you use line numbers they should always be 4 digits and match line number where loop started. ---
**Author:** ![Eugene.Miklovich](https://avatars.discourse-cdn.com/v4/letter/e/ce73a5/32.png) [@Eugene.Miklovich](https://techcommunity.softwareag.com/u/Eugene.Miklovich)\ **Post date:** [October 3, 2024, 1:53pm UTC](https://techcommunity.softwareag.com/t/nat3009-last-transaction-backed-out-of-database-15-subcode-3/300956/8 "2024-10-03T13:53:24Z")
Is your FUSER on same database as TEST1 and TEST2 Eugene (Gene) Miklovich ADABAS/NATURAL Systems Support and DBA Cell: 916-202-7047 Normal Hours: 8am-4pm E.T. Please call or text if assistance needed outside these hours. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 1, 2025, 1:53pm UTC](https://techcommunity.softwareag.com/t/nat3009-last-transaction-backed-out-of-database-15-subcode-3/300956/9 "2025-04-01T13:53:35Z")
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.