Skip to Content
Former Member
Feb 14, 2012 at 05:51 AM

IDM 7.2 AS Java (LDAP) Initial load fails - ORA-00942


Hi Experts,

I am trying to perform the AS Java (LDAP) initial load on IDM 7.2 and have many errors in job log. I checked the log details and found most of the error are from one database error. "ORA-00942: table or view does not exist"

The SQL indicates two tables should exist in the database, but I found the table "sapgroup" is missing. Can anyone explain why the table is missing and how I can fix that?

Best Regards

Jack Xiong

Line: -

<mx:PASS name="55E9C2D5-2F0F-4C7F-9B10-E3963ADAAA61" seq="11" title="Create Privileges for Global Groups" type="ToIDStore">



<mx:ERROR seq="1">

Exception executing SELECT distinct(sapgroup.dn), sapCE72JAVAroleAssign.roleassignments,


sapCE72JAVAroleAssign ON

'SPML.SAPGROUP.' || = sapCE72JAVAroleAssign.roleAssignments

<mx:TEXT>java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist




<mx:ERROR seq="2">

<mx:TEXT>Running pass failed with unhandled exception</mx:TEXT>

<mx:TEXT>java.lang.NullPointerException: while trying to invoke the method java.sql.ResultSet.getMetaData() of an object loaded from local variable 'rs'</mx:TEXT>






<mx:NENTRIES adds="0" dels="0" markdels="0" mods="0" noops="0">0</mx:NENTRIES>




Line: -