System.InvalidCastException when using savedInput.zinp file

Any template questions or comments or suggestions

System.InvalidCastException when using savedInput.zinp file

Postby geertv on Tue Dec 05, 2006 8:41 am

Hi,

I have no issues auto generating stored procs in SQL2005 online but when I want to schedule this process, I need to store my parameters as described in the \"ZeusCmd.exe Usage\" chm file (see example 3). But I get next error message:
Code:
Code: Select all
5/12/2006 9:01:16 Executing: SQL2005 Procedure generator
5/12/2006 9:01:36 Successfully rendered Template: SQL2005 Procedure generator
5/12/2006 9:01:36 ERROR: [System.InvalidCastException] - Unable to cast object of type 'System.String' to type 'Zeus.InputItem'.
5/12/2006 9:01:36 Template execution failed.



Even without using parameters for optimistic locking, I got this error.
All help more than welcome
geertv
Lurker
 
Posts: 1
Joined: Mon Dec 04, 2006 1:18 pm

Postby justin.greenwood on Tue Dec 05, 2006 1:56 pm

Send me the template and I will see if I can figure out whats going on. Some templates use custom user interfaces that don't support project files or any automated regeneration. When a template is saved in a zinp file, it serializes the input data. Only certain data types are supported. If you vary from the supported types, it will not be able to deserialize the data back into the template when it executes.

justin.greenwood@mygenerationsoftware.com
User avatar
justin.greenwood
Site Admin
 
Posts: 441
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN

Postby justin.greenwood on Wed Jan 31, 2007 2:53 pm

This was a serialazation error. I have built in support for certain types of collections, ArrayList and Hashtable, but I can't be sure of others. In the future, i should be able to add support for generic collections, arrays, etc.
User avatar
justin.greenwood
Site Admin
 
Posts: 441
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN


Return to General Template Questions/Comments

Who is online

Users browsing this forum: No registered users and 2 guests

cron