Saviynt Forums

ChrisBellobuono · 02/02/2024

It appears Saviynt does not support SQL containing CTEs (Common Table expression), specifically something as simple as this: with tmp as ( select USERKEY from USERS where FIRSTNAME = 'John' and LASTNAME = 'Smith' ) select * from tmp I...

ChrisBellobuono · 08/11/2023

We are experiencing the exact issue described in this now closed forum post: https://forums.saviynt.com/t5/identity-governance/indicator-of-ecm-restart-in-v23-x/m-p/33983Unfortunately, there is no mention as to what the actual fix was as it was resol...

ChrisBellobuono · 08/02/2023

As the subject states, we are unable to get #CONST#${ <javascript> } mapping values to work as it always results in the job failing with:Error in Users Import - Error while processing data: Data truncation: Data too long for column 'CUSTOMPROPERTY1' ...

ChrisBellobuono · 07/28/2023

We have setup a connection to SuccessFactors but when we try to do a User Import ( User Import via a Connection (UserImportJob) ) the job fails with the error "Failed to import one or more object types." without any details. The logs do not provide ...

ChrisBellobuono · 07/25/2023

We are trying to perform an incremental user update from a database ( Users Import (Incremental) from Database (UserImportIncrementalJob) ) but the job's updated user count is always zero and our test users are not being updated. Since we do not have...

ChrisBellobuono · 02/06/2024

Which I find really odd since it supports more advanced syntax like:select ... count(*) over (partition by FIRSTNAME, LASTNAME) as num_name, ...I also noticed that it will fail if there is any whitespace in front of the select.I will open a tic...

ChrisBellobuono · 09/11/2023

The XML is attached as requested.FYI, this problem is not limited to this connection. We are experiencing the same problem with a newly created connection to a PeopleSoft DB.

ChrisBellobuono · 09/08/2023

Per support's request, I am posting an updated summary of where we are.Our current configuration:DB "last modified" column: UPDATED_DATE (timestamp)Mapper: <mapper dateformat="timestamp" incrementalcolumn="UPDATED_DATE">Map Field: <mapfield saviyntpr...

ChrisBellobuono · 09/07/2023

We have a ticket opened with support about this and have been working with them for a few weeks on it. All of our code works as expected in the jdoodle groovy tester. Support is looking into why it works there and not in Saviynt. Once we have a so...

ChrisBellobuono · 08/21/2023

Per the ticket I opened, some of my scripts were generating enough IndexOutOfBoundsExceptions, due to the number user being imported, causing the application to eventually restart. After fixing the scripts so the errors stopped we no longer experien...

Online Status	Offline
Date Last Visited	‎02/06/2024 09:16 AM

Saviynt Forums

User Statistics

User Activity

SQL with CTE (Common Table expression) not supported.

SuccessFactors (REST) Full Import causing ECM restart

REST ImportUserJSON: Data too long for column error when using #CONST#${ ... }.

SuccessFactors: Import Users: Failed to import one or more object types.

Incremental User import from DB connection not updating identities.

Re: SQL with CTE (Common Table expression) not supported.

Re: Incremental User import from DB connection not updating identities.

Re: Incremental User import from DB connection not updating identities.

Re: REST ImportUserJSON: Data too long for column error when using #CONST#${ ... }.

Re: SuccessFactors (REST) Full Import causing ECM restart

Re: UTC Date Format for Rest Connector

Re: SuccessFactors: Import Users: Failed to import...

Re: User import from DB connection not updating id...