OperationalError: table ts_audit_logs has no column named "timestamp"

[bmofkn]

We filed a bug at #250. Posting here for visibility. Looking to download the audit logs daily into sqlite. The DB and tables get created successfully but cs_tools fails when writing the data to the ts_audit_log table.

OperationalError: table ts_audit_logs has no column named "timestamp"

Using the following cs_tools command:
cs_tools tools searchable audit-logs --last-k-days 7 --config prod_ts --syncer sqlite://syncerDefinitionAudit.toml

[saurabhsingh2974]

Hi @bmofkn, Could you please share the log file? Also, is this SQLite DB being created for the first time? or Since you're doing an upsert, it might be an older SQLite file where the values are being inserted.

[bmofkn]

Hi @saurabhsingh2974, the db was new. This happen when there is no sqlite db file (it gets created by the script).

The detailed error is listed in bug #250:

OperationalError: (sqlite3.OperationalError) table ts_audit_logs has no column named "timestamp" [SQL: INSERT OR REPLACE INTO ts_audit_logs (cluster_guid, org_id, sk_dummy, """timestamp""", log_type, user_guid, description, details) VALUES (<redacted>)

Is there a reason the script is using quotes for timestamp? Is it a reserved keyword in sqlite?

UPDATE: I reran the script a few minutes ago against an existing sqlite db and it completed successfully 🙂

[bmofkn]

Gonna mark this as "complete" and consider it a simple "inconvenience" given it only fails when the db is being created for the first time.

[saurabhsingh2974]

Thanks, i will look into it.