Self Hosted

Transaction error

Nov 21, 2025, 13:00Last activity 9 months ago

View on Discord

Votes

Replies

Participants

Messages

SabiyoOriginal post

Web Developer

Nov 21, 2025, 12:27

Future createOperations() async {
final client = Client()
.setEndpoint(AppwriteConstants.apiEndPoint)
.setProject(AppwriteConstants.projectId);

final tablesDB = TablesDB(client);

final tx = await tablesDB.createTransaction();

await tablesDB.createOperations(
  transactionId: tx.$id,
  operations: [
    {
      'action': 'create',
      'databaseId': '68ff00b800318a2a0fa8',
      'tableId': 'demo_table',
      'rowId': ID.unique(),
      'data': {'name': 'Walter'},
    },
    {
      'action': 'create',
      'databaseId': '68ff00b800318a2a0fa8',
      'tableId': 'demo_table_1',
      'rowId': ID.unique(),
      'data': {'name': 'new Walter'},
    },
  ],
);

await tablesDB.updateTransaction(transactionId: tx.$id, commit: true);

AppwriteException: transaction_not_found, Transaction with the requested ID could not be found. (404)

Can any one please help me to find where am wrong

Summary

Error is likely due to transaction not being created in the same database as operations. Make sure createTransaction() uses the same database ID. If using Appwrite, check if createTransaction() includes the database ID. Solution: - Ensure createTransaction() includes the database ID. - Double-check that the transaction is created in the proper database scope.

Oliva

Nov 21, 2025, 16:10

I can help!
This error usually happens when the transaction isn’t being created in the same database scope as the operations, or when the SDK call returns a transaction object that’s actually null/not committed.

Quick question:
When you call createTransaction(), are you sure it's using the same database ID (68ff00b800318a2a0fa8) you're passing in the operations? Some SDKs require specifying the database when creating the transaction.

If you can share how createTransaction() is implemented in your TablesDB class, I can point out the exact issue.

Sabiyo

Web Developer

Nov 21, 2025, 18:07

thanks a lot in advance
am sharing my code snip bellow
as you said I have created every thing is inside the function createOperations{}
but sadly getting the error
Uncaught error: AppwriteException: transaction_not_found, Transaction with the requested ID could not be found. (404)
The curd operation without transaction is happening

Future createOperations() async {
final client = Client()
.setEndpoint(AppwriteConstants.apiEndPoint)
.setProject(AppwriteConstants.projectId);

final tablesDB = TablesDB(client);

final tx = await tablesDB.createTransaction();
print(tx);
await tablesDB.createOperations(
  transactionId: tx.$id,
  operations: [
    {
      'action': 'create',
      'databaseId': 'test_db',
      'tableId': 'table_1',
      'rowId': ID.unique(),
      'data': {'name': 'Walter'},
    },
    {
      'action': 'create',
      'databaseId': 'test_db',
      'tableId': 'table_2',
      'rowId': ID.unique(),
      'data': {'name': 'new Walter'},
    },
  ],
);

await tablesDB.updateTransaction(transactionId: tx.$id, commit: true);

}

Oliva

Nov 21, 2025, 18:16

Got it I can help you fix this.
From your snippet, the issue is likely that createTransaction() isn’t being created inside the same database scope as the tables you’re using (test_db). If the transaction is created at the project level instead of the database level, Appwrite will return “transaction_not_found” the moment you try to attach operations.

Oliva

Nov 21, 2025, 18:16

Quick question:
In your TablesDB class, does createTransaction() accept or use the databaseId? If not, that’s almost definitely the root cause.

If you want, send me a message with the TablesDB class code I can pinpoint the exact fix in a few minutes.

Sabiyo

Web Developer

Nov 21, 2025, 18:27

Can you please send me the working code snippet.it would be a great help

Oliva

Nov 21, 2025, 18:39

Can you send me a message

Join the discussion

Reply to this thread by joining our Discord.

Reply on Discord

Need support?_

Join Discord Get premium support