<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_1_1433857718193_15481"><span id="yui_3_16_0_1_1433857718193_15493">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.</span></div><div id="yui_3_16_0_1_1433857718193_15668"><br><span id="yui_3_16_0_1_1433857718193_15493"></span></div><div id="yui_3_16_0_1_1433857718193_15714" dir="ltr"><span id="yui_3_16_0_1_1433857718193_15493">krikor Gullekian</span></div><div id="yui_3_16_0_1_1433857718193_15717" dir="ltr"><span id="yui_3_16_0_1_1433857718193_15493">Consultant</span></div><div id="yui_3_16_0_1_1433857718193_15818" dir="ltr"><span id="yui_3_16_0_1_1433857718193_15493">Modern Legacy Solution</span></div><div id="yui_3_16_0_1_1433857718193_15817" dir="ltr"><span id="yui_3_16_0_1_1433857718193_15493">tel: 647-216-6599</span></div><br> <div id="yui_3_16_0_1_1433857718193_15480" style="font-family: HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_1_1433857718193_15479" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_1_1433857718193_15478" dir="ltr"> <hr size="1"> <font id="yui_3_16_0_1_1433857718193_15477" face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> "powerh-l-request@lists.sowder.com" <powerh-l-request@lists.sowder.com><br> <b><span style="font-weight: bold;">To:</span></b> powerh-l@lists.sowder.com <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, June 9, 2015 4:20 AM<br> <b id="yui_3_16_0_1_1433857718193_15541"><span id="yui_3_16_0_1_1433857718193_15540" style="font-weight: bold;">Subject:</span></b> powerh-l Digest, Vol 115, Issue 1<br> </font> </div> <div id="yui_3_16_0_1_1433857718193_15543" class="y_msg_container"><br original_target="http://lists.sowder.com/mailman/listinfo/powerh-l">Send powerh-l mailing list submissions to<br> <a id="yui_3_16_0_1_1433857718193_15542" saprocessedanchor="true" ymailto="mailto:powerh-l@lists.sowder.com" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a saprocessedanchor="true" href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>or, via email, send a message with subject or body 'help' to<br> <a id="yui_3_16_0_1_1433857718193_15544" saprocessedanchor="true" ymailto="mailto:powerh-l-request@lists.sowder.com" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><br>You can reach the person managing the list at<br> <a saprocessedanchor="true" ymailto="mailto:powerh-l-owner@lists.sowder.com" href="mailto:powerh-l-owner@lists.sowder.com">powerh-l-owner@lists.sowder.com</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of powerh-l digest..."<br><br><br>Today's Topics:<br><br> 1. QTP Compile error on Itanium Powerhouse 840g<br> (Thurston, Alan R JTST:EX)<br> 2. RE:QTP Compile error on Itanium Powerhouse 840g (Ole Hansen)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Mon, 8 Jun 2015 21:38:15 +0000<br>From: "Thurston, Alan R JTST:EX" <<a saprocessedanchor="true" ymailto="mailto:alan.thurston@gov.bc.ca" href="mailto:alan.thurston@gov.bc.ca">alan.thurston@gov.bc.ca</a>><br>Subject: QTP Compile error on Itanium Powerhouse 840g<br>To: "'<a saprocessedanchor="true" ymailto="mailto:powerh-l@lists.sowder.com" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>'" <<a saprocessedanchor="true" ymailto="mailto:powerh-l@lists.sowder.com" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>><br>Cc: "Johnson, Harold A AVED:EX" <<a saprocessedanchor="true" ymailto="mailto:Harold.A.Johnson@gov.bc.ca" href="mailto:Harold.A.Johnson@gov.bc.ca">Harold.A.Johnson@gov.bc.ca</a>>,<br> "Holland, Peter A EDUC:EX" <<a saprocessedanchor="true" ymailto="mailto:peter.holland@gov.bc.ca" href="mailto:peter.holland@gov.bc.ca">peter.holland@gov.bc.ca</a>>, "Thornton, Norah<br> JTST:EX" <<a saprocessedanchor="true" ymailto="mailto:Norah.Thornton@gov.bc.ca" href="mailto:Norah.Thornton@gov.bc.ca">Norah.Thornton@gov.bc.ca</a>><br>Message-ID: <<a id="yui_3_16_0_1_1433857718193_15761" saprocessedanchor="true" ymailto="mailto:372eb71e4cc54e99a3f1bb6a4685e0c0@E3PMBX19.idir.BCGOV" href="mailto:372eb71e4cc54e99a3f1bb6a4685e0c0@E3PMBX19.idir.BCGOV">372eb71e4cc54e99a3f1bb6a4685e0c0@E3PMBX19.idir.BCGOV</a>><br>Content-Type: text/plain; charset="us-ascii"<br><br>Hello All,<br>I have a statement in QTP that compiles OK in Powerhouse 710g1 but fails to compile in Powerhouse 840g. The statement is:<br><br>access *CMS8020ASF &<br> link CBR_ID of CMS8020ASF &<br> to CBR_ID of CBR_TU in LRBDB &<br> link TU_NAME_ID of CBR_TU &<br> to TU_NAME_ID of TU_NAME in LRBDB &<br> link TU_LOCAL_ID of TU_NAME &<br> to TU_LOCAL_ID of TU_LOCAL in LRBDB &<br> link TU_ID of TU_LOCAL &<br> to TU_ID of TRADE_UNION in LRBDB<br><br><br>sort on CASE_ID of CMS8020ASF &<br> on DISP_ID of CMS8020ASF<br><br>The error is:<br>*E* Cannot sort table containing blob items.<br><br>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.<br><br>The statement does compile in QTP 710g1 and also compiles in QUIZ 840g, just not in QTP 840g<br><br>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.<br><br>Any ideas would be appreciated.<br><br>Thank you,<br><br><br>Alan Thurston - Senior Software Developer - Information Systems Branch<br>Ministry of Community, Sport and Cultural Development | Ministry of Jobs, Tourism, and Skills Training (and Responsible for Labour)<br><br>Phone: 250 387-0220 | Fax: 250 387-1590<br>3rd Floor, 800 Johnson Street, PO Box 9802 Stn Prov Govt, Victoria, BC V8W 9W1<br>P Please consider the environment before printing this e-mail<br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a saprocessedanchor="true" href="http://lists.sowder.com/pipermail/powerh-l/attachments/20150608/4b6dfc6a/attachment-0001.html" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20150608/4b6dfc6a/attachment-0001.html</a>><br><br>------------------------------<br><br>Message: 2<br>Date: Tue, 9 Jun 2015 08:20:11 +0000<br>From: Ole Hansen <<a saprocessedanchor="true" ymailto="mailto:oh@scanconsult.aero" href="mailto:oh@scanconsult.aero">oh@scanconsult.aero</a>><br>Subject: RE: QTP Compile error on Itanium Powerhouse 840g<br>To: "Thurston, Alan R JTST:EX" <<a saprocessedanchor="true" ymailto="mailto:alan.thurston@gov.bc.ca" href="mailto:alan.thurston@gov.bc.ca">alan.thurston@gov.bc.ca</a>>,<br> "'<a saprocessedanchor="true" ymailto="mailto:powerh-l@lists.sowder.com" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>'" <<a saprocessedanchor="true" ymailto="mailto:powerh-l@lists.sowder.com" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>><br>Cc: "Johnson, Harold A AVED:EX" <<a saprocessedanchor="true" ymailto="mailto:Harold.A.Johnson@gov.bc.ca" href="mailto:Harold.A.Johnson@gov.bc.ca">Harold.A.Johnson@gov.bc.ca</a>>,<br> "Holland, Peter A EDUC:EX" <<a saprocessedanchor="true" ymailto="mailto:peter.holland@gov.bc.ca" href="mailto:peter.holland@gov.bc.ca">peter.holland@gov.bc.ca</a>>, "Thornton, Norah<br> JTST:EX" <<a saprocessedanchor="true" ymailto="mailto:Norah.Thornton@gov.bc.ca" href="mailto:Norah.Thornton@gov.bc.ca">Norah.Thornton@gov.bc.ca</a>><br>Message-ID:<br> <<a id="yui_3_16_0_1_1433857718193_15762" saprocessedanchor="true" ymailto="mailto:D6CF093F47C9E347BC18914C39CE3A700F40E831@scserver501.scanconsult.local" href="mailto:D6CF093F47C9E347BC18914C39CE3A700F40E831@scserver501.scanconsult.local">D6CF093F47C9E347BC18914C39CE3A700F40E831@scserver501.scanconsult.local</a>><br> <br>Content-Type: text/plain; charset="us-ascii"<br><br>Hi Alan,<br><br>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.<br><br><br>Mange hilsner / With kind regards<br><br>Ole Hansen<br>IT-Consultant<br><br>ScanConsult IT-Partners ApS<br>Jegstrupvej 96A<br>DK-8361 Hasselager<br>Denmark<br><br>Phone (switchboard): +45 7734 7474<br>Phone (direct): +45 7734 7472<br>Mobile: +45 4040 1150<br>Fax: +45 7734 7575<br><a saprocessedanchor="true" ymailto="mailto:oh@scanconsult.aero" href="mailto:oh@scanconsult.aero">oh@scanconsult.aero</a><mailto:<a saprocessedanchor="true" ymailto="mailto:oh@scanconsult.aero" href="mailto:oh@scanconsult.aero">oh@scanconsult.aero</a>><br>www.scanconsult.aero<<a saprocessedanchor="true" href="http://www.scanconsult.aero/" target="_blank">http://www.scanconsult.aero</a>><br><br>ParaSuite: A Suite of Air Cargo Handling solutions<br>We partner with Microsoft, Hewlett-Packard, Oracle and others<br><br>From: powerh-l-bounces+oh=<a saprocessedanchor="true" ymailto="mailto:scanconsult.aero@lists.sowder.com" href="mailto:scanconsult.aero@lists.sowder.com">scanconsult.aero@lists.sowder.com</a> [mailto:powerh-l-bounces+oh=<a saprocessedanchor="true" ymailto="mailto:scanconsult.aero@lists.sowder.com" href="mailto:scanconsult.aero@lists.sowder.com">scanconsult.aero@lists.sowder.com</a>] On Behalf Of Thurston, Alan R JTST:EX<br>Sent: Monday, June 08, 2015 11:38 PM<br>To: '<a saprocessedanchor="true" ymailto="mailto:powerh-l@lists.sowder.com" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>'<br>Cc: Johnson, Harold A AVED:EX; Holland, Peter A EDUC:EX; Thornton, Norah JTST:EX<br>Subject: QTP Compile error on Itanium Powerhouse 840g<br><br>Hello All,<br>I have a statement in QTP that compiles OK in Powerhouse 710g1 but fails to compile in Powerhouse 840g. The statement is:<br><br>access *CMS8020ASF &<br> link CBR_ID of CMS8020ASF &<br> to CBR_ID of CBR_TU in LRBDB &<br> link TU_NAME_ID of CBR_TU &<br> to TU_NAME_ID of TU_NAME in LRBDB &<br> link TU_LOCAL_ID of TU_NAME &<br> to TU_LOCAL_ID of TU_LOCAL in LRBDB &<br> link TU_ID of TU_LOCAL &<br> to TU_ID of TRADE_UNION in LRBDB<br><br><br>sort on CASE_ID of CMS8020ASF &<br> on DISP_ID of CMS8020ASF<br><br>The error is:<br>*E* Cannot sort table containing blob items.<br><br>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.<br><br>The statement does compile in QTP 710g1 and also compiles in QUIZ 840g, just not in QTP 840g<br><br>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.<br><br>Any ideas would be appreciated.<br><br>Thank you,<br><br><br>Alan Thurston - Senior Software Developer - Information Systems Branch<br>Ministry of Community, Sport and Cultural Development | Ministry of Jobs, Tourism, and Skills Training (and Responsible for Labour)<br><br>Phone: 250 387-0220 | Fax: 250 387-1590<br>3rd Floor, 800 Johnson Street, PO Box 9802 Stn Prov Govt, Victoria, BC V8W 9W1<br>P Please consider the environment before printing this e-mail<br><br><br><br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a id="yui_3_16_0_1_1433857718193_15763" saprocessedanchor="true" href="http://lists.sowder.com/pipermail/powerh-l/attachments/20150609/9bc069ca/attachment.htm" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20150609/9bc069ca/attachment.htm</a>><br><br>------------------------------<br><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a saprocessedanchor="true" ymailto="mailto:powerh-l@lists.sowder.com" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: &quot;subscribe&quot; in message body to <a saprocessedanchor="true" ymailto="mailto:powerh-l-request@lists.sowder.com" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to <a saprocessedanchor="true" ymailto="mailto:powerh-l-request@lists.sowder.com" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a saprocessedanchor="true" href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>This list is closed, thus to post to the list you must be a subscriber.<br>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.<br><br>End of powerh-l Digest, Vol 115, Issue 1<br>****************************************<br><br><br></div> </div> </div> </div></body></html>