Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Synthetic Keys not created automatically

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?

14 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Same error message.

Not applicable
Author

Hi Jonathan,

Tables:

Geo: 4385 records

Time: 10 records

QUALITY_SELL: 489777 records

SELL_VALUE: 289075 records


This is my complete script.

jonathandienst
Partner - Champion III
Partner - Champion III

Well that's not a lot. What happens if you run these queries in MSQL MS or Toad?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Takes seconds to run without any error..