Skip to Content

Provisioning problem for AD and SAP ABAP Systems

Hi,

We're using IDM 7.20 SP3 and successfully run he Initial Load for AD, NW 7.30 and ERP 6.0 Systems successfully.

But, when I add the priviledge of systems to a new user created via IDM UI, It is not provisioned successfully.

Job Log show the following errors:

[http://imageshack.us/photo/my-images/69/idmerror1.png/|http://imageshack.us/photo/my-images/69/idmerror1.png/]

The detail log is as follow:

JOB: Update context info

Provisioned entries - Successes: 1 Failures:0

MSKey AuditID Status Info

9910 682 OK AALASARLI1

JOB: SYNC

Provisioned entries - Successes: 1 Failures:0

MSKey AuditID Status Info

9910 682 OK 1608

JOB: Set task to error state

Provisioned entries - Successes: 0 Failures:1

MSKey AuditID Status Info

9910 682 FAIL uSkip Called to skip entry

JOB: Skip pending operation

Provisioned entries - Successes: 1 Failures:0

MSKey AuditID Status Info

9910 683 OK not-existing-mskey

JOB: Trigger notification: assignment failure

Messages Warning Executing sap_core_getSkippedOK() got RuntimeException - org.mozilla.javascript.EvaluatorException: uSelect(select top 1 avalue from idmv_value_basic_active where attrname='MX_ATTRIBUTE_VALUE' and mskey=not-existing-mskey) got exception com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'not'. HINT: Check line 20 in the script sap_core_getSkippedOK

Provisioned entries - Successes: 0 Failures:1

MSKey AuditID Status Info

9910 683 FAIL Failed running function in string "$FUNCTION.sap_setContextVariable(NOTIFICATION_SUBJECT;Assignment failed!!<SKIPPEDOK>=$FUNCTION.sap_core_getSkippedOK()$$;<UIUSER_DISPLAYNAME>=$FUNCTION.sap_getDisplayName(manager)$$)$$". Marking entry as failed. Exceptio

any idea?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 27, 2012 at 08:15 AM

    Hi Huseyin,

    it seems, that the provisioning framework can't get the Entrytype. Is it an MX_PERSON? You may have a look into the audit table. If the results of the switch task "Check Entrytype" will be visible there in the msg column. Is the stored procedure in the db? Can the prov and rt user access it?

    BR,

    Christoph

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Hüseyin Bilgen

      Hi,

      to be honest, i don't use the notification framework of the SAP, and i outlined this line in the destination tab of the job "Trigger notification: assignment failure"

      That was a quick fix for me here, cause i haven't had the time to debug the script of SAP.

      But the real problem is, that it is running in an assigment failure. You might want to check the stored procedure: mxpt_get_entrytype and if the rt user can execute it.

      If the procedure is there an can be executed, what I expect, you can check the pending value. Have a look into the "Update Context" Task in provisioning, there is in the log the mskey of the pending value. Check this pending value, what its MX_ENTRY_REFERENCE?

      BR,

      Christoph

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.