DDT process errors


Author
Message
Edhy Rijo
E
StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
I am starting to use the DDT to update development/production databases but I am getting some errors which I don't have a clue how to fix them.  Attached is the log file, and here are some of the errors:

• 9/24/2008 8:29:42 PM -> Deploying meta-data for database 'Progytech_CommonDatabase'
• 9/24/2008 8:29:42 PM -> Ensuring Filegroups exist on database 'Progytech_CommonDatabase'
X 9/24/2008 8:29:44 PM -> Creating datafile 'Progytech_CommonDatabase' failed.
X 9/24/2008 8:29:44 PM -> FailedOperationException       
X 9/24/2008 8:29:44 PM ->   Create failed for DataFile 'Progytech_CommonDatabase'.        
X 9/24/2008 8:29:44 PM -> ExecutionFailureException       
X 9/24/2008 8:29:44 PM ->   An exception occurred while executing a Transact-SQL statement or batch.       
X 9/24/2008 8:29:44 PM -> SqlException       
X 9/24/2008 8:29:44 PM ->   The file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Progytech_CommonDatabase.mdf' cannot be overwritten.  It is being used by database 'Progytech_CommonDatabase'.       
X 9/24/2008 8:29:44 PM -> The logical file name "Progytech_CommonDatabase" is already in use. Choose a different name.
       

The database already exist on my ISP hosting server, so I guess I will get this error all the time, but should this be just a warning, because I am not really trying to create the database.

Here is another one which is really clueless to me:

X 9/24/2008 8:30:46 PM -> Altering table 'ServiceCalls' failed.
X 9/24/2008 8:30:46 PM -> FailedOperationException       
X 9/24/2008 8:30:46 PM ->   Alter failed for Table 'dbo.ServiceCalls'.        
X 9/24/2008 8:30:46 PM -> ExecutionFailureException       
X 9/24/2008 8:30:46 PM ->   An exception occurred while executing a Transact-SQL statement or batch.       
X 9/24/2008 8:30:46 PM -> SqlException       
X 9/24/2008 8:30:46 PM ->   Implicit conversion from data type datetime to bigint is not allowed. Use the CONVERT function to run this query. 

I don't have any table which I made that kind of change to the fields, so I don't even know in this table which field is this error related to.

And the last one:

X 9/24/2008 8:32:14 PM -> Altering index 'PK_ServiceCalls' failed.
X 9/24/2008 8:32:14 PM -> FailedOperationException       
X 9/24/2008 8:32:14 PM ->   Alter failed for Index 'PK_ServiceCalls'.        
X 9/24/2008 8:32:14 PM -> SmoException       
X 9/24/2008 8:32:14 PM ->   Modifying the IsClustered property of the Index object is not allowed. You must drop and recreate the object with the desired property.

I have not made any changes to this index at all.

I appreciate if somebody can clarify what am I doing wrong here.  At this point I am not able to do modifications to some of my tables with the DDT.

Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search