QTP Compile error on Itanium Powerhouse 840g

Tue Jun 9 09:01:19 CDT 2015

Try to sort the subfile, just before this request in a separate request, and see if you will have the same problem as long as you have case_id and disp_id in there to begin with. Overall it may run faster as well.
krikor GullekianConsultantModern Legacy Solutiontel: 647-216-6599
      From: "powerh-l-request at lists.sowder.com" <powerh-l-request at lists.sowder.com>
 To: powerh-l at lists.sowder.com 
 Sent: Tuesday, June 9, 2015 4:20 AM
 Subject: powerh-l Digest, Vol 115, Issue 1

Send powerh-l mailing list submissions to
    powerh-l at lists.sowder.com

To subscribe or unsubscribe via the World Wide Web, visit
    http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
    powerh-l-request at lists.sowder.com

You can reach the person managing the list at
    powerh-l-owner at lists.sowder.com

When replying, please edit your Subject line so it is more specific
than "Re: Contents of powerh-l digest..."

Today's Topics:

  1. QTP Compile error on Itanium Powerhouse 840g
      (Thurston, Alan R JTST:EX)
  2. RE:QTP Compile error on Itanium Powerhouse 840g (Ole Hansen)

----------------------------------------------------------------------

Message: 1
Date: Mon, 8 Jun 2015 21:38:15 +0000
From: "Thurston, Alan R JTST:EX" <alan.thurston at gov.bc.ca>
Subject: QTP Compile error on Itanium Powerhouse 840g
To: "'powerh-l at lists.sowder.com'" <powerh-l at lists.sowder.com>
Cc: "Johnson, Harold A AVED:EX" <Harold.A.Johnson at gov.bc.ca>,
    "Holland, Peter    A EDUC:EX" <peter.holland at gov.bc.ca>, "Thornton,    Norah
    JTST:EX" <Norah.Thornton at gov.bc.ca>
Message-ID: <372eb71e4cc54e99a3f1bb6a4685e0c0 at E3PMBX19.idir.BCGOV>
Content-Type: text/plain; charset="us-ascii"

Hello All,
I have a statement in QTP that compiles OK in Powerhouse 710g1 but fails to compile in Powerhouse 840g. The statement is:

access *CMS8020ASF                                &
  link CBR_ID      of CMS8020ASF                  &
    to CBR_ID      of CBR_TU  in LRBDB            &
  link TU_NAME_ID  of CBR_TU                      &
    to TU_NAME_ID  of TU_NAME  in LRBDB            &
  link TU_LOCAL_ID of TU_NAME                      &
    to TU_LOCAL_ID of TU_LOCAL in LRBDB            &
  link TU_ID      of TU_LOCAL                    &
    to TU_ID      of TRADE_UNION in LRBDB

sort on CASE_ID  of CMS8020ASF                    &
    on DISP_ID  of CMS8020ASF

The error is:
*E* Cannot sort table containing blob items.

The subfile is mostly blank fields that get populated later in this request. One of the linked tables does have a field defined as BLOB.

The statement does compile in QTP 710g1 and also compiles in QUIZ 840g, just not in QTP 840g

I suspect I could create a database view of the blob-containing table and exclude the blob from the view a the blob field does not get used in the QTP run but I was hoping not to re-code too much, and that there might be options or parameters somewhere that would resolve the issue.

Any ideas would be appreciated.

Thank you,

Alan Thurston - Senior Software Developer - Information Systems Branch
Ministry of Community, Sport and Cultural Development | Ministry of Jobs, Tourism, and Skills Training (and Responsible for Labour)

Phone: 250 387-0220 | Fax: 250 387-1590
3rd Floor, 800 Johnson Street, PO Box 9802 Stn Prov Govt, Victoria, BC V8W 9W1
P Please consider the environment before printing this e-mail

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20150608/4b6dfc6a/attachment-0001.html>

------------------------------

Message: 2
Date: Tue, 9 Jun 2015 08:20:11 +0000
From: Ole Hansen <oh at scanconsult.aero>
Subject: RE: QTP Compile error on Itanium Powerhouse 840g
To: "Thurston, Alan R JTST:EX" <alan.thurston at gov.bc.ca>,
    "'powerh-l at lists.sowder.com'" <powerh-l at lists.sowder.com>
Cc: "Johnson, Harold A AVED:EX" <Harold.A.Johnson at gov.bc.ca>,
    "Holland, Peter    A EDUC:EX" <peter.holland at gov.bc.ca>, "Thornton,    Norah
    JTST:EX" <Norah.Thornton at gov.bc.ca>
Message-ID:
    <D6CF093F47C9E347BC18914C39CE3A700F40E831 at scserver501.scanconsult.local>

Content-Type: text/plain; charset="us-ascii"

Hi Alan,

Since the two sort fields are in the subfile CMS8020ASF, you could sort the subfile in the request/run, where it is created, thus avoiding sorting the record complex containing the table with a blob.

Mange hilsner / With kind regards

Ole Hansen
IT-Consultant

ScanConsult IT-Partners ApS
Jegstrupvej 96A
DK-8361  Hasselager
Denmark

Phone (switchboard): +45 7734 7474
Phone (direct): +45 7734 7472
Mobile: +45 4040 1150
Fax: +45 7734 7575
oh at scanconsult.aero<mailto:oh at scanconsult.aero>
www.scanconsult.aero<http://www.scanconsult.aero>

ParaSuite: A Suite of Air Cargo Handling solutions
We partner with Microsoft, Hewlett-Packard, Oracle and others

From: powerh-l-bounces+oh=scanconsult.aero at lists.sowder.com [mailto:powerh-l-bounces+oh=scanconsult.aero at lists.sowder.com] On Behalf Of Thurston, Alan R JTST:EX
Sent: Monday, June 08, 2015 11:38 PM
To: 'powerh-l at lists.sowder.com'
Cc: Johnson, Harold A AVED:EX; Holland, Peter A EDUC:EX; Thornton, Norah JTST:EX
Subject: QTP Compile error on Itanium Powerhouse 840g