ERROR: Undefined type for the target identity property (4306311)

After uninstalling Java Cartridge, Attempting to re-install the cartridge resulted in failed topology type merges that failed.Attempting to restart the FMS caused the Topology Service to fail to start. There were messages like these in the FMS log:

2013-01-17 12:02:53.777 ERROR   [main] com.quest.nitro.service.topology.persistence.TopologySQL - An error has occurred while attempting to load the WebSphereApplicationInstance topology type.

com.quest.nitro.service.topology.persistence.InvalidTypeException: Undefined type for the target identity property.

Since the Topology Service couldn't start, all agents remained disconnected from the FMS

Data Collection had not been disabled for all Java agents when uninstalling the cartridge.As a result,new data arriving from one or more agents were creating new topology types as the Java cartridge uninstallation was removing these types.

The result was corrupt type definitions in the FMS model.

System.currentTimeMillis()

Result

1358451917370

With this information in hand, stop the FMS then start the (embedded) Foglight DB standalone:

%FMSHOME%\bin\runDB.bat

Then in a different command window, start the mysql client and connect to the DB (default install):

%FMSHOME%\mysql\bin\mysql .exe –P 13306 –ufoglight –pfoglight foglight

Then  run the command below to clean up the orphaned, corrupt type definitions replacing the effective_end_date with the value obtained above:

update topology_type_history set tth_effective_end_date =  1358451917370 where tth_cartridge_name = "Java_EE" and tth_effective_end_date = 100000000000000;

This command returns the number of rows affected.

Once this command completes, restart the FMS. The Java types will "age out" and you will be able to reinstall the Java cartridge without errors.