Salesforce Connector Access Recon job issue

[Anu]

Hi ,

We have setup a salesforce connector and provided the below filter query. The account recon job is executed successful however when we run access recon issue we are getting below error message.

Error::InvalidBatch : Failed to process query: MALFORMED_QUERY: unexpected token: 'username'

OBJECT_TO_BE_IMPORTED: Account,Profile,Group,PermissionSet,Role,Territory,PermissionSetLicense
ACCOUNT_FILTER_QUERY:(Profile.name IN ('profile1','profile2') and (NOT Username like '%@xyz%'))
ACCOUNT_FIELD_QUERY:Id, Username, LastName, FirstName, Name, CompanyName, Email, IsActive, UserRoleId, ProfileId, UserType, ManagerId, LastLoginDate,LastPasswordChangeDate, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp,AccountId, FederationIdentifier, CallCenterId, UserPermissionsSupportUser, Country, CommunityNickname, TimeZoneSidKey, LocaleSidKey,Emp_UserType__c
FIELD_MAPPING_JSON:
{
"accountfield_mapping": {
"accountID": "Id~#~char",
"name": "Username~#~char",
"customproperty2": "LastName~#~char",
"customproperty1": "FirstName~#~char",
"displayName": "Name~#~char",
"customproperty3": "CompanyName~#~char",
"customproperty4": "Email~#~char",
"customproperty10": "IsActive~#~bool",
"customproperty5": "UserRoleId~#~char",
"customproperty6": "ProfileId~#~char",
"accounttype": "UserType~#~char",
"customproperty7": "ManagerId~#~char",
"lastlogondate": "LastLoginDate~#~date",
"lastpasswordchange": "LastPasswordChangeDate~#~date",
"CREATED_ON": "CreatedDate~#~date",
"creator": "CreatedById~#~char",
"customproperty8": "LastModifiedDate~#~date",
"updateUser": "LastModifiedById~#~char",
"updatedate": "SystemModstamp~#~date",
"customproperty11": "AccountId~#~char",
"customproperty13": "FederationIdentifier~#~char",
"customproperty20": "UserPermissionsSupportUser~#~bool",
"customproperty23": "Country~#~char",
"customproperty27": "CommunityNickname~#~char",
"customproperty30": "CallCenterId~#~char",
"customproperty31": "TimeZoneSidKey~#~char",
"customproperty32": "LocaleSidKey~#~char",
"customproperty33": "Emp_UserType__c~#~char"
}
}

[nimitdave]

@Anu 

1. Are you getting response from postman using this query?

2. Also to isolate the issue pls try the without not keyword.

3. without braces 

[Anu]

Hi @nimitdave  Please find my response inline. The job is failing only when we run access recon Job. The issue only seems to be with not like condition, It is important for us to exclude users which contain "xyz" Do we have any alternate solution for this in salesforce OOTB?

1. Are you getting response from postman using this query? Tried the below in postman but not getting response However we have been able to reconcile the accounts successful in saviynt. The job is failing only when we run access recon Job. 

https://xxx.salesforce.com/services/data/v57.0/query?q=Select Id, Username from User where NOT Username like '%@xyz%'

2. Also to isolate the issue pls try the without not keyword. : Without not like keyword condition both Account and Access job execute successful

3. without braces : Tried without braces still the same error

[nimitdave]

@Anu , please create a support ticket and and provide this forum link in that. also Pls attach below:

1. all connector jsons

2. complete logs for account and access import.

3. logs for access import with not and without not keyword.

[Anu]

@nimitdave  Thanks for your response. We have created the ticket and provided the required details . Awaiting response.

https://saviyntsupport.saviynt.com/support/tickets/2004303