SqlException when deploying a package, at data deployment stage

Govinda Berrio — Wed, 21 May 2008 09:08:34 GMT

Hi,

I'm testing the trial version of Strataframe. The version of DDT is 1.6.0.0.

I imported a database with just 2 tables. I created 2 deployments data packages, one for all the data in each table. The tables and indexes are created successfully but the data is not deployed. I'm getting the following log... find the pkg attached (password = blue03). you need the database let me know.

• 5/18/2008 6:58:00 PM-> Deploying meta-data for database 'gkgincdb'
• 5/18/2008 6:58:01 PM-> Ensuring Filegroups exist on database 'gkgincdb'
• 5/18/2008 6:58:02 PM-> Filegroup verification complete.
• 5/18/2008 6:58:02 PM-> Ensuring Tables exist on database 'gkgincdb'
• 5/18/2008 6:58:03 PM-> Table verification complete.
• 5/18/2008 6:58:03 PM-> Dropping unneeded filegroups for 'gkgincdb'
• 5/18/2008 6:58:03 PM-> Unneeded filegroups dropped on database 'gkgincdb'
• 5/18/2008 6:58:03 PM-> Ensuring Indexes exist on database 'gkgincdb'
• 5/18/2008 6:58:03 PM-> Index verification complete.
• 5/18/2008 6:58:03 PM-> Ensuring Foreign Keys exist on database 'gkgincdb'
• 5/18/2008 6:58:03 PM-> Foreign Key verification complete.
• 5/18/2008 6:58:03 PM-> Ensuring Assemblies exist on database 'gkgincdb'
• 5/18/2008 6:58:03 PM-> Assembly verification complete.
• 5/18/2008 6:58:03 PM-> Ensuring Views, Stored Procedures, and UDFs exist on database 'gkgincdb'
• 5/18/2008 6:58:03 PM-> View, Stored Procedure, and UDF verification complete.
• 5/18/2008 6:58:03 PM-> Ensuring Indexes exist on database 'gkgincdb'
• 5/18/2008 6:58:03 PM-> Index verification complete.
• 5/18/2008 6:58:03 PM-> Finished verifying databases on server.
• 5/18/2008 6:58:03 PM-> The meta data conversion to the SQL Server has been completed.
X 5/18/2008 6:58:06 PM-> An error occurred while deploying the data to the server.
X 5/18/2008 6:58:06 PM-> SqlException
X 5/18/2008 6:58:06 PM-> Incorrect syntax near '='.
X 5/18/2008 6:58:06 PM->
X 5/18/2008 6:58:06 PM-> Source : .Net SqlClient Data Provider
X 5/18/2008 6:58:06 PM->
X 5/18/2008 6:58:06 PM-> Stack Trace:
X 5/18/2008 6:58:06 PM-> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
X 5/18/2008 6:58:06 PM-> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
X 5/18/2008 6:58:06 PM-> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
X 5/18/2008 6:58:06 PM-> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
X 5/18/2008 6:58:06 PM-> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
X 5/18/2008 6:58:06 PM-> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
X 5/18/2008 6:58:06 PM-> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
X 5/18/2008 6:58:06 PM-> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployDataSQLFromFile(String FileName, Int32 TablePK, String TableName, DBEDeploymentMergeType MergeType, Int32 CurrentLevel)
X 5/18/2008 6:58:06 PM-> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployDataSQL(DataRow DeployDataRow)
X 5/18/2008 6:58:06 PM-> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployDataThread()
X 5/18/2008 6:58:06 PM->

Please help.

Govinda
GKG Inc

RE: SqlException when deploying a package, at data deployment stage

Trent L. Taylor — Wed, 21 May 2008 09:08:34 GMT

Great! I thought that might do the trick :)

RE: SqlException when deploying a package, at data deployment stage

Govinda Berrio — Tue, 20 May 2008 09:32:41 GMT

Thanks! It's working now.

Govinda

RE: SqlException when deploying a package, at data deployment stage

Trent L. Taylor — Mon, 19 May 2008 08:17:16 GMT

First, please download the 1.6.6 beta. There have been a lot of changes to the DDT and the import process between versions. You can get it here: http://forum.strataframe.net/FindPost16061.aspx.

We will be posting another beta later this week with even more changes to the DDT. The DDT has been getting a lot of attention lately and will have many new features and enhancements through the next several releases. So try the same process on the 1.6.6 beta and then we can work from there. Thanks.

StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » SqlException when deploying a package, at data deployment stage

SqlException when deploying a package, at data deployment stage

RE: SqlException when deploying a package, at data deployment stage

RE: SqlException when deploying a package, at data deployment stage

RE: SqlException when deploying a package, at data deployment stage