topic Re: Was The Windchill Table WorkflowVariableEventInfo Retired? in Windchill

Was The Windchill Table WorkflowVariableEventInfo Retired?

DK_10560861 — Tue, 28 Mar 2023 12:50:43 GMT

Hi everyone!

Does anyone know if the Windchill table WorkflowVariableEventInfo is retired in version 12.0.2 and forward in the Windchill database? If so, does anyone by chance know what table it was replaced with in the Windchill database?

Re: Was The Windchill Table WorkflowVariableEventInfo Retired?

HelesicPetr — Tue, 28 Mar 2023 13:38:26 GMT

Hi @DK_10560861

The WorkflowVariableEventInfo table still exists in my installation Windchill 12.0.2.8 so I do not think that the table is retired

PetrH

Re: Was The Windchill Table WorkflowVariableEventInfo Retired?

DK_10560861 — Tue, 28 Mar 2023 13:45:12 GMT

Thank you so much! We have the table as well, but it stopped being updated when we migrated to version 12.0.2. I should have specified that in my original post and I apologize for not doing so.

Does your WorkflowVariableEventInfo table continue to get updated with new rows in your Windchill version 12.0.2.8?

Re: Was The Windchill Table WorkflowVariableEventInfo Retired?

HelesicPetr — Tue, 28 Mar 2023 14:19:58 GMT

in my case the table is empty. But the system is clear installation without user usage.

So my question is what information has been stored in the table? (I know variable of the workflow >D but what exactly :D)

PetrH

Re: Was The Windchill Table WorkflowVariableEventInfo Retired?

HelesicPetr — Tue, 28 Mar 2023 14:33:35 GMT

hi @DK_10560861

btw my Windchill 11.1 M020 CPS 08 installation does not contains any data in the table.

This system has been used a lot.

PetrH

Re: Was The Windchill Table WorkflowVariableEventInfo Retired?

rleir — Wed, 29 Mar 2023 21:55:58 GMT

It looks to be related to audits, judging by hits in these old articles:

https://www.ptc.com/en/support/article/CS342885
https://www.ptc.com/en/support/article/CS22182
https://www.ptc.com/pt/support/article/cs77185

Re: Was The Windchill Table WorkflowVariableEventInfo Retired?

d_graham — Wed, 29 Mar 2023 23:51:26 GMT

FYI, I have an OOTB installation of 12.1.2.0.

This dB also has the table.

Re: Was The Windchill Table WorkflowVariableEventInfo Retired?

HelesicPetr — Thu, 30 Mar 2023 06:50:22 GMT

Good one @rleir

So it could be audit record for workflow events(complete task and so on) that are not recorded OOTB now days I think.

PS: Security audit records are stored in an AuditRecord table

PetrH

Re: Was The Windchill Table WorkflowVariableEventInfo Retired?

DK_10560861 — Thu, 30 Mar 2023 12:03:53 GMT

Okay. Thanks for the information!

There was a rejection reason being stored there that users could add when there was a rejection in the task workflow process. Based off of what I am reading in the responses, I am wondering if the ability to add a rejection reason was something custom created and when the upgrade to version 12.0.2 occurred, something in the custom logic broke.

Re: Was The Windchill Table WorkflowVariableEventInfo Retired?

DK_10560861 — Thu, 30 Mar 2023 12:07:02 GMT

That very well could be! Thank you!

I am wondering if the ability to add a rejection reason was something custom created and when the upgrade to version 12.0.2 occurred, something in the custom logic broke.

Re: Was The Windchill Table WorkflowVariableEventInfo Retired?

DK_10560861 — Thu, 30 Mar 2023 12:07:24 GMT

Good to know. Thank you!

Re: Was The Windchill Table WorkflowVariableEventInfo Retired?

d_graham — Thu, 30 Mar 2023 15:09:16 GMT

@DK_10560861 , I never heard of an OOTB reason for rejection.

What I usually do is this, if a workflow is sent to Rework or Reject the user is required to specify why.

Their comments are then added to a history in the workflow and this history is displayed in all relevant workflow tasks.

Rework user can added to the history as well.

The whole thread displays like a chat window. The name of the user who added the comment is automatically added to their comment(s).

You can run but you can’t hide 😁

Re: Was The Windchill Table WorkflowVariableEventInfo Retired?

rleir — Sat, 01 Apr 2023 11:36:58 GMT

The Audit system is configurable in server-side XMLs. Maybe the default configuration changed in the upgrade?