0 Replies Latest reply: Nov 13, 2012 1:24 PM by user618384 RSS

    ODBC Probem with EIM

      I have an odd problem. an EIM srvrmgr job is getting disconnected from Oracle 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.

      Edited by: user618384 on Nov 13, 2012 11:24 AM