<html><body>
<p>Some of the access items are not qualified.<br>
<font face="Arial">> LINK D-DOC-NO [of filename] TO AJ-NUMBER OF AJ-TOTAL OPTIONAL &</font><br>
<font face="Arial">> LINK AJ-KEY [of filename] TO AJ-KEY OF AJ-DETAIL OPTIONAL &</font><br>
<font face="Arial">...</font><br>
<font face="Arial">LINK D-DELPNT-X TO DELPNT-CODE-X OF DELPNTS OPTIONAL &</font><br>
<br>
<font face="Arial">In QTP the most recently accessed file becomes the default.</font><br>
<font face="Arial">The lack of qualification may be causing a problem not otherwise seen until statement was modified.</font><br>
<br>
Although there are only 10 files in the access list, depending on the overal record lengths there may be a large amount of memory being consumed in the record complex.<br>
Since adding the last linkage resulted in the failure, in your boots I would start by looking at the SAPSCEZ9 record to see if there are large fields.<br>
<br>
Something to look into is to create a test subfile of a subset of the content of SAPSCEZ9. Substitute the test subfile into the access stmt to see how much of the content, or what specific content, can be accommodated before a failure occurs.<br>
<br>
Depending on your testing you may be forced to re-work the creation process for the content of SAPSCEZ9 to reduce the overall size of the record complex, <br>
<br>
Even with the access statement accepted, if you have TEMP and DEFINE statements you may still encounter the error later on.<br>
<br>
<br>
<br>
<br>
<br>
<br>
<img width="16" height="16" src="cid:1__=0ABBF398DFC55E158f9e8a93df938@ca.ibm.com" border="0" alt="Inactive hide details for "Grace, Ron (Chipping Sodbury) UK" ---09/14/2011 09:24:47 AM---Afternoon listers, I'm running the fol"><font color="#424282">"Grace, Ron (Chipping Sodbury) UK" ---09/14/2011 09:24:47 AM---Afternoon listers, I'm running the following code on a HP3000 using MPEIX and after adding the new f</font><br>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=0ABBF398DFC55E158f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2" color="#5F5F5F">From:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=0ABBF398DFC55E158f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2">"Grace, Ron (Chipping Sodbury) UK" <Ron.Grace@hanson.biz></font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=0ABBF398DFC55E158f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2" color="#5F5F5F">To:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=0ABBF398DFC55E158f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2">"powerh-l@lists.sowder.com" <powerh-l@lists.sowder.com></font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=0ABBF398DFC55E158f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Date:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=0ABBF398DFC55E158f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2">09/14/2011 09:24 AM</font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=0ABBF398DFC55E158f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Subject:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=0ABBF398DFC55E158f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2">Powerhouse fatal error</font></td></tr>
<tr valign="top"><td width="1%"><img width="96" height="1" src="cid:2__=0ABBF398DFC55E158f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2" color="#5F5F5F">Sent by:</font></td><td width="100%"><img width="1" height="1" src="cid:2__=0ABBF398DFC55E158f9e8a93df938@ca.ibm.com" border="0" alt=""><br>
<font size="2">powerh-l-bounces+michael.cousins=ca.ibm.com@lists.sowder.com</font></td></tr>
</table>
<hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br>
<br>
<br>
<font face="Arial">Afternoon listers,</font><br>
<font face="Arial"> </font><br>
<font face="Arial">I'm running the following code on a HP3000 using MPEIX and after adding the new file linkage at the bottom of the access statement it's started bombing out. I checked the fields I'm linking and both are 2 characters in length. PROD-GR-CODE is a key/index field of the SAPSCEZ9 subfile. I have also checked the file equations for the subfiles and they all exist and in the correct locations. Am I missing something obvious?</font><br>
<font face="Arial"> </font><br>
<font face="Arial">Ron</font><br>
<font face="Arial"> </font><br>
<font face="Arial">> REQUEST EXTRACT_DATA</font><br>
<font face="Arial">> </font><br>
<font face="Arial">> ACCESS *JD0221Z1 &</font><br>
<font face="Arial">> LINK ("UN" + UNIT-CODE-X OF JD0221Z1) TO MQ-KEY OF MQ-TEXT OPTIONAL &</font><br>
<font face="Arial">> LINK D-PROD-CODE OF JD0221Z1 TO PROD-CODE OF PRODUCTS OPTIONAL &</font><br>
<font face="Arial">> LINK D-DOC-NO TO AJ-NUMBER OF AJ-TOTAL OPTIONAL &</font><br>
<font face="Arial">> LINK AJ-KEY TO AJ-KEY OF AJ-DETAIL OPTIONAL &</font><br>
<font face="Arial">> LINK D-PROD-GR-CODE OF JD0221Z1 &</font><br>
<font face="Arial">> TO PROD-GR-CODE OF PROD-GROUP OPTIONAL &</font><br>
<font face="Arial">> LINK D-DELPNT-X TO DELPNT-CODE-X OF DELPNTS OPTIONAL &</font><br>
<font face="Arial">> LINK D-PROD-CODE OF JD0221Z1 TO PROD-CODE OF PRODUCTS-EXTRA OPTIONAL &</font><br>
<font face="Arial">> LINK D-PROD-CODE OF JD0221Z1 TO PROD-CODE OF *SAPSCEZ8 OPTIONAL &</font><br>
<font face="Arial">> ;A.01.005 Start</font><br>
<font face="Arial">> LINK D-PROD-GR-CODE OF JD0221Z1 TO PROD-GR-CODE OF &</font><br>
<font face="Arial">> *SAPSCEZ9 OPTIONAL</font><br>
<font face="Arial">Code Trap :</font><br>
<font face="Arial"> 01634010227</font><br>
<font face="Arial"> 00003044033</font><br>
<font face="Arial"> 00000001442</font><br>
<font face="Arial"> 00000000017</font><br>
<font face="Arial">*E* Memory fault (invalid address).</font><br>
<font face="Arial">*Fatal Error* *1370* Notify Cognos Customer Support</font><br>
<font face="Arial"> </font><br>
<br>
<u><font size="4" color="#C0C0C0" face="Arial"> ________________________________ </font></u><br>
<font size="2" color="#808080" face="Arial">Each of Hanson Aggregates, Hanson Aggregates UK, Hanson Bath & Portland Stone, Hanson Construction Projects, Hanson Contracting, Hanson Premix, Hanson Recycling, Ashbridge Concrete and Supamix is a trading name of Hanson Quarry Products Europe Limited. Hanson Quarry Products Europe Limited is a private limited company incorporated in England and Wales with registered number 00300002 and with registered address Hanson House, 14, Castle Hill, Maidenhead, Berkshire<br>
<br>
Hanson Quarry Products Europe Limited is a member of the HeidelbergCement Group.</font><br>
<br>
<u><font size="4" color="#C0C0C0" face="Arial"> ________________________________ </font></u><br>
<font size="2" color="#808080" face="Arial">This e-mail and any attachment transmitted with it are confidential and are intended for the named person’s use only. The contents of the e-mail may contain sensitive and private or legally privileged information. If you have received this e-mail in error, please delete it (and any attachment) from your system and notify the sender immediately. You should not retain, copy or print the contents of this e-mail (or any attachment) nor should you, directly or indirectly, disclose or distribute the contents to anyone.</font><tt>--<br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: powerh-l@lists.sowder.com<br>
Subscribe: 'subscribe' in message body to powerh-l-request@lists.sowder.com<br>
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to powerh-l-request@lists.sowder.com<br>
<a href="http://lists.sowder.com/mailman/listinfo/powerh-l">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.</tt><br>
<br>
</body></html>