How many security systems(or characters count) can be used in Provisioning Job (WSRETRYJOB)

[ravikumarghr]

SYSTEMNAME column in ecmimportjob table limited to 255 characters but we can include more than 255 characters in the job trigger in the system list.

Can you please let us if System supports/works if we have more than 255 characters in the job trigger?

[sudeshjaiswal]

Hello @ravikumarghr,

You should be able to save 65535 characters for all your requests, available from 2021.x versions.

Thanks,

[rushikeshvartak]

It stores security system key in backend, and length 65535

[ravikumarghr]

Thanks for the confirmation, we are getting below error , Saviynt is failing to store job logs because of long list of security systems in the provisioning job?

"ecm-worker","2023-07-07T08:30:00.944+00:00","2023-07-07T08:30:00.359539613Z stdout F 2023-07-07 08:30:00,359 [quartzScheduler_Worker-10] ERROR util.JDBCExceptionReporter  - Data truncation: Data too long for column 'SYSTEMNAME' at row 1"
"ecm-worker","2023-07-07T08:30:00.944+00:00","2023-07-07T08:30:00.360061319Z stdout F 2023-07-07 08:30:00,359 [quartzScheduler_Worker-10] ERROR jobs.WSRetryJob  - Error while saving EcmImportJob: "
"ecm-worker","2023-07-07T08:30:00.944+00:00","2023-07-07T08:30:00.360074319Z stdout F org.springframework.dao.DataIntegrityViolationException: could not insert: [com.saviynt.ecm.identitywarehouse.domain.EcmImportJob]; SQL [insert into ECMIMPORTJOB (COMENTS, EXTERNALCONNECTION, IPADDRESS, JOBENDDATE, JOBSTARTDATE, JOBGROUP, JOBNAME, SAVRESPONSE, SYSTEMNAME, TRIGGERNAME, TRIGGERTYPE, UPDATEUSER) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert: [com.saviynt.ecm.identitywarehouse.domain.EcmImportJob]"
"ecm-worker","2023-07-07T08:30:00.944+00:00","2023-07-07T08:30:00.360081019Z stdout F     at WSRetryJob$_execute_closure3.doCall(WSRetryJob.groovy:164)"
"ecm-worker","2023-07-07T08:30:00.944+00:00","2023-07-07T08:30:00.360085319Z stdout F     at org.grails.datastore.gorm.GormStaticApi.withTransaction(GormStaticApi.groovy:814)"
"ecm-worker","2023-07-07T08:30:00.944+00:00","2023-07-07T08:30:00.36008932Z stdout F     at 

[sudeshjaiswal]

Hello @ravikumarghr,

Can you please run the below query to check the length of the table?

SELECT 'ecmimportjob' as 'Table Name','externalconnection' as 'Coulmn Name',Max(CHAR_LENGTH(externalconnection)) as 'Length' FROM ecmimportjob;

Thanks,

[ravikumarghr]

[sudeshjaiswal]

Hello @ravikumarghr,

Please kindly submit an FD ticket for further troubleshooting.

Thanks.

[ravikumarghr]

We already have below tickets

https://saviynt.freshdesk.com/support/tickets/1646596
https://saviynt.freshdesk.com/support/tickets/1645479