Test connection fails in Webservices COnnector

P96337 · September 27, 2024, 11:55pm

Hi Team,

I am getting the below error when attempting a test connection for a Web Services Connector. Any Ideas?

Exception occurred in Test Connection. Error: class java.lang.String cannot be cast to class java.util.Map (java.lang.String and java.util.Map are in module java.base of loader 'bootstrap')

liamkokeeffe · September 28, 2024, 12:38am

Hi Marvin,

Could you show us what your Test Connection operation configuration looks like? Are you attempting to map any attributes in the Test Connection operation?

Thanks,

Liam

P96337 · September 30, 2024, 12:02pm

Hi Liam,

Thanks for chiming in. I am not attempting to map attributes in the test connection.

See below.

Test Connection
Operation Name
Test Connection
Operation Type
Test Connection
Use cURL Command
false
Context URL
odatav4/searchStudent/v1/Students?$filter=criteria/domainIDs eq %2785350%27
HTTP Method
GET
Authorization
Bearer $application.accesstoken$
Root Path
Success Codes (1)
2**
Account Aggregation
Operation Name
Account Aggregation
Operation Type
Account Aggregation
Use cURL Command
false
Context URL
odatav4/searchStudent/v1/Students?$top=200&amp;$skip=0
HTTP Method
GET
Authorization
Bearer $application.accesstoken$
Content-Type
application/json;odata.metadata=minimal
Root Path
$.value
Success Codes (1)
2**
studentID
studentID
personExternalID
personExternalID
emailAddr
emailAddr
Parent Endpoint Name
Initial Page Offset
0
Page Size
200
Paging Steps
$sysparm_limit$ = 200 TERMINATE_IF $RECORDS_COUNT$ &lt; $sysparm_limit$ $sysparm_offset$ = $sysparm_offset$ + $sysparm_limit$ $endpoint.fullUrl$ = $application.baseUrl$ + &quot;odatav4/searchStudent/v1/Students?$top=200&amp;$skip=&quot; + $sysparm_offset$
Account Aggregation 2
Operation Name
Account Aggregation 2
Operation Type
Account Aggregation
Use cURL Command
false
Context URL
odatav4/public/user/learningHistory/v1/learninghistorys?$filter=criteria/targetUserID%20eq%20&#39;$response.studentID$&#39;
HTTP Method
GET
Authorization
Bearer $application.accesstoken$
Content-Type
application/json;odata.metadata=minimal
Root Path
Success Codes (1)
2**
componentID
$.value[*].componentID
title
$.value[*].title
status
$.value[*].status
Parent Endpoint Name
Account Aggregation
Initial Page Offset
0
Page Size
200
Paging Steps
Entitlement Aggregation
Operation Name
Entitlement Aggregation
Operation Type
Group Aggregation
Use cURL Command
false
Context URL
odatav4/public/admin/searchItem/v1/Items?$filter=criteria/itemTypeIDs eq 'COURSE'&amp;$top=200&amp;$skip=0
HTTP Method
GET
Authorization
Bearer $application.accesstoken$
Content-Type
application/json;odata.metadata=minimal
Root Path
$.value
Success Codes (1)
2**
itemID
itemID
title
title
Parent Endpoint Name
Initial Page Offset
0
Page Size
200
Paging Steps
$sysparm_limit$ = 200 TERMINATE_IF $RECORDS_COUNT$ &lt; $sysparm_limit$ $sysparm_offset$ = $sysparm_offset$ + $sysparm_limit$ $endpoint.fullUrl$ = $application.baseUrl$ + &quot;odatav4/public/admin/searchItem/v1/Items?$filter=criteria/itemTypeIDs eq 'COURSE'&amp;$top=200&amp;$skip=&quot; + $sysparm_offset$
Entitlement Aggregation 2
Operation Name
Entitlement Aggregation 2
Operation Type
Group Aggregation
Use cURL Command
false
Context URL
odatav4/public/admin/searchItem/v1/Items?$filter=criteria/itemTypeIDs eq 'ILT'&amp;$top=200&amp;$skip=0
HTTP Method
GET
Authorization
Bearer $application.accesstoken$
Content-Type
application/json;odata.metadata=minimal
Root Path
$.value
Success Codes (1)
2**
itemID
itemID
title
title
Parent Endpoint Name
Initial Page Offset
0
Page Size
200
Paging Steps
$sysparm_limit$ = 200 TERMINATE_IF $RECORDS_COUNT$ &lt; $sysparm_limit$ $sysparm_offset$ = $sysparm_offset$ + $sysparm_limit$ $endpoint.fullUrl$ = $application.baseUrl$ + &quot;odatav4/public/admin/searchItem/v1/Items?$filter=criteria/itemTypeIDs eq 'ILT'&amp;$top=200&amp;$skip=&quot; + $sysparm_offset$
Entitlement Aggregation 3
Operation Name
Entitlement Aggregation 3
Operation Type
Group Aggregation
Use cURL Command
false
Context URL
odatav4/public/admin/searchItem/v1/Items?$filter=criteria/itemTypeIDs eq 'CHECKLIST'&amp;$top=200&amp;$skip=0
HTTP Method
GET
Authorization
Bearer $application.accesstoken$
Content-Type
application/json;odata.metadata=minimal
Root Path
$.value
Success Codes (1)
2**
itemID
itemID
title
title
Parent Endpoint Name
Initial Page Offset
0
Page Size
200
Paging Steps
$sysparm_limit$ = 200 TERMINATE_IF $RECORDS_COUNT$ &lt; $sysparm_limit$ $sysparm_offset$ = $sysparm_offset$ + $sysparm_limit$ $endpoint.fullUrl$ = $application.baseUrl$ + &quot;odatav4/public/admin/searchItem/v1/Items?$filter=criteria/itemTypeIDs eq 'CHECKLIST'&amp;$top=200&amp;$skip=&quot; + $sysparm_offset$

zeel_sinojia · September 30, 2024, 12:08pm

Do you have any rules attached to the Test Connection operation?

Also if you could get snapshots/json of the Test Connection operation would help us to debug the issue.

rohit_wekhande · September 30, 2024, 12:56pm

Hello,

There is high possible that you are getting this Java exception of “Exception occurred in Test Connection. Error: class java.lang.String cannot be cast to class java.util.Map” because of an Web Service Before Ops Rule or Before Prov Rule which is attached to your source which is using web service connector where for a particular operation, the data is in key value pair but you have declared the variable to capture that data as String due to which you are getting cannot cast exception.

Regards,
Rohit

P96337 · September 30, 2024, 6:04pm

Hi Zeel,

Not the test Operation but for the Account Aggregation 2 there is a WebServiceAfterOperationRule attached. See below from the Source Config.

{
                "httpMethodType": "GET",
                "sequenceNumberForEndpoint": "2",
                "uniqueNameForEndPoint": "Test Connection",
                "afterRule": null,
                "curlCommand": null,
                "rootPath": null,
                "body": {
                    "jsonBody": null,
                    "bodyFormat": "raw"
                },
                "responseCode": [
                    "2**"
                ],
                "resMappingObj": null,
                "contextUrl": "odatav4/searchStudent/v1/Students?$filter=criteria/domainIDs eq %2785350%27",
                "curlEnabled": false,
                "header": {
                    "Authorization": "Bearer $application.accesstoken$"
                },
                "operationType": "Test Connection",
                "beforeRule": null,
                "xpathNamespaces": null,
            }

{
                "httpMethodType": "GET",
                "pagingInitialOffset": 0,
                "sequenceNumberForEndpoint": "4",
                "uniqueNameForEndPoint": "Account Aggregation 2",
                "afterRule": "Parkland Pathways Concatenate Course",
                "curlCommand": null,
                "rootPath": null,
                "body": {
                    "bodyFormData": null,
                    "jsonBody": null,
                    "bodyFormat": "raw"
                },
                "customAuthUrl": null,
                "paginationSteps": null,
                "responseCode": [
                    "2**"
                ],
                "resMappingObj": {
                    "componentID": "$.value[*].componentID",
                    "title": "$.value[*].title",
                    "status": "$.value[*].status"
                },
                "contextUrl": "odatav4/public/user/learningHistory/v1/learninghistorys?$filter=criteria/targetUserID%20eq%20&#39;$response.studentID$&#39;",
                "pagingSize": 200,
                "curlEnabled": false,
                "header": {
                    "Authorization": "Bearer $application.accesstoken$",
                    "Content-Type": "application/json;odata.metadata=minimal"
                },
                "operationType": "Account Aggregation",
                "beforeRule": null,
                "xpathNamespaces": null,
                "parentEndpointName": "Account Aggregation"
            }

P96337 · September 30, 2024, 6:06pm

Hi Rohit,

I was thinking down the same path as you but the only rule I see connected is the one below.

{
                "httpMethodType": "GET",
                "pagingInitialOffset": 0,
                "sequenceNumberForEndpoint": "4",
                "uniqueNameForEndPoint": "Account Aggregation 2",
                "afterRule": "Parkland Pathways Concatenate Course",
                "curlCommand": null,
                "rootPath": null,
                "body": {
                    "bodyFormData": null,
                    "jsonBody": null,
                    "bodyFormat": "raw"
                },
                "customAuthUrl": null,
                "paginationSteps": null,
                "responseCode": [
                    "2**"
                ],
                "resMappingObj": {
                    "componentID": "$.value[*].componentID",
                    "title": "$.value[*].title",
                    "status": "$.value[*].status"
                },
                "contextUrl": "odatav4/public/user/learningHistory/v1/learninghistorys?$filter=criteria/targetUserID%20eq%20&#39;$response.studentID$&#39;",
                "pagingSize": 200,
                "curlEnabled": false,
                "header": {
                    "Authorization": "Bearer $application.accesstoken$",
                    "Content-Type": "application/json;odata.metadata=minimal"
                },
                "operationType": "Account Aggregation",
                "beforeRule": null,
                "xpathNamespaces": null,
                "parentEndpointName": "Account Aggregation"
            }

udayputta · September 30, 2024, 6:26pm

In your Account Aggregation 2 operation you does not have rootpath configured. Can you put a sample response on how you are getting compoentID, title and status. You might have to check your rule where this error would be throwing.

zeel_sinojia · October 1, 2024, 5:06am

Hey Marvin,

High chance you are getting this error because of your after rule. Check if you’re assigning a variable to a Map.

I had got similar error when mapping rawResponseObject directly to a Map. Could be the same reason for you.

Please check this once.

rohit_wekhande · October 1, 2024, 10:49am

Hello,

Validate the rule as highlighted below.

There could be some issues there because the error which you are getting is more of sort of Java Error and high changes that you will get it in before or after create web service rule.

Thank You,

Regards,
Rohit

P96337 · October 2, 2024, 6:51pm

Thanks Rohit and everyone,

Let me dig into your suggestions. I’ll keep you posted.

P96337 · October 9, 2024, 12:33am

Hi Team,

I ended up having to create another source as I was not able to determine what part of the rule was causing the issue. Thanks everyone for the assist. Much appreciated.

saikumarS · October 21, 2024, 8:14am

You didn’t find any root cause of this, Otherthan creating new source ?

P96337 · November 3, 2024, 2:38am

That’s correct my friend

Topic		Replies	Views
Attempts to use WSBO rule produces cannot be cast to class java.lang.String error ISC Discussion and Questions identity-security-cloud	4	738	November 17, 2023
Getting Error while AD Test Connection - Exception occurred while executing the RPCRequest: Errors returned from IQService. Unable to cast object of type 'System.String' to type 'System.Collections.ArrayList' ISC Discussion and Questions identity-security-cloud , provisioning	6	260	June 9, 2024
Webservice connector connectivity issue ISC Discussion and Questions webservice-connector , identity-security-cloud , connectors	3	46	November 1, 2024
Timeout error while doing test connection for web service connector ISC Discussion and Questions webservice-connector , identity-security-cloud	3	211	June 1, 2024
Custom Web Services Connector Pagination failing ISC Discussion and Questions webservice-connector , aggregation , identity-security-cloud	10	189	July 28, 2024

Test connection fails in Webservices COnnector

Related topics