Have a project and database with Security tables. As an FYI, I initially deployed but then had to make extensive changes to the actual SQL Database that had the Security tables in it. Wanted to rebuild the DT from the SQL Database so I deleted to DT Project and then IMPORTED it back into the DT.

Then wanted to test the deployment immediately after the import and got these errors.

When I click to create a new package I get the "Verification complete, review log for more details" with "Verification completed: 0 errors, 0 warnings"
Then click OK

The process starts and then an error:

Database Management Toolkit
Event ID: 1026

An error occurred while attempting to create installation package. See below for more details.

Error Message
IndexOutOfRangeException
There is no row at position 0

Source: System.Data

Stack Trace:
at System.Data.RBTree'1.GetNodeByIndex(Int32 userIndex)
at System.Data.RBTree'1.get_Item(Int32 index)
at System.Data.DataRowCollection.get_Item(Int32 index)
at MicroFour.StrataFrame.Business.DBEDeploymentDataBO.GetItemSelectQueries(Int32 deployDataPK)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.PackageDeploymentDataFromSQL(PackageFile ThePackage, DataRow DeploymentDataRow, Boolean silent)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.PackageDeploymentData(PackageFile ThePackage, Boolean silent)
at MicroFor.StrataFrame.Data.ProfileEditorDialog.PackageProfileForInstall(Boolean silent)

If I select to NOT create a newe package before deploying to the server:

Then click to Deplot Data Only, click NEXT, NEXT, NEXT and NEXT again when the Deployment Data screen appears.Then the final screen appears showing selected options and I click FINISH.

This error appears:

Deployment Progress
An error occurred while deploying the data to the server.
IndexOutOfRangeException
Index was outside the bounds of the array
Source: MicroFour StrataFrame DBEngine
Stack Trace:
at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployDataThread()


 

It is throwing the error while trying to package your deployment data. What data deployment packages do you have? Just the standard security ones, or do you have some custom ones as well? 

If it is just the security packages, I would remove them and let them be re-created by the data deployment wizard. If you have some custom ones, I would look over them again to make sure they are still pointed to the proper server and tables now that you have made your customizations.

Thanks

Thanks. That fixed it.