-
Notifications
You must be signed in to change notification settings - Fork 3
Description
Current Behavior
Some SARIF files fail to be imported due to an SSC artifact processing error.
Expected Behavior
All valid SARIF files should be successfully imported into SSC.
Steps To Reproduce
As an example, the WebGoat5.0.fpr.sarif sample file included in this repository fails to be processed by current SSC versions, resulting in the following exceptions in ssc.log:
[ERROR] com.fortify.manager.BLL.impl.FPRBLLImpl - Error parsing issues: WebGoat5.0.fpr.sarif.zip
com.fortify.manager.exception.FMDALException: Unable to execute batch.
...
Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO finding(projectVersion_id,guid,name,description,findingType) VALUES(?,?,?,?,?)]; (conn=64) Data too long for column 'guid' at row 1; nested exception is java.sql.BatchUpdateException: (conn=64) Data too long for column 'guid' at row 1
Anything else?
The issue data generated by the parser plugins is used calculate a correlation guid; apparently this calculation sometimes generates values that are too large to be stored in the guid database column. This calculation is done by SSC, hence this is considered to be an SSC bug, not a parser plugin bug.
Subject to change, this is currently planned to be fixed in SSC 25.4. Customers affected by this issue may consider opening a support case, referencing engineering ticket OCTCR11A1806016.