Script help!

[#1]

I get ErrorCount=3 when trying to make a partial reload on our Qlikview Server.

I can't see where the Script error is. The script works perfectly locally and when I make a normal Reload on the server using Publisher. I only get the error when trying to make a partial reload using EDX.

I have attached a copy of the script.

Can it have something to do with making a REPLACE LOAD on a RESIDENT table?

--

What I am trying to is;

I have a Purchase Order table containing lets say 100 unique Purchase Order numbers.

My Buyers write a comment per line and select a Status (Resolved or Escalated). If no status is selected than it's Open)

I save the comment and status to an SQL table.

Lets say I have written comments for 50 out the 100 POs and 25 of these are Resolved.

I want have a Multibox where I can select the current status (in this case 75 Open and 25 Resolved).

The problem I'm having is getting a status for those Purchase Order that are not present in the SQL Table.

This is why I join the two tables

--

Grateful for any help!

Best Regards,

Jonas

[#2]

There are two changed variables: partial reload + EDX. Have you tried a partial reload locally , or in the server?

Partial reload might result in tables being empty when having WHERE clauses (because the first 100 rows are excluded), or empty tables when doing JOIN with little data (no common values in first 100 rows)

If partial reload works in server, than you can debug the EDX

-Alex

[#3 · Accepted solution]

Thanks for your reply Alexandru,

I found the problem.

The error in the script was the left join of the text file and the SQL Table. I needed to use the prefix REPLACE on the join as well, otherwise this didn't execute via EDX/partial reload.

I've attached the corrected script.

Best Regards,
Jonas