Saviynt Forums

shubhangsinha_ · ‎05/31/2023

Hello everyone ,

I am trying to import accounts from a MSSQL server database using DB connector in Saviynt but it is failing with the below error, please suggest any changes which I can make to my account import -->

"ecm-worker","2023-05-31T11:04:58.648+00:00","{"log":"31-May-2023 11:04:57.930 WARNING [quartzScheduler_Worker-8] groovy.sql.Sql.handleError Rolling back due to: No signature of method: java.lang.Long.replace() is applicable for argument types: (java.lang.String, java.lang.String) values: [\\, \\\\]\n","stream":"stderr","time":"2023-05-31T11:04:57.930683814Z"}"
"ecm-worker","2023-05-31T11:04:58.648+00:00","{"log":"2023-05-31 11:04:57,931 [quartzScheduler_Worker-8] ERROR saviynt.AccountsImportService - Error processing records\n","stream":"stdout","time":"2023-05-31T11:04:57.933054904Z"}"
"ecm-worker","2023-05-31T11:04:58.648+00:00","{"log":"groovy.lang.MissingMethodException: No signature of method: java.lang.Long.replace() is applicable for argument types: (java.lang.String, java.lang.String) values: [\\, \\\\]\n","stream":"stdout","time":"2023-05-31T11:04:57.933066999Z"}"

Here is the account import I have configured as well -->

Thank you .

sudeshjaiswal · ‎06/01/2023

Hello @shubhangsinha_,

Please review the following Account Import configuration and ensure that the SQL query's attributes are present in the system. Run the query and verify if it produces the desired outputs.

Sample Query:

```xml
<dataMapping>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="UI">
<![CDATA[
SELECT
CAST(userid AS VARCHAR) AS UI,
email AS EM,
epf AS CP12,
UserName AS username,
'TEST_SS' AS systemname,
'TEST_SS' AS endpoint,
'1' AS status
FROM
[User]
]]>
</sql-query>
<mapper description="This is the mapping field for Saviynt Field name" accountnotinfileaction="Suspend" deleteaccountentitlement="true" ifusernotexists="noaction">
<mapfield saviyntproperty="accounts.customproperty12" sourceproperty="UI" type="character"/>
<mapfield saviyntproperty="accounts.customproperty14" sourceproperty="EM" type="character"/>
<mapfield saviyntproperty="accounts.name" sourceproperty="CP12" type="character"/>
<mapfield saviyntproperty="accounts.customproperty2" sourceproperty="username" type="character"/>
<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="systemname" type="character"/>
<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpoint" type="character"/>
<mapfield saviyntproperty="accounts.status" sourceproperty="status" type="character"/>
</mapper>
</dataMapping>
```

Please note that the provided link is for reference and contains additional information on configuring the integration for importing accounts.

Thank you.

For Ref:-
https://docs.saviyntcloud.com/bundle/Database-v23x/page/Content/Configuring-the-Integration-for-Impo...

If you find the above response useful, Kindly Mark it as "Accept As Solution".

shubhangsinha_ · ‎06/06/2023

Thank you , this worked!

Saviynt Forums

Database account import from MSSQL server is failing