Localization’s Tables update


Author
Message
Ertan Deniz
Ertan Deniz
StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)
Group: Forum Members
Posts: 163, Visits: 493

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.


Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K

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

Ertan Deniz
Ertan Deniz
StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)
Group: Forum Members
Posts: 163, Visits: 493
That option fails as you see in my message.
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
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.

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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.

Ertan Deniz
Ertan Deniz
StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)
Group: Forum Members
Posts: 163, Visits: 493
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.

Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi Ertan.

Regarding this:

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.)

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

Ertan Deniz
Ertan Deniz
StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)
Group: Forum Members
Posts: 163, Visits: 493
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


Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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.

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