Query execution was interrupted, maximum statement execution time exceeded - SAP HR import

[Sharan]

we have created a staging tables in Saviynt and loaded the data from SAP HR via connections. while Loading the Data from Staging tables to Users table. we are getting the below issue Query execution was interrupted, maximum statement execution time exceeded.

can anyone help me on this.

[rushikeshvartak]

Staging DB is MySQL? 

https://community.progress.com/s/article/How-can-I-determine-the-size-of-the-MySQL-database 

[Sharan]

yes. we have created tables using custom query job in Saviynt

[avinashchhetri]

@Sharan,

Saviynt does not recommend or support custom tables. Could you elaborate a bit more on your use case and what you are trying to achieve ?

[Sharan]

Hi @Avinash Chhetri,

Thank you for your response. we are trying to get data from SAP HR via connections using the below query in user import json, if we limit the query with condition it is working,but we want full data not a limited one.

{
"USERTABLEMAPPING":[
{
"SAPTABLE":"PA0002",
"SAVTABLE":"PA0002",
"SAPMAP":"PERNR,SUBTY,ENDDA,BEGDA,AEDTM,VORNA,MIDNM,NACHN,CNAME,TITEL,UNAME,VORNA,NACHN"
},
{
"SAPTABLE":"PA0001",
"SAVTABLE":"PA0001",
"SAPMAP":"PERNR,ENDDA,BEGDA,AEDTM,UNAME,BUKRS,WERKS,PERSG,PERSK,VDSK1,BTRTL,KOSTL,ORGEH,PLANS,STELL"
},
{
"SAPTABLE":"PA0000",
"SAVTABLE":"PA0000",
"SAPMAP":"PERNR,ENDDA,BEGDA,AEDTM,UNAME,STAT2,MASSN,MASSG"
}
],
"USERIMPORTQRY":"SELECT DISTINCT p0.PERNR customproperty1,p0.PERNR username,CASE WHEN (p0.STAT2 = 3) THEN 1 END statuskey,p0.ENDDA enddate, p0.BEGDA startdate, p2.VORNA firstname,p2.NACHN lastname, p1.BUKRS customproperty6, p1.KOSTL costcenter, p1.PERSG customproperty13, p1.PLANS employeeclass, p1.PERSK customproperty12, p1.WERKS jobcode, p1.STELL Job, p1.ORGEH orgunitid FROM PA0000 p0 LEFT JOIN PA0001 p1 ON p0.PERNR = p1.PERNR LEFT JOIN PA0002 p2 ON p1.PERNR = p2.PERNR WHERE p1.BUKRS='LU35'",
"SAVCOLMAPPING":"customproperty1,username,statuskey,enddate,startdate,firstname,lastname,customproperty6,costcenter,customproperty13,customproperty35,employeeclass,customproperty12,jobcode,orgunitid",
"userNotInFileAction":"NOACTION",
"zeroDayProvisioning":"TRUE",
"generateSystemUsername":"TRUE",
"checkRules":"TRUE",
"buildUserMap":"FALSE"
}