store into qvd not working

LESSASSY_K — Thu, 10 Jun 2021 09:25:11 GMT

Hello everyone ,

I create an inline table with variable that i want to store:

NoConcatenate
[$(vL.AppName)]:
LOAD * INLINE [
AppCategory,AppName,AppType,AppTypeName,LastReloadStart,LastReloadEnd,ReloadTime
$(vL.AppCategory),$(vL.AppName),$(vL.AppType),$(vL.AppTypeName),$(v_LastReloadStart),$(v_LastReloadEnd),$(v_ReloadTime)
];

When i store it it doen't work

my script is the following one :

STORE [$(vL.AppName)] INTO '$(vL.QVDPath)Andon\Andon Monitoring\Test_unitaire_2021.qvd' (qvd);

In the log i get this :

20210610T110946.046+0200 0532 [Empack_Putaway_Lines]:
20210610T110946.046+0200 0533 LOAD * INLINE [
20210610T110946.046+0200 0534 AppCategory,AppName,AppType,AppTypeName,LastReloadStart,LastReloadEnd,ReloadTime
20210610T110946.046+0200 0535 Andon,Empack_Putaway_Lines,QVD2Mart,QVD2Mart_Inbound_following_Empack_Putaway_Lines,10/06/2021 11:07:33 AM,10/06/2021 11:09:46 AM,00:02:13
20210610T110946.046+0200 0536 ]
20210610T110946.047+0200 7 fields found: AppCategory, AppName, AppType, AppTypeName, LastReloadStart, LastReloadEnd, ReloadTime,
20210610T110946.048+0200 1 lines fetched
20210610T110946.049+0200 0553 STORE [Empack_Putaway_Lines] INTO 'C:\102.GTO\999.Self_BI\WMS2\2.QVD\'Andon Monitoring'\Test_unitaire.qvd' (qvd)
20210610T110946.058+0200 0556 STORE [Empack_Putaway_Lines] INTO 'C:\102.GTO\999.Self_BI\WMS2\2.QVD\Supervision Dashboard\'Andon Monitoring'\Test_unitaire_2.qvd' (qvd)
20210610T110946.063+0200 0557 STORE [Empack_Putaway_Lines] INTO 'C:\102.GTO\999.Self_BI\WMS2\2.QVD\Supervision Dashboard\Andon\[Andon Monitoring]\Test_unitaire_2021.qvd' (qvd)
20210610T110946.068+0200 0558 STORE [Empack_Putaway_Lines] INTO 'C:\102.GTO\999.Self_BI\WMS2\2.QVD\Supervision Dashboard\Andon\Andon Monitoring\Test_unitaire_2021.qvd' (qvd)
20210610T110946.073+0200 0559 STORE [Empack_Putaway_Lines] INTO 'C:\102.GTO\999.Self_BI\WMS2\2.QVD\Supervision Dashboard\Andon\'Andon Monitoring'\Test_unitaire_2021.qvd' (qvd)
20210610T110946.076+0200 0568 EXIT SCRIPT
20210610T110946.306+0200 Execution finished.

But i have no issue even if the qvd is not generated.

But it worked when i drop the table.

Anyone could help ?

Thanks

Re: store into qvd not working

sunny_talwar — Thu, 10 Jun 2021 13:17:54 GMT

I see multiple store statements in your logs, is that you trying to store the file in different places to see if any of those works? Also, I see single quotes around Andon Monitoring in few of them and square brackets in other places, is that still you trying different things?

Re: store into qvd not working

LESSASSY_K — Fri, 11 Jun 2021 15:48:50 GMT

Yes indeed.

A mistake from my part.

Path variable were defined in other location than the one i used to store qvd.

It was a coworker who developped it and left dso that's why i had issues with that.

Thanks a lot

topic store into qvd not working in QlikView

store into qvd not working

Re: store into qvd not working

Re: store into qvd not working