DDT Evaluation


DDT Evaluation
View
Options
Author
Message
Chan
Chan
Chan
posted 15 Years Ago HOT
Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)
Group: Forum Members
Posts: 533, Visits: 2K
Hi,

Our developers have spent few days to test on DDT and found some unclear issue as below and would like to ask for clarification:



Scenarios

----------

1.Created 1st package to create the db structure and deployment data, and run the wizard to deploy the database.

Then create another new package,2nd package with the same db structure and deployment data to deploy the database

pointing to the same db that have been created using the 1st package.Error will occured(eg:FlexHRDatabase_results.log)



2.Created package using DDT and remove any one of the database from the DDT and deploy the package again.

An error will occured if click deploy the package. This happen even though I have deleted the db deletion history.



3.Import Security table to a database using DDT.When import the security table for the 2nd time to the same database,

it will create another table for all the tables which are defined the table relationship and a message prompt out to inform

that "Relationship name: Relationship with this name already exists in the database".

Then, it will create additional new tables with same name instead of updating to the existing table.This will only occur if the table has relationship. If the table is without any relationship, it will just update to the same table without creating a duplicate new table.



Any ideas? Please advice.



Thank you
Attachments
FlexHRDatabase_results.zip (183 views, 2.00 KB)
Reply Like 1
Replies
Chan
Chan
Chan
posted 15 Years Ago
Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)
Group: Forum Members
Posts: 533, Visits: 2K
Hi,

I am not able to upgrade now as we are rushing for a project, and new beta required regeneate all BO.

Anyway, I have attached our package here. Please try it.



Thank you
Reply Like 1
Chan
Chan
Chan
posted 15 Years Ago
Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)
Group: Forum Members
Posts: 533, Visits: 2K
I have sent the attachment to Trent via PM.



Thank you
Reply Like 1
Chan
Chan
Chan
posted 15 Years Ago
Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)Advanced StrataFrame User (609 reputation)
Group: Forum Members
Posts: 533, Visits: 2K
Hi,

I have download the latest beta build, and try the following steps



1. Create new DDT profile

2. Import VfsLocalization database.

3. Run Deploy to Server. Target database name is VfsLocalization as well.

4. Error occured as below.



This is to test whether DDT support to "continue" deploy pre-existing database for upcoming release.



Please advice. Thank you



• 18/02/2009 7:52:24 PM   -> Deploying meta-data for database 'VfsLocalization'

• 18/02/2009 7:52:24 PM   -> Ensuring Filegroups exist on database 'VfsLocalization'

• 18/02/2009 7:52:24 PM   -> Filegroup verification complete.

• 18/02/2009 7:52:24 PM   -> Ensuring Tables exist on database 'VfsLocalization'

• 18/02/2009 7:52:24 PM   -> Table verification complete.

• 18/02/2009 7:52:24 PM   -> Dropping unneeded filegroups for 'VfsLocalization'

• 18/02/2009 7:52:24 PM   -> Unneeded filegroups dropped on database 'VfsLocalization'

• 18/02/2009 7:52:24 PM   -> Ensuring Indexes exist on database 'VfsLocalization'

• 18/02/2009 7:52:24 PM   -> Index verification complete.

• 18/02/2009 7:52:24 PM   -> Ensuring Foreign Keys exist on database 'VfsLocalization'

• 18/02/2009 7:52:24 PM   -> Foreign Key verification complete.

• 18/02/2009 7:52:24 PM   -> Ensuring Triggers exist on database 'VfsLocalization'

• 18/02/2009 7:52:24 PM   -> Trigger verification complete.

• 18/02/2009 7:52:24 PM   -> Ensuring Assemblies exist on database 'VfsLocalization'

• 18/02/2009 7:52:24 PM   -> Assembly verification complete.

• 18/02/2009 7:52:24 PM   -> Ensuring Views, Stored Procedures, and UDFs exist on database 'VfsLocalization'

X 18/02/2009 7:52:24 PM   -> An error occurred while creating the stored procedure [dbo].[MessageItemsInsertOverwrite].

X 18/02/2009 7:52:24 PM   -> SqlException

X 18/02/2009 7:52:24 PM   -> There is already an object named 'MessageItemsInsertOverwrite' in the database.

X 18/02/2009 7:52:24 PM   ->

X 18/02/2009 7:52:24 PM   -> Source : .Net SqlClient Data Provider

X 18/02/2009 7:52:24 PM   ->

X 18/02/2009 7:52:24 PM   -> Stack Trace:

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

X 18/02/2009 7:52:24 PM   -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeploySprocsOfPriority(Database parent, DatabaseInfo dbInfo, Int32 priority)

X 18/02/2009 7:52:24 PM   ->

X 18/02/2009 7:52:24 PM   -> An error occurred while creating the stored procedure [dbo].[MessageLanguagesInsertOverwrite].

X 18/02/2009 7:52:24 PM   -> SqlException

X 18/02/2009 7:52:24 PM   -> There is already an object named 'MessageLanguagesInsertOverwrite' in the database.

X 18/02/2009 7:52:24 PM   ->

X 18/02/2009 7:52:24 PM   -> Source : .Net SqlClient Data Provider

X 18/02/2009 7:52:24 PM   ->

X 18/02/2009 7:52:24 PM   -> Stack Trace:

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

X 18/02/2009 7:52:24 PM   -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

X 18/02/2009 7:52:24 PM   -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeploySprocsOfPriority(Database parent, DatabaseInfo dbInfo, Int32 priority)

X 18/02/2009 7:52:24 PM   ->

• 18/02/2009 7:52:24 PM   -> View, Stored Procedure, and UDF verification complete.

• 18/02/2009 7:52:24 PM   -> Ensuring Indexes exist on database 'VfsLocalization'

• 18/02/2009 7:52:24 PM   -> Index verification complete.

• 18/02/2009 7:52:24 PM   -> Finished verifying databases on server.

• 18/02/2009 7:52:24 PM   -> The meta data conversion to the SQL Server has been completed.
Reply Like 1
ChanKK
ChanKK
ChanKK
posted 15 Years Ago
StrataFrame User (248 reputation)StrataFrame User (248 reputation)StrataFrame User (248 reputation)StrataFrame User (248 reputation)StrataFrame User (248 reputation)StrataFrame User (248 reputation)StrataFrame User (248 reputation)StrataFrame User (248 reputation)StrataFrame User (248 reputation)
Group: Forum Members
Posts: 190, Visits: 1.3K
Hi,

Just would like to inform that, my personal account "Chan" has been expired (since no longer able to post any message). I would use this account "VisualSolutions" to reply my post.



Anyhow, I still waiting for SF reply.



Thank you
Reply Like 1
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...



Submit

Threaded View
Threaded View
DDT Evaluation
Chan - 15 Years Ago
     For 1 and 2, it sounds like you deleted a database in between the...
Dustin Taylor - 15 Years Ago
             Hi,

[quote][b]Dustin Taylor (02/16/2009)[/b][hr]For 1 and...
Chan - 15 Years Ago
                 Hi,
Accidently put my reply in quote, I worry SF Team missed out...
Chan - 15 Years Ago
     The is used DDT daily by us and many of our customers in exactly the...
Dustin Taylor - 15 Years Ago
             Hi,
I am not able to upgrade now as we are rushing for a project,...
Chan - 15 Years Ago
                 I have sent the attachment to Trent via PM.

Thank you
Chan - 15 Years Ago
                     Hi,
I have download the latest beta build, and try the following...
Chan - 15 Years Ago
                     Hi,
Just would like to inform that, my personal account "Chan"...
ChanKK - 15 Years Ago
     Hi,
I have gone thru DatabaseMigrator source code, found that the...
ChanKK - 15 Years Ago
     The priority is required, but it should not be deployed with a null...
Dustin Taylor - 15 Years Ago
             [quote][b]Dustin Taylor (02/19/2009)[/b][hr]The priority is required,...
ChanKK - 15 Years Ago

Similar Topics

Post Quoted Reply
Reading This Topic

Powered by InstantForum 2017-1 Final © 2024
Execution: 0.000. 3 queries. Compression Enabled.

Login

Explore
Messages
Mentions
Search