StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Database creation

Database creation

Ian Hammond — Mon, 04 Apr 2011 07:57:15 GMT

I am attempting to create my database, but I get an exception:

Ensuring Tables exist on database 'HLS'
X 04/04/2011 12:00:28 -> Creating table 'HLS' failed.
X 04/04/2011 12:00:28 -> FailedOperationException
X 04/04/2011 12:00:28 ->   Create failed for Table 'dbo.HLS'.
X 04/04/2011 12:00:28 -> ExecutionFailureException
X 04/04/2011 12:00:28 ->   An exception occurred while executing a Transact-SQL statement or batch.
X 04/04/2011 12:00:28 -> SqlException
X 04/04/2011 12:00:28 ->   Incorrect syntax near ','.
X 04/04/2011 12:00:28 ->
X 04/04/2011 12:00:28 -> Source     : Microsoft.SqlServer.Smo
X 04/04/2011 12:00:28 ->
X 04/04/2011 12:00:28 -> Stack Trace:
X 04/04/2011 12:00:28 ->    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
X 04/04/2011 12:00:28 ->    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
X 04/04/2011 12:00:28 ->    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
X 04/04/2011 12:00:28 ->    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
X 04/04/2011 12:00:28 ->    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
X 04/04/2011 12:00:28 ->    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
X 04/04/2011 12:00:28 ->    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
X 04/04/2011 12:00:28 ->    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
X 04/04/2011 12:00:28 ->    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
X 04/04/2011 12:00:28 ->    at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
X 04/04/2011 12:00:28 ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)
X 04/04/2011 12:00:28 ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingOptions so)
X 04/04/2011 12:00:28 ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
X 04/04/2011 12:00:28 ->    at Microsoft.SqlServer.Management.Smo.Table.Create()
X 04/04/2011 12:00:28 ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.CreateSmoObject(ICreatable ObjectToCreate, String ObjectName, DBEObjectType ObjectType, Boolean verboseLogging)
X 04/04/2011 12:00:28 ->

Is there anyway I ccan see what Transact coomand is used to create the database table?

Are there any pointers to waht I may be doing wrong?

Many thanks.

RE: Database creation

Ian Hammond — Mon, 04 Apr 2011 07:57:15 GMT

I have successfully created 3 other databases, so I assumed the connections were viable.

Is there anything else that could cause the problem?

It seems that I may have cut too much from the error log, the following is the text relating to HLS.

• 05/04/2011 09:12:50 -> Deploying meta-data for database 'HLS'
• 05/04/2011 09:12:51 -> The database 'HLS' was created successfully.
• 05/04/2011 09:12:51 -> Ensuring Filegroups exist on database 'HLS'
• 05/04/2011 09:12:51 -> Filegroup verification complete.
• 05/04/2011 09:12:51 -> Ensuring Tables exist on database 'HLS'
X 05/04/2011 09:12:52 -> Creating table 'HLS' failed.
X 05/04/2011 09:12:52 -> FailedOperationException
X 05/04/2011 09:12:52 ->   Create failed for Table 'dbo.HLS'.
X 05/04/2011 09:12:52 -> ExecutionFailureException
X 05/04/2011 09:12:52 ->   An exception occurred while executing a Transact-SQL statement or batch.
X 05/04/2011 09:12:52 -> SqlException
X 05/04/2011 09:12:52 ->   Incorrect syntax near ','.
X 05/04/2011 09:12:52 ->
X 05/04/2011 09:12:52 -> Source     : Microsoft.SqlServer.Smo
X 05/04/2011 09:12:52 ->
X 05/04/2011 09:12:52 -> Stack Trace:
X 05/04/2011 09:12:52 ->    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
X 05/04/2011 09:12:52 ->    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
X 05/04/2011 09:12:52 ->    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
X 05/04/2011 09:12:52 ->    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
X 05/04/2011 09:12:52 ->    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
X 05/04/2011 09:12:52 ->    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
X 05/04/2011 09:12:52 ->    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
X 05/04/2011 09:12:52 ->    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
X 05/04/2011 09:12:52 ->    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
X 05/04/2011 09:12:52 ->    at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
X 05/04/2011 09:12:52 ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)
X 05/04/2011 09:12:52 ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingOptions so)
X 05/04/2011 09:12:52 ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
X 05/04/2011 09:12:52 ->    at Microsoft.SqlServer.Management.Smo.Table.Create()
X 05/04/2011 09:12:52 ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.CreateSmoObject(ICreatable ObjectToCreate, String ObjectName, DBEObjectType ObjectType, Boolean verboseLogging)
X 05/04/2011 09:12:52 ->
• 05/04/2011 09:12:52 -> Table verification complete.
• 05/04/2011 09:12:52 -> Dropping unneeded filegroups for 'HLS'
• 05/04/2011 09:12:52 -> Unneeded filegroups dropped on database 'HLS'
• 05/04/2011 09:12:52 -> Ensuring Indexes exist on database 'HLS'
X 05/04/2011 09:12:52 -> Indexes for table 'HLS' could not be verified because the table could not be found on database 'HLS'
X 05/04/2011 09:12:52 ->
• 05/04/2011 09:12:52 -> Index verification complete.
• 05/04/2011 09:12:52 -> Ensuring Foreign Keys exist on database 'HLS'
X 05/04/2011 09:12:52 -> Foreign Keys for table 'HLS' could not be verified because the table could not be found on database 'HLS'
X 05/04/2011 09:12:52 ->
• 05/04/2011 09:12:53 -> Foreign Key verification complete.
• 05/04/2011 09:12:53 -> Ensuring Triggers exist on database 'HLS'
X 05/04/2011 09:12:53 -> Triggers for table 'HLS' could not be verified because the table could not be found on database 'HLS'
X 05/04/2011 09:12:53 ->
• 05/04/2011 09:12:53 -> Trigger verification complete.
• 05/04/2011 09:12:53 -> Ensuring Assemblies exist on database 'HLS'
• 05/04/2011 09:12:53 -> Assembly verification complete.
• 05/04/2011 09:12:53 -> Ensuring Views, Stored Procedures, and UDFs exist on database 'HLS'
• 05/04/2011 09:12:54 -> View, Stored Procedure, and UDF verification complete.
• 05/04/2011 09:12:54 -> Ensuring Indexes exist on database 'HLS'
• 05/04/2011 09:12:54 -> Index verification complete.
• 05/04/2011 09:12:54 -> Deploying meta-data for database 'StrataFrame'

When clicking on Setup in the DDT, you ghet the option to define Database Connection, but I'm not sure if I use this to set up a connection for a database that's outside the StratFrame. Can you please advise

The structure of HLS is the same as CUSTOM which was created successfully, so I'm at a loss here. I don't know if there is a connection issue since the HLS database was created. It would be nice to be able to see the Transact SQL statement that caused the issue.

Could anyone please advise, many thanks.

Regards

RE: Database creation

Ivan George Borges — Mon, 04 Apr 2011 07:40:16 GMT

Have you checked your connection information? It looks like it wasn't able to connect to your SQL Server.