Scan task fails at commit due to 'ORA-01400: cannot insert NULL into ("PALAMIDAADMIN"."PSE_SCANNED_ITEMS"."NAME

Title

Scan task fails at commit due to 'ORA-01400: cannot insert NULL into ("PALAMIDAADMIN"."PSE_SCANNED_ITEMS"."NAME_")'

Summary

This article documents the known bug recorded in PAS-10636 where scan commits will fail with the 'ORA-01400: cannot insert NULL into ("PALAMIDAADMIN"."PSE_SCANNED_ITEMS"."NAME_")' error

Symptoms

When scanning a workspace the scan will fail to commit to an Oracle database. The scanEngineDetail.log and the catalina.out log will both contain the the following error:

2017-10-16 11:05:11,576 ERROR [http-bio-8888-exec-7] [ScanServiceImpl] Encountered an exception during scan commit
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
...
Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("PALAMIDAADMIN"."PSE_SCANNED_ITEMS"."NAME_")
...

Cause

The bug is caused by the way that FlexNet Code Insight requires empty strings (such as "") to be handled. When processed by MySQL and MS SQL these are treated as a blank string but when processed by Oracle these are treated as NULL values.

Resolution

A check for these null values was added to the logic of release 6.11.1 to ensure this error was rectified. Unfortunately the only way to resolve this error on 6.10.3 is to ensure that any empty strings contain a space (such as " ") or by upgrading to 6.11.1. Adding a space to the name allows for Oracle to store a blank string rather than a NULL value.

Was this helpful?

Support Hub

Product

Code Insight

Visibility

Guest

URL Name

scan-task-fails-at-commit-due-to-ora-01400-cannot-insert-null-into-palamidaadmin-pse-scanned-items-name

Are you sure you want to cancel the case creation?

Case closed successfully

Action performed successfully

Upload Attachment

Maximum file size allowed is 3 MB.

File type not supported.

Supported file types:

Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to close this case

Get Hotline support

Products	Region	Phone Numbers
FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield	North America *	+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America)
	Europe *	+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe)
	Japan *	+81 3-4540-5335 (select option 2)
	Australia *	+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia)
Usage Intelligence (formerly Revulytics) Compliance Intelligence	Please use the Case Portal to submit your support ticket or reach out to your Revenera contact.

Summary

Symptoms

Cause

Resolution

Related Articles

Please wait...

Case id: 00001065