Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Getting error in INLINE PREPROCESSOR Query

Go to solution
manish97sh
New Contributor III
New Contributor III

‎09/21/2023 08:22 AM - last edited on ‎09/22/2023 02:42 AM by Community Manager

Hi,

 

I am trying to populate some user attributes using Inline Preprocessor but getting error while running job.

Please find Inline Preprocessor query below:

{
  "ADDITIONALTABLES": {
    "USERS": "SELECT USERNAME,EMAIL, COMPANYNAME,CUSTOMPROPERTY4,CUSTOMPROPERTY1,LOCATIONNUMBER,LOCATION,CUSTOMPROPERTY20,OWNER,CUSTOMPROPERTY54,CUSTOMPROPERTY60,CUSTOMPROPERTY55,CUSTOMPROPERTY14FROM USERS",
    "LOCATIONDS": "SELECT ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9 FROM DATASET_VALUES WHERE DATASETNAME  = 'DS_IMPORT_LOCATION_MAPPING' OR datasetname = 'DS_Userform_NonWorkdayMarkets_Mapping'",
"ACCOUNTS": "SELECT NAME,CUSTOMPROPERTY52,CUSTOMPROPERTY9,CUSTOMPROPERTY2 FROM ACCOUNTS",
"COMPANYDOMAINDS": "SELECT ATTRIBUTE1 as companyname, ATTRIBUTE3 as domainname FROM DATASET_VALUES WHERE DATASETNAME='DS_Import_Domain_Mapping' and ATTRIBUTE1 is not null and ATTRIBUTE1 !=''",
"SITENAMEDOMAINDS": "SELECT ATTRIBUTE2 as sitename, ATTRIBUTE3 as domainname FROM DATASET_VALUES WHERE DATASETNAME ='DS_Import_Domain_Mapping' and ATTRIBUTE2 is not null and ATTRIBUTE2 != ''",
    "VENDORCOMPANYDS": "SELECT ATTRIBUTE1, ATTRIBUTE2 FROM DATASET_VALUES WHERE DATASETNAME  = 'DS_IMPORT_VENDORCOMPANY_MAPPING' ",
"BSUNITDS":"SELECT ATTRIBUTE1 AS A1,ATTRIBUTE2 AS A2 FROM DATASET_VALUES WHERE DATASETNAME  = 'DS_Import_BusinessUnit_Mapping'"
  },
  "COMPUTEDCOLUMNS": [
  "OWNER",
"LOCATION",
"COUNTRY",
"CUSTOMPROPERTY3",
"REGION",
"CUSTOMPROPERTY30",
"CUSTOMPROPERTY56",
"CUSTOMPROPERTY8",
"CUSTOMPROPERTY60",
"CUSTOMPROPERTY55",
"CUSTOMPROPERTY54",
"CUSTOMPROPERTY51"
  ],
  "PREPROCESSQUERIES": [
    "UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.OWNER = (SELECT CURRENTUSERS.USERNAME FROM CURRENTUSERS WHERE CURRENTUSERS.EMAIL = nu.CUSTOMPROPERTY20 limit 1)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.LOCATION = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE2 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
    "UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.COUNTRY = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE3 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
    "UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY3 = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE4 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.REGION = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE5 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY30 = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE6 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY56 = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE7 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY8 =  (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE8 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY60 = CASE WHEN nu.CUSTOMPROPERTY30 IS NOT NULL AND nu.CUSTOMPROPERTY30 != '' THEN CONCAT('OU=USERS,OU=USERS,OU=',nu.CUSTOMPROPERTY30,',DC=DEVGUWW,DC=NET') ELSE cu.CUSTOMPROPERTY60 END",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY55 = (SELECT DISTINCT CURRENTVENDORCOMPANYDS.ATTRIBUTE2 FROM CURRENTVENDORCOMPANYDS WHERE CURRENTVENDORCOMPANYDS.ATTRIBUTE1 = nu.COMPANYNAME)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY54 = cu.CUSTOMPROPERTY54",
"UPDATE NEWUSERDATA AS nu SET nu.CUSTOMPROPERTY51= (SELECT DISTINCT CURRENTBSUNITDS.A1 FROM CURRENTBSUNITDS WHERE CURRENTBSUNITDS.A2 = nu.CUSTOMPROPERTY14)",
"CUSTOMFUNCTION###GENERATEUPN"
  ],
  "CUSTOMFUNCTIONS": {
  "GENERATEUPN": {
"FULLCLASSNAME": "com.diageo.saviynt.utility.UserTransformation",
"METHODNAME": "generateUniqueUPN"
}
}
}
 
Please find error below:
 
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493575395Z stderr F because: Unknown column 'USERNAME' in 'field list'"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493758796Z stdout F 2023-09-21 14:14:58,493 [quartzScheduler_Worker-7] ERROR services.ImportSAvDataUserService - Error occured while creating table TEMPUSERS_465616 "
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493776296Z stdout F com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'USERNAME' in 'field list'"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493813896Z stdout F at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493817796Z stdout F at com.mysql.jdbc.Util.getInstance(Util.java:383)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493822696Z stdout F at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493825796Z stdout F at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493828696Z stdout F at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493831696Z stdout F at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493834196Z stdout F at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493836796Z stdout F at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2820)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493839696Z stdout F at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2769)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493841996Z stdout F at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:907)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493844696Z stdout F at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:791)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493847996Z stdout F at com.saviynt.ecm.services.ImportSAvDataUserService$_createTempTables_closure15.doCall(ImportSAvDataUserService.groovy:625)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493851596Z stdout F at com.saviynt.ecm.services.ImportSAvDataUserService.createTempTables(ImportSAvDataUserService.groovy:612)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493855096Z stdout F at com.saviynt.ecm.services.ImportSAvDataUserService.doImportDataPreprocessing(ImportSAvDataUserService.groovy:281)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493857596Z stdout F at com.saviynt.ecm.services.ImportSAvDataUserService.importDataFromFile(ImportSAvDataUserService.groovy:728)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493859896Z stdout F at com.saviynt.provisoning.rest.RestProvisioningService.processUsers(RestProvisioningService.groovy:3062)"
"ecm-worker","2023-09-21T14:14:58.904+00:00","2023-09-21T14:14:58.493862396Z stdout F at com.saviynt.provisoning.rest.RestProvisioningService.importUsers(RestProvisioningService.groovy:2915)"
"ecm-worker","2023-09-21T1
 
 
Also if i remove last query ("UPDATE NEWUSERDATA AS nu SET nu.CUSTOMPROPERTY51= (SELECT DISTINCT CURRENTBSUNITDS.A1 FROM CURRENTBSUNITDS WHERE CURRENTBSUNITDS.A2 = nu.CUSTOMPROPERTY14)) then it is working fine.
 
 can you please help on this ?
 
[This message has been edited by moderator to merge reply comment]
Labels:
0 Kudos
3 REPLIES 3

Go to solution
Darshanjain
Saviynt Employee
Saviynt Employee

‎09/22/2023 10:33 AM

Hi @manish97sh 

If you remove the last line is it working fine and all fields are getting updated?

("UPDATE NEWUSERDATA AS nu SET nu.CUSTOMPROPERTY51= (SELECT DISTINCT CURRENTBSUNITDS.A1 FROM CURRENTBSUNITDS WHERE CURRENTBSUNITDS.A2 = nu.CUSTOMPROPERTY14))

If yes then dont use the Alias as A2, use the column name directly as Attribute2 and try it out.

 

Thanks

Darshan

0 Kudos

Go to solution
manish97sh
New Contributor III
New Contributor III
In response to Darshanjain

‎09/22/2023 10:58 AM

Hi @Darshanjain ,

I was able to fix that issue and it is working fine now but i am facing issue in another query in Pre-Processor.

Please find JSON below:

{
"ADDITIONALTABLES": {
"USERS": "SELECT EMAIL, USERNAME, DISPLAYNAME, CUSTOMPROPERTY21, ENDDATE, CUSTOMPROPERTY44, COMPANYNAME, CUSTOMPROPERTY4, CUSTOMPROPERTY1, CUSTOMPROPERTY20, LOCATIONNUMBER, LOCATION, OWNER, CUSTOMPROPERTY54, CUSTOMPROPERTY60, CUSTOMPROPERTY55, CUSTOMPROPERTY14 FROM USERS",
"LOCATIONDS": "SELECT ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9 FROM DATASET_VALUES WHERE DATASETNAME = 'DS_IMPORT_LOCATION_MAPPING' OR datasetname = 'DS_Userform_NonWorkdayMarkets_Mapping'",
"ACCOUNTS": "SELECT NAME,CUSTOMPROPERTY52,CUSTOMPROPERTY9,CUSTOMPROPERTY2 FROM ACCOUNTS",
"COMPANYDOMAINDS": "SELECT ATTRIBUTE1 as companyname, ATTRIBUTE3 as domainname FROM DATASET_VALUES WHERE DATASETNAME='DS_Import_Domain_Mapping' and ATTRIBUTE1 is not null and ATTRIBUTE1 !=''",
"SITENAMEDOMAINDS": "SELECT ATTRIBUTE2 as sitename, ATTRIBUTE3 as domainname FROM DATASET_VALUES WHERE DATASETNAME ='DS_Import_Domain_Mapping' and ATTRIBUTE2 is not null and ATTRIBUTE2 != ''",
"VENDORCOMPANYDS": "SELECT ATTRIBUTE1, ATTRIBUTE2 FROM DATASET_VALUES WHERE DATASETNAME = 'DS_IMPORT_VENDORCOMPANY_MAPPING' ",
"BSUNITDS": "SELECT ATTRIBUTE1, ATTRIBUTE2 FROM DATASET_VALUES WHERE DATASETNAME = 'DS_Import_BusinessUnit_Mapping'"
},
"COMPUTEDCOLUMNS": [
"OWNER",
"LOCATION",
"COUNTRY",
"CUSTOMPROPERTY3",
"REGION",
"CUSTOMPROPERTY30",
"CUSTOMPROPERTY56",
"CUSTOMPROPERTY8",
"CUSTOMPROPERTY60",
"CUSTOMPROPERTY55",
"CUSTOMPROPERTY54",
"CUSTOMPROPERTY21",
"LOCATIONNUMBER",
"CUSTOMPROPERTY51",
"TERMDATE"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.OWNER = (SELECT CURRENTUSERS.USERNAME FROM CURRENTUSERS WHERE CURRENTUSERS.EMAIL = nu.CUSTOMPROPERTY20 limit 1)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.LOCATION = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE2 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.COUNTRY = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE3 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY3 = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE4 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.REGION = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE5 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY30 = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE6 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY56 = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE7 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY8 = (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE8 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = nu.LOCATIONNUMBER)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY60 = CASE WHEN nu.CUSTOMPROPERTY30 IS NOT NULL AND nu.CUSTOMPROPERTY30 != '' THEN CONCAT('OU=USERS,OU=USERS,OU=',nu.CUSTOMPROPERTY30,',DC=DEVGUWW,DC=NET') ELSE cu.CUSTOMPROPERTY60 END",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY55 = (SELECT DISTINCT CURRENTVENDORCOMPANYDS.ATTRIBUTE2 FROM CURRENTVENDORCOMPANYDS WHERE CURRENTVENDORCOMPANYDS.ATTRIBUTE1 = nu.COMPANYNAME)",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY54 = cu.CUSTOMPROPERTY54",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.LOCATIONNUMBER = CASE WHEN (cu.LOCATIONNUMBER = '' AND cu.CUSTOMPROPERTY44 = '') THEN (SELECT CURRENTLOCATIONDS.ATTRIBUTE1 from CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE2 = nu.LOCATION) ELSE nu.LOCATIONNUMBER END",
"UPDATE NEWUSERDATA AS nu LEFT JOIN CURRENTUSERS AS cu ON nu.USERNAME = cu.USERNAME SET nu.CUSTOMPROPERTY51= (SELECT DISTINCT CURRENTBSUNITDS.ATTRIBUTE1 FROM CURRENTBSUNITDS WHERE CURRENTBSUNITDS.ATTRIBUTE2 = nu.CUSTOMPROPERTY14)",
"update newuserdata nu left join currentusers cu on cu.email = nu.customproperty20 set nu.customproperty21 = CONCAT(cu.displayname, '; ', cu.customproperty21)",
"UPDATE NEWUSERDATA SET NEWUSERDATA.TERMDATE = CASE WHEN (NEWUSERDATA.ENDDATE IS NULL OR NEWUSERDATA.ENDDATE = '') then '' ELSE ADDDATE(ADDDATE(NEWUSERDATA.ENDDATE, interval 23 HOUR), interval (SELECT DISTINCT CURRENTLOCATIONDS.ATTRIBUTE9 FROM CURRENTLOCATIONDS WHERE CURRENTLOCATIONDS.ATTRIBUTE1 = NEWUSERDATA.LOCATIONNUMBER) MINUTE) END",

"CUSTOMFUNCTION###GENERATEUPN"
],
"CUSTOMFUNCTIONS": {
"GENERATEUPN": {
"FULLCLASSNAME": "com.diageo.saviynt.utility.UserTransformation",
"METHODNAME": "generateUniqueUPN"
}
}
}

 

I am getting error as below:

"ecm-worker","2023-09-21T21:45:14.294+00:00","2023-09-21T21:45:13.847576606Z stderr F 21-Sep-2023 21:45:13.847 WARNING [quartzScheduler_Worker-7] groovy.sql.Sql.executeUpdate Failed to execute: UPDATE TEMPNEWUSERS_466519 SET TEMPNEWUSERS_466519.TERMDATE = CASE WHEN (TEMPNEWUSERS_466519.ENDDATE IS NULL OR TEMPNEWUSERS_466519.ENDDATE = '') then '' ELSE ADDDATE(ADDDATE(TEMPNEWUSERS_466519.ENDDATE, interval 23 HOUR), interval(SELECT DISTINCT TEMPLOCATIONDS_466519.ATTRIBUTE9 FROM TEMPLOCATIONDS_466519 WHERE TEMPLOCATIONDS_466519.ATTRIBUTE1 = TEMPNEWUSERS_466519.LOCATIONNUMBER) MINUTE) END because: Data truncation: Incorrect datetime value: 'Nov 22, 2023 00:00:00'"
"ecm-worker","2023-09-21T21:45:14.294+00:00","2023-09-21T21:45:13.847787706Z stdout F 2023-09-21 21:45:13,847 [quartzScheduler_Worker-7] ERROR services.ImportSAvDataUserService - Error while processing data: "
"ecm-worker","2023-09-21T21:45:14.294+00:00","2023-09-21T21:45:13.847806506Z stdout F com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: 'Nov 22, 2023 00:00:00'"
"ecm-worker","2023-09-21T21:45:14.294+00:00","2023-09-21T21:45:13.847813306Z stdout F at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4206)"
"ecm-worker","2023-09
-21T21:45:14.294+00:00","2023-09-21T21:45:13.847817506Z stdout F at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140)"
"ecm-worker","2023-09-21T21:45:14.294+00:00","2023-09-21T21:45:13.847820606Z stdout F at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597)"
"ecm-worker","2023-09-21T21:45:14.294+00:00","2023-09-21T21:45:13.847824006Z stdout F at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758)"
"ecm-worker","2023-09-21T21:45:14.294+00:00","2023-09-21T21:45:13.847827706Z stdout F at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2820)"
"ecm-worker","2023-09-21T21:45:14.294+00:00","2023-09-21T21:45:13.847831306Z stdout F at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1759)"
"ecm-worker","2023-09-21T21:45:14.294+00:00","2023-09-21T21:45:13.847834406Z stdout F at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1679)"

0 Kudos

Go to solution
Darshanjain
Saviynt Employee
Saviynt Employee
In response to manish97sh

‎09/25/2023 03:04 AM

HI @manish97sh 

make sure the end date column is same as term data, looks like a format issue

 

Thanks

Darshan

0 Kudos
Copyright © 2024 Khoros, LLC