Hello Guys,
Am trying to test a smartobject in k2 4.5 version. The smartobject is mapped to a database through a service configured in brokermanagement.
For testing am using Smartobject- Service- Tester. When trying to run the method :Get List for this smartobject. I get the following error
Specified Cast is not Valid
Thanks,
Sunil
Set the server and client to same regional settings. If it is not, there might be a problem with datetime formatting. Another thing to look for is not to format the date to a string. In 4.5, the ServiceBroker expects the DateTime value to be of type DateTime.
I take it you used the SQL Server Service to create the smart objects.
You can try to go to the SmartObject service tester and edit the instance of the SQL Server Service Instance.
There is a property "Use Native SQL execution" set this to true and it should resolve your issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.