Saviynt Forums

Sekhar · ‎07/03/2024

Hi,

Iam trying to import the accounts from DB connection to saviynt but it is not importing.

used Query:

Error:

No signature of method: [B.replace() is applicable for argument types: (java.lang.String, java.lang.String) values: [\, \\]

Could you please anyone help me in this issue.

Thanks,

Sekhar

NM · ‎07/03/2024

@Sekhar , update status

Sekhar · ‎07/03/2024

Hi @NM

I tried above one but it is giving same error again.

NM · ‎07/03/2024

@Sekhar share debug logs

SumathiSomala · ‎07/03/2024

@Sekhar What are the possible values for status?

Replace the actual name od ep and ss name in the query

'<endpointname>' as 'endpoint',
'<securitysystemname>' as 'securitysystem',

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

Raghu · ‎07/03/2024

@Sekhar try below

<dataMapping>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="name">
<![CDATA[
select
sam_account_name as 'USERID',
employee_id as 'EMPLOYEEID',
'endpoint' as endpoint,
'securitysystem' as securitysystem,
'1' as 'status',
upn as 'accountcn',
email_address as 'emailAdd',
ad_guid as 'Guid',
ad_account_status as 'accStatus',
utc_created_ts as 'createdDate',
utc_modified_ts as 'modifiedDate'
from [DB name]
]]>
</sql-query>
<importsettings>
<zeroDayProvisioning>false</zeroDayProvisioning>
<userNotInFileAction>NOACTION</userNotInFileAction>
<checkRules>false</checkRules>
<buildUserMap>false</buildUserMap>
</importsettings>
<mapper description="This is the mapping field for Saviynt Field name" accountnotinfileaction="noaction" deleteaccountentitlement="true" dateformat="date" ifusernotexists="noaction" systems="'securitysystem'">
<mapfield saviyntproperty="accounts.name" sourceproperty="USERID" type="character"/>
<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="securitysystem" type="character"/>
<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpoint" type="character"/>
<mapfield saviyntproperty="accounts.status" sourceproperty="status" type="character"/>
<mapfield saviyntproperty="accounts.accountID" sourceproperty="accountcn" type="character"/>
<mapfield saviyntproperty="users.username" sourceproperty="accountcn" type="character"/>
<mapfield saviyntproperty="accounts.customproperty1" sourceproperty="EMPLOYEEID" type="character"/>
<mapfield saviyntproperty="accounts.customproperty2" sourceproperty="emailAdd" type="character"/>
<mapfield saviyntproperty="accounts.customproperty3" sourceproperty="Guid" type="character"/>
<mapfield saviyntproperty="accounts.customproperty4" sourceproperty="accStatus" type="character"/>
<mapfield saviyntproperty="accounts.customproperty5" sourceproperty="createdDate" type="date"/>
<mapfield saviyntproperty="accounts.customproperty6" sourceproperty="modifiedDate" type="date"/>
</mapper>
</dataMapping>

Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

rushikeshvartak · ‎07/03/2024

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Sekhar · ‎07/04/2024

Hi @rushikeshvartak

If i remove the GUID mapping in the above query then working fine else still getting same error.

No signature of method: [B.replace() is applicable for argument types: (java.lang.String, java.lang.String) values: [\, \\]

I need to add GUID as well, please suggest how can i add it.

Thanks,

Sekhar

SumathiSomala · ‎07/04/2024

@Sekhar what is the datatype for GUID in the database?

then adjust the mapping

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

Sekhar · ‎07/04/2024

Hi @SumathiSomala ,

GUID datatype is varbinary in database.

I tried with <mapfield saviyntproperty="accounts.customproperty3" sourceproperty="Guid" type="Binary"/> .

Job is success but GUID value is not imported into CP.

Thanks,

Sekhar

rushikeshvartak · ‎07/04/2024

What is target database ?

cast the data

SELECT CONVERT(varbinary_column USING utf8) AS char_column FROM your_table;

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Sekhar · ‎07/04/2024

Hi @rushikeshvartak

Target database is MS SQL SERVER.

I tried with below query but getting error i.e, Incorrect syntax near 'USING'

I tried for GUID mapping as Varbinary & character but facing same error.

<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="name">

<![CDATA[

select sam_account_name as 'USERID',

employee_id as 'EMPLOYEEID',

ENDPOINT as 'endpoint',

SYSTEM as 'securitysystem',

upn as 'accountcn',

email_address as 'emailAdd',

ad_account_status as 'accStatus',

CASE WHEN ad_account_status = 'Enabled' THEN 1 ELSE 0 END as 'status',

utc_created_ts as 'createdDate',

utc_modified_ts as 'modifiedDate',

CONVERT(ad_guid USING utf8)as 'Guid'

from TABLE ]]>

</sql-query>

</mapper>

</dataMapping>

Thanks.

Sekhar

rushikeshvartak · ‎07/04/2024

-- Using CAST
SELECT CAST(your_varbinary_column AS CHAR(length)) AS your_char_column
FROM your_table;

-- Using CONVERT
SELECT CONVERT(CHAR(length), your_varbinary_column) AS your_char_column
FROM your_table;

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Saviynt Forums

Getting error while importing the account from DB connection to saviynt