Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
People, I started working with Qlikview last week, and there's my problem bellow.
I have to load 2 tables with finance information, and they have 3 columns in common. When I load, give me an error: 'Execution of Script Failed. Reload old data?'
Check the statements bellow:
SQL SELECT
MONTHY,
QUARTER,
YEAR
FROM "DBM_MKT".dbo."TIME";
SQL SELECT
PK_AGENCY,
NAME_AGENCY,
DISTRICT,
SR,
SUAT,
REGION,
WORKERID,
NAME_WORKER
FROM "DBM_MKT".dbo."GEO"
WHERE SUAT LIKE 'AREA%';
SQL SELECT
PK_AGENCY,
MONTHY,
PRODUCT,
TRANSACTION,
QUALITYSELL,
AMOUNT
FROM "DBM_MKT".dbo."QUALITY_SELL";
SQL SELECT
PK_AGENCY,
MONTHY,
PRODUCT,
SUMVALUE
FROM "DBM_MKT".dbo."SELL_VALUE";
Someone can help me?
Hi
How large are these tables and how much RAM do you have on the machine doing the reload? Have you checked the memory consumption? There should be no synthetic keys being created if you followed my post exactly.
What else are you doing in your script. If you single step, where does the error occur. I suggest that you post your complete script here.
HTH
Jonathan
Same error message.
Hi Jonathan,
Tables:
Geo: 4385 records
Time: 10 records
QUALITY_SELL: 489777 records
SELL_VALUE: 289075 records
This is my complete script.
Well that's not a lot. What happens if you run these queries in MSQL MS or Toad?
Takes seconds to run without any error..