Too many files declared for this run. QTP ending.

[Ken Langendock]

HP is very forgiving in it's files. splitting the programs into two will be
your fastest approach
 
Another thing to watch out for, if you have any requests that read and
overwrite to the same sub file, change it.!
 
as in:
 
ACCESS *FileA
 
select out some stuff
 
SUBFILE FileA alias newfile
 
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 10:18 AM
To: Ken Langendock
Cc: powerh-l at lists.sowder.com
Subject: Re: Too many files declared for this run. QTP ending.


Hi Ken,

We were told that QTP was not very fast without creating alternative index
so we have created many search keys in Oracle. We are converting to the new
enviroment our first QTP's now I realize that the performance it's not so
bad without indexes... 

We will study more carefully the creation of indexes in the future...  Thank
you very much!

But, my problem with the number of files still exists. I've removed all the
viaindex, replaced a 3 file access statement with one cursor and  the
problem continues... I'm going slightly mad... I think we will split in 2
all those big QTP's... but it's a little bit annoying... 

Best regards,

Daniel Rodriguez.



2007/10/2, Ken Langendock <Ken at langendock.com>: 

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
<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/248256ba/attachment.html