topic WorkflowDataStoreException: Failed to create schema in ArcGIS Workflow Manager Questions

WorkflowDataStoreException: Failed to create schema

Ranga_Tolapi — Wed, 10 Nov 2021 14:31:27 GMT

Create Workflow Item is running for sometime and failing with the below error. Error was captured from ArcGIS Server logs.

! @7ljj2046l - Internal server error, for (POST) [/workflow/admin/createWorkflowItem?name=Workflow%20Item%205&token=1vwTx2yA8HsT9PghnM34DYo2qjxnoGKyngpZEep_Zy9QOMrTwuaKOvdY9vIou8Drv0ziA6QHqnLJnZeg2LmH0AZhFqqSZg9dclJq99SrSFeAmqdF_tdSmoJ96YFV3igUtTsoEv-dqlih2xiIkIC0Qpiu2GuPBJ-FP4tg4mrGDX5_Dm2mM1qBfhAq6me5qEslKTsucKqh8kcswQ2GuG5LWvJ-OfKy3PUHJCfU-l45GuiCtiAPek2cnFs33sRvJMfG8JAWzmvFvvEdiw..] -> play.api.UnexpectedException: Unexpected exception[WorkflowDataStoreException: Failed to create schema] at play.api.http.HttpErrorHandlerExceptions$.throwableToUsefulException(HttpErrorHandler.scala:355) Caused by: esri.workflow.exceptions.WorkflowDataStoreException: Failed to create schema at esri.workflow.exceptions.WorkflowDataStoreException$.apply(Exceptions.scala:68)

Environment:

OS: Windows Server 2012 R2 Standard
ArcGIS Workflow Manager 10.9

Patches applied:

ArcGIS Workflow Manager 10.9 Patch 1 (Server | Web App)
- WorkflowManagerServer_10.9_Patch1.msp
- WMXWebApp_10.9_Patch1.msp

Re: WorkflowDataStoreException: Failed to create schema

JFarmer — Wed, 10 Nov 2021 16:48:03 GMT

@Ranga_Tolapi

When you say that the create workflow item process is running for sometime, how long does it go before this error occurs? Are you able to create regular hosted layers in your Portal environment?

Is there any security software in this environment? If so, what is it?

All this may help narrow it down a bit.

Thanks,

Jonathan

Re: WorkflowDataStoreException: Failed to create schema

Ranga_Tolapi — Thu, 11 Nov 2021 03:45:24 GMT

Create workflow item process took around 65 sec. before the error occurred. Enclosed the trimmed video on the same.

Unable to create regular hosted layer in Portal. Enclosed the screenshot of the error.

Re: WorkflowDataStoreException: Failed to create schema

JFarmer — Thu, 11 Nov 2021 16:30:38 GMT

Hi @Ranga_Tolapi

Thanks. It does sound like this may not be Workflow Manager related but an issue with Portal hosted layers itself. When you create a workflow item in the Workflow Manager Web App, we are creating 3 things in your Portal

1. Workflow Item

2. Hosted layer containing all of your data

3. Hosted layer view containing information on your job locations.

I'd recommend you work with Tech Support to get the Portal issues sorted out and then see if that resolves your create workflow item problem. But, until you can create a regular hosted layer in your Portal, this likely won't work either.

Re: WorkflowDataStoreException: Failed to create schema

Ranga_Tolapi — Fri, 12 Nov 2021 02:31:53 GMT

Hi @JFarmer

Thank you.

After multiple attempts of restarting Portal windows service and the machine itself, was able to create Workflow Item successfully.

Now the issue is with connecting to Workflow Item from ArcGIS Pro (version 2.8.3).

Under Workflow pane in Pro, able to select Workflow Manager Portal and can see Workflow item.

However, after selecting the workflow item and clicking on Connect button, getting an error. Please refer to the below screenshot.

Re: WorkflowDataStoreException: Failed to create schema

JFarmer — Fri, 12 Nov 2021 13:42:22 GMT

@Ranga_Tolapi

Good news on the item creation!

For Pro, have you federated your Workflow Manager Server machine using a web adaptor? Or over port 6443? If you used the port, you'll want to switch that to use a web adaptor.

If that isn't it, I'm going to reiterate my suggestion to work with Tech Support. There are some troubleshooting steps they can take to get more information, including setting up logs in Pro.

Jonathan

Re: WorkflowDataStoreException: Failed to create schema

Ranga_Tolapi — Sat, 13 Nov 2021 05:52:07 GMT

@JFarmer

Initially used ArcGIS Enterprise Builder 10.8.1 for base deployment, later upgraded the deployment using ArcGIS Enterprise Builder 10.9.

Both ArcGIS Workflow Manager Server and ArcGIS Workflow Manager Web App were installed on the same machine that of base deployment.

ArcGIS Enterprise Builder federated ArcGIS Server using web adaptor only, please refer to the below screenshot.

Enabled server roles are:

Note: ArcGIS Pro installed on a separate machine, it got access to "Service URL", but no access to "Administration URL" of above screenshot.

Re: WorkflowDataStoreException: Failed to create schema

JFarmer — Tue, 16 Nov 2021 13:38:44 GMT

@Ranga_Tolapi

I don't see anything off in that configuration. ArcGIS Pro should be using that services URL to do what it needs.

I'd say next steps would be setting up and looking at logs in Pro. I've included a screen shot below of what that should be. These are entries into the registry editor on your Pro machine. You'll need to add the WorkflowManager folder and then the entries for the log level and path manually. The path is a location you choose and the level should be set to 5. Once this is setup, open ArcGIS Pro and try to connect.

Re: WorkflowDataStoreException: Failed to create schema

Ranga_Tolapi — Wed, 24 Nov 2021 15:20:05 GMT

With the help of Esri technical team got to know that, root cause of this issue is the self-signed certificate (without Subject Alternative Name) of the web server (IIS) where Portal and ArcGIS Server web adaptors were installed.

Recreated the self-signed certificate with Subject Alternative Name and bind it to IIS. With this, Workflow Manager connectivity issue from ArcGIS Pro was successfully resolved.