Windchill admins,
I am trying to generate a report that I was able to generate last week. I receive the error message below.
We are on WC 9.1 M060.
Does anyone have any suggestions why it is not working?
<html>
<head>
<title>Template Processor Invocation Failed</title>
</head>
<base href="<a" style="COLOR:" blue;=" text-decoration:=" underline"=" target="_BLANK" href="http://windchill.sargent.local/Windchill/">">http://windchill.sargent.local/Windchill/">
<h2>An attempt to display a web page via a template processor has failed. Following is the text message from the exception that was generated:</h2>
wt.pom.DatastoreException: A SQL error has occurred for the statement "SELECT A0.idA2A2,A0.updateCountA2,A0.classnameA2A2,ABS(NULL),ABS(NULL),TO_CHAR(A0.startTime,'dd mm yyyy hh24:mi:ss'),A0.startTime,A1.idA2A2,A1.updateCountA2,A1.classnameA2A2,ABS(NULL),ABS(NULL),A1.name,TO_CHAR(A1.startTime,'dd mm yyyy hh24:mi:ss'),A1.startTime,TO_CHAR(A0.endTime,'dd mm yyyy hh24:mi:ss'),A0.endTime,A0.idA2A2,A2.idA2A2,A2.updateCountA2,A2.classnameA2A2,ABS(NULL),ABS(NULL),A2.status,A0.classnameA2A2,TO_CHAR(A1.endTime,'dd mm yyyy hh24:mi:ss'),A1.endTime,A3.idA2A2,A3.updateCountA2,A3.classnameA2A2,ABS(NULL),A3.branchIdA2typeDefinitionRefe,A3B.name,A4.idA2A2,A4.updateCountA2,A4.classnameA2A2,ABS(NULL),A4.branchIdA2typeDefinitionRefe,TRUNC(((A1.endTime)-(A1.startTime))*(24),'3'),TRUNC((A1.startTime)-(A1.endTime),'2'),ROUND((A0.endTime)-(A0.startTime),'1'),TRUNC(SYSDATE),A5.idA2A2,A5.updateCountA2,A5.classnameA2A2,ABS(NULL),ABS(NULL),TO_CHAR(A1.startTime,'dd mm yyyy hh24:mi:ss'),A1.startTime C0 FROM (SELECT A0.state,A0.name,A0.idA2A2,A0.idA3B7,A0.updateCountA2,A0.classnameA2A2,A0.startTime,A0.endTime FROM WfProcess A0 UNION ALL SELECT A0.state,A0.name,A0.idA2A2,A0.idA3B7,A0.updateCountA2,A0.classnameA2A2,A0.startTime,A0.endTime FROM ProjectPlan A0) A0,(SELECT A1.idA2A2,A1.startTime,A1.idA3parentProcessRef,A1.updateCountA2,A1.classnameA2A2,A1.name,A1.endTime FROM Milestone A1 UNION ALL SELECT A1.idA2A2,A1.startTime,A1.idA3parentProcessRef,A1.updateCountA2,A1.classnameA2A2,A1.name,A1.endTime FROM WfInternalMethod A1 UNION ALL SELECT A1.idA2A2,A1.startTime,A1.idA3parentProcessRef,A1.updateCountA2,A1.classnameA2A2,A1.name,A1.endTime FROM WfExpressionRobot A1 UNION ALL SELECT A1.idA2A2,A1.startTime,A1.idA3parentProcessRef,A1.updateCountA2,A1.classnameA2A2,A1.name,A1.endTime FROM WfURLRobot A1 UNION ALL SELECT A1.idA2A2,A1.startTime,A1.idA3parentProcessRef,A1.updateCountA2,A1.classnameA2A2,A1.name,A1.endTime FROM WfAssignedActivity A1 UNION ALL SELECT A1.idA2A2,A1.startTime,A1.idA3parentProcessRef,A1.updateCountA2,A1.classnameA2A2,A1.name,A1.endTime FROM ProjectActivity A1) A1,(SELECT A2.idA2A2,A2.idA3A4,A2.classnamekeyB4,A2.updateCountA2,A2.classnameA2A2,A2.status FROM WorkItem A2 UNION ALL SELECT A2.idA2A2,A2.idA3A4,A2.classnamekeyB4,A2.updateCountA2,A2.classnameA2A2,A2.status FROM ProjectWorkItem A2) A2,WTDocument A3,WTDocumentMaster A3B,(SELECT A4.idA2A2,A4.latestiterationInfo,A4.classnameA2A2,A4.branchIditerationInfo,A4.updateCountA2,A4.branchIdA2typeDefinitionRefe FROM WTDocument A4 WHERE (A4.branchIdA2typeDefinitionRefe IN (31891799,31395192))) A4,WTUser A5 WHERE (A3.idA3masterReference=A3B.idA2A2) AND (((A0.state = ?) AND (A0.name LIKE '%Design%') AND ((A2.idA2A2 > ?) AND (A1.idA2A2 > ?) AND (A5.idA2A2 > ?) AND (A4.idA2A2 > ?) AND (A3.idA2A2 > ?)))) AND ((A1.idA3parentProcessRef = A0.idA2A2) AND (A2.idA3A4 = A1.idA2A2) AND (A2.classnamekeyB4 = DECODE(A3.latestiterationInfo,?,(?)||(A3.classnameA2A2)||(?)||(A3.idA2A2),?,(?)||(A3.classnameA2A2)||(?)||(A3.branchIditerationInfo))) AND (A2.classnamekeyB4 = DECODE(A4.latestiterationInfo,?,(?)||(A4.classnameA2A2)||(?)||(A4.idA2A2),?,(?)||(A4.classnameA2A2)||(?)||(A4.branchIditerationInfo))) AND (A0.idA3B7 = A5.idA2A2)) ORDER BY C0; Bind Parameters=[OPEN_RUNNING, 0, 0, 0, 0, 0, 0, OR:, :, 1, VR:, :, 0, OR:, :, 1, VR:, :]". Database system message follows:
java.sql.SQLException: ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
Nested exception is: org.xml.sax.SAXException: Message: Resource bundle/Message key = wt.pom.pomResource/0
</html>
Richard Stavish
Pro/E System Administrator
[cid:image001.jpg@01CD5E77.35D89D00]
[cid:image009.jpg@01CD5E77.E2C123C0] <
">http://www.linkedin.com/company/sargent-aerospace-&-defense> [cid:image010.jpg@01CD5E77.E2C123C0] <
">https://twitter.com/#!/SargentAero>E-mail:
Office:
Fax:
Mobile:
RStavish@sargentaerospace.com
520-744-1000 x4570
520-744-7529
520-437-5811
