Too many files declared for this run. QTP ending.

[Daniel Rodríguez]

Ok, another thing to revise in the migration process... the list is getting
too long... I'm starting to miss the old HP3000 ;-)

Thanks,

Dani


2007/10/2, Ken Langendock <Ken at langendock.com>:
>
>  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 >:
> > >
> > >  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/e6bf5945/attachment.htm