StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Localization’s Tables update

Localization’s Tables update

Ertan Deniz — Mon, 28 Jan 2008 09:34:18 GMT

I’m trying to update source localization information to destination.
Steps I’ve followed inside the DDT ;
1. New Profile (LocalizationUpdate) with the option “Always Package”
2. Add New Database (StrataFrameSample)
3. Add Messaging And Localization Tables
4. Focus Deployment Data and Start Data Deployment Package Wizard
a. Select Deployment Data Type
b. Source and Destination
c. Include Localization Project
5. Now, I have Two packages (Localization(Messages) and Localization(Languages)
6. Run the package (with SampleInstaller executable in Vb.NET samples)
The package is now ready to be deployed. Review the deployment options below before continuing. If you would like to make changes, click the '< Back' button.

Package: LocalizationUpdate.pkg
SQL Server:
SQL Authentication: SQL Server Security
SQL Username: sa
Deployment Data Includes: None

Note: Password information omitted intentionally.

Questions

1. What is missing with the process ?
2. Why Deployment Data Includes property (see above) is set to none ? When I ‘ve controlled package file no bin files in it.? How Data packages can be included in the package file ?
3. “Create package for install” menu doesn’t work at any time. Event Id = 1026. No Error Message detail. (Error Message : An Error occured while attemting )
4. Deploy To Server – I Yes buton is selected. I’ve got the error message below ;

NullReferenceException
Object reference not set to an instance of an object.

Source : DatabaseDTK

Stack Trace:
   at MicroFour.StrataFrame.Data.ProfileEditorDialog.PackageProfileForInstall()
   at MicroFour.StrataFrame.Data.ProfileEditorDialog.cmdDeployToServer_Click(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.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)

if No button is selected then got the same error message with sample installer.

RE: Localization’s Tables update

Trent L. Taylor — Mon, 28 Jan 2008 09:34:18 GMT

Ertan,

I cannot see the error. Open the Log fiel and either attach the log file as an attachment here or you might be able to determine what went wrong. The log file will be in teh same location as the PKG file and have a name like PackageFilename_Results.log.

RE: Localization’s Tables update

Ertan Deniz — Mon, 28 Jan 2008 09:18:35 GMT

It is not SQLexpress. In other windows of strataframe for db connection, SQL Servers are listed.

Sample installer application starts Deployment Package prebuilt dialogs. I couldn't select SQL Server. (But source and destination connections exist in the package. I think, It may not be necessart to select). At Next page, SQL Server validation have been done and I have seen Database name on the server (Strataframesample) with databasename in the profile (StrataFrameSample).

I've got the error

RE: Localization’s Tables update

Ivan George Borges — Mon, 28 Jan 2008 04:57:11 GMT

Hi Ertan.

Regarding this:

[quote]It is interesting, I've selected the package but Database Deployment Wizard's "select sql server combo" does not work. (SQL server instances were not listed.)[/quote]

Is it the SQLServer Expresses edition? If so, try typing your SQLServer on the box, like "localhost\sqlexpress" or "YourMachineName\sqlexpress"

RE: Localization’s Tables update

Ertan Deniz — Mon, 28 Jan 2008 01:55:51 GMT

Let me repeat the steps ;

Connection (StrataFrame Data Store points Strataframe database in my local machine.)

The new profile (TestLocalizationUpdate),

Import Database (StrataFrame Sample),

Deployment Package wizard (Source : StrataFrame, Destination : StrataFrameSample)

Deployment Items added into the list. Check source and destination settings. Everything seems okey.

"Create package for install" button does not work. (See my first message)

So I will work with sample installer.

It is interesting, I've selected the package but Database Deployment Wizard's "select sql server combo" does not work. (SQL server instances were not listed.)

(Another question may be asked ? Why this sample asks for the connection ? Source and Destination connections are in the package ?)

I've seen bin files included in my package. (So connection is valid and this part of work is running)

I want to verify my information ; DDT requires Destination Database (with the same name as destination) and all or part of items to compare with the destination database for upgrading. Is it true ?

In my case, I have imported all Strataframesample database items but my need is only messaging tables. The process has failed with CustomerCreditCards Table.

RE: Localization’s Tables update

Trent L. Taylor — Sun, 27 Jan 2008 10:23:08 GMT

Ertan,

It would appear to me that in this case you have a Data Deployment package that cannot authenticate the server from which the records are to be pulled. Since you indicated that the Package File was created but did not have any .bin files, this would lead me to believe that the server or query information provided in the Data Deployment item is either incorrect or the server specified cannot be contacted. Double-check the data deployment item settings to ensure that the server, database, and WHERE statement are all valid. You may want to bring up a copy of SQL Server Management Studio to ensure that all is correct when testing this.

RE: Localization’s Tables update

Ivan George Borges — Fri, 25 Jan 2008 11:33:34 GMT

As we've talked about your StrataFrame Data Store having been changed, would you like to check this first and make sure it is pointing to the correct place?

Still on the DDT, you can go to File menu, and then Database Connection. You should have StrataFrame Data Store selected, and in it you should be pointing correctly to the StrataFrame Database. Please, also check that your Login Information is correct.

RE: Localization’s Tables update

Ertan Deniz — Fri, 25 Jan 2008 09:15:36 GMT

That option fails as you see in my message.

RE: Localization’s Tables update

Ivan George Borges — Fri, 25 Jan 2008 08:26:43 GMT

Hi Ertan.

Before you run the Database Installer Sample, did you click the "Create Package for Install" on the Database Deployment Toolkit? Maybe you are trying to install an older version of your .pkg