Received error "Object cannot be cast from DBNull to other types" in KTA Validation
Question / Problem:
All jobs from the newer version of process map displayed the error "Object cannot be cast from DBNull to other types" when users opening them at KTA Validation.
Error observed in the application event viewer:
Message: HandlingInstanceID: de6d0feb-c9d5-4b3c-8d11-c07cf23604c7
An exception of type 'System.ServiceModel.FaultException`1' occurred and was caught.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Type : System.ServiceModel.FaultException`1, System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Object cannot be cast from DBNull to other types.
Source : Agility.Server.Core
Help link :
Detail : Agility.Server.Integration.Common.ErrorHandling.CustomExceptionDetail
Action :
Code : System.ServiceModel.FaultCode
Reason : Object cannot be cast from DBNull to other types.
Data : System.Collections.ListDictionaryInternal
TargetSite : Void ExecuteDotNet(Agility.Server.Core.Model.Variables.VariableCollection, Agility.Server.Core.Model.Activities.DotNetActivity, Agility.Server.Core.Model.Variables.VariableCollection)
HResult : -2146233087
Stack Trace : at Agility.Server.Core.Activities.ActivityExecutor.ExecuteDotNet(VariableCollection inputParameters, DotNetActivity info, VariableCollection outputParameters)
at Agility.Server.Core.Worker.WorkerThreads.AutoActivityThread.ExecuteDotNet()
Answer / Solution:
Examine the process in KTA Designer on the system where it's failing and see if there is an "Unknown Resource" assigned to the Resources for the Validation activity. If so, remove that resource, and if necessary, add a valid one to the activity then re-release the process map. Restart the jobs to reflect the new process map version.
Applies to:
Product | Version |
---|---|
KTA | 7.3 |