QTP Compile error on Itanium Powerhouse 840g

[Ole Hansen]

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

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/20150609/9bc069ca/attachment-0001.htm>