Skip to main content
T
TS_138068483-Newcomer
3-Newcomer
August 14, 2025
Solved

Report on all File Upload Errors for all Users

  • August 14, 2025
  • 1 reply
  • 391 views

Version: Windchill 12.1

 

Use Case: This idea is to help prevent the bad practice of letting files sit with upload errors without attention for long periods of time (weeks/months/etc.) This report would be able to capture all files within Windchill that have upload or other related errors, so the support team can work with those users proactively instead of reactively when something is broken or lost at a bad time.


Description:

We had a scenario where a user had some check-in errors from almost a year ago on some files and didn't address them then like they should've. Since so much time had passed, the user may have deleted something referenced as well as some file name conflict issues that were present. It was a mess in the moment for many reasons but seemed like a valuable opportunity to see if we can be proactive for other users/errors that exist. All-in-all, if we had a report to catch all upload errors

 

Fields to capture:  User, FileName, UploadDate, ErrorStatus, Size, Revision.

Best answer by joe_morton

I had a similar issue, but a different approach. I made a report to query New Objects in Workspaces that hadn't been checked in. The report is a little more complex than probably needed because it returns both WTParts and CAD files. The report has a parameter so you can choose to only return items that have been sitting for over X days.

 

Here's what the tables and joins look like: 

joe_morton_0-1755187515901.png

 

Select or Constrain:

joe_morton_1-1755187550502.png

 

And then Criteria:

joe_morton_9-1755187787979.png

 

 

The Or condition has 2 sub-selects. It's been so long since I made this, I don't actually remember why this works. The first one is for returning CAD:

joe_morton_3-1755187666244.png

joe_morton_4-1755187676863.png

joe_morton_5-1755187687996.png

 

The 2nd is highly similar, but for the WTParts:

joe_morton_6-1755187708208.png

joe_morton_7-1755187717687.png

joe_morton_8-1755187727694.png

 

In practice though, what I've found is that engineers have a ton of abandoned files, and they don't like to clean up after themselves. I've stopped using the report entirely 

 

1 reply

joe_morton
18-Opal
joe_morton18-OpalAnswer
18-Opal
August 14, 2025

I had a similar issue, but a different approach. I made a report to query New Objects in Workspaces that hadn't been checked in. The report is a little more complex than probably needed because it returns both WTParts and CAD files. The report has a parameter so you can choose to only return items that have been sitting for over X days.

 

Here's what the tables and joins look like: 

joe_morton_0-1755187515901.png

 

Select or Constrain:

joe_morton_1-1755187550502.png

 

And then Criteria:

joe_morton_9-1755187787979.png

 

 

The Or condition has 2 sub-selects. It's been so long since I made this, I don't actually remember why this works. The first one is for returning CAD:

joe_morton_3-1755187666244.png

joe_morton_4-1755187676863.png

joe_morton_5-1755187687996.png

 

The 2nd is highly similar, but for the WTParts:

joe_morton_6-1755187708208.png

joe_morton_7-1755187717687.png

joe_morton_8-1755187727694.png

 

In practice though, what I've found is that engineers have a ton of abandoned files, and they don't like to clean up after themselves. I've stopped using the report entirely 

 

    T
    TS_138068483-NewcomerAuthor
    3-Newcomer
    August 14, 2025

    Hi Joe, great explanation and detail! Thank you so much! This seems like a great idea and I will be sure to test/report back asap. 

     

    Cheers!

      Terms & ConditionsCookie settingsAccessibility statement