[Version: 1.1.8] SQLITE ERROR on automatic status update query after successful Upload of attachments

[navinkrishnan]

Describe the bug

After the successful upload of the attachments, there is some automatic status update query happens and it fails.

Error Message:

/git/incidents-app/node_modules/better-sqlite3/lib/methods/wrappers.js:5
        return this[cppdb].prepare(sql, this, false);
                           ^
SqliteError {
  code: 'SQLITE_ERROR',
  query: "UPDATE sap_capire_incidents_Incidents_attachments AS attachments SET status=?,modifiedAt=session_context('$now'),modifiedBy=session_context('$user.id') WHERE attachments.ID = ?"
}

The same works fine without error, if downgraded to 1.1.7.

Request to take this as priority as its linked with the BTP Developer Guide missions using incidents-app.

To Reproduce

1. git clone https://github.com/cap-js/incidents-app.git
2. npm install
3. npm test test/attachments.test.js
4. Notice the error message

Expected behavior
No SQLITE ERROR should be thrown.

[ ] is it a regression issue?

Screenshots
If applicable, add screenshots to help explain your problem.

Customer Info
Company: xyz.