Error while reloading the script????

[#1]

Hi all,

I have one script where i am calling more than ten data base views for my document having 10 sheets.

Here i am simply writing all the load scripts without any joins implicitly.The joins are getting from the QlickView automatically by generating the Syn keys.

So i am finding lots of SYn keys over.

But it was working fine ,but sometimes i am getting some error saying

" OUT OF VIRTUAL AND /OR LOGICAL MEMORY, allocationg 146.965 MB"

Can some one please help me on this ?

Whats the reason i am getting this error and how to resolve the same?

Is this depends upon the data size (performance)?

Please help me out here.

Thanks & regards,

Mahasweta

[#2]

hi

Existence of synthetic keys is the reason for slow performance and for getting the out of memory message

there should be only one field common between two tables

remove all the synthetic keys, this will help to improve the performance of your model

regards

peter

[#3]

Hi Peter,

Thanks a ton for the reply.

I am sorry to ask you some basic question.

The number of Syn keys is teh number of links in between the tables right?

I dont know exactly about this, will you please help me out?

I have attached my table viewer here.

What i mean to ask you here is that I am seeing in $SYn 13 table there are 3 Syn at top followed by $ symbol, are those the Syn keys only or any thing else.

Like i am seeing Under Capacity table for $Syn 12 i am seeing 7 column nmaes under beneath the Syn 12.

Thanks,

Mahasweta

[#4]

Hi Mahasweta

The $Syn12 etc only indicates which combination of the fields in the synthetic field table is used to link the two tables. To fix this you need to decide which columns you actually want to link the tables on.

Say you want to link Capacity.. and Purchasin... tables on Product and API I suggest you rename these in the Capacity table as Cap_Product and Cap_API, renaming in Purchasin... table as Pur_Product and Pur_API and then creating an extra field in both tables: Product + API as Prod_API.

Also rename all other fields common to both tables that you don't want to link on.

The two tables will then only be linked on the concatenated field and sort out your problem.

Regards

Dewald

[#5]

Hi Peter,

Will you please tell me how i will delink or reduce these unnecessary Syn keys as i am seeing

Syn 55 = Syn 34 + Syn 35 + Syn 32 + Syn31.......

like this so many Syn keys when i am reloading.

Can i remove these?

Ideally i want only 5 keys all through out the tables, and others should not be a Syn key ,which is hitting my performance.

But i dont know why i am not able to do.

I tried the Qualify and unqualify as you said, but i dont know where i am missing so i am not getting it.

Will you please send me some example if you have?

Thanks,

Mahasweta

[#6 · Accepted solution]

see below sample

qualify *;

Capacity:

load * from ......; ( this is your Capacity table)

Purchasing:

load * from ......; (this is your purchasing table)

Absorption:

load * from ......; (this is your Absorption table)

unqualify *;

load * resident Capacity;

load * resident Purchasing;

load * resident Absorption;

drop table Capacity;

drop table Purchasing;

drop table Absorption;

now you can link these tables with the key field using alias function(renaming field ex- abc as a)

regards

peter

[#7]

Hi Peter,

if you dont mind can i have your mail id please?

I need to ask some quick helps.

Thanks,

Mahasweta