Duplicate entries are recording in alm_hardware table

[chaitnaya]

Hi Folks,

When I'm inserting new records into alm_hardware table its accepting duplicate entries without throwing an error

java.sql.BatchUpdateException: Duplicate entry 'XXXXXXXX' for key 'Serial Number'

Invalid insert

Previously my hardware table throws the above error while submit same serial number   but not now.

we didn't write any business rule. I checked everything but no luck.

Where all these duplicate entry errors will be there?

How to get back my hardware table behavior as normal.

Thanks and regards,

Naga Chaitanya

[Raju Koyagura]

That error only because of some BR so please verify all these OOB BRs are active or not, which are related to asset and ci.

[sergiu_panaite]

Table alm_hardware actually extends table alm_asset and the serial_number column is on alm_asset. The error you're getting suggests me that you have a unique index on that column (serial_number) and therefore the insert is rejected.

The error "java.sql.BatchUpdateException" means platform is trying multiple SQL statements in one batch. So your action is causing probably multiple updates (maybe cascade ones).