StrataFrame Forum / StrataFrame Database Deployment Toolkit / Issues

DDT error when trying to edit a stored proc.

Keith Gordijn — Fri, 05 Mar 2010 20:46:43 GMT

I have just gone into the DDT to edit a stored procedure. When clicking the 'Stored Procedures' treeview node I get this messagebox:

[codesnippet]ClrAssemblyEnumerator has stopped working[/codesnippet]

options are debug and close program. Selecting close program gives:

[codesnippet]UIException
Dynamically populating the ListView failed. Could not create and fill the business object of type 'MicroFour.StrataFrame.Business.DBEProceduresBO'
TargetInvocationException
Exception has been thrown by the target of an invocation.
BusinessLayerException
The CurrentRow for table '[dbo].[DBEAssemblies]' could not be evaluated because the CurrentRowIndex is out of range. Business object record count: 0. CurrentRowIndex: -1.

Source : MicroFour StrataFrame UI

Stack Trace:
at MicroFour.StrataFrame.Business.BusinessLayer.get_CurrentRow()
at MicroFour.StrataFrame.Business.DBEAssembliesBO.get_as_assemblypath()
at MicroFour.StrataFrame.Business.DBEProceduresBO.GetAll(Int32 DatabasePK, Boolean IncludeTableInsertAndUpdateProcedures, Boolean byCategory, String categoryName)
at MicroFour.StrataFrame.Business.DBEProceduresBO.GetAll(Int32 DatabasePK, Boolean IncludeTableInsertAndUpdateProcedures)
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at MicroFour.StrataFrame.UI.Windows.Forms.ListView.GetFilledBusinessObject(Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.ListView.PopulateListView(Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.ListView.Requery()
at MicroFour.StrataFrame.Data.ProfileEditorDialog.Load_StoredProceduresDetails()
at MicroFour.StrataFrame.Data.ProfileEditorDialog.PopulateDetailList(DBEObjectType tvitem)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.ProcessTreeviewSelection(DBETVItem tvItem)[/codesnippet]

I also get the same problem with StrataFlix sample.

Has anyone come across this before or maybe a pointer as to whats going on?

Regards,
Keith

Error on index creation if column number > 16

Michel Levy — Fri, 12 Feb 2010 10:16:03 GMT

Hi,

All is OK when I create an index within SSMS with this script

[codesnippet]

CREATE NONCLUSTERED INDEX [IX_ligne_1_rpt_et_dev1] ON [dbo].[ligne_1]
(
[cde_cmd] ASC,
[no_ligne_1] ASC,
[cde_mat] ASC
)
INCLUDE ( [epaisseur],
[cal_surf],
[surf_lq],
[lq_m2],
[px2_m2],
[laq_l1],
[laq_l2],
[laq_f2],
[modew],
[mat_four],
[libelle3],
[longueur],
[largeur],
[raly],
[com_lg1],
[typ_laq],
[fl_bcl]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

[/codesnippet]

but the same description in DDT raises an error when deployment

(in log file:)
[quote]X 12/02/2010 16:19:50 -> Le index 'IX_ligne_1_rpt_et_dev1' sur la table 'dbo.ligne_1' a 20 noms de colonnes dans la liste de clés index. La limite maximale pour la liste des colonnes de clés d'index ou de statistiques est 16. [/quote]

Is that limit of 16 column names in an index definition a SF DDT limit, or a Microsoft SMO limit?

We really need many indexes like this (with sometimes more than 40 columns as INCLUDE), and hoped that DDT could manage it.

Thanks in advance

Error while attempting to create package (event ID #1026)

Michel Levy — Fri, 12 Feb 2010 09:31:05 GMT

Hi,

I've got an error IndexOutOfRange during during the creation of a package.

what does it mean? what should I do?

Deployment App Could not load correct Microsoft.SQLServer.ConnectionInfo Assembly

Marcel Heitlager — Thu, 03 Dec 2009 01:51:24 GMT

Hi guys,

I'm no doubt doing something retarded. But when I use the MicroFour.StrataFrame.DBEngine.Deployment.MDDeployMain in my app. to deploy my data on my XP development machine, I have no problems. Installing it on Windows Server 2003 with InstallAware, and running the application after that gets me the error below.
The error pops up after I click the final next button in the Deployment app.

I have Microsoft.SqlServer.ConnectionInfo version 9.0.242.0 installed on both machines, with SQl Server Express 2005. But for some reason it is looking for version 10 on the server.

Any thoughts as to why?

Thanks,

Marcel

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IO.FileLoadException: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
File name: 'Microsoft.SqlServer.ConnectionInfo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator..ctor(String ServerAndInstanceName, Boolean UseWindowsAuth, ISynchronizeInvoke SyncObj, String Username, String Password)
at MicroFour.StrataFrame.DBEngine.Deployment.MDDeployMain.StartMetaDataBuild()
at MicroFour.StrataFrame.DBEngine.Deployment.MDDeployMain.ManageNextAndBack(Boolean MoveNext)
at MicroFour.StrataFrame.DBEngine.Deployment.MDDeployMain.cmdNext_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3603 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
AESPPMDataInstaller
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/AWA%20Data%20Installer/AESPPMDataInstaller.exe
----------------------------------------
MicroFour StrataFrame UI
Assembly Version: 1.7.0.0
Win32 Version: 1.7.0.2
CodeBase: file:///C:/Program%20Files/AWA%20Data%20Installer/MicroFour%20StrataFrame%20UI.DLL
----------------------------------------
MicroFour StrataFrame Business
Assembly Version: 1.7.0.0
Win32 Version: 1.7.0.2
CodeBase: file:///C:/Program%20Files/AWA%20Data%20Installer/MicroFour%20StrataFrame%20Business.DLL
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
MicroFour StrataFrame Base
Assembly Version: 1.7.0.0
Win32 Version: 1.7.0.2
CodeBase: file:///C:/Program%20Files/AWA%20Data%20Installer/MicroFour%20StrataFrame%20Base.DLL
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
MicroFour StrataFrame DBEngine
Assembly Version: 1.7.0.0
Win32 Version: 1.7.0.2
CodeBase: file:///C:/Program%20Files/AWA%20Data%20Installer/MicroFour%20StrataFrame%20DBEngine.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

Issue with package encryption/compression

Alan Jones — Wed, 28 Oct 2009 10:22:37 GMT

Guys,
In our installation we've run into an issue on deploying data to machines with a specific local security policy.

The policy:
System cryptography: Use FIPS compliant algorithms for encryption, hashing and signing

When I enable this policy on my machine, I am unable to open any of our package files (no encryption) because of the compression being used.
Get the generic message:
PackageIt has encountered a problem and needs to close. We are sorry for the inconvenience.

Our installation will be for government machines, many of which will likely have this option set. Programmatically we can turn off this setting IF local policy allows it, but there is a very real chance this won't be the case.

Are there any settings you have within the DDT or PackageIt! that you can change to make the data packages FIPS compliant?

I've attached an overview of the policy if it helps.

Problem after upgrade to version 1.7.0

Jiri Brazda — Mon, 03 Aug 2009 14:24:59 GMT

When clicking Stored procedures in DDT i receive the following error:

UIException
Dynamically populating the ListView failed. Could not create and fill the business object of type 'MicroFour.StrataFrame.Business.DBEProceduresBO'
TargetInvocationException
Exception has been thrown by the target of an invocation.
SqlException
Invalid column name 'as_Rank'.

Source : MicroFour StrataFrame UI

Stack Trace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(QueryInformation QueryInfo, OnChangeEventHandler CallBack)
at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(QueryInformation QueryInfo, Boolean RegisterNotification)
at MicroFour.StrataFrame.Business.BusinessLayer.FillOrGetByParentPrimaryKey(Object[] ParentPrimaryKeys, Boolean ReplaceCurrentDataTable)
at MicroFour.StrataFrame.Business.BusinessLayer.FillByParentPrimaryKey(Int32 ParentPrimaryKey)
at MicroFour.StrataFrame.Business.DBEProceduresBO.GetAll(Int32 DatabasePK, Boolean IncludeTableInsertAndUpdateProcedures, Boolean byCategory, String categoryName)
at MicroFour.StrataFrame.Business.DBEProceduresBO.GetAll(Int32 DatabasePK, Boolean IncludeTableInsertAndUpdateProcedures)
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at MicroFour.StrataFrame.UI.Windows.Forms.ListView.GetFilledBusinessObject(Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.ListView.PopulateListView(Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.ListView.Requery()
at MicroFour.StrataFrame.Data.ProfileEditorDialog.Load_StoredProceduresDetails()
at MicroFour.StrataFrame.Data.ProfileEditorDialog.PopulateDetailList(DBEObjectType tvitem)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.ProcessTreeviewSelection(DBETVItem tvItem)

Column tr_Schema does not belong to table DBETriggers

Keith Chisarik — Tue, 02 Jun 2009 09:36:24 GMT

I have reinstalled 1.6.7 beta three times now and this field is not created in my database. Please help.

If there is a no immediate package available to fix this, can you tell me how to manually create this field if you think that will allow me to deploy my triggers?

Vista DPE issue when importing VFP database

Michel Levy — Mon, 04 May 2009 03:39:27 GMT

Hi,

Vista raises "Data Execution Prevention" (DPE) during importation from VFP database.

Import process start, then seems frozen, and finally DPE close process. Database is created, but no tables, views, SP...
No problem when importing SQL databases, only with VFP

(Vista pro UAC disabled, Visual Studio 2008, SQL Server 2008, VFP9 SP2)

DDT Erasing Existing Database's Trigger

Jim Keansuai — Tue, 28 Apr 2009 05:23:54 GMT

Hi all, Jim here.

Currently i having an issue while upgrading the existing database by DDT. Existing database containing trigger that not created by DDT. Now after i install DDT supposed to only modify the structure of database by without removing the existing trigger.
I had checked the DDT, inside do not contains any new trigger/ any history on deleting the trigger. Do i have miss out any setting i can do?

Does anyone can provide some guideline on the this issue?

Thanks a lot.

Object name history Modified field null

Sierra Fourwinds — Thu, 23 Apr 2009 20:25:22 GMT

I have a very simple question. As a new user to the DDT application, I have made several changes to tables now and have lots of rows in the Object name history table. When I review this activity, all the dates in the Modified column are 1/1/1800 12:00:00 AM. Is there a setup step that I have not done that is causing this field to be full of null values??

Thanks

TableName property not being updated properly

Edhy Rijo — Sun, 05 Apr 2009 13:35:27 GMT

I have a table named [b]"CardImages"[/b], the BO was created using the name "bizCardImages", later on I renamed the table name to [b]"CardImage"[/b] and the BO to "bizCardImage", everything was working fine until I tried to Insert a record, I got an error saying that the SP CardImages_Insert does not exist, so I went to the bizCardImage.Designer.vb and found out that the property TableName() was not updated with the new name of the table.

I had to manually fix the TableName() property to return the table new name and that fix the problem. Shouldn't the BOM take care of this property everytime a build partial is regenerated?

Drop failed for DefaultConstraint

ChanKK — Wed, 04 Mar 2009 07:16:48 GMT

Hi,

I have a scenario whereby there is a column slip with data type image which allows null and no default value is set since it allows null.

I deleted the slip column in the ddt and save. Then I create the column slip again with data type nvarchar(256) which does not allow null with default value (‘’) and save.

Then I generate the package and run the package. It tries to drop the column but failed. The reason behind it due to it tries to drop the default constraint for the slip column which does not exist in the first place since it allows null.

I’m attaching the log file as a reference for the given problem.

[quote]• 04/03/2009 7:43:12 PM -> Deploying meta-data for database 'VfsDocumentHope'
• 04/03/2009 7:43:12 PM -> Ensuring Filegroups exist on database 'VfsDocumentHope'
• 04/03/2009 7:43:12 PM -> Filegroup verification complete.
• 04/03/2009 7:43:12 PM -> Ensuring Tables exist on database 'VfsDocumentHope'
• 04/03/2009 7:43:14 PM -> The table 'LVELeaves' is being prepared to be modified.
X 04/03/2009 7:43:15 PM -> An error occurred while deploying the meta-data to the server.
X 04/03/2009 7:43:15 PM -> FailedOperationException
X 04/03/2009 7:43:15 PM -> Drop failed for DefaultConstraint 'DF_LVELeaves_Slip'.
X 04/03/2009 7:43:15 PM -> InvalidSmoOperationException
X 04/03/2009 7:43:15 PM -> You cannot execute this operation since the object has not been created.
X 04/03/2009 7:43:15 PM ->
X 04/03/2009 7:43:15 PM -> Source : Microsoft.SqlServer.Smo
X 04/03/2009 7:43:15 PM ->
X 04/03/2009 7:43:15 PM -> Stack Trace:
X 04/03/2009 7:43:15 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CheckObjectStateImpl(Boolean throwIfNotCreated)
X 04/03/2009 7:43:15 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CheckObjectState(Boolean throwIfNotCreated)
X 04/03/2009 7:43:15 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImplWorker(Urn& urn)
X 04/03/2009 7:43:15 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImpl()
X 04/03/2009 7:43:15 PM -> at Microsoft.SqlServer.Management.Smo.DefaultConstraint.Drop()
X 04/03/2009 7:43:15 PM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.PrepareColumnForAlter(Column Col, Boolean DropAllDependencies)
X 04/03/2009 7:43:15 PM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.VerifyColumns(Table Tbl, TableInfo TblInfo)
X 04/03/2009 7:43:15 PM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.VerifyTable(Table Tbl, TableInfo TblInfo)
X 04/03/2009 7:43:15 PM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureTables(Database TblParent, DatabaseInfo DbInfo)
X 04/03/2009 7:43:15 PM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureDatabases()
X 04/03/2009 7:43:15 PM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployMetaDataThread()
X 04/03/2009 7:43:15 PM ->
[/quote]

Thanks.

Deploy with DatabaseMigrator class using Connection String

Derek Price — Wed, 04 Mar 2009 13:19:13 GMT

I created a console application to deploy our package to have it be automated. It's based on your Database Installer Sample. Most of the code is reading in the command line arguments, but this is where I decide to run either by a connection string or explicit settings:

[codesnippet]_databaseMigrator = ConnectionString.Length > 0 ?
new DatabaseMigrator(connectionString, this) :
new DatabaseMigrator(SQLServer, winAuth, this, SQLUserName, SQLPassword);

_databaseMigrator.DeployMetaData(PackagePath, FrameworkPassword);[/codesnippet]

When I run the app with these settings, it works flawlessly:

[codesnippet]// This works:
SQLServer = "MyServer";
winAuth = true;
SQLUserName = "";
SQLPassword = "";[/codesnippet]

When I run it with a connection string (that we use on our main application using StrataFrame), it does not work and fails on dropping the exisiting database. We drop the database in the Pre-Deploy Script.

[codesnippet]// This does not work:
connectionString = "Data Source=MyServer;Initial Catalog=MyDatabase;Integrated Security=True";[/codesnippet]

The error I get back is this:

[codesnippet]*** Starting Deployment...
Package Path = P:\PathToPackage\DDT_Packages\MyPackage.pkg
Connection String = Data Source=MyDataSource;Initial Catalog=MyDatabase;Integrated Security=True
Windows Authen. = True
Checking SQL Connection...
SQL Connection is valid
Executing Pre-Deployment Scripts, Executing Pre-Deployment Scripts

*** Error Executing Script, SqlException
Cannot drop database "MyDatabase" because it is currently in use.

Source : .Net SqlClient Data Provider

Stack Trace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName,Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.ExecuteProfileScripts(DataView scriptsToExecute)
***

*** Error Deploying Meta-Data, ThreadAbortException
Thread was being aborted.

Source : MicroFour StrataFrame DBEngine

Stack Trace:
at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.ExecuteProfileScripts(DataView scriptsToExecute)
at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.ExecutePreProfileScripts()
at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureDatabases()
at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployMetaDataThread()

***[/codesnippet]

It almost seems like the DatabaseMigrator instance is grabbing hold of the database preventing it from being dropped, but [b]only[/b] when used with a connection string. What am I missing here? I can zip up the project and send it to you directly if you need the code.

Thanks,
Derek

DDT Evaluation

Chan — Fri, 13 Feb 2009 00:06:08 GMT

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

Database Physical File Location

Tim Dol — Wed, 28 Feb 2007 10:02:29 GMT

I am using a separate database for the role based security files and when I deploy for the first time it automatically creates the physical database files in a default folder. We have customers that implement policies for the physical location of database files. Is there any way to specify the folder location if the database does not exist? I basically use your standard deployment routines, which I have wrapped for customer use, so does your standard deployment routine currently support this?.

Tim

Data Deploy Fails on XML Fields

Derek Price — Tue, 10 Feb 2009 09:32:02 GMT

We have a simple table with no relationships that is not deploying data due to an XML Field. The DDT error is shown in the attached file "DDT_Data_Deploy_Error.png" and the actual table properties are in the file "Settings_Table_XML.png." Here's a snippet from the text log file:

[codesnippet]2/10/2009 8:57:49 AM-> Deploying data from OHRSettings...
2/10/2009 8:57:49 AM-> An error occurred while deploying the data to the server.
2/10/2009 8:57:49 AM-> SqlException
2/10/2009 8:57:49 AM-> Procedure or function 'OHRSettingsInsertOverwrite' expects parameter '@SettingsXML', which was not supplied.[/codesnippet]

We have a Data Deployment package that will copy data if the User_fk = -1. If there's any data that matches this, the deploy fails with the above message. I checked that the OHRSettingsInsertOverwrite SP is on the db and it is:

[codesnippet]USE [SYSTOC800]
GO
/****** Object: StoredProcedure [dbo].[OHRSettingsInsertOverwrite] Script Date: 02/10/2009 10:26:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[OHRSettingsInsertOverwrite] @OHRSettings_pk as Int, @User_fk as Int, @RetrievalKey as VarChar(255), @GroupKey as VarChar(255), @SettingsXML as Xml, @RowVersion as Int, @RowState as TinyInt AS BEGIN DELETE FROM OHRSettings WHERE OHRSettings_pk = @OHRSettings_pk SET IDENTITY_INSERT OHRSettings ON INSERT INTO OHRSettings (OHRSettings_pk, User_fk, RetrievalKey, GroupKey, SettingsXML, RowVersion, RowState) VALUES (@OHRSettings_pk, @User_fk, @RetrievalKey, @GroupKey, @SettingsXML, @RowVersion, @RowState) SET IDENTITY_INSERT OHRSettings OFF END[/codesnippet]

Have you run into any issues with XML fields? If so, do you have a workaround for this situation? I can provide more info if you need it.

Thanks,
Derek

Installation Error

Qwerty Reality — Sat, 31 Jan 2009 05:03:39 GMT

This is the error i get when installing the latest of the Strata Frame.

Incorrext syntax near 'sname'

Tim Dol — Wed, 28 Jan 2009 08:24:06 GMT

I have a package file that I have deployed on 5 or 6 different databases without any problems, however I have two database where the attached error occurs and I can't figure out what the problem is. Any earlier version of the package, a week ago, worked fine on these two databases and now the new one and the actual original pacakge that worked, has failed.

Any Ideas? Can you suggest how I can narrow down the problem?

Thanks,

Tim

Use $DbName$ in Deploy Scripts?

Derek Price — Thu, 22 Jan 2009 08:31:55 GMT

When running the DDT on our package everything works fine. If I change the name of the database in the last step of the deployment wizard, we get package errors. This is due to a pre-deploy script that drops the database if it exists (temporary step during development). However, the database name is hard coded in the script. Do the any of the scripts support using the [b]$DbName$[/b] variable? That would get us around the issue of manually deleting the db first. We're trying to automate the entire process.

Thanks,
Derek

Error after successful deployment

Randy Jean — Thu, 10 Jul 2008 13:31:39 GMT

This is from the end of the deployment log:

• 7/10/2008 2:00:39 PM -> Finished verifying databases on server.
• 7/10/2008 2:00:39 PM -> Executing Post-Deployment Scripts
• 7/10/2008 2:00:39 PM -> Executing Post-Deployment Scripts - Complete
• 7/10/2008 2:00:39 PM -> The meta data conversion to the SQL Server has been completed.
X 7/10/2008 2:00:39 PM -> An error occurred while deploying the data to the server.
X 7/10/2008 2:00:39 PM -> InvalidOperationException
X 7/10/2008 2:00:39 PM -> The connection was not closed. The connection's current state is open.
X 7/10/2008 2:00:39 PM ->
X 7/10/2008 2:00:39 PM -> Source : System.Data
X 7/10/2008 2:00:39 PM ->
X 7/10/2008 2:00:39 PM -> Stack Trace:
X 7/10/2008 2:00:39 PM -> at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
X 7/10/2008 2:00:39 PM -> at System.Data.SqlClient.SqlConnection.Open()
X 7/10/2008 2:00:39 PM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployDataThread()
X 7/10/2008 2:00:39 PM ->

Notice it was successful. I'm using the dataprogress.vb form class from the demo source for database installer sample. I'm guessing something is not getting cleaned up properly but I'm not sure what.

My code that calls the form is thus:

' Update database
Dim loData As New DataProgress()

''-- Show and install database changes
dr = loData.ShowDialog()
loData.Close()
loData.Dispose()

I added the code to close and dispose the progress form so that I could delete the package file. Unfortunately, I'm not sure if this is where the problem started...

Unable to import my database using the DDT

Adam Symonds — Wed, 19 Nov 2008 13:57:25 GMT

I am just trying out the new version (1.6.6) of the DDT and am unable to import my local database. I am using the Import wizard and It showes all of my tables as checked. However when I click Finish, I see a quick status bar (..Finalizing), the database is added to my profile, but there is no data (no Tables, Stored Procedures).

Now if I import the StrataFrame DB...No problem. I see the status bar importing all the tables, and all the data is there. What am I doing wrong? I don't have much experience with this product. Please help....

Null table in Autogenerated SP

Juan Carlos Pazos — Wed, 05 Nov 2008 16:24:48 GMT

I'm begin to use the DDT, almost all works fine, just an error that I don't know where it comes.

After create an deploy a packege, the log indicate two errors, both are that a SP has not column. I take a look to the Auto-generated SP and found two that has not table, I think that this are the errors.

Please take a look to the screenshots, if you can see it says Procedure name and the first two rows are only dbo. the others have the name of the SP.

The error I think is relative to the not existing names in the Auto-generated SP.

Hope you can help me with this.

Regards

Error when deploy localization tables

Chan — Mon, 03 Nov 2008 03:50:36 GMT

Hi,

I hit error as attached when I try to deploy localization tables and data to server.

Please advice Thank you

Modifying the User Table

Michael Reese — Mon, 03 Nov 2008 13:02:31 GMT

What is the recommendation for modifying the User table in my application? I need to track more information and is currently utilizing a separate table and then linking it to the user table.

DDT NameOnServer not working

Randy Jean — Fri, 10 Oct 2008 15:07:51 GMT

I'm so close to having my deployment issues resolved I can taste it, however,I have one nagging problem that I can't seem to figure out. I need to be able to maintain 2 separate SQLExpress local databases, test and live. I have separate locations set for the connection.dat files, etc. The only thing I can't seemt to get to work is creating a database with a different name than what is in my DDT profile. I step in and see that indeed NameOnServer property is getting set to "MyLocalDBTest" but it just keeps updating updating MyLocalDB and never creates the test database. Any ideas?

[codesnippet]

Dim _DatabaseSetup as New SQL.DatabaseMigrator

Dim loDatabase As New DatabaseTargetName("MyLocalDb")

loDatabase.NameOnServer = CStr(IIf(MyApp.AppMain._TestEnv, "MyLocalDbTest", "MyLocalDb"))

' using NT auth, no user/password
_DatabaseSetup = New DatabaseMigrator("MyServer", True, Me)

_DatabaseSetup.EnableLogging = True
_DatabaseSetup.DeployMetaData("MyLocalDBPackage.pkg", "", New DatabaseTargetName() {loDatabase})

[/codesnippet]

Error during sql data deployment - connection already open.

Alan Jones — Fri, 26 Sep 2008 17:06:27 GMT

While trying to deploy data, we are getting a successful meta-data deployment.
However, during the data deployment phase we are erroring with the generic sql connection is already open.

Within our code prior we are able to open and close the sql connection fine, but once it gets to the data deployment phase in the DBEngine it fails. We have a couple of machines this works fine on, but there are a couple that just won't work.

Any thoughts as to what might be causing this?

RegistryKey: Access denied under Vista

Ralph Rutschmann — Sat, 16 Aug 2008 02:42:32 GMT

Hi Trent,

I have got the same problem again as mentioned here: http://forum.strataframe.net/Topic18446-21-1.aspx but now with the Database Deployment Toolkit. The Registry-Key is the same: HKEY_LOCAL_MACHINE\Software\MicroFour\...

This Time an a different Machine with also a new and clean install of Vista Ultimate. I'm logged on as admin. No other programs as Vista Ultimate standard programs, VS 2008 SP1, and SQL Management Studio. And StrataFrame, of course. ;)

At the other thread (see above) you wrote: "This is actually an environment issue as this does actually work on Vista Ultimate..."

Unfortunately I must say, maybe it is an environment issue, but this does actually not working for me on Vista Ultimate.

It is my second install of Vista Ultimate on two different machines. Both seems to have the same problem. I can't believe that it is an environment issue, because it happened within a few days and on both machine at the first try from the beginning on. And both was my first install of Vista...

For me it looks like a generally Vista problem, because of two clean installs from scratch with no changes to the environment after install. Why is the key "HKEY_LOCAL_MACHINE\Software\MicroFour\..." read only? Is it a problem of "HKEY_LOCAL_MACHINE\Software\..." generally?

This thing is very annoying, because the DDT is not closing, I have to shoot them up any time thru the Task-Manager.

Any hint highly appreciated.

TIA, Ralph

VFP DBC imports but tables ignored

Charles R Hankey — Fri, 29 Aug 2008 10:28:52 GMT

Perhaps someone else can confirm :

Importing VFP DBC with very latest 1.66:

tables of selected DBC show in picklist. Whether selecting all or some, no tables are imported into DDT schema. Database created, but no tables.

TIA

:w00t:

How do you reset the database connection for Sample Console App

Mike Thomas — Fri, 22 Aug 2008 14:50:56 GMT

How do you reset the database connection for Sample Console App? I entered in the wrong database information.

DDT Exceptions when deploying package.

George Nentidis — Fri, 30 May 2008 04:53:15 GMT

Hi,

I have added a new Data Deployment package in my DDT project and I get a few exceptions:

1. When deploying a uniqueidentifier column that contains NULL values, I get an Invalid Cast exception. After filling up all values it works fine.

2. When deploying a nvarchar column that contains NULL values, I get an exception saying that it cannot convert DBNull to String. After filling the values here too, it works fine.

3. When deploying a timestamp column, I get an SQL exception saying that timestamp columns cannot be assigned. Which is true, since timestamps get values on their own.

I can provide you with the package if you think it could help more.

DDT, SProcs and Views . . . Oh, My!

Bill Cunnien — Mon, 18 Aug 2008 07:39:37 GMT

For a new project I imported 2 tables into the DDT. No stored procedures were imported. No views were imported.

I made sure that object name history was clear.

I edited these two tables. I also added two new tables to the DDT.

The object name history was looking good and ready for a deployment.

I deployed my changes to the database. At this point, I have four tables that should be showing up in the table list with my changes. They did!! Suh-weeet! This is great stuff...and so easy. :w00t:

Maybe too easy!?!

At the time I did not know it, but ALL stored procedures were dropped from the database. ALL views were dropped from the database. Only table schema should have been altered in the DB, right? Did I blow by some checkbox somewhere that says, "Drop all SPs/Views"? What configuration of the DDT would cause this behavior?

Please help me so that I am not dropping things every time I deploy changes to my database. :hehe:

Thanks,
Bill

Data File Name

Bill Cunnien — Thu, 14 Aug 2008 18:40:31 GMT

After importing the database schema, the internet explorer (default browser) opens and displays this message:

[quote]

Data File Name :

A data file with this name already exists in the profile.

[/quote]

This happened yesterday, too, when I imported. I tried it again tonight and got the same message. Not sure what I am doing differently than a few nights ago (no IE window then), but I am definitely doing something wrong. Can someone point me in the right direction?

Thanks!
Bill

Importing database in the DDT

Peter Havenaar — Thu, 07 Aug 2008 08:36:49 GMT

Hi,

I was just playing with the newest BETA from the framework (Build date 8-1-2008) and tried to import one of my existing databases. Although i selected to import the relations and indexes,they were NOT imported!! This is working in 1.6.5

Is this a known issue or do i do something wrong?

Hope to hear from you,

Regards

Peter

Trying to deploy Write UDF in DDT

Geoff Hirst — Mon, 11 Aug 2008 08:14:35 GMT

Guys,

A simple UDF, that I need to return a date based on some info in my DB, I wanted this as a UDF, which I have written and tested in SQL Server, works fine.

What I can't do is get the DDT to deploy it. I know my issue lies in the first 2-3 lines, but I really don't know what it might want.

Can anyone send me a translation of how it should be put into the DDT?

thanks in advance

UDF is as follows

[codesnippet]

CREATE FUNCTION [dbo].[FirstDayHolidayYear]()

RETURNS smalldatetime

BEGIN

-- Declare the return variable here

DECLARE @Year CHAR(4)

DECLARE @Month VARCHAR(2)

DECLARE @Day VARCHAR(2)

SELECT @year = YEAR(GETDATE())

SELECT @day = '01'

IF (SELECT annualleaveyearstart FROM dbo.ApplicationSettings)<10

SELECT @Month = '0'+CAST(annualleaveyearstart AS CHAR(1)) FROM dbo.ApplicationSettings

ELSE

SELECT @month = CAST(annualleaveyearstart AS CHAR(2)) FROM dbo.ApplicationSettings

BEGIN

-- Insert statements for procedure here

return (CAST(@year+'-'+@month+'-'+@day AS SMALLDATETIME))

END

[/codesnippet]

Evaluating DDT - error when opening

Johnny R Smith — Sat, 26 Jul 2008 17:40:38 GMT

I recently downloaded the trial version in order to test the Database Deployment Toolkit. I activated the DDT license only and attempted to run the DDT. When the DDT dialog opens, I received the error message below. What should I do?

SqlException
Invalid object name 'dbo.DBEProfile'.

Source : .Net SqlClient Data Provider

Stack Trace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(String Statement, OnChangeEventHandler CallBack)
at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(String Statement, Boolean RegisterNotification)
at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(String SelectStatement)
at MicroFour.StrataFrame.Business.DBEProfileBO.FillAllByCategory()
at MicroFour.StrataFrame.Data.ProfileOpen..ctor()
at MicroFour.StrataFrame.Data.DatabaseMain.ShowProfileOpenDialog()
at MicroFour.StrataFrame.Data.DatabaseMain.tmShowOpenDialog_Tick(Object sender, EventArgs e)
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Category List - Stored Procedures

Geoff Hirst — Mon, 21 Jul 2008 08:50:01 GMT

Chaps,

The category list that you recently added seems to hold the details of all categories created across all database projects? Is this by design?

If it is, fine. I just created a new project and found all my categories for other projects there and didn't expect to.

thanks

Geoff Hirst

Error creating DD package

Michael Reese — Mon, 07 Jul 2008 10:51:25 GMT

I have been getting the following error when creating my DDT. It has not prevented me from completing my work but I would like to know what is happening? I am getting an IndexOutofRangeException Message stating that "There is no Row a Position 0.

How can I make it go away without blowing away my project work?

SQL Views and Indexes

Aaron Young — Tue, 08 Jul 2008 10:26:27 GMT

Hi,

I would like to add indexes to a couple of SQL Views in the DDT. However, when I edit the view in the DDT it doesn't detect all of the field names in the view. As a result, I can't add an index as it only allows an index to be added to a field that is detected in the view.

Is there a way around this?

Thanks,

Aaron

Replicated Database and Stored Procedures / Views

Aaron Young — Wed, 02 Jul 2008 17:33:47 GMT

Hi,

When upgrading a SQL Server 2005 database which has replicated stored procedures and views, the DDT throws errors messages. I don't know if you are dropping and recreating them but is it possible to alter them instead?

On a similar note, it would be useful if the DDT didn't drop the indexes added to the database by SQL Server for merge replication. These indexes would never be in the DDT model and are used only by replication. Replication will work without them but performance drops - we have a replicated system with around 800 databases and we can't afford the indexes to be dropped.

Thanks,

Aaron

Importing of DDT Package into DDT

Geoff Hirst — Sat, 28 Jun 2008 06:44:05 GMT

Hi Chaps,

I needed to work on a different machine and discovered that I could import a pkg file into the DDT and it created everything, with the exception of deployment data packages.

Is this by design? So, do I need to re-create them? Or should they have been deployed and their is an issue on my side somewhere?

thanks

Geoff