Skip to main content
S
SWilyums
Contributor
July 9, 2026
Solved

BiBlend Workflow Import Step automation - no valid data keys

  • July 9, 2026
  • 3 replies
  • 21 views

I have a workflow step that loads to BiBlend.  Workflow Name set to Blend.

I am trying to use a DM Job to call a Extender Business Rule to execute the load, so I can schedule a DM Sequence.

I call the Business Rule from a DM Job and pass in osPeriod = 2026M8 and wfName=Labor_Actual.HC_Load_BIBlend.

Scenario is currently hardcoded into the rule and is set to “Actual”

I think I have narrowed my issue to a missing scenario key.  I am using this command in the rule   BRApi.ErrorLog.LogMessage(si, "Cluster ScenarioKey=" & wfClusterPk.ScenarioKey.ToString) and it is writing a 0 to the log.  

The time and wfprofile keys are writing to log.  

Here is a section of my rule.  

The three parameters are listed in the text above, I did not want to lengthen this post unnecessarily.

----------------------------------

Dim wfClusterPk As WorkflowUnitClusterPk =

 BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, wfName, scenarioName, osPeriod)

BRApi.ErrorLog.LogMessage(si, "Cluster ProfileKey=" & wfClusterPk.ProfileKey.ToString)

BRApi.ErrorLog.LogMessage(si, "Cluster ScenarioKey=" & wfClusterPk.ScenarioKey.ToString)

BRApi.ErrorLog.LogMessage(si, "Cluster TimeKey=" & wfClusterPk.TimeKey.ToString)

 BRApi.ErrorLog.LogMessage(si, "Cluster TimeName=" & BRApi.Finance.Time.GetNameFromId(si, wfClusterPk.TimeKey))

                                                                                                     

Dim importInfo As LoadTransformProcessInfo =                                                                                            BRApi.Import.Process.ExecuteParseAndTransform(si, wfClusterPk,String.Empty,Nothing, TransformLoadMethodTypes.ReplaceBiBlendTable, SourceDataOriginTypes.FromDirectConnection, False)

Any help would be greatly appreciated.

Best answer by SWilyums

I caused the issue.  In the connector rule the Entity was not being passed correctly when using automation.  Thanks

3 replies

S
OneStream Employee
sameburnOneStream Employee
OneStream Employee
July 10, 2026

Hi ​@SWilyums 

That error is misleading.  It means the Import cannot find any data 

This could be for a number of reasons, usually a step missed in setup

The best way to debug is to download the Log File from the Workflow Import Step and this will help identify the root cause

If you search “valid datakeys” on OneCommunity there are multiple solved pages with same advice e.g. Data Import Error: No valid DataKeys (Scenario / Time) found in data source | Community

 

Hope this helps

Sam

S
SWilyumsAuthor
Contributor
July 10, 2026

Hello Sam, If I run the workflow step manually it works, so there is data.  The issue is how the business rule is passing the keys (scenario, time and Workflow).  Time and Workflow appear to work per the log.  The issues is the look up of the scenario key.  It is coming back with a value of 0.  The is related to this part of the business rule.  

Dim wfClusterPk As WorkflowUnitClusterPk =

 BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, wfName, scenarioName, osPeriod)

S
OneStream Employee
sameburnOneStream Employee
OneStream Employee
July 10, 2026

ok thanks for clarifying.  What happens if you log into that workflow profile step, scenario and time and use si.WorkflowClusterPk e.g. instead of generating WorkflowUnitClusterPk from strings?  Does that give you the same result?

S
SWilyumsAuthorAnswer
Contributor
July 10, 2026

I caused the issue.  In the connector rule the Entity was not being passed correctly when using automation.  Thanks

Terms & ConditionsAccessibility statement