Conversion from type ‘DBNull’ to type ‘Date’ is not valid

Cognos Controller 10.3
Oracle 12c database
Microsoft Windows 2008 R2 Server

Standard Error generated when running Multi Period Locking report, and you have not selected a “Use Filter”.

Error message:
“Number: 5
Source: FrangoDirect.PerLockHandler.SelectMultiPerLocks#System.Web.Services
Description: System.Web.Services.Protocols.SoapException:
Server was unable to process request. —> System.InvalidCastException:
Conversion from type ‘DBNull’ to type ‘Date’ is not valid……..”

Possible Solution:
Set a Selected filter when using “Multi Period Locking” and run the report for a specific period.

This is different behavior since Controller version 10.1.1 where this did not give a error.

Other workaround is to enter a date in the column for date in the “Define Submission” dialog in Cognos Controller for all rows.

More Information: