How to import the UpdateDate coloumn data from database

[AravindK]

Hi Team,

We have a column called Update_Date in DB and we are trying to import through ACCOUNTSIMPORT.
we are able to fetch all the attributes and but not able to import the Update_Date and getting this error .

Mapping:

<mapfield saviyntproperty="accounts.created_on" sourceproperty="Update_date" type="date"></mapfield>

Error Message :

No such property: Update for class: groovy.sql.GroovyRowResult

Logs :

[quartzScheduler_Worker-12] ERROR saviynt.AccountsImportService - Exception in AccountsImportService
groovy.lang.MissingPropertyException: No such property: Update for class: groovy.sql.GroovyRowResult


Thanks,
Aravind

[rushikeshvartak]

Column alias should not contain underscore

[AravindK]

@rushikeshvartak We have 30 columns and all columns have underscore and able to fetch those into Saviynt but only update_date not able to fetch.

[rushikeshvartak]

Does date in required format ?

[FranciscoS]

Hi!

@AravindK did you manage to solve the issue?

Thanks in advance.

[FranciscoS]

Dear @AravindK ,

I have tried solution provided by @rushikeshvartak and it worked for me. I want to clarify some details about configuration in accountsimport JSON that made it possible:

1. Sourceproperty in the mapper entry should not contain underscore.

2. Therefore, sql-query included in CDATA must contain alias for every column whose name has got an underscore.

Example:

<dataMapping>

<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="name" >
<![CDATA[select SURNAME,EMAIL,EMPLOYEE_CODE AS EMPLOYEECODE from TABLENAME]]>
</sql-query>

<mapper description="This is the mapping field for Saviynt Field name" accountnotinfileaction="Suspend" deleteaccountentitlement="true" ifusernotexists="noaction">
<...>
<mapfield saviyntproperty="accounts.customproperty2" sourceproperty="SURNAME" type="character"></mapfield>
<mapfield saviyntproperty="accounts.customproperty3" sourceproperty="EMAIL" type="character"></mapfield>
<mapfield saviyntproperty="accounts.customproperty4" sourceproperty="EMPLOYEECODE" type="character"></mapfield>

<...>

<dataMapping>

<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="name" >
<![CDATA[select SURNAME,EMAIL,EMPLOYEE_CODE AS EMPLOYEECODE from TABLENAME]]>
</sql-query>

<mapper description="This is the mapping field for Saviynt Field name" accountnotinfileaction="Suspend" deleteaccountentitlement="true" ifusernotexists="noaction">
<...>
<mapfield saviyntproperty="accounts.customproperty2" sourceproperty="SURNAME" type="character"></mapfield>
<mapfield saviyntproperty="accounts.customproperty3" sourceproperty="EMAIL" type="character"></mapfield>
<mapfield saviyntproperty="accounts.customproperty4" sourceproperty="EMPLOYEECODE" type="character"></mapfield>

<...>

[FranciscoS]

@AravindK 

PD: Could you be so kind to mark the most detailed and correct reply as the solution in order to help other colleagues within the community to solve this issue?

Many thanks in advance