QTP Compile error on Itanium Powerhouse 840g RESOLVED.

Tue Jun 9 20:52:31 CDT 2015

You may want to place a service call with Unicom. As long as the sort item is not a blob you should not have an error.
Krikor GullekianModern Legacy Solutionstel: 647-216-6599

      From: "Thurston, Alan R JTST:EX" <alan.thurston at gov.bc.ca>
 To: 'krikor Gullekian' <krigul at yahoo.com>; "'powerh-l at lists.sowder.com'" <powerh-l at lists.sowder.com> 
 Sent: Tuesday, June 9, 2015 2:15 PM
 Subject: RE: RE:QTP Compile error on Itanium Powerhouse 840g RESOLVED.

 <!--#yiv5287196624 _filtered #yiv5287196624 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv5287196624 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv5287196624 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv5287196624 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv5287196624 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv5287196624 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv5287196624 {font-family:Webdings;panose-1:5 3 1 2 1 5 9 6 7 3;}#yiv5287196624 #yiv5287196624 p.yiv5287196624MsoNormal, #yiv5287196624 li.yiv5287196624MsoNormal, #yiv5287196624 div.yiv5287196624MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}#yiv5287196624 a:link, #yiv5287196624 span.yiv5287196624MsoHyperlink {color:blue;text-decoration:underline;}#yiv5287196624 a:visited, #yiv5287196624 span.yiv5287196624MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv5287196624 p.yiv5287196624MsoAcetate, #yiv5287196624 li.yiv5287196624MsoAcetate, #yiv5287196624 div.yiv5287196624MsoAcetate {margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", "sans-serif";}#yiv5287196624 span.yiv5287196624BalloonTextChar {font-family:"Tahoma", "sans-serif";}#yiv5287196624 span.yiv5287196624EmailStyle19 {font-family:"Calibri", "sans-serif";color:#1F497D;}#yiv5287196624 .yiv5287196624MsoChpDefault {font-size:10.0pt;} _filtered #yiv5287196624 {margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv5287196624 div.yiv5287196624WordSection1 {}-->Thanks to all for suggestions. The subfile was sorted so I changed the SORT ON that failed  to SORTED ON. Now it compiles.    Still having fun with blobs though, so I will post another question when I can make in an intelligent questionJ    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 PPlease consider the environment before printing this e-mail    From: powerh-l-bounces+alan.thurston=gov.bc.ca at lists.sowder.com [mailto:powerh-l-bounces+alan.thurston=gov.bc.ca at lists.sowder.com]On Behalf Of krikor Gullekian
Sent: Tuesday, June 9, 2015 7:01 AM
To: powerh-l at lists.sowder.com
Subject: RE:QTP Compile error on Itanium Powerhouse 840g    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 Gullekian Consultant Modern Legacy Solution tel: 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