Re: sharepoint integration with qlikview -QMC TASK... - Qlik Community

Anonymous · ‎2014-12-08

Hi

can any one give the solution for the below problem

Using Web Files (RPC) sharepoint list data read qvw file created the same fils can able to reload from the server can read the data

But while schedule task from QMC the below error was faced

12/4/2014 12:25:42 PM: Execution started.

12/4/2014 12:25:42 PM: QlikView Version:11.20.12577.0

12/4/2014 12:25:42 PM: CPU Target x64

12/4/2014 12:25:42 PM: Operating System Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)

12/4/2014 12:25:42 PM: Wow64 mode Not using Wow64

12/4/2014 12:25:42 PM: MDAC Version 6.1.7601.17514

12/4/2014 12:25:42 PM: MDAC Full Install Version 6.1.7601.17514

12/4/2014 12:25:42 PM: PreferredCompression 2

12/4/2014 12:25:42 PM: EnableParallelReload 1

12/4/2014 12:25:42 PM: ParallelizeQvdLoads 1

12/4/2014 12:25:42 PM: AutoSaveAfterReload 0

12/4/2014 12:25:42 PM: BackupBeforeReload 0

12/4/2014 12:25:42 PM: EnableFlushLog 0

12/4/2014 12:25:42 PM: SaveInfoWhenSavingFile 0

12/4/2014 12:25:42 PM: UserLogfileCharset 1200

12/4/2014 12:25:42 PM: OdbcLoginTimeout -1

12/4/2014 12:25:42 PM: OdbcConnectionTimeout -1

12/4/2014 12:25:42 PM: ScriptWantsDbWrite false

12/4/2014 12:25:42 PM: ScriptWantsExe false

12/4/2014 12:25:42 PM: LogFile CodePage Used: 1200

12/4/2014 12:25:42 PM: Reload Executed By DOMAIN\SERVERNAME

12/4/2014 12:25:42 PM: Process Executing: QVB

12/4/2014 12:25:42 PM: Process ID: 22196

12/4/2014 12:25:42 PM: 0002 SET ThousandSep=','

12/4/2014 12:25:42 PM: 0003 SET DecimalSep='.'

12/4/2014 12:25:42 PM: 0004 SET MoneyThousandSep=','

12/4/2014 12:25:42 PM: 0005 SET MoneyDecimalSep='.'

12/4/2014 12:25:42 PM: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'

12/4/2014 12:25:42 PM: 0007 SET TimeFormat='h:mms TT'

12/4/2014 12:25:42 PM: 0008 SET DateFormat='M/D/YYYY'

12/4/2014 12:25:42 PM: 0009 SET TimestampFormat='M/D/YYYY h:mms[.fff] TT'

12/4/2014 12:25:42 PM: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

12/4/2014 12:25:42 PM: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

12/4/2014 12:25:42 PM: 0012 LOAD [IM_COE_PROJ_ID ],

12/4/2014 12:25:42 PM: 0013 [ COLUMN 1]

12/4/2014 12:25:42 PM: 0014 [COLUMN 2 ],

12/4/2014 12:25:42 PM: 0015 [COLUMN 3 ]

12/4/2014 12:25:42 PM: 0016 etc..

12/4/2014 12:25:42 PM: 0030 FROM

12/4/2014 12:25:42 PM: 0031 [https:SharepointlistpageURL]

12/4/2014 12:25:42 PM: 0032 (html, utf8, embedded labels, table is @32, filters(

12/4/2014 12:25:42 PM: 0033 Remove(Col, Pos(Top, 2)),

12/4/2014 12:25:42 PM: 0034 Remove(Col, Pos(Top, 1))

12/4/2014 12:25:42 PM: 0035 ))

12/4/2014 12:25:42 PM: Error: Cannot locate table in HTML file

12/4/2014 12:25:42 PM: General Script Error

12/4/2014 12:25:42 PM: Execution Failed

12/4/2014 12:25:42 PM: Execution finished.

Note added the server from the IE security setting also....

SunilChauhan · ‎2014-12-08

either file has been stored in web format.try saving it again

or filename or worksheetname is not proper

could you please check this

Sunil Chauhan

Anonymous · ‎2014-12-08

Hi

thanks for the suggetion ,but no luck

i have saveas new file and created the new task but the same error

simenkg · ‎2014-12-08

Sharepoint Lists can be read as XML and I would use that instead.

Anonymous · ‎2014-12-08

HI

Thanks

I try XML also but am fachin the below errror

12/8/2014 5:15:15 PM: Execution started.

12/8/2014 5:15:15 PM: QlikView Version:11.20.12577.0

12/8/2014 5:15:15 PM: CPU Target x64

12/8/2014 5:15:15 PM: Operating System Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)

12/8/2014 5:15:15 PM: Wow64 mode Not using Wow64

12/8/2014 5:15:15 PM: MDAC Version 6.1.7601.17514

12/8/2014 5:15:15 PM: MDAC Full Install Version 6.1.7601.17514

12/8/2014 5:15:15 PM: PreferredCompression 2

12/8/2014 5:15:15 PM: EnableParallelReload 1

12/8/2014 5:15:15 PM: ParallelizeQvdLoads 1

12/8/2014 5:15:15 PM: AutoSaveAfterReload 0

12/8/2014 5:15:15 PM: BackupBeforeReload 0

12/8/2014 5:15:15 PM: EnableFlushLog 0

12/8/2014 5:15:15 PM: SaveInfoWhenSavingFile 0

12/8/2014 5:15:15 PM: UserLogfileCharset 1200

12/8/2014 5:15:15 PM: OdbcLoginTimeout -1

12/8/2014 5:15:15 PM: OdbcConnectionTimeout -1

12/8/2014 5:15:15 PM: ScriptWantsDbWrite false

12/8/2014 5:15:15 PM: ScriptWantsExe false

12/8/2014 5:15:15 PM: LogFile CodePage Used: 1200

12/8/2014 5:15:15 PM: Reload Executed By DOMAIN\SERVER

12/8/2014 5:15:15 PM: Process Executing: QVB

12/8/2014 5:15:15 PM: Process ID: 26372

12/8/2014 5:15:15 PM: 0002 SET ThousandSep=','

12/8/2014 5:15:15 PM: 0003 SET DecimalSep='.'

12/8/2014 5:15:15 PM: 0004 SET MoneyThousandSep=','

12/8/2014 5:15:15 PM: 0005 SET MoneyDecimalSep='.'

12/8/2014 5:15:15 PM: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'

12/8/2014 5:15:15 PM: 0007 SET TimeFormat='h:mm:ss TT'

12/8/2014 5:15:15 PM: 0008 SET DateFormat='M/D/YYYY'

12/8/2014 5:15:15 PM: 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

12/8/2014 5:15:15 PM: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

12/8/2014 5:15:15 PM: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

12/8/2014 5:15:15 PM: 0037 AttributeType:

12/8/2014 5:15:15 PM: 0038 LOAD name,

12/8/2014 5:15:15 PM: 0039 rs:name,

12/8/2014 5:15:15 PM: 0040 rs:number,

12/8/2014 5:15:15 PM: 0041 [datatype/dt:type] as dttype,

12/8/2014 5:15:15 PM: 0042 [datatype/dt:maxLength] as dtmaxLength,

12/8/2014 5:15:15 PM: 0043 %Key_xml_98C49F546A18E856

12/8/2014 5:15:15 PM: 0044 FROM [https://servername/Site /_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={LISTID}&View={ VIEWID}] (XmlSimple, Table is [xml/Schema/ElementType/AttributeType])

12/8/2014 5:15:15 PM: Error: Required white space was missing.

12/8/2014 5:15:15 PM: On line number: 1. On column number: 62. System ID: https:// servername /site /_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={ LISTID}&View={ VIEWID}.

12/8/2014 5:15:15 PM: General Script Error

12/8/2014 5:15:15 PM: Execution Failed

12/8/2014 5:15:15 PM: Execution finished.

Report Inappropriate Content · ‎2016-01-07

I am trying schedule the same job: what, if any, was the resolution for this? My QVW is loading perfectly on my desktop; however, it is failing in QMC on a scheduled reload.

Thanks in advance!

Taylor

Report Inappropriate Content · ‎2016-02-19

Look into a command-line reload of your QVW and schedule it through the windows task scheduler. I had been having trouble with a QMC reload for months and finally tried a .bat file reload of my QVW - worked like a charm. Here is a good article for reference:

QlikView Maven: QlikView Command Line and Automation

Reload and save using command line

Best of luck and glad to answer any questions you may have,

Taylor

sharepoint integration with qlikview -QMC TASK Schedule problem