Skip to main content
R
rleir17-Peridot
17-Peridot
April 11, 2022
Question

Change Monitor NullPointerException

  • April 11, 2022
  • 1 reply
  • 1723 views

Hi team

I tried 'Change Monitor' and get

Windchill JSP Exception Nested exception is: java.lang.NullPointerException

 

Change Monitor is available in Browse->recent products->some-product->Change Monitor

or similarly by library

or under Changes (between Recent Programs and Organizations)

There are several report templates which seem to be part of the 'out-of-the-box Change Monitor' but they were not enabled. Do they all need to be enabled? Is anything else needed to get this working?

thanks -- Rick

1 reply

R
rhart16-Pearl
16-Pearl
April 12, 2022

Hi @rleir 

Does the exception happen if you view the change monitor in an empty/new product, or is it only when you try to view the site/org change monitor?

Regards

Rob

    R
    rleir17-PeridotAuthor
    17-Peridot
    April 16, 2022

    Hi Rob

    Good question, it works when used on a very simple library which just has a few documents! This is a big step forward. This looks like a Jasper report?

     

    The display contains a sub-report: All Open Problem Reports, All Open Change Requests, All Open Change Notices which work with no results because this simple library has no PR's, CR's or CN's. The reports under "All Special Reports" all fail:

    "Average Change Request Completion Time (Entire System)"  fails "An attempt to display a web page via a template processor has failed. Contact your administrator for assistance. Information for their reference follows: Request Id: aaaa  Method Context Id: aaaa


    But this is hard to debug because I just have a stack trace to work from :

    	at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: Error : 937, Position : 15, Sql = SELECT TO_CHAR(A1.createStampA2,'dd mm yyyy hh24:mi:ss'),ROUND(AVG((A0.resolutionDate)-(A1.createStampA2)),TO_NUMBER('3')),COUNT(A1.idA2A2) FROM WTChangeIssue A0,WTChangeIssueMaster A1 WHERE (((A1.idA3containerReference = :1 ) AND (A0.resolutionDate IS NOT NULL ) AND (A0.latest = :2 ))) AND (A0.idA3masterReference = A1.idA2A2), OriginalSql = SELECT TO_CHAR(A1.createStampA2,'dd mm yyyy hh24:mi:ss'),ROUND(AVG((A0.resolutionDate)-(A1.createStampA2)),TO_NUMBER('3')),COUNT(A1.idA2A2) FROM WTChangeIssue A0,WTChangeIssueMaster A1 WHERE (((A1.idA3containerReference = ?) AND (A0.resolutionDate IS NOT NULL ) AND (A0.latest = ?))) AND (A0.idA3masterReference = A1.idA2A2), Error Msg = ORA-00937: not a single-group group function

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)

     

    I can't tell you when Change Monitor started failing, it might have been long ago. Maybe these reports will tell me something when I run them directly, let's see..

    thanks -- Rick

     

    avillanueva
    23-Emerald I
    avillanueva23-Emerald I
    23-Emerald I
    July 7, 2025

    Might be unrelated to your issue but I am closing out mine via another thread (Change Monitor fails to load - Throws NullPointerException ). Issue was solved by the following PTC article. CS359502. I finally saw the error again on an WC 13 upgrade rehearsal system so was safe to try out for real. I was nervous about deleting OOTB reports and reloading but it certainly fixed the issue. Some of these reports were from very old Windchill versions. Make sense to update them. This is what I saw in my screen.

    Caused by: wt.util.WTException: java.lang.NullPointerException
Nested exception is: java.lang.NullPointerException
	at com.ptc.windchill.enterprise.reportBuilder.ReportBuilderHelper.generateInfo(ReportBuilderHelper.java:803)
	at com.ptc.windchill.enterprise.reportBuilder.ReportBuilderHelper.generateTableModel(ReportBuilderHelper.java:744)
	... 73 more
Caused by: java.lang.NullPointerException
	at com.ptc.windchill.enterprise.reportBuilder.ReportBuilderSoftQueryUtil.buildSoftItemBuilder(ReportBuilderSoftQueryUtil.java:69)
	at com.ptc.windchill.enterprise.reportBuilder.ReportBuilderSoftQueryUtil.buildSoftRelationalExpression(ReportBuilderSoftQueryUtil.java:132)

    Had some trouble with an attributeMap. WC 12 did not report this. Deleted reports, Reloaded them from file. Stop Windchill. Clear cache and restart. Issue is resolved.

    Terms & ConditionsCookie settingsAccessibility statement