Process flow doesnt fill in the variable

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

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.

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

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

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:

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.

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