Too many files declared for this run. QTP ending.

[Ken Langendock]

Daniel, why did you use VIAINDEX statements when using Oracle? My rule of
thumb is to have only one Primary/Unique index in a file and allow Oracle to
control the access method itself. It is smart enough to know the fastest way
of retrieving the results you want without being told what index to use.
 
LINK a, b to a,b in mytable is all you need to do.
 
Adding Cursors will definitely speed it up 10 fold.
 
Ken

  _____  

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Daniel Rodríguez
Sent: October 2, 2007 5:45 AM
To: Franck LERAY
Cc: powerh-l at lists.sowder.com
Subject: Re: Too many files declared for this run. QTP ending.


Ok, I will try to replace some lines of code with SQL statements and we'll
see...

Thanks,

Dani


2007/10/2, Franck LERAY <franck.leray at cheops.fr
<mailto:franck.leray at cheops.fr> >: 

Hi Daniel,

 

Mmm, I think there's a difference of one file between HP3000 and UNIX. Oh, I
can't explain why!!!

 

Regards,

 

Franck.

 


  _____  


De : powerh-l-bounces+franck.leray=cheops.fr at lists.sowder.com
[mailto:powerh-l-bounces+franck.leray=cheops.fr at lists.sowder.com] De la part
de Daniel Rodríguez
Envoyé : mardi 2 octobre 2007 10:02
À : powerh-l at lists.sowder.com
Objet : Too many files declared for this run. QTP ending.

 

Hi all,

When compiling a big QTP migrated from HP3000/MPE/TurboImage/Powerhouse 7.29
to HP9000/Hp-UX/Oracle 10.2/Powerhouse 8.43.D1 we get the following error:
"Too many files declared for this run. QTP ending." and it exits from QTP. 

We haven't added any file to the QTP in the migration process. We have only
added the VIAINDEX keyword in the access statement.

Has the file limit been decreased in the new version? Or, QTP counts files
and subfiles in a different way in this version? 

Regards,

Daniel Rodriguez Olías


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20071002/19b11795/attachment.html