Yes I have validated all of that.
Here is the full code up to there:
Dim jobLog As New Text.StringBuilder
Dim returnValue As New List(Of Object)
Dim jobStatus As Boolean = True
Dim wfUnitClusterPk As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, wfProfileName, wfScenarioName, wfTimeName)
Dim ProfileKey As Guid = wfUnitClusterPk.ProfileKey
Dim ScenarioKey As Integer = wfUnitClusterPk.ScenarioKey
Dim TimeKey As Integer = wfUnitClusterPk.TimeKey
Dim wfProfileInfo As WorkflowProfileInfo = BRApi.Workflow.Metadata.GetProfile(si, wfProfileName)
log.AppendLine($"*********************> {wfProfileInfo.Type}")
jobLog.AppendLine($"{Environment.NewLine}============ Workflow Start ============")
log.AppendLine($"{Environment.NewLine}============ Workflow Start ============")
jobLog.AppendLine($" {DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss tt")} UTC {Environment.NewLine}")
log.AppendLine($" {DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss tt")} UTC {Environment.NewLine}")
log.AppendLine($" Workflow: {wfProfileName}")
log.AppendLine($" Scenario: {wfScenarioName}")
log.AppendLine($" Time: {wfTimeName}")
log.AppendLine($" WfPk: {wfUnitClusterPk}")
log.AppendLine($" ProfileKey {ProfileKey}")
log.AppendLine($" ScenarioKey {ScenarioKey}")
log.AppendLine($" TimeKey {TimeKey}")
log.AppendLine($" ----------------------------------------")
log.AppendLine($" Load & Transform: True")
log.AppendLine($" Validate Transformation: {valTransform}")
log.AppendLine($" Validate Intersections: {valIntersect}")
log.AppendLine($" Load Cube: {loadCube}")
log.AppendLine($" Process Cube: {processCube}")
log.AppendLine($" Run Confirmation: {confirm}")
log.AppendLine($" Run Auto Certify: {autoCertify}")
log.AppendLine("=======================================" & Environment.NewLine)
'---------------------------------
' Parse and Transform:
'---------------------------------
Dim ImportInfo As New LoadTransformProcessInfo
Try
log.AppendLine($"Here 1 {wfUnitClusterPk}")
ImportInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, wfUnitClusterPk, "", Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, False)
log.AppendLine("Here 2")
Catch ex As Exception
log.AppendLine("Import Done - Status: " & ImportInfo.Status & " - RowCount: " & FormatNumber(ImportInfo.RowCount, 0,,,-1))
log.AppendLine(ImportInfo.ErrorMessage)
log.AppendLine("------------------------------")
log.AppendLine(ex.GetBaseException.Message.ToString.Trim)
End Try
