AnsweredAssumed Answered

Processing workflows getting stalled throwing SQL Exception error

Question asked by Sonali Dhulap on Apr 28, 2020
Latest reply on Apr 29, 2020 by Ian Staines

Like • Show 0 Likes0
Comment • 3

Hi All,

We are facing issues at workflow level where processing workflows are getting stalled throwing SQL Exception error. anybody encountered same issue?

Below are error details -

04/26/2020 06:41:00.802 ERROR (EventHandler for event [ProvisioningCommandEvent])
[com.aveksa.server.workflow.scripts.nodes.ProvisioningCommandNode] Exception occurred in the ProvisioningNode callback cycle
com.workpoint.common.exception.WpServiceException: An SQL Exception has occurred. Please see the server logs for details.

What will be possible root cause.

Mostafa Helmy

Apr 28, 2020 7:19 AM

Correct Answer

I would recommend logging a case with RSA support for these types of problems. It would require some troubleshooting, looking through multiple logs and maybe a remote session to check certain things in your environment. Reference How to contact RSA Support.

You might also take a look at New Feature: Log Artifact and 000030327 - Artifacts to gather in RSA Identity Governance & Lifecycle to make sure you provide the required logs when opening the support case. This would speed up the troubleshooting process.

See the reply in context

No one else had this question

Outcomes

Mostafa Helmy

Apr 28, 2020 7:19 AM

Actions

Sonali Dhulap Apr 29, 2020 6:07 AM

Thanks Mostafa Helmy for your recommendation. I will raise RSA support ticket for same.

Actions

Ian Staines

@ Sonali Dhulap on Apr 29, 2020 11:42 AM

Most likely this exception is not the primary failure but a secondary error related to some other issue. You will have to expand the investigation to look at the overall health of WorkPoint and your other workflows.

No single error message will lead you to a solution.

Actions

3 Replies

Mostafa Helmy Apr 28, 2020 7:19 AM
Unmark Correct
Correct Answer
I would recommend logging a case with RSA support for these types of problems. It would require some troubleshooting, looking through multiple logs and maybe a remote session to check certain things in your environment. Reference How to contact RSA Support.

You might also take a look at New Feature: Log Artifact and 000030327 - Artifacts to gather in RSA Identity Governance & Lifecycle to make sure you provide the required logs when opening the support case. This would speed up the troubleshooting process.
Like • Show 0 Likes0
Actions
Sonali Dhulap Apr 29, 2020 6:07 AM
Mark Correct
Correct Answer
Thanks Mostafa Helmy for your recommendation. I will raise RSA support ticket for same.
Like • Show 0 Likes0
Actions
- Ian Staines @ Sonali Dhulap on Apr 29, 2020 11:42 AM
  Mark Correct
  Correct Answer
  Most likely this exception is not the primary failure but a secondary error related to some other issue. You will have to expand the investigation to look at the overall health of WorkPoint and your other workflows.
  
  No single error message will lead you to a solution.
  Like • Show 0 Likes0
  Actions

Processing workflows getting stalled throwing SQL Exception error

Outcomes

Related Content

Recommended Content