Article Original Creation Date: 2013-06-26
Overview
Updating device via the GUI, e.g. adding a service or an attribute gives the following error in server.logs:
2013-06-26 11:41:33,549 ERROR [encore.inventory] class: com.supportsoft.encore.inventory.ejb.devicemanager.dao.DeviceManagerGenericDAO method: updateDevice: 00007 - SQL Error occurred while updating Device
2013-06-26 11:41:33,550 ERROR [encore.inventory] ORA-01722: invalid number
com.supportsoft.encore.common.exception.DAOException: ORA-01722: invalid number
...
Environment
- Solaris 10
- JBoss 4.0.4GA
- Oracle 10
Root Cause
The root cause of the error mentioned previously is improper migration of column
SPRT_EC_DEVICE.STATICALLY_ASSIGNED_IPADDRESS during the upgrade from SG2.x to SG4.x or later while updating SG4.x to support IPv6.Another cause for the error is when
SPRT_EC_DEVICE.STATICALLY_ASSIGNED_IPADDRESS has a value 0 instead of a 'null'.
Resolution
The error mentioned previously can be resolved by executing the following SQL queries:
UPDATE SPRT_EC_DEVICE SET
STATICALLY_ASSIGNED_IPADDRESS = null
WHERE STATICALLY_ASSIGNED_IPADDRESS = 0;
ALTER TABLE SPRT_EC_DEVICE MODIFY ( STATICALLY_ASSIGNED_IPADDRESS VARCHAR2(39) DEFAULT NULL );