ml_ra_get_orphan_taskdbs system procedure

Results	Description
remote_id	VARCHAR(128). The remote ID.
orig_agent_id	VARCHAR(128). The ID of the original agent the agent database was associated with.
last_sync	TIMESTAMP. The time of the last synchronization.
p_crsr	SYS_REF_CURSOR. This is an OUT parameter for Oracle only.

Orphaned databases can be the result of a number of problems in a synchronization system, such as creating duplicate agent ids on different computers or having two agent databases trying to use the same agent id.

The remote_id field has the computer name in it to aid in diagnosing problems.

ml_ra_reassign_taskdb system procedure

ml_ra_get_orphan_taskdbs system procedure

Returns

Remarks

See also