Hi Team,
Where clause in process giving an error,process will trigger on delete event on a custom table
code:
'Get the uid_UNSRootB for SAP
Dim uid_UNSRootB As String = Connection.GetSingleProperty("UNSRootB", _
"UID_UNSRootB", _
"Ident_UNSRoot = 'SAP'").ToString
'Get the uid_UNSGroupB
Dim uid_UNSGroupB as String = Connection.GetSingleProperty("UNSGroupB", _
"UID_UNSGroupB", _
"UID_UNSRootB = '" & uid_UNSRootB & "' AND CCC_SAPSystem = '" & $CCC_Connector$ & "' AND CCC_SAPRoleName = '" & $CCC_RoleName$ & "'").ToString
'Get the uid_UNSAccountB
Dim uid_UNSAccountB as string = Connection.GetSingleProperty("UNSAccountB", _
"UID_UNSAccountB", _
"UID_UNSRootB = '" & uid_UNSRootB & "' AND AccountName = '" & $CCC_UserID$ & "'").ToString
Value = "UID_UNSGroupB = '" + values("uid_UNSAccountB").ToString+ "'and UID_UNSAccountB = '" + Values("uid_UNSGroupB").ToString + "'"
Error While process is executed:
[810306] Error during execution of 'OnGenerate' in logic module 'VI.DB.Entities.EventsEntityLogic'.
at VI.DB.Entities.EntitySingleDbObject.<>c__DisplayClass36_0.<<Save>b__0>d.MoveNext()
at VI.DB.Entities.EventUnitOfWork.<PutAsync>d__2.MoveNext()
at VI.DB.Entities.PermissionsUnitOfWork.<PutAsync>d__10.MoveNext()
at VI.DB.Entities.EventUnitOfWork.<PutAsync>d__2.MoveNext()
at VI.DB.Entities.UnitOfWorkImpl.<PutAsync>d__37.MoveNext()
at VI.DB.Entities.DbEntitySink.<PutAsync>d__15.MoveNext()
at VI.DB.Entities.InteractiveSaveEntityStrategy.<Generate>d__5.MoveNext()
at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
at VI.DB.Entities.CombinedEntityLogic.<OnGenerate>d__14.MoveNext()
[810103] Error generating processes for event Delete.
at VI.DB.Entities.CombinedEntityLogic.<OnGenerate>d__14.MoveNext()
at VI.DB.Entities.EventsEntityLogic.<OnGenerate>d__2.MoveNext()
at VI.DB.Entities.UnitOfWorkImpl.<GenerateAsync>d__39.MoveNext()
at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
at VI.DB.JobGeneration.JobGeneratorImpl.<CreateChainsAsync>d__6.MoveNext()
[810222] Error executing script 'Event_Delete'.
at VI.DB.JobGeneration.JobGeneratorImpl.<CreateChainsAsync>d__6.MoveNext()
at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
at VI.DB.JobGeneration.JobGeneratorImpl.<_CreateChainsForSingle>d__7.MoveNext()
at VI.DB.Scripting.ScriptRunner.Eval(String key, Object[] parameters)
[810108] Error generation process step event Delete.
at DynScripts.JobGen_CCCstg_SAP_UsersToRoles_060VtgP6unl6plK4fH0htrl8Fg.Event_Delete(JobGenContext context)
[810109] Error generating process CCC_CCCstg_SAP_UsersToRoles_Delete.
at DynScripts.JobGen_CCCstg_SAP_UsersToRoles_060VtgP6unl6plK4fH0htrl8Fg.Event_Delete(JobGenContext context)
at DynScripts.JobGen_CCCstg_SAP_UsersToRoles_060VtgP6unl6plK4fH0htrl8Fg.Chain_CCC_CCCstg_SAP_UsersToRoles_Delete(JobGenContext context, String EventName)
[810110] Error generating process step DeleteEntry from UNSAccountBinUNSGroupB.
at DynScripts.JobGen_CCCstg_SAP_UsersToRoles_060VtgP6unl6plK4fH0htrl8Fg.Chain_CCC_CCCstg_SAP_UsersToRoles_Delete(JobGenContext context, String EventName)
at DynScripts.JobGen_CCCstg_SAP_UsersToRoles_060VtgP6unl6plK4fH0htrl8Fg.Job_CCC_CCCstg_SAP_UsersToRoles_Delete_DeleteEntry_from_UNSAccountBinUNSGroupB(JobGenContext context, String EventName, JobChain myChain, IVarContext chainValues)
[810156] Error generating parameter WhereClause.
at DynScripts.JobGen_CCCstg_SAP_UsersToRoles_060VtgP6unl6plK4fH0htrl8Fg.Job_CCC_CCCstg_SAP_UsersToRoles_Delete_DeleteEntry_from_UNSAccountBinUNSGroupB(JobGenContext context, String EventName, JobChain myChain, IVarContext chainValues)
Object reference not set to an instance of an object.
at DynScripts.JobGen_CCCstg_SAP_UsersToRoles_060VtgP6unl6plK4fH0htrl8Fg.Job_CCC_CCCstg_SAP_UsersToRoles_Delete_DeleteEntry_from_UNSAccountBinUNSGroupB(JobGenContext context, String EventName, JobChain myChain, IVarContext chainValues)
