[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.

[SoujitD-SAP]

Hi @navinkrishnan

I found the fix for the prescribed issue, it involves minor fix in the attachments.test.js file due to some test profile change in attachments from 1.1.7 to 1.1.8, basically the malware scanning service mocks a delay of 5 sec for scanning within test as well as development profile that's why we need to add some delay to test for execution. I am attaching the screenshot of prescribed changes(line no 65 and 68 in attachments.test.js) as I am unable to push the changes in incident-app git repo due to permissions. You can test it locally from your side and push the changes.

Best Regards
Soujit Das