Skip to main content
R
rstavish1-Visitor
1-Visitor
November 8, 2010
Question

Report error

  • November 8, 2010
  • 4 replies
  • 1785 views
I have a report that I have created and it has worked for several weeks now when I try to run it I get this error message.

Any suggestions?

java.sql.SQLException: ORA-01652: unable to extend temp segment by 64 in tablespace TEMP


Thanks
Rich

Richard Stavish
Pro/E System Administrator

[cid:image001.jpg@01CB7F3C.D1CAB840]

E-mail:
Office:
Fax:
Mobile:

RStavish@sargentaerospace.com
520-744-1000 x4570
520-744-7529
520-437-5811

4 replies

A
achukwuka1-Visitor
1-Visitor
November 8, 2010


Alexius C. Chukwuka
JDPS Division SAP BASIS Team
John Deere Power Systems
R
rstavish1-VisitorAuthor
1-Visitor
July 10, 2012
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="&lt;a" style="COLOR:" blue;=" text-decoration:=" underline&quot;=" 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
M
MikeLockwood22-Sapphire I
22-Sapphire I
July 10, 2012
Likely due to the "Macro" CURRENT_TIME in one criteria being applied to additional criteria. This seems like it's corrupted all the time.
Check all the criteria - see that only those intended have the Macro checkbox checked. I hate this bug - sometimes have to rebuild reports from scratch.
M
MorganBelais11-Garnet
11-Garnet
July 10, 2012
Hello,

Terms & ConditionsAccessibility statement