Solved

Process flow doesnt fill in the variable

  • 16 August 2023
  • 7 replies
  • 74 views

Badge +1

We currently have a task where if you click on it. It redirects you to an other table and it activates its document.

 

This part work on our Dev envoirement and we have synchronized it with our Acc envoirement as well. But testing it on our Acc envoirement. The variable does not get filled in our process flow monitor in Acc envoirement. While on the Dev envoirement it does.

 

How can I solve this issue?

icon

Best answer by Mark Jongeling 16 August 2023, 16:39

View original

This topic has been closed for comments

7 replies

Userlevel 7
Badge +23

Hi Anthony,

Using the following code, you can view the model that you have synchronized to IAM. Verify on both environments that the Input/Output are set correctly. If the data differs, try to re-sync the model:

-- Run on IAM database
declare @model_id model_id = 'model',
@branch_id branch_id = 'branch',
@process_flow_id process_flow_id = 'process flow name'

select *
from process_variable p
where p.model_id = @model_id
and p.branch_id = @branch_id
and p.process_flow_id = @process_flow_id

select *
from process_action_input_parmtr p
where p.model_id = @model_id
and p.branch_id = @branch_id
and p.process_flow_id = @process_flow_id

select *
from process_action_output_parmtr p
where p.model_id = @model_id
and p.branch_id = @branch_id
and p.process_flow_id = @process_flow_id

 

Badge +1

It seems indeed that the process flow are not synchronized. I just tried to synchronize it. But for some reason it doesnt even show up. When I ran above query again.

Userlevel 7
Badge +23

When syncing to IAM, a hash will be stored to ensure the “same data” does not get processed again. Now it is possible to alter values in the model inside the IAM database (not recommended of course), but that also means the hash does not actually correspond with the data that once was processed.

You can run the following to empty those stored hashes and retry to synchronize. If that also does not help, we may need to dive deeper into why the process flow is not synchronized:

-- Run on IAM database for the correct model and branch
declare @model_id "model_id" = '',
@branch_id "branch_id" = ''

delete from sync_view
where model_id = @model_id
and branch_id = @branch_id

 

Badge +1

By 'correct model and branch’ do you mean by the targeted envoirement where the process flow needs to be implemented or?

 

Because if yes, There is no row over here in the sync_view table of the IAM database

Userlevel 7
Badge +23

From the Software Factory, you synchronize the model/branch into IAM with a particular name. That name should be set as parameter values. For example:

sync_view table data

targeted environment where the process flow needs to be implemented

The process flow is part of the model, so when you sync the model to IAM, it should be present in IAM with all its properties and its related data. If there's no data in this table, that is pretty odd as this is part of the Synchronization process.

Badge +1

Nope, sadly after deleting the sync_view and re-synchronising it still doesnt work

Userlevel 7
Badge +23

Our support team can most likely help out finding the exact cause of the process flow not working properly. Can you create a ticket in TCP? Thanks! Sorry I couldn't solve it on the spot😅