StrataFrame Forum

Error when select language

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

By Chan - 4/7/2007

Hi,

I hit error while I select language from langauge form. I checked my table and I can see field lng_EventID. Also, I can run RetrieveTextValue() sucessfully. Any ideas?

Thank you

ArgumentException
 lng_eventid is neither a DataColumn nor a DataRelation for table .
Source     : System.Data
Stack Trace:
   at System.Data.DataRowView.get_Item(String property)
   at MicroFour.StrataFrame.UI.Localization.SetActiveLanguageButtonText(Int32 LocaleID)
   at MicroFour.StrataFrame.UI.Localization.SetActiveLanguage(String ApplicationKey, Int32 LocaleID, String UserName)
   at MicroFour.StrataFrame.UI.LanguageSelectionDialog.cmdSelect_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)
By Trent L. Taylor - 4/7/2007

hmm...could you post the Languages and Message items files so I could take a look at this?  I am not sure without looking at the data what to tell you.
By Chan - 4/7/2007

I use SQL Server database as data storage. Here it is.

Thank you

By Chan - 4/9/2007

Hi,

Any news?

Thank you

By StrataFrame Team - 4/10/2007

It seems as through the SQL Tables are missing some data... there are only a few columns in the report data that you sent.  Is the structure of the tables a match to the structure of the tables within the StrataFrame database?
By Chan - 4/10/2007

Hi,

I use management studio to create "create script" and run against my database.

By StrataFrame Team - 4/12/2007

Well, all of the columns should be there, then.  Does your StrataFrame database contain the field lng_EventID in the MessageLanguages table?  I believe that the field has been included in the database for quite some time, but it could be that your database does not include it...
By Chan - 4/13/2007

Hi,

I checked, and the field exist as shown in attached file.

By StrataFrame Team - 4/16/2007

Thanks, Chan, give me a bit to see if I can reproduce it on this end.
By Chan - 4/18/2007

Hi,

Any update?

Thank you

By Peter Denton - 5/13/2007

G'day

I'm also trying storing the localisation messages in my Application's SQL server database. I copied the MessageLanguages and MessageItems from the StrataFrame database into my database (I think using SQL Server to generate a create script on each table in the StrataFrame database, running the scripts against my database and then creating my own rows appropriate to my application).

I'm having the same problem with ShowAvailableLanguages casuing the following exception:

Exception Source:      System.Data
Exception Type:        System.ArgumentException
Exception Message:     lng_eventid is neither a DataColumn nor a DataRelation for table .
Exception Target Site: get_Item

---- Stack Trace ----
   System.Data.DataRowView.get_Item(property As String)
       NewRecipeMaint.EXE: N 00428
...

I have checked and lng_eventid is definitely in the MessageLanguages table where it's meant to be. I've checked to ensure that I'm accessing the database for localisation that I thought I was (by changing a value and seeing that new value reflected in my program).

Are there any further thoughts on the problem?

Peter

By StrataFrame Team - 5/14/2007

Ah, yes, I was able to reproduce this and fix it.  Here are the newest DLLs containing the fix.  I've included all 7 because there are probably a few other minor changes that might have changed a method signature, and you don't want to get a MissingMethodException...
By Peter Denton - 5/15/2007

Ben,

I copied the dll's into both "C:\ProgramFiles\MicroFour\StrataFrame\Assemblies" and "C:\Windows\assembly" (aka the GAC) and it fixes the problem of an exception being caused whenever ShowAvailableLanguages() is called.

Unfortunately, there is now a different problem. I have just started a new application, and had just created a few new BOs and went to the Business Object Mapper, confugured the project and the business objects, and then went to "Build All Partials" and I get the following exception:

FileNotFoundException
 Could not load file or assembly 'IBM.Data.DB2, Version=9.0.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208' or one of its dependencies. The system cannot find the file specified.

Source     : MicroFour StrataFrame AddIns

Stack Trace:
   at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.BuildPartialClass(String ClassName, Int32 ProjectItemPK, Project ParentProject)
   at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.BuildPartialClassesForProjectThread(Object ProjectNode)

At this point the Buisness Object Mapper is frozen, the only way out is to use the the task manager to end the task, which also exits visual studio. I'm not using DB2, and the only recent change was the dll's so I copied the old ones back and tried again and I could build the partials fine. New ones in again and the exception came back.

I can work with the ShowAvailableLanguages() causing an exception, and at least I now know that it wasn't me doing something stupid, so I'll revert to the old dll's. I hope that, in the fullness of time, there will be a fix that allows both ShowAvailableLanguages() and the business object mapper to work.

Peter

By Trent L. Taylor - 5/16/2007

Peter,

Drag the attached file into your GAC.  This will resolve the DB2 provider error.  The files that were posted the other day had a reference to this assembly but won't when we actually release 1.6.1. 

Extract the ZIP file and drag the DLL file into the c:\windows\assembly folder and see if the problem persists.

By Peter Denton - 5/16/2007

Trent,

Thanks for that, worked perfectly. I'm very impressed with timeliness and quality of the support for StrataFrame.

When is 1.6.1 due, is it weeks or months?

Thanks, Peter

By Trent L. Taylor - 5/17/2007

Thanks for that, worked perfectly. I'm very impressed with timeliness and quality of the support for StrataFrame.

I am glad it got you going!  Thanks for your nice comments! Smile

When is 1.6.1 due, is it weeks or months?

We are still 3-4 weeks out from releasing it.  We have made quite a few changes and even added a some new controls.  Additionally we have made some changes that we just want to really test thorougly through unit testing and real-world environments before making it available.  So it will be mid-June before we post it.  Even though the release will be 1.6.1, it will have a lot of new features.