Pages: 1 2 [3] 4 5 6 7 8 9 10 11 12 13 .. 13 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
EVEHelpisSeriousBusiness
|
Posted - 2009.05.05 19:39:00 -
[61]
Originally by: Maestro Del'Tirith Edited by: Maestro Del''Tirith on 05/05/2009 17:29:24
Originally by: Mme Pinkerton
IMO it would be a very good idea to move this part of code from the database to LINQ, anyway. We have only one frontend/program accessing the database and the potentially increased performance from using stored procedures is not worth the vendor tie-in IMHO.
I'd say I disagree with LINQ, only because it is frankly far too new and I don't have the time to fuddle with the next latest thing MS has decided to push out the door. Give it a year or so and sure. As far as the stored procs, I'd agree that the time saved by them in this application is probably minimal, but also given the amount of work which has gone into building it in the current way leads me to prefer sticking to how it is for now. Perhaps with 2.0 we could consider some architectural changes, but the effort to pull all of those out and rewrite would be somewhat significant.
EDIT - and, lets be honest, this program is written in .Net. Vendor tie-in is a given. One could argue that the whole thing should have been written in Java to be portable, but it wasn't and I don't see it as a major issue at this point.
LINQ itself is pretty close to vendor tie-in right now.
Sure you can use arbitrary ODBC connections but you lose about half the features you'd get with LINQ+MS SQL Server (design time support, various query features aren't implemented for non MS-sql server linq , etc.) LINQ+SQLite is pretty nice, but it's slow.
|
Maestro Del'Tirith
Space Exploration
|
Posted - 2009.05.06 17:19:00 -
[62]
I have added information on an alternative means for connecting the EMMA database. -------------
Looking for a mature group to play with? Recruitment Thread |
Leyawiin
|
Posted - 2009.05.06 18:09:00 -
[63]
Edited by: Leyawiin on 06/05/2009 18:10:23 Edited by: Leyawiin on 06/05/2009 18:09:31
Originally by: Maestro Del'Tirith Edited by: Maestro Del''Tirith on 05/05/2009 17:29:24 Perhaps with 2.0 we could consider some architectural changes, but the effort to pull all of those out and rewrite would be somewhat significant.
I'd still consider getting rid of the stored procedures. Unless the number of roundtrips needed to perform some action on the database is significantly high, stored procedures are NEVER a good idea. I most likely wouldn't change the data model to use an ORM though. The current Table Module pattern is sufficient for these kind of data intensive applications.
I'd also clean up the project and the dependencies of classes. EMMA currently contains a lot of circular dependencies. One might consider the number of interfaces (interfaces + abstract classes) to be a sign of this tight coupling: there are only 6 of those defined upon 586 classes.
|
Maestro Del'Tirith
Space Exploration
|
Posted - 2009.05.06 21:03:00 -
[64]
Did I mention that I am still open to adding an additional developer to the team?
Anyone interested in contributing time to clean up, enhance stability, or otherwise contribute to the project may contact me via in game mail. Even at this pre-IPO stage isk incentives will be associated with development tasks. -------------
Looking for a mature group to play with? Recruitment Thread |
Magnet Trade
|
Posted - 2009.05.06 23:41:00 -
[65]
Very nice programe,
it say it cannot get market prices from .... and will etc, I am assuming I need the registration for this, so I sent the isk to the test corp as the programme says.
Hope to have the code by morning. ( uk tz here )
MT...
|
Mel Vin
Gallente 6thsense Corp Blue Sun Trust
|
Posted - 2009.05.07 07:14:00 -
[66]
EXCEPTION REPORT ===================================================================================== 5/7/2009 7:51:11 AM Error - EveMarketMonitorApp.Common.EMMAException - Failed to contact www.eve-prices.net Inner Exception: An exception occurred during a Ping request. Stack Trace: at System.Net.NetworkInformation.Ping.Send(String hostNameOrAddress, Int32 timeout, Byte[] buffer, PingOptions options) at System.Net.NetworkInformation.Ping.Send(String hostNameOrAddress, Int32 timeout) at EveMarketMonitorApp.GUIElements.Main.Ping(String url) Inner Exception: No such host is known Stack Trace: at System.Net.Dns.GetAddrInfo(String name) at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6) at System.Net.Dns.GetHostAddresses(String hostNameOrAddress) at System.Net.NetworkInformation.Ping.Send(String hostNameOrAddress, Int32 timeout, Byte[] buffer, PingOptions options)
Thanks for the key. Any idea about that?
MT...
|
Mel Vin
Gallente 6thsense Corp Blue Sun Trust
|
Posted - 2009.05.07 07:19:00 -
[67]
Edited by: Mel Vin on 07/05/2009 07:19:53 The eve prices service is down - in the next release it will be dropped. It should not impact your other operations.
What IS impacting you are other errors which are being received from the EVE API. The EVE API calls are failing with an error code of '0' (you can see this in your attached exception log). Are you sure that when you setup the user you used a Full license key, not just the limited one? (you have to click an extra button on the screen to get a full instead of a limited key from the eve api web page).
I would also give it a go again and see if it once again fails to contact the EVE api - but the errors being received are from the EVE api itself, not the application
End..
From the google search for other users a little more lazy than I :P
I am using the full api btw and have tried reloading EMMA
Magnets alt
|
Lost Hamster
Hamster Holding Corp
|
Posted - 2009.05.07 08:18:00 -
[68]
Regarding the API errors, I noticed that you get the error, when you try to get many information at once.
Suggested workaround: Put a 5 second delay between the queries, which goes to the API servers. It will take longer to fetch the data, but there will be less error occur.
|
Maestro Del'Tirith
Space Exploration
|
Posted - 2009.05.07 13:07:00 -
[69]
Unfortunately eve prices has disappeared from the map as far as we can tell. We can only assume that the person running it decided it wasn't really worth the hosting fees anymore. I have pulled it out of our current code build, so you shouldn't receive that error after the next posted update.
I agree on the multiple updates call comment, it seems to run into issues (which, frankly, it shouldn't - that API server should be serving a whole lot more requests than our little app can throw at it). One thing I have found is that if I uncheck all of the API update requests and just check one at a time it sometimes has some better success.
Tonight I'll be running through several install scenarios on a new laptop. I may be posting updates to expand the data in the exception log, remove eve prices, and a few other things sooner rather than later. -------------
Looking for a mature group to play with? Recruitment Thread |
Lost Hamster
Hamster Holding Corp
|
Posted - 2009.05.07 17:34:00 -
[70]
Originally by: Maestro Del'Tirith
One thing I have found is that if I uncheck all of the API update requests and just check one at a time it sometimes has some better success.
Yep, this is what I do as well. This way I rarely get API error. To narrow down the problem, you can initiate multiple API request, as long they don't use the same API key. So if you have 3 accounts, then you can do 3 separate query - each pointing one of your account.
|
|
Lost Hamster
Hamster Holding Corp
|
Posted - 2009.05.12 09:45:00 -
[71]
Can we get an ETA for the next minor patch? Will the new version published to the same eve file host? -http://dl.eve-files.com/media/corp/Ambo/ <--- I mean this.
|
Roger Kiyosaki
|
Posted - 2009.05.12 09:50:00 -
[72]
I recently made the switch from PC to Mac. Question: Is there any software like this that'll work on the mac? Or is it even on the radar to have EMMA ported to OS X?
|
Maestro Del'Tirith
Space Exploration
|
Posted - 2009.05.12 18:17:00 -
[73]
Originally by: Lost Hamster Can we get an ETA for the next minor patch? Will the new version published to the same eve file host? -http://dl.eve-files.com/media/corp/Ambo/ <--- I mean this.
ETA is soon(tm) - there are a few other things I'd like to have done before the next update.
Yes, they will be done through the same place to avoid hassles with switching it. -------------
Looking for a mature group to play with? Recruitment Thread |
Maestro Del'Tirith
Space Exploration
|
Posted - 2009.05.12 18:19:00 -
[74]
Originally by: Roger Kiyosaki I recently made the switch from PC to Mac. Question: Is there any software like this that'll work on the mac? Or is it even on the radar to have EMMA ported to OS X?
I do not know of any Mac software for doing something like this. I don't have any plans to work on porting to Mac any time soon, for a variety of reasons. It is written in .Net which ties it pretty tightly to Windows to start - in addition EMMA requires MS SQL Server, which ties it even more to Windows. There would need to be a large amount of changes to make it truly portable, most likely a full rewrite. -------------
Looking for a mature group to play with? Recruitment Thread |
Kazzac Elentria
|
Posted - 2009.05.12 18:24:00 -
[75]
For those with a mac, it will run under vmware fusion instance of windows. I'd recommend picking the tablet version of windows if you go that route though. |
Grinte Loco
|
Posted - 2009.05.14 17:57:00 -
[76]
Don't know if you've checked today or not, but the latest Apocrypha patch seems to have 'broken' EMMA...poor girl, and just when I need her the most!!!
Looking forward to the update....
|
Don Lapre
|
Posted - 2009.05.14 18:57:00 -
[77]
It's working fine here. API journal updates aren't coming down yet but otherwise everything's ok.
|
Maestro Del'Tirith
Space Exploration
|
Posted - 2009.05.14 19:41:00 -
[78]
Typically they shut down the API servers when they are doing updates. I will give it a bit before any panic ensues. -------------
Looking for a mature group to play with? Recruitment Thread |
Sophil
|
Posted - 2009.05.15 14:08:00 -
[79]
Edited by: Sophil on 15/05/2009 14:10:04 Edit: I admit I didn't read the posts above - Stupid me. Anyone have any idea when the journal entries will be updated?
So now one DT after the patch the api server should be up and running right? Well transactions, orders and assets are updating fine on all characters, but the journal is only updated on one character. A noob character that I use for scouting the market in other regions, he has no money what so ever. Is there anyone else with this problem? It goes from Updating - Overdue - Queued all the time, slowing my computer way down so I have to shut emma down.
|
Lost Hamster
Hamster Holding Corp
|
Posted - 2009.05.15 17:01:00 -
[80]
Originally by: Sophil Edited by: Sophil on 15/05/2009 14:10:04 Edit: I admit I didn't read the posts above - Stupid me. Anyone have any idea when the journal entries will be updated?
Currently Journal works fine.
|
|
Zynce
|
Posted - 2009.05.15 20:19:00 -
[81]
Originally by: bunglebonce When I try to start the program, I get the generic Windows error 'sqlservr.exe has stopped working', followed by the program's error message: 'EMMA is unable to connect to the database. Please try restarting if the problem persists then more detail can be found in Logging/ExceptionLog.txt'.
I'm running into this also, however I managed to find the ExceptionLog. In it, it simply says it was unable to start the service for this user and therefore failed. I do have MySQL installed on my computer as well as .net 3.0, could either of those be interfering at all?
If anybody has encountered this problem before and found a way around it or at least what exactly is causing the service to not start when asked politely, please let me know!
|
Lost Hamster
Hamster Holding Corp
|
Posted - 2009.05.15 21:14:00 -
[82]
Originally by: Zynce
I'm running into this also, however I managed to find the ExceptionLog. In it, it simply says it was unable to start the service for this user and therefore failed. I do have MySQL installed on my computer as well as .net 3.0, could either of those be interfering at all?
If anybody has encountered this problem before and found a way around it or at least what exactly is causing the service to not start when asked politely, please let me know!
Can you please look into the windows application / system events, and look for events which could be related to this problem. Like you try to start emma, then look into the event log to see if there is any error at that time.
Or I would suggest to try it from a different point to resolve this problem: I put together a small doc, how to set up differently the connection: http://dl.eve-files.com/media/corp/hamster/connect_db.pdf It's still in "beta" phase. I plan to proper document how to install the management studio etc.. But you can give a try and set up like this.
|
buildmahcrap
|
Posted - 2009.05.15 22:49:00 -
[83]
Edited by: buildmahcrap on 15/05/2009 22:50:14
Originally by: Lost Hamster
Can you please look into the windows application / system events, and look for events which could be related to this problem. Like you try to start emma, then look into the event log to see if there is any error at that time.
I assume you mean the event viewer, in the control panel/administrative tools/event viewer. I checked all the different logs in there and nothing was entered for the time I was attempting to run EMMA.
Originally by: Lost Hamster
Or I would suggest to try it from a different point to resolve this problem: I put together a small doc, how to set up differently the connection: http://dl.eve-files.com/media/corp/hamster/connect_db.pdf It's still in "beta" phase. I plan to proper document how to install the management studio etc.. But you can give a try and set up like this.
Tried it, only made EMMA take longer to load before erroring out in the same way.
btw, I think you may have a typo? not totally sure but on the last page in the red text, ...database=EveData;Integrated... should that be ...database=EveData;;Integrated... In any case, I tried both configurations and didn't make any headway. Thanks for the attempt
|
Kazzac Elentria
|
Posted - 2009.05.16 02:56:00 -
[84]
Originally by: Zynce
Originally by: bunglebonce When I try to start the program, I get the generic Windows error 'sqlservr.exe has stopped working', followed by the program's error message: 'EMMA is unable to connect to the database. Please try restarting if the problem persists then more detail can be found in Logging/ExceptionLog.txt'.
I'm running into this also, however I managed to find the ExceptionLog. In it, it simply says it was unable to start the service for this user and therefore failed. I do have MySQL installed on my computer as well as .net 3.0, could either of those be interfering at all?
If anybody has encountered this problem before and found a way around it or at least what exactly is causing the service to not start when asked politely, please let me know!
The MSSQL service must run as a system account or account which has administrative priv.
If you are under Vista, logon as local admin go to control panel, administrative tools, then services. Look for the Microsoft SQL server service and then right click and properties. I think its the third tab which allows you to set which account it can run under.
Same thing for XP
Its odd since normally speaking it always installs itself to run under the system account. |
Lost Hamster
Hamster Holding Corp
|
Posted - 2009.05.16 17:10:00 -
[85]
Originally by: buildmahcrap
btw, I think you may have a typo? not totally sure but on the last page in the red text, ...database=EveData;Integrated... should that be ...database=EveData;;Integrated... In any case, I tried both configurations and didn't make any headway. Thanks for the attempt
Actually It doesn't matter if there is one or two ; sign. It works in both way. :) I hope you did all the configuration in the doc, which configures the sql server, so it have the emma database attached. Without that it will not work.
|
Zynce
|
Posted - 2009.05.16 21:40:00 -
[86]
Originally by: Kazzac Elentria The MSSQL service must run as a system account or account which has administrative priv.
I set SQL Server(SQLEXPRESS) to run under the ./Administrator account. My problem still persists. Should the other SQL services (SQL Server Active Directory Helper, SQL Server Browser, SQL Server VSS Writer) have any specific settings? I would assume they're not used by EMMA. Thanks for your advice
Originally by: Lost Hamster
I hope you did all the configuration in the doc, which configures the sql server, so it have the emma database attached. Without that it will not work.
Followed exactly, attached EVEData and EMMADatabase files, still no progress.
The exact error I'm receiving is as follows: Error EMMA is unable to connect to the database. Please try restarting if the problem persists then more detail can be found in Logging/ExceptionLog.txt
Taken from Logging/ExceptionLog.txt 15.05.2009 15:52:48 Critical - EveMarketMonitorApp.Common.EMMAException - Error connecting to database Inner Exception: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
|
Lost Hamster
Hamster Holding Corp
|
Posted - 2009.05.16 23:28:00 -
[87]
Originally by: Zynce
Taken from Logging/ExceptionLog.txt 15.05.2009 15:52:48 Critical - EveMarketMonitorApp.Common.EMMAException - Error connecting to database Inner Exception: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
Looking at your error log, I think the EveMarketMonitorApp.exe.config is not modified.
Can you please paste here the <connectionStrings> part of the EveMarketMonitorApp.exe.config file? And I would need your computer name as well.
|
Zynce
|
Posted - 2009.05.17 01:06:00 -
[88]
Originally by: Lost Hamster Can you please paste here the <connectionStrings> part of the EveMarketMonitorApp.exe.config file? And I would need your computer name as well.
<connectionStrings> <add name="EveMarketMonitorApp.Properties.Settings.EMMA_DatabaseConnectionString" connectionString="Data Source=anonymous;database=EMMADatabase;;Trusted_Connection=yes" providerName="System.Data.SqlClient" /> <add name="EveMarketMonitorApp.Properties.Settings.ebs_DATADUMPConnectionString" connectionString="Data Source=anonymous;database=EveData;;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings>
name = anonymous
|
staggietillidie
|
Posted - 2009.05.17 16:16:00 -
[89]
Originally by: bunglebonce I apologise in advance if this is really obvious, but is there a noob's guide to installing EMMA?
I installed v1.3.0.3 together with SQL Server 2005, running on Vista Home Premium 32-bit.
When I try to start the program, I get the generic Windows error 'sqlservr.exe has stopped working', followed by the program's error message: 'EMMA is unable to connect to the database. Please try restarting if the problem persists then more detail can be found in Logging/ExceptionLog.txt'. I don't see the Logging folder within the installation folder.
I have never used SQL before, which does not help.
Any guidance on where I can find the right information would be appreciated. I am a keen trader, a little wet behind the ears still, but I have made a fair bit of isk and I think that this would be very helpful in managing my investments as I become more involved in trading.
It looks like I have EMMA working.
Solution: I installed the WIndows 7 RC instead of trying to work it with Vista.
Time to look at the tutorial.
|
Maestro Del'Tirith
Space Exploration
|
Posted - 2009.05.18 15:12:00 -
[90]
You are not the first to have much more success with 7 than with Vista. It is generally a better OS based on my own testing. That said, I have been making a few modifications through Vista testing, mostly around the location of installed media in Vista's structure, and do hope that perhaps things might be a bit more stable once I have get an update out. -------------
Looking for a mature group to play with? Recruitment Thread |
|
|
|
|
Pages: 1 2 [3] 4 5 6 7 8 9 10 11 12 13 .. 13 :: one page |
First page | Previous page | Next page | Last page |