• State Suggested Answer
  • +2 person also asked this people also asked this
  • Locked Locked
  • Replies 6 replies
  • Answers 3 answers
  • Subscribers 95 subscribers
  • Views 7358 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Remove ADSAccount outstanding objects

lerodriguezdiez
over 6 years ago

Hi

 

When we try to delete the outstanding mark from Manager, Manager got frozen while we click on ADSAccount table as we have lots of outstanding objects.

 

Is there any way by script or sql to delete ADSAccount outstanding objects without using Manager?

 

Regards

 

Leticia

  • 0 over 6 years ago

    Hi,

    we ended up creating a maintenance process with a CallMethod component that calls DeleteOutstanding() on the table in question (ADSAccount), with a given WhereClause.

    Although the Manager did not hang up, the WhereClause aspect was crucial to us and missing from the Synchronization interface.

    Also I'm not sure if the Method does the correct thing. It seems that the account deletion was being provisioned (ADS_ADSAccount_Delete got triggered) in our case. Maybe adding connection variable "FULLSYNC" is better.

  • +1 over 6 years ago
    You need to set the session (or connection) variable ManageOutstanding before you call the method to avoid the process to be generated. Do not forget to remove the variable afterward.
  • 0 over 6 years ago
    Thanks Markus for the hint.

    I was now wondering what would be the "best way" to do this.
    I wrote a script, but now I'm wondering about the "ConnectionVariables" job parameter in process orchestration. It looks like most process tasks have it.
    Does it do exactly that - setting the listed variables before executing the process step and removing them afterwards? I couldn't find any documentation on this parameter.
  • +1 over 6 years ago

    The description of the parameter is saying Connection variables to set. and it is doing exactly that.

    If you execute a script, the ScriptComponent will set the connection variable before it starts the script, execute the script and remove the connection variable from it's connection.

  • 0 over 6 years ago
    Hi,

    just in case it would be an option for you: next to Manager you can use Object browser for handling those objects. Using Object browser you can delete objects from the table without processes being generated.

    I use this approach as it was given to me by a PFE and I had just to remove some transient outstanding objects after implementation tests.

    BR,
    Stefan