Received error "Object cannot be cast from DBNull to other types" in KTA Validation

Last updated
Save as PDF

3014835

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