StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Exception during deploymentExpand / Collapse
Author
Message
Posted 09/30/2006 9:37:14 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 10/10/2006 2:02:37 PM
Posts: 19, Visits: 86
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...

Post #3204
Posted 10/01/2006 8:21:44 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 10:13:07 AM
Posts: 4,799, Visits: 4,768
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?

Post #3209
Posted 10/02/2006 5:20:41 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 10/10/2006 2:02:37 PM
Posts: 19, Visits: 86
Trent, I have only the role based security data. I have only done exactly as described in my first post.
Post #3213
Posted 10/02/2006 5:22:53 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 10/10/2006 2:02:37 PM
Posts: 19, Visits: 86
In other words, the only Deployment Data Packages is for role based security and this was created with the wizard.
Post #3214
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 11:00am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.109. 9 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.