Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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?
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