Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

etrotter
Contributor II

Qlik Connection to Workday

Hello Experts,

I am struggling with a workday connection, I'm using a soap API and its incredibly slow, each time it runs its been taking over 24 hours. I haven't actually been able to finish a whole load, I'm using a loop to go through the data and it pulls 700 rows at a time. There is a total of around 53,000 rows but on the 27th loop it fails unexpectly, this is what it says in the script log:

  2018-03-21 23:55:01 1036 [Personal_Data]:

  2018-03-21 23:55:01 1037 LOAD [Birth_Date] AS [Birth_Date],

  2018-03-21 23:55:01 1038 [Hispanic_or_Latino] AS [Hispanic_or_Latino],

  2018-03-21 23:55:01 1039 [Tobacco_Use] AS [Tobacco_Use],

  2018-03-21 23:55:01 1040 [__KEY_Personal_Data] AS [__KEY_Personal_Data],

  2018-03-21 23:55:01 1041 [__FK_Personal_Data] AS [__KEY_Worker_Data]

  2018-03-21 23:55:01 1042 RESIDENT RestConnectorMasterTable

  2018-03-21 23:55:01 1043 WHERE NOT IsNull([__FK_Personal_Data])

  2018-03-21 23:55:03      5 fields found: Birth_Date, Hispanic_or_Latino, Tobacco_Use, __KEY_Personal_Data, __KEY_Worker_Data,

  2018-03-21 23:55:03      Execution Failed

  2018-03-21 23:55:03      Execution finished.



When I try to debug it it has this error: Qvx file read error on line 1, too many columns


So my question is two fold, why is it so slow at pulling in data and is there a way to make it faster? Why is it failing on the 27th loop and how do I fix this?


If I do a limited load with 5 loops it finishes fine, the problem only occurs when i try to load the whole thing.


Thanks in advance!



Tags (2)
1 Reply
agni_gold
Valued Contributor

Re: Qlik Connection to Workday

How you connected with workday , can you please explain me bit more with any example and any connector you used ?

Community Browser