<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName" /><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]--><style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="Section1">
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">Hi I am importing a module and this appears to stop after importing 57 of 126 files when I look at the database I see that the following sql statement is continuously
running.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">SELECT CMS_OFFLINE_STRUCTURE.STRUCTURE_ID,CMS_OFFLINE_STRUCTURE.RESOURCE_ID,CMS_<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">OFFLINE_STRUCTURE.RESOURCE_PATH,CMS_OFFLINE_STRUCTURE.STRUCTURE_STATE,CMS_OFFLIN<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">E_STRUCTURE.DATE_RELEASED,CMS_OFFLINE_STRUCTURE.DATE_EXPIRED,CMS_OFFLINE_RESOURC<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">ES.RESOURCE_ID,CMS_OFFLINE_RESOURCES.RESOURCE_TYPE,CMS_OFFLINE_RESOURCES.RESOURC<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">E_FLAGS,CMS_OFFLINE_RESOURCES.RESOURCE_STATE,CMS_OFFLINE_RESOURCES.DATE_CREATED,<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">CMS_OFFLINE_RESOURCES.DATE_LASTMODIFIED,CMS_OFFLINE_RESOURCES.USER_CREATED,CMS_O<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">FFLINE_RESOURCES.USER_LASTMODIFIED,CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED LO<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">CKED_IN_PROJECT,CMS_OFFLINE_RESOURCES.RESOURCE_SIZE,CMS_OFFLINE_RESOURCES.SIBLIN<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">G_COUNT,CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED FROM CMS_OFFLINE_STRUCTURE,CM<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">S_OFFLINE_RESOURCES WHERE CMS_OFFLINE_STRUCTURE.RESOURCE_PATH=:1 AND CMS_OFFLINE<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">_STRUCTURE.RESOURCE_ID=CMS_OFFLINE_RESOURCES.RESOURCE_ID ORDER BY CMS_OFFLINE_ST<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">RUCTURE.STRUCTURE_STATE ASC<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">The application appears to hang at this point. Has anything like this been seen before?<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial">Thanks<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"> </span></font><b><font size="2" face="Arial"><span style="font-size:
10.0pt;font-family:Arial;font-weight:bold"><img width="94" height="53" id="_x0000_i1025" src="cid:image001.jpg@01CB5A50.65DAC230" align="baseline" border="0"><img width="32" height="32" id="_x0000_i1026" src="cid:image002.gif@01CB5A50.65DAC230" align="baseline" border="0"><o:p></o:p></span></font></b></p>
<p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt;
font-family:Arial;font-weight:bold"><o:p> </o:p></span></font></b></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><st1:PersonName w:st="on"><strong><b><font size="3" color="black" face="Times New Roman"><span style="font-size:12.0pt;color:black">Frank James</span></font></b></strong></st1:PersonName><font size="2" color="blue" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:blue"> </span></font><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial"><br>
Operational Support Manager<br>
</span></font><strong><b><font size="2" face="Times New Roman"><span style="font-size:11.0pt">monitise</span></font></b></strong><o:p></o:p></p>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:11.0pt;
font-family:Arial"><br>
</span></font><font size="2" color="#7f7f7f" face="Arial"><span style="font-size:
10.0pt;font-family:Arial;color:#7F7F7F"><a href="mailto:Frank.James@monitisegroup.com" title="mailto:Frank.James@monitisegroup.com
mailto:name.surname@monitisegroup.com
mailto:name.surname@monilink.co.uk"><font color="gray"><span style="color:gray">Frank.James@<span title="mailto:Frank.James@monitisegroup.com
mailto:name.surname@monitisegroup.com
mailto:name.surname@monilink.co.uk"><span title="mailto:Frank.James@monitisegroup.com
mailto:name.surname@monitisegroup.com">monitisegroup.com</span></span></span></font></a></span></font><o:p></o:p></p>
<p class="MsoNormal"><strong><b><font size="3" color="#7f7f7f" face="Times New Roman"><span style="font-size:12.0pt;color:#7F7F7F">t +44 (0)20 7947 4259</span></font></b></strong><o:p></o:p></p>
<p class="MsoNormal"><strong><b><font size="3" color="#7f7f7f" face="Times New Roman"><span style="font-size:12.0pt;color:#7F7F7F">f +44 (0)20 7947 4301</span></font></b></strong><o:p></o:p></p>
<p class="MsoNormal"><b><font size="2" color="#7f7f7f" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:#7F7F7F;font-weight:bold">m</span></font></b><font size="2" color="#7f7f7f" face="Arial"><span style="font-size:10.0pt;font-family:
Arial;color:#7F7F7F"> </span></font><strong><b><font color="#7f7f7f" face="Times New Roman"><span style="color:#7F7F7F">+44
(0)7882 799 674</span></font></b></strong><font size="2" color="#7f7f7f" face="Arial"><span style="font-size:10.0pt;font-family:
Arial;color:#7F7F7F"><br>
</span></font><strong><b><font color="gray" face="Times New Roman"><span style="color:gray"><a href="http://www.monitisegroup.com/" title="http://www.monitisegroup.com/"><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial">www</span></font><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial">.</span></font><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial;font-weight:
normal"><span title="http://www.monitisegroup.com/
http://www.monilink.co.uk/">m</span></font><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial;font-weight:
normal">o</span></span></font><font size="2" face="Arial"><span style="font-size:
10.0pt;font-family:Arial;font-weight:normal">n</span></font><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial;font-weight:normal">i<span title="http://www.monitisegroup.com/"></span></font><font size="2" face="Arial"><span style="font-size:10.0pt;font-family:Arial;font-weight:normal"></span>tisegroup.com</span></font></a></span></font></b></strong><font size="2" color="gray" face="Arial"><span style="font-size:10.0pt;font-family:Arial;
color:gray">
</span></font><o:p></o:p></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"> <o:p></o:p></span></font></p>
<p class="MsoNormal"><strong><b><font size="3" color="#e7b631" face="Times New Roman"><span style="font-size:12.0pt;color:#E7B631"><span title="http://www.monitisegroup.com/"><span title="http://www.monitisegroup.com/
http://www.monilink.co.uk/">think</span></span>
before you print</span></font></b></strong><o:p></o:p></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"> <o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:
12.0pt"><o:p> </o:p></span></font></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1">This message contains confidential and proprietary information of the sender, and is intended only for the person(s) to whom it is addressed. Any use, distribution, copying, disclosure or taking of any action in reliance
upon it by any other person is strictly prohibited. If you have received this message in error, please notify the e-mail sender immediately, and delete the original message without making a copy.<br>
<br>
The Monitise group comprises: Monitise plc (Reg. No. 6011822), Monitise Group Limited (Reg. No. 5590897), Monitise International Limited (Reg. No. 5556711), Monitise Europe Limited (Reg. No. 4831976) and Monitise Business Solutions Limited (Reg. No. 5814266).
These companies are registered in England and Wales and their registered office address is: Warnford Court, 29 Throgmorton Street, London, EC2N 2AT United Kingdom.<br>
</font>
</body>
</html>