How to solve "There is a syntactical error in the SQL statement."

There’s something here, fine people. I have encountered this today. I created is a logger using Sqlite as my file system. It works fine in Community Edition (CE), but it fails in Enterprise Edition (EE). The sql statement is as follows:

INSERT INTO ApplicationSessions (ApplicationName,ServerName,StartDateTime,LoggedBy) VALUES ('CreateApplicationSession','mfdaabc3','2024-08-19 14:25:12.833','niedo');

And the table structure is as follows:

CREATE TABLE IF NOT EXISTS "ApplicationSessions"
(
    Id              INTEGER
        constraint ApplicationSessions_pk
            primary key autoincrement,
    ApplicationName TEXT collate NOCASE not null,
    ServerName      TEXT collate NOCASE not null,
    StartDateTime   TEXT collate NOCASE,
    EndDateTime     TEXT collate NOCASE,
    LoggedBy        Text default ''
);

CREATE TRIGGER IF NOT EXISTS StandardizeApplicationSession
   AFTER INSERT ON ApplicationSessions
    BEGIN
        UPDATE ApplicationSessions SET 
            ApplicationName = Trim(ApplicationName)
            , ServerName = Trim(ServerName)
            , LoggedBy = Upper(Trim(LoggedBy)) 
        WHERE ROWID = new.ROWID;
    END;

The insert statement also works from the sqlite3 command line app. But when I test the system using my account in EE, then I get “There is a syntactical error in the SQL statement. - SQL statement got timed out.”

Things I have tried:
_ setting time out seconds
_ making sure there is no unnecessary whitespace in the insert command
_ making sure there was a semi-colon at the end of the statement
_ reworking the create table syntax so there was no unnecessary whitespace in that (looking for anything)
_ i dropped the trigger
_ destroying the database and building it by hand ahead of bot testing

I’ll add more detail, trial and errors as I continue to work this. Real head scratcher.

Replying to my own post. Unfortunately, it is not a solution. It just more details of what I have attempted.

I abandoned my bot framework and just cobbled together a simple bot that has just the necessary statements to open, insert, end. (My thought process was that maybe the database session variable was getting corrupted being passed around to the various bots.) But it results with the same time out error:

I have confirmed the following: the database file does exist (no brainer), the table does exist, the actual insert does work within sqlite3.exe. There are no permissions with a sqlite database unlike server based databases. If you can connect to it, you can use it.

Note in the image above there are two “Database: Insert...” tasks. The first one executes; it is a PRAGMA statement for database control. It executes fine. The second one is the INSERT failure.

I have also connected to the database file using JetBrains sqlite driver and there are no issues.

Again, my problems are with the Enterprise Edition and not Community Edition. It appears to be the jdbc adapter that is employed by AA. I can’t think of any other reason for the problem. There appears to be a real problem, here. What URL should I use to log an official bug report with Automation Anywhere?

Thank you all for your time and consideration, dvn