open All Channels
seplocked Market Discussions
blankseplocked The Next EMMA thread. - 1.5.1.0 now available. Massive update.
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: first : previous : 1 2 3 4 [5] 6 7 8 9 ... : last (30)

Author Topic

Lost Hamster
Hamster Holding Corp
Posted - 2009.12.18 08:47:00 - [121]
 

I can post it, but first I need to downgrade the database to SQL 2005.

Lost Hamster
Hamster Holding Corp
Posted - 2009.12.18 19:07:00 - [122]
 

I'm done:

Here is the link:
http://rapidshare.com/files/322670862/Dominion-Data-sql2005.zip.html

You can use it with SQL2005.

Keep in mind that with this DB, the REPROCESSOR is BROKEN, until the application is changed to work fine with the new dominion database tables.

Ambo in the dbo.GetReprocesResults I changed the reprocessor to this:

SELECT invTypeMaterials.materialTypeID, invTypeMaterials.quantity
FROM invTypeMaterials WHERE invTypeMaterials.typeID = @itemID

As I saw, this gives back the correct values. I have checked T1, named module, and T2 module, all of them gived back the same result as the current procedure.

Vested Interest
Posted - 2009.12.18 19:54:00 - [123]
 

once the API comes up I'll give it a try and pay out!

Lost Hamster
Hamster Holding Corp
Posted - 2009.12.18 20:50:00 - [124]
 

Originally by: Vested Interest
once the API comes up I'll give it a try and pay out!


I didn't do for the money. And honestly, without the code change, the DB is only 40% worth.

Ambo
I've Got Nothing
Posted - 2009.12.18 23:02:00 - [125]
 

Ok Hamster, thanks for your efforts.

With the reprocessor still not working, I'll hold off on supplying the new DB through the auto-update process. I might look into getting it sorted this weekend... no promises though.

Vested Interest
Posted - 2009.12.21 18:02:00 - [126]
 

I can give the db a tentative thumbs-up. EMMA starts up fine with it, I don't use the reprocessor anyway.

I will get some Dominion items listed later and make sure it works for trading.

Vested Interest
Posted - 2009.12.27 07:21:00 - [127]
 

Assets report is toast:

EXCEPTION REPORT
=====================================================================================
12/27/2009 12:19:54 AM Error - EveMarketMonitorApp.Common.EMMAReportingException - Problem creating report.
Inner Exception: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Stack Trace: at System.Data.DataTable.EnableConstraints()
at System.Data.DataTable.set_EnforceConstraints(Boolean value)
at System.Data.DataTable.EndLoadData()
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
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 EveMarketMonitorApp.DatabaseClasses.EveDataSetTableAdapters.ReprocesResultsTableAdapter.Fill(ReprocesResultsDataTable dataTable, Nullable`1 itemID)
at EveMarketMonitorApp.DatabaseClasses.Items.ReproCache_DataUpdateNeeded(Object myObject, DataUpdateNeededArgs`2 args)
at EveMarketMonitorApp.Common.Cache`2.Get(KeyType key)
at EveMarketMonitorApp.DatabaseClasses.Items.GetItemMaxReprocessResults(Int32 itemID)
at EveMarketMonitorApp.DatabaseClasses.ReprocessJob.UpdateResults()
at EveMarketMonitorApp.Reporting.AssetsReport.GetDataFromDatabase()
at EveMarketMonitorApp.Reporting.AssetsReport.FillReport()
at EveMarketMonitorApp.Reporting.ReportBase.CreateReport(Dictionary`2 paramters)

Veevi Fenikusu
Minmatar
Fenikusu Trade
Posted - 2009.12.31 12:42:00 - [128]
 

I just checked out the source to take a look at it, friend suggested I should work on this instead of my own tool, so might as well do that,
I'll figure out how everything fits together whenever I have time, and try to fix stuff, I'm not sure what your stand on the sql server is, but if it's possible, I could try & convert it to sqlite, which might make it more portable!


Mme Pinkerton
The pink win
Posted - 2009.12.31 13:18:00 - [129]
 

Originally by: Veevi Fenikusu
I'm not sure what your stand on the sql server is, but if it's possible, I could try & convert it to sqlite, which might make it more portable!


I think no one really likes the current model and a successful port to sqlite (or MSSQL CE) would certainly be very welcome.

However, a substantial part of EMMA's logic is written in stored procedures (+ there are a few C# functions stored in the database as well) which would have to be rewritten (in a tidy way, atm they have the advantage of not cluttering the main code) when porting to sqlite.

Also, I am not sure if fixing the dependance on MSSQL is really the best way to spend developer time - IMHO a UI rewrite (MDI is broken in Vista+, Reports interface is extremely clumsy) would be of more value.

When changing the DB backend, using a sqlite-to-LINQ adapter might be a idea worth considering.

Veevi Fenikusu
Minmatar
Fenikusu Trade
Posted - 2009.12.31 13:33:00 - [130]
 

Edited by: Veevi Fenikusu on 31/12/2009 14:52:58
I really can't make any promises, in about a month I'm out of the country for my internship , and don't have anything that can run eve to take with me(yet!), so it will probably limit my ability to test stuff(and time)

edit: yes, just spotted the bunch of procedures, can't say I'm a big fan of em :p

Ambo
I've Got Nothing
Posted - 2009.12.31 15:23:00 - [131]
 

Yes, I'm afraid EMMA uses some rather chunky stored procedures. This was simply to give the best performance possible. The data sets EMMA works with can get rather large and with some of the queries being so complex, performance was a primary concern for me.

Additionally, the c# based procedures are used in a lot of places and are impossible to port to sqlite. I think they would have to be re-written into functions within the code itself that then made multiple calls to the database in a looping fashion.

All this would be time-consuming and you would end up with worse performance and possibly difficulties converting the datadump to sqlite each time it was updated. Having said that, it would almost certainly be easier to install.

Personally, I would not even attempt it if you only have a month to work on it.
If you need any help getting your head around anything then feel free to give me a shout in-game or at [email protected]

Bangbroo
Posted - 2010.01.03 11:48:00 - [132]
 

Ugh just installed EMMA and it doesnt seem to work on Windows 7 is that correct?

Veevi Fenikusu
Minmatar
Fenikusu Trade
Posted - 2010.01.03 17:51:00 - [133]
 

Edited by: Veevi Fenikusu on 03/01/2010 19:28:09
Originally by: Mme Pinkerton

Also, I am not sure if fixing the dependance on MSSQL is really the best way to spend developer time - IMHO a UI rewrite (MDI is broken in Vista+, Reports interface is extremely clumsy) would be of more value.


How exactly is MDI broken in vista+ ? (using windows 7 here, though), and it seems to work fine? I do agree on the reports interface, might be best to try outputting it to something more capable.(like excel?)

I have to admit that my .NET knowledge is not really up to date. I checked out the code, and a bit disencouraged to see how the code is build up, and the stored procedures... Started giving my own tool a try again, which would be written in java, seems to handle MDI ok'ish.

EDIT: or rather, what would you suggest as an improvement for the gui?

Ambo
I've Got Nothing
Posted - 2010.01.03 22:25:00 - [134]
 

Originally by: Bangbroo
Ugh just installed EMMA and it doesnt seem to work on Windows 7 is that correct?


It works but it can be a bit weird at times. Try right click -> run as administrator.

ThePhoenixBird
Posted - 2010.01.03 22:48:00 - [135]
 

Originally by: Bangbroo
Ugh just installed EMMA and it doesnt seem to work on Windows 7 is that correct?


Yes it does, if you are running Windows 7 x64 you will need to download the x64 version of SQL Express 2005 you can get it from here download the SQLEXPR32.EXE if you are running under 32 bits windows.

Install and after the instalation is complete use the Surface SQL config tool to enable CLR Integration, then restart your PC and run EMMA as Administrator

Im here running on Windows 7 x64 without problems, it just was a nightmare to upgrade to lastest 1.3.1.4 version since eve-files.com is really slow another mirror would be welcome.

Queen Krystal
Posted - 2010.01.04 02:56:00 - [136]
 

Running on version 1.3.1.4 and i get this error while updaing the Journal

Quote:
=====================================================================================
EXCEPTION REPORT
=====================================================================================
03/01/2010 10:18:04 p.m. Critical - EveMarketMonitorApp.Common.EMMADataException - The journal entries you are adding appear to be for a generation after the latest one in the EMMA database.
You will be unable to import journal entries from the EveAPI until the EMMA database is updated with newer journal generation data.


Linu Solongo
Universal Fleet Operations
Veneratio Venator Alliance
Posted - 2010.01.04 12:00:00 - [137]
 

Originally by: ThePhoenixBird
Originally by: Bangbroo
Ugh just installed EMMA and it doesnt seem to work on Windows 7 is that correct?


Yes it does, if you are running Windows 7 x64 you will need to download the x64 version of SQL Express 2005 you can get it from here download the SQLEXPR32.EXE if you are running under 32 bits windows.

Install and after the instalation is complete use the Surface SQL config tool to enable CLR Integration, then restart your PC and run EMMA as Administrator

Im here running on Windows 7 x64 without problems, it just was a nightmare to upgrade to lastest 1.3.1.4 version since eve-files.com is really slow another mirror would be welcome.


Good to hear it runs fine on Windows 7 x64. Thanks for that info Phoenix. But where are you guys getting the 1.3.1.4 version? I checked the googlecode page and it only has version 1.3.1.0 available to download. I even checked Ambo's eve files but the latest one I saw was EMMA_1.3.1.2_-_partial.zip.

Lost Hamster
Hamster Holding Corp
Posted - 2010.01.04 15:09:00 - [138]
 

Originally by: Queen Krystal
Running on version 1.3.1.4 and i get this error while updaing the Journal

Quote:
=====================================================================================
EXCEPTION REPORT
=====================================================================================
03/01/2010 10:18:04 p.m. Critical - EveMarketMonitorApp.Common.EMMADataException - The journal entries you are adding appear to be for a generation after the latest one in the EMMA database.
You will be unable to import journal entries from the EveAPI until the EMMA database is updated with newer journal generation data.




Can you check via the SQL management console the:
JournalGenerations table in "EMMA database.mdf" ?

And post what is there? There was an issue here Could be similar.

Ambo
I've Got Nothing
Posted - 2010.01.04 18:54:00 - [139]
 

Originally by: Linu Solongo
Originally by: ThePhoenixBird
Originally by: Bangbroo
Ugh just installed EMMA and it doesnt seem to work on Windows 7 is that correct?


Yes it does, if you are running Windows 7 x64 you will need to download the x64 version of SQL Express 2005 you can get it from here download the SQLEXPR32.EXE if you are running under 32 bits windows.

Install and after the instalation is complete use the Surface SQL config tool to enable CLR Integration, then restart your PC and run EMMA as Administrator

Im here running on Windows 7 x64 without problems, it just was a nightmare to upgrade to lastest 1.3.1.4 version since eve-files.com is really slow another mirror would be welcome.


Good to hear it runs fine on Windows 7 x64. Thanks for that info Phoenix. But where are you guys getting the 1.3.1.4 version? I checked the googlecode page and it only has version 1.3.1.0 available to download. I even checked Ambo's eve files but the latest one I saw was EMMA_1.3.1.2_-_partial.zip.


In EMMA, go into settings -> and enable 'check for beta updates'.

Also, note there are two update servers listed, you can simply delete the eve-files one if it's too slow for you.

Linu Solongo
Universal Fleet Operations
Veneratio Venator Alliance
Posted - 2010.01.04 20:16:00 - [140]
 

So if I've never installed EMMA on my computer before, should I install v1.3.1.0 and then go to the settings to upgrade or should I install EMMA_1.3.1.2_-_partial to replace 1.3.1.0 first, then go to settings and upgrade? I just want to make sure I'm installing with the correct files and upgrading it correctly to avoid any errors.

Ambo
I've Got Nothing
Posted - 2010.01.04 22:05:00 - [141]
 

Originally by: Linu Solongo
So if I've never installed EMMA on my computer before, should I install v1.3.1.0 and then go to the settings to upgrade or should I install EMMA_1.3.1.2_-_partial to replace 1.3.1.0 first, then go to settings and upgrade? I just want to make sure I'm installing with the correct files and upgrading it correctly to avoid any errors.


Just go for the full install and then the automatic update. The partial install was a one-off thing I did for someone with a particular problem.

Linu Solongo
Universal Fleet Operations
Veneratio Venator Alliance
Posted - 2010.01.04 23:37:00 - [142]
 

Thanks Ambo. The install was successful. The only error I got so far seems to be related to Windows 7 permissions I think. I've had permission problems with other programs before and I had to change the correct folders to Full Control. Anyways, when I tried to build a report, I got this message:

Problem creating report
Eve API error.
Code: 200
Description: Current security level not high enough.

I ran EMMA as administrator but I still got the error message. Also, I'm not sure if the API is updating correctly because I'm getting Overdue statuses across the board.

Any ideas on how to fix this?

Thanks!

Queen Krystal
Posted - 2010.01.05 05:27:00 - [143]
 

Edited by: Queen Krystal on 05/01/2010 05:29:38
Originally by: Lost Hamster
Originally by: Queen Krystal
Running on version 1.3.1.4 and i get this error while updaing the Journal

Quote:
=====================================================================================
EXCEPTION REPORT
=====================================================================================
03/01/2010 10:18:04 p.m. Critical - EveMarketMonitorApp.Common.EMMADataException - The journal entries you are adding appear to be for a generation after the latest one in the EMMA database.
You will be unable to import journal entries from the EveAPI until the EMMA database is updated with newer journal generation data.




Can you check via the SQL management console the:
JournalGenerations table in "EMMA database.mdf" ?

And post what is there? There was an issue here Could be similar.


here is the dump of the JournalGenerations table

Quote:
0 01/01/2000 12:00:00 a.m. 01/09/2007 12:00:00 a.m. 0 1000000000
1 01/12/2007 12:00:00 a.m. 27/11/2008 09:53:00 a.m. 1085796677 1887206022
2 29/11/2008 01:00:00 a.m. 30/11/2008 01:00:00 a.m. 2591720933 368341979


Also i have enabled TCP/IP and Pipes as suggestd on the other topic.

Shared Memory - enabled
Named Pipes - enabled
TCP/IP - enabled
VIA - disabled

But still im getting the same error
Quote:
=====================================================================================
EXCEPTION REPORT
=====================================================================================
05/01/2010 12:48:52 a.m. Critical - EveMarketMonitorApp.Common.EMMADataException - The journal entries you are adding appear to be for a generation after the latest one in the EMMA database.
You will be unable to import journal entries from the EveAPI until the EMMA database is updated with newer journal generation data.


Quote:
<?xml version="1.0" encoding="UTF-16" standalone="yes"?>
<eveapi version="2">
<currentTime>2010-01-05 05:18:32</currentTime>
<error code="103">Already returned one week of data: retry after 2010-01-05 06:18:29.</error>
<cachedUntil>2010-01-05 06:18:29</cachedUntil>
</eveapi>


Any suggestion?

Ambo
I've Got Nothing
Posted - 2010.01.05 08:45:00 - [144]
 

Originally by: Linu Solongo
Thanks Ambo. The install was successful. The only error I got so far seems to be related to Windows 7 permissions I think. I've had permission problems with other programs before and I had to change the correct folders to Full Control. Anyways, when I tried to build a report, I got this message:

Problem creating report
Eve API error.
Code: 200
Description: Current security level not high enough.

I ran EMMA as administrator but I still got the error message. Also, I'm not sure if the API is updating correctly because I'm getting Overdue statuses across the board.

Any ideas on how to fix this?

Thanks!


This problem is due to eve permissions, not windows permissions.
It usually indicates that you have entered your regular API key instead of the full permissions one. To change this, go into 'manage group' double click the eve account line and change the API key to the correct one for full access.
If the corp includes a corp then you may need corp-level permissions to access certain data, if that is the case then just don't include the corp in the report.

Vaerah Vahrokha
Minmatar
Vahrokh Consulting
Posted - 2010.01.05 08:54:00 - [145]
 

I used to use a pre-Dominion version (because it just worked, I need it for doing audits) with no problem.

I installed the latest and it works but when I use the NAV report it constantly throws out issues with EvE-Central.

I tried JEveassets, EvEMeep, manual browsing the site and even manually using EvE-Central API and I don't get any error instead.

Any clue?

Ambo
I've Got Nothing
Posted - 2010.01.05 09:11:00 - [146]
 

Edited by: Ambo on 05/01/2010 09:11:22
Originally by: Queen Krystal
<problem>

Any suggestion?



This is due to the way that CCP have to keep adjusting journal entry IDs when they start to run out of room in the table. (ID is a 32-bit int so can only hold 2 billion odd entries).
You can fix this by manually adjusting the last entry in the journal generations table. (you can use microsoft SQL management studio express to do this)
You need the values from someone else's journal generations table that is currently working. I'd give you mine but unfortunately, I'm having trouble with my DB at the moment.


Ambo
I've Got Nothing
Posted - 2010.01.05 09:16:00 - [147]
 

Originally by: Vaerah Vahrokha
I used to use a pre-Dominion version (because it just worked, I need it for doing audits) with no problem.

I installed the latest and it works but when I use the NAV report it constantly throws out issues with EvE-Central.

I tried JEveassets, EvEMeep, manual browsing the site and even manually using EvE-Central API and I don't get any error instead.

Any clue?


There should be an error log 'ExceptionLog.txt' in your Emma/Logging folder, could you post the error that you're getting when connecting to eve-central?

Queen Krystal
Posted - 2010.01.05 09:32:00 - [148]
 

Edited by: Queen Krystal on 05/01/2010 09:33:01
Edited by: Queen Krystal on 05/01/2010 09:32:32
Originally by: Ambo
Edited by: Ambo on 05/01/2010 09:11:22
Originally by: Queen Krystal
<problem>

Any suggestion?



This is due to the way that CCP have to keep adjusting journal entry IDs when they start to run out of room in the table. (ID is a 32-bit int so can only hold 2 billion odd entries).
You can fix this by manually adjusting the last entry in the journal generations table. (you can use microsoft SQL management studio express to do this)
You need the values from someone else's journal generations table that is currently working. I'd give you mine but unfortunately, I'm having trouble with my DB at the moment.




I shouldnt be reading this forums at 3am... you can easily miss stuff while reading.

Noticed the Lost Hamster values for his JournalGenerations table
Quote:
ID Start Date End Date Offset LargersID
0 2000-01-01 00:00:00.000 2007-09-01 00:00:00.000 0 1000000000
1 2007-12-01 00:00:00.000 2008-11-27 09:53:00.000 1085796677 1887206022
2 2008-11-29 01:00:00.000 2009-09-16 08:29:24.000 2591720933 1642241558


And replaced the last row on mine, it worked! it just trew out the most recent journal entries for today 05/01/2010, not all the data but at least its something, i just hope to see all the data comming on next sync.

Thanks for your awesome app Ambo! i would like to see if its posible to port it to use sqlite or postgre for a less-resource-eater database rather than MSSQL

Linu Solongo
Universal Fleet Operations
Veneratio Venator Alliance
Posted - 2010.01.05 17:19:00 - [149]
 

Originally by: Ambo
Originally by: Linu Solongo
Thanks Ambo. The install was successful. The only error I got so far seems to be related to Windows 7 permissions I think. I've had permission problems with other programs before and I had to change the correct folders to Full Control. Anyways, when I tried to build a report, I got this message:

Problem creating report
Eve API error.
Code: 200
Description: Current security level not high enough.

I ran EMMA as administrator but I still got the error message. Also, I'm not sure if the API is updating correctly because I'm getting Overdue statuses across the board.

Any ideas on how to fix this?

Thanks!


This problem is due to eve permissions, not windows permissions.
It usually indicates that you have entered your regular API key instead of the full permissions one. To change this, go into 'manage group' double click the eve account line and change the API key to the correct one for full access.
If the corp includes a corp then you may need corp-level permissions to access certain data, if that is the case then just don't include the corp in the report.


*face palm* Embarassed Yep. That was it. Now everything works. I've used EMMA before but I haven't tried the latest version on Windows 7 x64 until now. Works like a charm! Thanks for the awesome support! EMMA is by far the best trading tool out there IMO.

I know the project isn't in active development anymore, but I'll throw in a features request anyways in case you ever decide to start development again. Now, I love the reports feature but I would love if you had something that could display the top n% of your most profitable items in a bar graph or in some sort of chart form.

Anyways, that's just something to consider in case you ever start to actively develop EMMA again.

Thanks again for your help.

Valyrian Tyr
Posted - 2010.01.06 02:38:00 - [150]
 

I'm having a bit of trouble getting emma to work. Right now all I get upon opening the program is an immediate 'EMMA has stopped working' window which says

'a problem caused the program to stopworking correctly. Windows will clost the program and notify you if a solution is available'

A little info:
Windows Vista 64 sp2
I have installed SQL with SQLEXPR.EXE file. It seemed to install properly after the second attempt.
I ran the setup.exe file first and that seemed to install properly as well.
I've restarted windows multiple times to get the sql to kick on.

Any help? I'll keep at the threads and see if I can figure it out but I'll take any sugestions you may have.

Thanks!



Pages: first : previous : 1 2 3 4 [5] 6 7 8 9 ... : last (30)

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only