StrataFrame Forum

SqlException when deploying a package, at data deployment stage

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

By Govinda Berrio - 5/18/2008

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
By Trent L. Taylor - 5/19/2008

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.

By Govinda Berrio - 5/20/2008

Thanks! It's working now.



Govinda
By Trent L. Taylor - 5/21/2008

Great!  I thought that might do the trick Smile