QTP Compile error on Itanium Powerhouse 840g

[Thurston, Alan R JTST:EX]

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.html>