Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

How to import the UpdateDate coloumn data from database

AravindK
Regular Contributor
Regular Contributor

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
6 REPLIES 6

rushikeshvartak
All-Star
All-Star

Column alias should not contain underscore


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

AravindK
Regular Contributor
Regular Contributor

@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.

 

Does date in required format ?


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

FranciscoS
New Contributor III
New Contributor III

Hi!

@AravindK did you manage to solve the issue?

Thanks in advance.

FranciscoS
New Contributor III
New Contributor III

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
New Contributor III
New Contributor III

@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