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

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

75 Views

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:REPOSITORYNAME>CE72JAVA</mx:REPOSITORYNAME>

<mx:MESSAGES>

<mx:ERROR seq="1">

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

FROM sapgroup INNER JOIN

sapCE72JAVAroleAssign ON

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

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

</mx:TEXT>

<mx:ENTRY/>

</mx:ERROR>

<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:ENTRY/>

</mx:ERROR>

</mx:MESSAGES>

<mx:DELTA>0</mx:DELTA>

<mx:TIMEUSED>0</mx:TIMEUSED>

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

<mx:NERRORS>2</mx:NERRORS>

<mx:NWARNINGS>0</mx:NWARNINGS>

</mx:PASS>

Line: -