"row-fetch-failure-multi-valued" eror when importing from Oracle 10g R2 Management agent
Hello! We import users and groups from Oracle MA with 2 identically configured MA. The data is taken from Oracle views. The first agent works ok and groups / members are provisioned in the FIM / AD. The second agent is generating the following error "row-fetch-failure-multi-valued" (connected Oracle version- 10g R2). How to solve the problem? Thanks!
November 24th, 2011 5:02am
Hi I have never encountered this error but i would suggest to check if the attribute you are fetching in Oracle is multivalued in the FIM sync metaverse and service. Second I would investigate your view/table/sql function in Oracle because I beleive here is where the issue is. If the sql functions is not correct it cannot perform a fetch command successfully. Try running your sql select in a SQL browser, if you get same error then you know. //Christian www.cortego.se
December 1st, 2011 5:49am
I guess you have this error on import profile run, are you running the import on the agents together, it seems there some sql blocking or deadlock on oracle database side try not to run parallel import profiles on those MAs together, instead do it sequentially one after the other ends it's import operation. It's never too late in life ... to start living
December 1st, 2011 7:24am