topic Re: Failed in QMC read Sharepoint in QlikView

Failed in QMC read Sharepoint

kenji_khoo — Thu, 29 Mar 2018 02:50:24 GMT

Hi All,

Below is my script. Run successfully locally but failed in QMC. Any idea? Any solution?

let vPath = '\\XXXXXXXXXXXX.sharepoint.com@SSL\DavWWWRoot\sites\Shared Documents';

DO while vCheck=0

LET vFileSize=filesize('$(vPath)\Country\*.txt');

trace $(vFileSize);

//**Explaination: if file exists

IF vFileSize>0 then

trace 'success';

exit script;

ELSE

//**Trigger an email

//**Explaination throw an error, qlik task will stop

LOAD B;

LOAD * Inline [

Col1

];

ENDIF

LOOP;

let vCheck=0;

Re: Failed in QMC read Sharepoint

tamilarasu — Thu, 29 Mar 2018 03:42:40 GMT

Hello Kenji,

Does your server having access to the below sharepoint path ? I think it is not having access. Check it once.

\\XXXXXXXXXXXX.sharepoint.com@SSL\DavWWWRoot\sites\Shared Documents

Re: Failed in QMC read Sharepoint

kenji_khoo — Thu, 29 Mar 2018 03:48:41 GMT

Hi Tamil Arasu,

Yes, it can access. Via mapping network drive, https://, all are fine. If I run the QVW locally, it's fine as well. Only happen in QMC, checking on the log, the log shown it is not get the filesize and goto else statement.

Check on the user ID, is same with QDS services.

Re: Failed in QMC read Sharepoint

tamilarasu — Thu, 29 Mar 2018 16:05:29 GMT

Hi Kenji,

Here is the answer for your question.

Re: Failed in QMC read Sharepoint

Peter_Cammaert — Thu, 29 Mar 2018 16:48:13 GMT

I think that, since your UNC path appears to be correct, the problem may still be caused by access permissions or environment differences.

Can you try running a reload under QMC control of a document with just this script?

LET vPath = '\\XXXXXXXXXXXX.sharepoint.com@SSL\DavWWWRoot\sites\Shared Documents';

FOR EACH vFile in filelist(vPath & '\Country\*.txt')

TRACE >>>> Trying to determine size of file [$(vFile)];

LET vFileSize = FileSize(vFile);

TRACE Size appears to be $(vFileSize) bytes;

Best,

Peter

Re: Failed in QMC read Sharepoint

kenji_khoo — Fri, 30 Mar 2018 04:02:47 GMT

I'm using UNC path, but not https.

Re: Failed in QMC read Sharepoint

tamilarasu — Fri, 30 Mar 2018 09:29:54 GMT

Did you try pcammaertsuggestion?

Re: Failed in QMC read Sharepoint

kenji_khoo — Fri, 30 Mar 2018 09:32:41 GMT

Not working. 😃

Re: Failed in QMC read Sharepoint

tamilarasu — Fri, 30 Mar 2018 10:03:21 GMT

I haven't worked in sharepoint connectivity. So it is bit hard for me to guess what is the real reason. Could you post the log file so that someone can help you.