StrataFrame Forum

XML generation problem (All languages)

http://forum.strataframe.net/Topic13723.aspx

By Ertan Deniz - 1/24/2008

In my Project There are English and Turkish languages. When I ‘ve pressed  “All languages” button I’ve got the error message below. But There is no problem in English option.

SqlException
  Invalid object name 'messageitems'.

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.GetDataTable(String SelectStatement)
   at SFMessaging.MessageItemsBO.GetAllCodePages(Int32 MessageProjectPK)
   at SFMessaging.MessageEditorBasics.GenerateXMLDocuments(Int32 ProjectPK, String CurrentLanguageText, Int32 CurrentCodePage, Boolean Silent)
   at SFMessaging.MessageEditorDialog.cmdPackage_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)
By Ivan George Borges - 1/25/2008

Hey Ertan.

You haven't accidentaly changed the StrataFrame Database Connection, have you? You can find it under the StrataFrame menu on Visual Studio, the Connection is called "StrataFrame Data Store". If that is so, you should be pointing it to the StrataFrame database on your SQL Server.

By Ertan Deniz - 1/25/2008

 When I've got the error. My Connection name was different. But I ve changed it to the back as StrataFrame Data Store.

I ve tested it but it has failed as my first attempt.

By Ivan George Borges - 1/25/2008

Please, Ertan... click Edit on your StrataFrame Data Store and confirm that it is pointing to the StrataFrame Database.
By Trent L. Taylor - 1/27/2008

I think that Ivan is going down the right road here.  Many times it is easy to look to the languages (as this has been the difference in errors before in the past on certain items).  However, this time I think that it may be more simple.  The only time I have ever seen this error is when it cannot find the database.  If you look at the call stack, it is when it is trying to connection to the database through the SqlConnection object.  So it hasn't even got to the point of creating the XML files yet.  When you go into the connection, go ahead and click edit, make sure it is correct, then click the StrataFrame Data Store and Select to close the dialog to make sure that it is selected.
By Ertan Deniz - 1/27/2008

All languages option does not work. But English (United States) option is running.

For the second option The connection is used, isn't it ? If so, Why all languages does not work ?

By Trent L. Taylor - 1/28/2008

Ertan,

As I mentioned in my previous post, I do not think that this is language related.  If you create a new message project, add English and Turkish, and then add a single message to each language.  Do you still get the same error?  I think that the issue here is not the languages but rather something related to the connection.  Try this and see if you have the same results.