This discussion is archived
0 Replies Latest reply: Nov 13, 2012 11:24 AM by user618384 RSS

ODBC Probem with EIM

user618384 Newbie
Currently Being Moderated
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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points