QTP Compile error on Itanium Powerhouse 840g

Tue Jun 9 10:43:58 CDT 2015

Hi Alan:

   The scratch file that is created when you perform a sort contains all the items in the access statement.
   1) if you are not using the blob then create a view excluding the blob access the view instead.
   2) if you are using the blob  then create a view excluding the blob save your results in a subfile in a new request access the subfile use sorted instead of sort
      and link back to the table with the blob.

   We just about to go forward with our Itanium experience.

Regards,
Peter Bateman 

-----Original Message-----
From: powerh-l-bounces+peter.bateman=hpadvancedsolutions.com at lists.sowder.com [mailto:powerh-l-bounces+peter.bateman=hpadvancedsolutions.com at lists.sowder.com] On Behalf Of powerh-l-request at lists.sowder.com
Sent: Tuesday, June 09, 2015 1:21 AM
To: powerh-l at lists.sowder.com
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