I have an odd problem. an EIM srvrmgr job is getting disconnected from Oracle 126.96.36.199 after attempting to run a lonlg query with lots of unions against the S_TABLE,S_COLUMN, S_REPOSITORY. when Irun the query in SQLPLUS it returns 1027 rows right away showing the row_ids for the source and target data. The problem appears to be related to EIM_ASSET and EIM_ASSET1. I did a EIM load into EIM_BU without getting this error.
If I run the same query through odbcsql it dies the same way it does on srvrmgr. Unfortunatly, this is running on a closed system and I am not able to get the query out to post to the group.