StrataFrame Forum

Exception during deployment

http://forum.strataframe.net/Topic3204.aspx

By Jason Jarvis - 9/30/2006

I get the following exception during deployment.

OverflowException
 Value was either too large or too small for an Int32.

Source     : mscorlib

Stack Trace:
   at System.Convert.ToInt32(Double value)
   at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.GetProgressPercent(Boolean IncProgress, Int32 IncAmount)
   at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployDataThread()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

I created a new database profile, add a new database, add the security tables, add the security deployment data with the wizard.

Then created package for install and then click deploy to server.

My log looks like this. Once it gets to Preparing for data deployment... is when the exception occurs and the DDT crashes.

• 30/09/2006 15:29:51 -> Deploying meta-data for database 't4'
• 30/09/2006 15:29:52 -> The database 't4' was created successfully.
• 30/09/2006 15:29:52 -> Ensuring Filegroups exist on database 't4'
• 30/09/2006 15:29:52 -> Filegroup verification complete.
• 30/09/2006 15:29:52 -> Ensuring Tables exist on database 't4'
• 30/09/2006 15:29:53 -> The table 'SFSPermissions' was created successfully.
• 30/09/2006 15:29:53 -> The table 'SFSPreferences' was created successfully.
• 30/09/2006 15:29:53 -> The table 'SFSRestrictionItems' was created successfully.
• 30/09/2006 15:29:53 -> The table 'SFSRestrictions' was created successfully.
• 30/09/2006 15:29:53 -> The table 'SFSRoles' was created successfully.
• 30/09/2006 15:29:54 -> The table 'SFSRolesXPermissions' was created successfully.
• 30/09/2006 15:29:54 -> The table 'SFSUsers' was created successfully.
• 30/09/2006 15:29:54 -> The table 'SFSUsersXPermissions' was created successfully.
• 30/09/2006 15:29:54 -> The table 'SFSUsersXRoles' was created successfully.
• 30/09/2006 15:29:54 -> Table verification complete.
• 30/09/2006 15:29:54 -> Dropping unneeded filegroups for 't4'
• 30/09/2006 15:29:54 -> Unneeded filegroups dropped on database 't4'
• 30/09/2006 15:29:54 -> Ensuring Views exist on database 't4'
• 30/09/2006 15:29:54 -> The view 'SFSUserPermissionInfo' was created successfully.
• 30/09/2006 15:29:54 -> The view 'SFSUserRolePermissionInfo' was created successfully.
• 30/09/2006 15:29:54 -> View verification complete.
• 30/09/2006 15:29:54 -> Ensuring Indexes exist on database 't4'
• 30/09/2006 15:29:55 -> The index 'PK_SFSPermissions' was created successfully.
• 30/09/2006 15:29:55 -> The index 'PK_SFSPreferences' was created successfully.
• 30/09/2006 15:29:55 -> The index 'PK_SFSRestrictionItems' was created successfully.
• 30/09/2006 15:29:55 -> The index 'PK_SFSRestrictions' was created successfully.
• 30/09/2006 15:29:56 -> The index 'PK_SFSRoles' was created successfully.
• 30/09/2006 15:29:56 -> The index 'PK_SFSRolesXPermissions' was created successfully.
• 30/09/2006 15:29:56 -> The index 'PK_SFSUsers' was created successfully.
• 30/09/2006 15:29:57 -> The index 'PK_SFSUsersXPermissions' was created successfully.
• 30/09/2006 15:29:57 -> The index 'PK_SFSUsersXRoles' was created successfully.
• 30/09/2006 15:29:57 -> Index verification complete.
• 30/09/2006 15:29:57 -> Ensuring Foreign Keys exist on database 't4'
• 30/09/2006 15:29:57 -> The relationship 'FK_SFSRestrictions_SFSRestrictionItems' was created successfully.
• 30/09/2006 15:29:57 -> The relationship 'FK_SFSPermissions_SFSRolesXPermissions' was created successfully.
• 30/09/2006 15:29:58 -> The relationship 'FK_SFSRoles_SFSRolesXPermissions' was created successfully.
• 30/09/2006 15:29:58 -> The relationship 'FK_SFSPermissions_SFSUsersXPermissions' was created successfully.
• 30/09/2006 15:29:58 -> The relationship 'FK_SFSUsers_SFSUsersXPermissions' was created successfully.
• 30/09/2006 15:29:58 -> The relationship 'FK_SFSRoles_SFSUsersXRoles' was created successfully.
• 30/09/2006 15:29:58 -> The relationship 'FK_SFSUsers_SFSUsersXRoles' was created successfully.
• 30/09/2006 15:29:58 -> Foreign Key verification complete.
• 30/09/2006 15:29:58 -> Ensuring Assemblies exist on database 't4'
• 30/09/2006 15:29:58 -> Assembly verification complete.
• 30/09/2006 15:29:58 -> Ensuring Stored Procedures exist on database 't4'
• 30/09/2006 15:29:58 -> Stored Procedure verification complete.
• 30/09/2006 15:29:58 -> Finished verifying databases on server.
• 30/09/2006 15:29:58 -> The meta data conversion to the SQL Server has been completed.
• 30/09/2006 15:29:58 -> Preparing for data deployment...

By Trent L. Taylor - 10/1/2006

If you look at the last line of the log, it looks like this:

 30/09/2006 15:29:58 -> Preparing for data deployment...

So the schema deployment was completed.  What Deployment Data Packages do you have in your project and how were they created?

By Jason Jarvis - 10/1/2006

Trent, I have only the role based security data. I have only done exactly as described in my first post.
By Jason Jarvis - 10/1/2006

In other words, the only Deployment Data Packages is for role based security and this was created with the wizard.