Resident table not found

[k_burata]

Hi Guys,

Been running this script below but it always tells me that table not found. This works on my Dev environment but when I Reload on Prod error comes out. Seems easy though.

cheers,

"Purchase Orders":

LOAD [PO Cost Centre],

     [PO Company ID] AS [Company ID],

     [PO Account ID],

     [PO Order No],

     [PO Order Line],

     [PO Release No],

     [PO Currency Code],

     [PO Part No],

     [PO Pre Accounting ID],

     [PO Amount Balance],

     [PO Created Date],

     [PO Part Description],

     [PO Amount Balance 3rd],

     [PO Quantity Balance],

     [PO Accounting Period],

     [PO Accounting Year],

     [PO Date],

     [PO Wanted Delivery Date],

     [PO Reference Link]

FROM

[..\QvData\Transform\IFS\QVD\Purchase Order VM.qvd]

(qvd);

NoConcatenate

MinMaxOpenPODate:

Load

min([PO Wanted Delivery Date]) as MinDatePO,

max([PO Wanted Delivery Date]) as MaxDatePO

RESIDENT "Purchase Orders";

[Anil_Babu_Samineni]

Can you change your directory from " " to [ ] ... Even with Resident as well

[k_burata]

You mean to this?

[Purchase Orders]:

LOAD [PO Cost Centre],

     [PO Company ID] AS [Company ID],

     [PO Account ID],

     [PO Order No],

     [PO Order Line],

     [PO Release No],

     [PO Currency Code],

     [PO Part No],

     [PO Pre Accounting ID],

     [PO Amount Balance],

     [PO Created Date],

     [PO Part Description],

     [PO Amount Balance 3rd],

     [PO Quantity Balance],

     [PO Accounting Period],

     [PO Accounting Year],

     [PO Date],

     [PO Wanted Delivery Date],

     [PO Reference Link]

FROM

[..\QvData\Transform\IFS\QVD\Purchase Order VM.qvd]

(qvd);

NoConcatenate

MinMaxOpenPODate:

Load

min([PO Wanted Delivery Date]) as MinDatePO,

max([PO Wanted Delivery Date]) as MaxDatePO

RESIDENT [Purchase Orders];

Still same error.

[Anil_Babu_Samineni]

Image please? Because, I tested it's working..

[k_burata]

Yeah, it's a bit strange because it's working on my Dev.

*I've commented out the tabs on the right of this

[Anil_Babu_Samineni]

When you say, It is working for Dev. I believe there is some path issue. But, Path issue come under "File name not allowed" error will up. So, this case Can you give exact path instead root ...

[k_burata · Accepted solution]

Strange it's working now.

This caused the error. Because we were transferring to a new environment, when I put in the correct values in the variable.txt file it worked right away. Strange though, it doesn't seem to be connected to the error I'm getting. Might be wrong though.

[Anil_Babu_Samineni]

Haha.. Good. You can close this thread..