Error: java.sql.SQLException: ORA-01722: invalid number

Today i received an error on the emoms.trc file on Oracle Enterprise Manager Grid control. The error is:

WARN eml.XMLLoader LoadFiles.680 - Marking the file for retry : 50000909090.xml after receiving exceptionjava.sql.SQLException: ORA-01722: invalid number

2009-10-05 05:00:35,878 [XMLLoader0 500000909090.xml] ERROR eml.XMLLoader markFileAsError.824 - Failed to load 50000909090.xml even after 2 attempts; moving to errors directory. Error: java.sql.SQLException: ORA-01722: invalid number

This is a problem with the OMS Loader. The OMS fails to load xml to repository with an error ORA-01722: invalid number.

This OMS error is a bug in Enterprise Manager Grid Control - Version: 10.2.0.1.0 to 10.2.0.3.0.

The solution is to upgrade the OEM to 10.2.0.4 or 10.2.0.5 by applying the patch. Or apply the verrsion 10.1.0.4.2 of patch 4488715 to fix this particular problem.

I decided to upgrade the OEM to 10.2.0.4.