QlikSense Task Fail : General Script Error in statement handling.

[qwebnm]

A QlikSense Task Fail is being analyzed.

Err Msg : General Script Error in statement handling
As a result of checking the error message, it seems that it occurs when a value such as a null value or a space exists in the script.

So, when I checked the log, I checked to see if there were any values to be inserted into the DB.
log Msg:
SQL INSERT INTO qlik_sense_user.tb_user_attr_qlik
20221021T023708.048+0900 0164 (userid, type, value)
20221021T023708.048+0900 0165 values ('cdwuser050', 'exportappdata', 'Human Genome Resource Center')
20221021T023708.048+0900 0166 !EXECUTE_NON_SELECT_QUERY

I'm trying to troubleshoot, but I'm stuck.
How can I check where the problem is?
I have attached the error log file, so please check and reply.

All Err Msg :

20221021T023624.558+0900 Execution started.
20221021T023624.558+0900 Qlik Sense Server Version 12.811.6
20221021T023624.558+0900 CPU Target x64
20221021T023624.559+0900 Operating System Windows Server 2019 Standard (64 bit edition)
20221021T023624.559+0900 Wow64 mode Not using Wow64
20221021T023624.559+0900 Language 0412 한국어 Korean
20221021T023624.559+0900 Country KOR 대한민국 South Korea
20221021T023624.560+0900 MDAC Version 6.3.9600.16384
20221021T023624.560+0900 MDAC Full Install Version 6.3.9600.16384
20221021T023624.560+0900 PreferredCompression 2
20221021T023624.560+0900 EnableParallelReload 1
20221021T023624.560+0900 AutoSaveAfterReload 0
20221021T023624.560+0900 BackupBeforeReload 0
20221021T023624.560+0900 EnableFlushLog 0
20221021T023624.560+0900 UserLogfileCharset 65001
20221021T023624.560+0900 OdbcLoginTimeout -1
20221021T023624.560+0900 OdbcConnectionTimeout -1
20221021T023624.560+0900 LongestPossibleLine 1048576
20221021T023624.560+0900 MaxCoreMask -1
20221021T023624.560+0900 WebFileTimeout 0
20221021T023624.560+0900 WebFileUserAgent Mozilla/5.0
20221021T023624.560+0900 DontUseInternetCache 1
20221021T023624.562+0900 ScriptWantsDbWrite false
20221021T023624.562+0900 ScriptWantsExe false
20221021T023624.562+0900 LogFile CodePage Used: 65001
20221021T023624.562+0900 UseMemoryFillPattern 1
20221021T023624.562+0900 ScriptMode Standard (limits system access)
20221021T023624.562+0900 SequentialThreadCount 194
20221021T023624.562+0900 NumberOfCores (effective) 64
20221021T023624.562+0900 ReloadCodebase Bnf
20221021T023626.367+0900 Reload ID eddb9c5e-f281-47a3-bded-27547767b454
20221021T023626.367+0900 Reload Executed By UserDirectory=INTERNAL; UserId=sa_scheduler
20221021T023626.367+0900 Process Executing Qlik Sense Server
20221021T023626.367+0900 Process ID 347048
20221021T023626.367+0900 Grpc version 7.0.0
20221021T023626.367+0900 Protobuf version 3.6.1
20221021T023626.367+0900 Effective strict level 0
20221021T023626.391+0900 0002 SET ThousandSep=','
20221021T023626.391+0900 0003 SET DecimalSep='.'
20221021T023626.391+0900 0004 SET MoneyThousandSep=','
20221021T023626.391+0900 0005 SET MoneyDecimalSep='.'
20221021T023626.391+0900 0006 SET MoneyFormat='₩#,##0;-₩#,##0'
20221021T023626.391+0900 0007 SET TimeFormat='TT h시 m분 s초'
20221021T023626.391+0900 0008 SET DateFormat='YYYY. M. D.'
20221021T023626.391+0900 0009 SET TimestampFormat='YYYY. M. D. TT h시 m분 s초[.fff]'
20221021T023626.391+0900 0010 SET FirstWeekDay=6
20221021T023626.391+0900 0011 SET BrokenWeeks=1
20221021T023626.391+0900 0012 SET ReferenceDay=0
20221021T023626.392+0900 0013 SET FirstMonthOfYear=1
20221021T023626.392+0900 0014 SET CollationLocale='ko-KR'
20221021T023626.392+0900 0015 SET CreateSearchIndexOnReload=1
20221021T023626.392+0900 0016 SET MonthNames='1월;2월;3월;4월;5월;6월;7월;8월;9월;10월;11월;12월'
20221021T023626.392+0900 0017 SET LongMonthNames='1월;2월;3월;4월;5월;6월;7월;8월;9월;10월;11월;12월'
20221021T023626.392+0900 0018 SET DayNames='월;화;수;목;금;토;일'
20221021T023626.392+0900 0019 SET LongDayNames='월요일;화요일;수요일;목요일;금요일;토요일;일요일'
20221021T023626.392+0900 0020 SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y'
20221021T023626.392+0900 0023 LIB CONNECT TO 'monitor_apps_REST_appobject'
20221021T023627.319+0900 Connected.
20221021T023627.321+0900 0025 RestConnectorMasterTable:
20221021T023627.321+0900 0026 SQL SELECT
20221021T023627.321+0900 0027 "__KEY_root",
20221021T023627.321+0900 0028 (SELECT
20221021T023627.321+0900 0029 "id" AS "id_u1",
20221021T023627.321+0900 0030 "name" AS "name_u1",
20221021T023627.321+0900 0031 "appId",
20221021T023627.321+0900 0032 "publishTime",
20221021T023627.321+0900 0033 "published",
20221021T023627.321+0900 0034 "stream",
20221021T023627.321+0900 0035 "savedInProductVersion",
20221021T023627.321+0900 0036 "migrationHash",
20221021T023627.321+0900 0037 "availabilityStatus",
20221021T023627.321+0900 0038 "privileges" AS "privileges_u1",
20221021T023627.321+0900 0039 "__KEY_app",
20221021T023627.321+0900 0040 "__FK_app",
20221021T023627.321+0900 0041 (SELECT
20221021T023627.321+0900 0042 "id" AS "id_u0",
20221021T023627.321+0900 0043 "name" AS "name_u0",
20221021T023627.321+0900 0044 "privileges" AS "privileges_u0",
20221021T023627.321+0900 0045 "__FK_stream"
20221021T023627.321+0900 0046 FROM "stream" FK "__FK_stream")
20221021T023627.321+0900 0047 FROM "app" PK "__KEY_app" FK "__FK_app")
20221021T023627.321+0900 0048 FROM JSON (wrap on) "root" PK "__KEY_root"
20221021T023648.034+0900 18 fields found: id_u0, name_u0, privileges_u0, __FK_stream, id_u1, name_u1, appId, publishTime, published, stream, savedInProductVersion, migrationHash, availabilityStatus, privileges_u1, __KEY_app, __FK_app, __KEY_root, __extra_,
20221021T023649.351+0900 36,740 lines fetched
20221021T023649.354+0900 0052 [stream]:
20221021T023649.354+0900 0053 LOAD
20221021T023649.354+0900 0054 Distinct
20221021T023649.354+0900 0055 [name_u0] AS Stream_Name,
20221021T023649.354+0900 0056 [__FK_stream] AS [__KEY_app]
20221021T023649.354+0900 0057 RESIDENT RestConnectorMasterTable
20221021T023649.354+0900 0058 WHERE NOT IsNull([__FK_stream])
20221021T023649.355+0900 2 fields found: Stream_Name, __KEY_app,
20221021T023651.222+0900 4,626 lines fetched
20221021T023651.257+0900 0060 Left Join([stream])
20221021T023651.257+0900 0061 LOAD [id_u1] AS App_Id,
20221021T023651.257+0900 0062 [name_u1] AS App_Name,
20221021T023651.257+0900 0063 [__KEY_app]
20221021T023651.257+0900 0064 RESIDENT RestConnectorMasterTable
20221021T023651.257+0900 0065 WHERE NOT IsNull([__FK_app])
20221021T023651.257+0900 3 fields found: App_Id, App_Name, __KEY_app,
20221021T023653.774+0900 16,057 lines fetched
20221021T023653.774+0900 Joining/Keeping
20221021T023654.085+0900 0068 DROP TABLE RestConnectorMasterTable
20221021T023654.154+0900 0072 포탈사용자:
20221021T023654.154+0900 0073 LOAD
20221021T023654.154+0900 0074 Distinct
20221021T023654.154+0900 0075 gid as Role_CD,
20221021T023654.154+0900 0076 group_name as Role_NM,
20221021T023654.154+0900 0077 subfield(group_name,'_',1) as Role_Item,
20221021T023654.154+0900 0078 subfield(group_name,'권한_',2) as Stream_Name
20221021T023654.154+0900 0079 FROM [lib://Source/iect7009.qvd]
20221021T023654.154+0900 0080 (qvd)
20221021T023654.154+0900 0081 Where WildMatch(group_name,'환자번호조회권한_*','데이터내보내기권한_*','식별화요청권한_*')
20221021T023654.662+0900 4 fields found: Role_CD, Role_NM, Role_Item, Stream_Name,
20221021T023655.840+0900 49 lines fetched
20221021T023655.844+0900 0086 Role_Group:
20221021T023655.844+0900 0087 LOAD
20221021T023655.844+0900 0088 gid as Role_CD,
20221021T023655.844+0900 0089 fkey as c_dept
20221021T023655.844+0900 0090 FROM [lib://Source/iect7010.qvd]
20221021T023655.844+0900 0091 (qvd)
20221021T023655.844+0900 0092 where type='p'
20221021T023655.961+0900 2 fields found: Role_CD, c_dept,
20221021T023655.991+0900 752 lines fetched
20221021T023656.006+0900 0094 inner Join(Role_Group)
20221021T023656.006+0900 0095 LOAD
20221021T023656.006+0900 0096 unid,
20221021T023656.006+0900 0097 c_dept
20221021T023656.006+0900 0098 FROM [lib://Source/customuser.qvd]
20221021T023656.006+0900 0099 (qvd)
20221021T023656.006+0900 0100 where c_use_yn='Y'
20221021T023656.071+0900 2 fields found: unid, c_dept,
20221021T023656.118+0900 136 lines fetched
20221021T023656.118+0900 Joining/Keeping
20221021T023656.145+0900 0103 inner Join(Role_Group)
20221021T023656.145+0900 0104 LOAD
20221021T023656.145+0900 0105 unid,
20221021T023656.145+0900 0106 Lower(user_id) as UserID
20221021T023656.145+0900 0107 FROM [lib://Source/iect7003.qvd]
20221021T023656.145+0900 0108 (qvd)
20221021T023656.249+0900 2 fields found: unid, UserID,
20221021T023656.275+0900 137 lines fetched
20221021T023656.275+0900 Joining/Keeping
20221021T023656.647+0900 0110 Concatenate(Role_Group)
20221021T023656.647+0900 0111
20221021T023656.647+0900 0112 LOAD
20221021T023656.647+0900 0113 gid as Role_CD,
20221021T023656.647+0900 0114 Lower(fkey) as UserID
20221021T023656.647+0900 0115 FROM [lib://Source/iect7010.qvd]
20221021T023656.647+0900 0116 (qvd)
20221021T023656.647+0900 0117 where type='u'
20221021T023657.237+0900 2 fields found: Role_CD, UserID,
20221021T023659.159+0900 1,911 lines fetched
20221021T023659.167+0900 0120 Inner Join(포탈사용자)
20221021T023659.167+0900 0121 Load
20221021T023659.167+0900 0122 Distinct
20221021T023659.167+0900 0123 Role_CD,
20221021T023659.167+0900 0124 UserID
20221021T023659.167+0900 0125 Resident Role_Group
20221021T023659.168+0900 2 fields found: Role_CD, UserID,
20221021T023659.330+0900 1,902 lines fetched
20221021T023659.330+0900 Joining/Keeping
20221021T023659.778+0900 0128 Drop Table Role_Group
20221021T023659.978+0900 0131 Left Join(포탈사용자)
20221021T023659.978+0900 0132 Load
20221021T023659.978+0900 0133 Stream_Name,
20221021T023659.978+0900 0134 App_Id,
20221021T023659.978+0900 0135 App_Name
20221021T023659.978+0900 0136 Resident [stream]
20221021T023659.978+0900 3 fields found: Stream_Name, App_Id, App_Name,
20221021T023702.304+0900 4,626 lines fetched
20221021T023702.304+0900 Joining/Keeping
20221021T023704.308+0900 0138 Drop Table [stream]
20221021T023704.321+0900 0140 Store 포탈사용자 into [lib://Target/포탈사용자_Role.qvd](qvd)
20221021T023704.569+0900 0142 데이터내보내기권한:
20221021T023704.569+0900 0143 Load
20221021T023704.569+0900 0144 Distinct
20221021T023704.569+0900 0145 UserID&'%'&Stream_Name&'%'&'exportappdata' as Export_Key
20221021T023704.569+0900 0146 Resident 포탈사용자
20221021T023704.569+0900 0147 where Role_Item='데이터내보내기권한'
20221021T023704.570+0900 1 fields found: Export_Key,
20221021T023704.831+0900 452 lines fetched
20221021T023704.866+0900 0150 Drop Table 포탈사용자
20221021T023704.868+0900 0152 LIB CONNECT TO 'PostgreSQL_Portal'
20221021T023705.473+0900 Connected.
20221021T023705.475+0900 0154 SQL delete from qlik_sense_user.tb_user_attr_qlik T1 where T1.type='exportappdata'!EXECUTE_NON_SELECT_QUERY
20221021T023705.677+0900 1 fields found: __empty_field,
20221021T023705.734+0900 0 lines fetched
20221021T023705.749+0900 0156 for each key in FieldValueList('Export_Key')
20221021T023705.751+0900 0158 let vUserId = subfield('cdwuser040%공통%exportappdata','%',1)
20221021T023705.751+0900 0159 let vStream_Name = subfield('cdwuser040%공통%exportappdata','%',2)
20221021T023705.751+0900 0160 let vExport_Data = subfield('cdwuser040%공통%exportappdata','%',3)
20221021T023705.751+0900 0163 SQL INSERT INTO qlik_sense_user.tb_user_attr_qlik
20221021T023705.751+0900 0164 (userid, type, value)
20221021T023705.751+0900 0165 values ('cdwuser040', 'exportappdata', '공통')
20221021T023705.751+0900 0166 !EXECUTE_NON_SELECT_QUERY
20221021T023705.838+0900 1 fields found: __empty_field,
20221021T023705.893+0900 0 lines fetched
20221021T023705.894+0900 0167 next
20221021T023705.894+0900 0158 let vUserId = subfield('cdwuser030%공통%exportappdata','%',1)
20221021T023705.895+0900 0159 let vStream_Name = subfield('cdwuser030%공통%exportappdata','%',2)
20221021T023705.895+0900 0160 let vExport_Data = subfield('cdwuser030%공통%exportappdata','%',3)
20221021T023705.895+0900 0163 SQL INSERT INTO qlik_sense_user.tb_user_attr_qlik
20221021T023705.895+0900 0164 (userid, type, value)
20221021T023705.895+0900 0165 values ('cdwuser030', 'exportappdata', '공통')
20221021T023705.895+0900 0166 !EXECUTE_NON_SELECT_QUERY
20221021T023705.970+0900 1 fields found: __empty_field,
20221021T023706.027+0900 0 lines fetched
20221021T023706.032+0900 0167 next
20221021T023706.032+0900 0158 let vUserId = subfield('hm1994%공통%exportappdata','%',1)
20221021T023706.033+0900 0159 let vStream_Name = subfield('hm1994%공통%exportappdata','%',2)
20221021T023706.033+0900 0160 let vExport_Data = subfield('hm1994%공통%exportappdata','%',3)
20221021T023706.033+0900 0163 SQL INSERT INTO qlik_sense_user.tb_user_attr_qlik
20221021T023706.033+0900 0164 (userid, type, value)
20221021T023706.033+0900 0165 values ('hm1994', 'exportappdata', '공통')
20221021T023706.033+0900 0166 !EXECUTE_NON_SELECT_QUERY
20221021T023706.106+0900 1 fields found: __empty_field,
20221021T023707.030+0900 0 lines fetched
20221021T023707.032+0900 0167 next
20221021T023707.032+0900 0158 let vUserId = subfield('ap%공통%exportappdata','%',1)
20221021T023707.033+0900 0159 let vStream_Name = subfield('ap%공통%exportappdata','%',2)
20221021T023707.033+0900 0160 let vExport_Data = subfield('ap%공통%exportappdata','%',3)
20221021T023707.034+0900 0163 SQL INSERT INTO qlik_sense_user.tb_user_attr_qlik
20221021T023707.034+0900 0164 (userid, type, value)
20221021T023707.034+0900 0165 values ('ap', 'exportappdata', '공통')
20221021T023707.034+0900 0166 !EXECUTE_NON_SELECT_QUERY
20221021T023707.241+0900 1 fields found: __empty_field,
20221021T023707.311+0900 0 lines fetched
20221021T023707.313+0900 0167 next
20221021T023707.313+0900 0158 let vUserId = subfield('obgy%공통%exportappdata','%',1)
20221021T023707.313+0900 0159 let vStream_Name = subfield('obgy%공통%exportappdata','%',2)
20221021T023707.313+0900 0160 let vExport_Data = subfield('obgy%공통%exportappdata','%',3)
20221021T023707.314+0900 0163 SQL INSERT INTO qlik_sense_user.tb_user_attr_qlik
20221021T023707.314+0900 0164 (userid, type, value)
20221021T023707.314+0900 0165 values ('obgy', 'exportappdata', '공통')
20221021T023707.314+0900 0166 !EXECUTE_NON_SELECT_QUERY
20221021T023707.465+0900 1 fields found: __empty_field,
20221021T023707.784+0900 0 lines fetched
20221021T023707.784+0900 0167 next
20221021T023707.785+0900 0158 let vUserId = subfield('tr%공통%exportappdata','%',1)
20221021T023707.785+0900 0159 let vStream_Name = subfield('tr%공통%exportappdata','%',2)
20221021T023707.785+0900 0160 let vExport_Data = subfield('tr%공통%exportappdata','%',3)
20221021T023707.785+0900 0163 SQL INSERT INTO qlik_sense_user.tb_user_attr_qlik
20221021T023707.785+0900 0164 (userid, type, value)
20221021T023707.785+0900 0165 values ('tr', 'exportappdata', '공통')
20221021T023707.785+0900 0166 !EXECUTE_NON_SELECT_QUERY
20221021T023707.978+0900 1 fields found: __empty_field,
20221021T023708.046+0900 0 lines fetched
20221021T023708.047+0900 0167 next
20221021T023708.047+0900 0158 let vUserId = subfield('cdwuser050%인체유전체자원센터%exportappdata','%',1)
20221021T023708.047+0900 0159 let vStream_Name = subfield('cdwuser050%인체유전체자원센터%exportappdata','%',2)
20221021T023708.048+0900 0160 let vExport_Data = subfield('cdwuser050%인체유전체자원센터%exportappdata','%',3)
20221021T023708.048+0900 0163 SQL INSERT INTO qlik_sense_user.tb_user_attr_qlik
20221021T023708.048+0900 0164 (userid, type, value)
20221021T023708.048+0900 0165 values ('cdwuser050', 'exportappdata', '인체유전체자원센터')
20221021T023708.048+0900 0166 !EXECUTE_NON_SELECT_QUERY
20221021T023708.164+0900 General Script Error in statement handling
20221021T023708.164+0900 Execution Failed
20221021T023708.168+0900 Execution finished.

[RafaelBarrios]

Hi @qwebnm 

By default Qlik Sense dont let you anything different than a Select statement.

But you can try this

https://community.qlik.com/t5/Qlik-Sense-Documents/Store-a-QlikSense-table-directly-into-an-SQL-tabl...

Hope this works for you.

Best,

users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂

[qwebnm]

I have already checked the script of the Task to be inserted into the DB.

This task schedule usually succeeds, but this time it failed.

Where do I start to check?
Do you have any guesses?

Please answer.
Thanks & Regards.