WSRETRY / Provisioing Job Not Picking Up Pending Tasks

[msharma]

Hello,

Our Provisioning Jobs are failing (for at least two different security systems) with the following error and all associated Pending Tasks remain to be Pending even after the Provisioning Job ends as "success" under Job Control Panel.

There seems to be a connection error following a getToken call. Any advise on why this is happening and where this could possibly be configured would really help us troubleshoot this further.

DEBUG jobs.WSRetryJob - starting connectorserver logic.

DEBUG externalws.ExternalConnectorService - Enter syncConnectorTasksToCloud

DEBUG externalws.ExternalConnectorService - Enter callcloudwebservice... json

DEBUG externalws.ExternalConnectorService - json is --- {\"nodeuuid\":\"22ba2d60-a7de-438b-ad4c-555335116b51\",\"systemNameListStr\":\"TEST_Database\"}

DEBUG externalws.ExternalConnectorService - Enter getToken

DEBUG externalws.ExternalConnectorService - Preparing POST call - POST http://192.168.255.2:4444/connect2/api/login HTTP/1.1

ERROR externalws.ExternalConnectorService - Error in webservice call = Connection timed out (Connection timed out)

----- ATTACHED FULL WSRETRY LOG EXCERPT -----

[rushikeshvartak]

• Does Automated Provisioning enabled under endpoint ?
• Does entitlement is active ?
• Does security system have any provisioning threshold added ?

[msharma]

Hello Rushikesh,

Thanks for the quick response.

• Does Automated Provisioning enabled under endpoint ? - Yes it is
• Does entitlement is active ? - No active entitlements were requested. Pending tasks are "New Account" Task Type
• Does security system have any provisioning threshold added ? - No thresholds are added.

Thanks,

Maruthi

[rushikeshvartak]

Which connector ?

Does connector have createAccountJSON

Does any comments visible under tasks after provisioning job executed ?

[msharma]

This is a DB connection. We have following CREATEACCOUNTJSON

{
  "createaccountqry": "Insert into targetusers (FirstName,LastName,EmailAddress,Username) values ( '${user.firstname}', '${user.lastname}', '${user.email}','${user.username}')";
}

 No Provisioning Metadata or Comments were present (attached screenshot)

[rushikeshvartak]

createAccountQry

{
  "createAccountQry": "Insert into targetusers (FirstName,LastName,EmailAddress,Username) values ( '${user.firstname}', '${user.lastname}', '${user.email}','${user.username}')";
}

[msharma]

Hello Rushikesh,

We tried using createAccountQry and are still seeing the same errors when provisioning job is run.

Please note that when we turn on instant provisioning, accounts are getting created on target system. But, whenever we have pending tasks (instant provisioning is turned off) & when we run WSRETRY job, we don't see any outcome and see the following errors

{"log":"2022-11-02 09:50:26,137 [quartzScheduler_Worker-10] DEBUG externalws.ExternalConnectorService - Enter syncConnectorTasksToCloud\n","stream":"stdout","time":"2022-11-02T09:50:26.137547026Z"}

{"log":"2022-11-02 09:50:26,138 [quartzScheduler_Worker-10] DEBUG externalws.ExternalConnectorService - Enter callcloudwebservice... json\n","stream":"stdout","time":"2022-11-02T09:50:26.138328Z"}

{"log":"2022-11-02 09:50:26,138 [quartzScheduler_Worker-10] DEBUG externalws.ExternalConnectorService - json is --- {\"nodeuuid\":\"22ba2d60-a7de-438b-ad4c-555335116b51\",\"systemNameListStr\":\"TEST_Database\"}\n","stream":"stdout","time":"2022-11-02T09:50:26.138350257Z"}

{"log":"2022-11-02 09:50:26,141 [quartzScheduler_Worker-10] DEBUG externalws.ExternalConnectorService - Enter getToken\n","stream":"stdout","time":"2022-11-02T09:50:26.141508107Z"}

{"log":"2022-11-02 09:50:26,141 [quartzScheduler_Worker-10] DEBUG externalws.ExternalConnectorService - Preparing POST call - POST http://xxx.xxx.xxx.x:4444/connect2/api/login HTTP/1.1\n","stream":"stdout","time":"2022-11-02T09:50:26.141671416Z"}

{"log":"2022-11-02 09:52:37,179 [quartzScheduler_Worker-10] ERROR externalws.ExternalConnectorService - exception in get token--\n","stream":"stdout","time":"2022-11-02T09:52:37.180568239Z"}

{"log":"java.net.ConnectException: Connection timed out (Connection timed out)\n","stream":"stdout","time":"2022-11-02T09:52:37.180605152Z"}

[rushikeshvartak]

java.net.ConnectException: Connection timed out

You have connectivity issue.

[msharma · Accepted solution]

Hello Everyone,

The issue got resolved. We had an issue with SC2 Connect. Hence the below message in logs before the error.

DEBUG externalws.ExternalConnectorService - Preparing POST call - POST http://192.168.255.2:4444/connect2/api/login HTTP/1.1