$PbRunContext
$PbRunContext (system variable)
The $PbRunContext
system variable is instantiated and set for each script execution. It contains useful information that can be utilized.
Note 1: Profitbase may change the content of the $PbRunContext
at any time.
Note 2: From InVision platform version 2022.3, the $pbRunContext
is removed as argument in functions supplied by Profitbase. Remove this argument on upgrade and check the function name. Functions using this argument will not work after v.2022.4.
Internal use:
The
$PbRunContext.WorkDir
value is required when usingProfitbase.IO
functions.The
$PbRunContext.SolutionId
value is required when calling[Profitbase.Data.SqlScript]::Execute
.The
$PbRunContext.LogHandle
value is used when calling[Profitbase.PS.PsScript]::Execute
from Designer/WebApp context.The
$PbRunContext.TaskId
value is used when calling[Profitbase.PS.PsScript]::Execute
from Data Flow/Worker context.
Example 1 non data flow execution:
WorkDir : C:\InVision\WebApp\Profitbase.Invision.WebApp\PwshTempFolders\cc1604bb-42cSolutionId : SHHealthChecksMmrJQlemljTJb9SZbiGCUserId : domainname\userLanguage : en-USConnectionString : Data Source=dbsrv;Initial Catalog=pbInvision_Test;Integrated Security=True;DataFlowExecution : FalseLogHandle : 84c01459-b754-4d2b-aafb-49c99dd08319TaskId :DataFlowId :ParentLogItemId :DataFlowStepId :DataFlowItemId :
Example 2 data flow execution:
WorkDir : C:\InVision\WebApp\Executables\Worker\PwshTempFolders\80b6d7f5-6abe-42d8SolutionId : SHHealthChecksMmrJQlemljTJb9SZbiGCUserId : domainname\userLanguage : en-USConnectionString : Data Source=dbsrv;Initial Catalog=pbInvision_Test;Integrated Security=True;DataFlowExecution : TrueLogHandle :TaskId : fd371b0a-edff-47fb-b5cb-ed757222189dDataFlowId : 0b942eba-f035-48dc-bb38-d8655ebf452eParentLogItemId : entry_1b98165d-35a2-4c0b-922e-7ac8a0cf2f25DataFlowStepId : 9bf09f3a-a239-46f9-9b87-957788c1d612DataFlowItemId : d21119b2-d73e-453c-828b-b8fe7df424f9