These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

EMMA - Update to work with new style API keys - version 1.6
Author
Previous Topic Next Topic
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#41 - 2012-07-23 21:37:58 UTC
Strange, seems ok for me. I'll have to take a more detailed look and get back to you.
Thanatois
Reblier Innovations
#42 - 2012-07-25 16:23:42 UTC  |  Edited by: Thanatois
Shinya Shazih wrote:
Hello,

I tried to use the update feature under General Settings, but Emma is telling me she is missing summary.xml and/or summary.zip

Quote:
Problem downloading file 'summary.xml'
External name could not be retrieved 'summary.zip'



I get that error a lot when trying to do various things. I also keep running into a problem where Emma will say that the Eve api is down and thus basically not let me do anything once the program loads. I can ping api.eveonline.com just fine from my computer.

Quote:
Pinging api.eveonline.com [87.237.39.199] with 32 bytes of data:
Reply from 87.237.39.199: bytes=32 time=2033ms TTL=240
Reply from 87.237.39.199: bytes=32 time=1427ms TTL=240
Reply from 87.237.39.199: bytes=32 time=1467ms TTL=240
Reply from 87.237.39.199: bytes=32 time=1456ms TTL=240



Quote:
EXCEPTION REPORT
=====================================================================================
7/25/2012 11:17:56 AM Error - EveMarketMonitorApp.Common.EMMAException - Failed to contact api.eveonline.com
Status - TimedOut
=====================================================================================
EXCEPTION REPORT
=====================================================================================
7/25/2012 11:18:10 AM Error - EveMarketMonitorApp.Common.EMMAException - Failed to contact www.eve-central.com
Status - TimedOut
=====================================================================================
EXCEPTION REPORT
=====================================================================================
7/25/2012 11:18:14 AM Error - EveMarketMonitorApp.Common.EMMAException - Failed to contact www.eve-metrics.com
Status - TimedOut
=====================================================================================
EXCEPTION REPORT
=====================================================================================
7/25/2012 11:18:20 AM Error - EveMarketMonitorApp.Common.EMMAException - Failed to contact www.eve-files.com
Status - TimedOut
=====================================================================================
EXCEPTION REPORT
=====================================================================================
7/25/2012 11:18:24 AM Error - EveMarketMonitorApp.Common.EMMAException - Failed to contact www.starfreeze.com
Status - TimedOut
=====================================================================================
EXCEPTION REPORT
=====================================================================================
7/25/2012 11:18:44 AM Critical - EveMarketMonitorApp.Common.EMMAEveAPIException - No XML document to process
=====================================================================================


(the XML error at the end repeats like 1000 times)


I've turned off my firewall and tried to boot it with no luck. I got fewer errors when trying it from my laptop at a coffee shop (with better internet) and still got the error about eve-central.com which was puzzling. I should add that while I got errors last night, Emma was still able to access the eve api and thus allow me to do things.
Raven Ballhammer
Bird and Hammer
#43 - 2012-07-27 00:21:47 UTC
Not to add to your work, but the field code for typeID was coded as int16 in EMMA. CCP, in their infinite wisdom, has added items with typeIDs greater than 32787 to the game, so it is throwing an error. Any chance of a fix?

Thanks
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#44 - 2012-07-27 17:38:42 UTC
It's actually 32bit so not sure what's going on there... Can you paste your error log?
Raven Ballhammer
Bird and Hammer
#45 - 2012-07-27 18:14:15 UTC
=====================================================================================
EXCEPTION REPORT
=====================================================================================
7/27/2012 1:11:50 PM Error - EveMarketMonitorApp.Common.EMMADataException - Problem adding item to database.
Inner Exception: Value was either too large or too small for an Int16.Couldn't store <32772> in typeID Column. Expected type is Int16.
Stack Trace: at System.Data.DataColumn.set_Item(Int32 record, Object value)
at System.Data.DataTable.NewRecordFromArray(Object[] value)
at System.Data.DataTable.LoadDataRow(Object[] values, Boolean fAcceptChanges)
at System.Data.ProviderBase.SchemaMapping.LoadDataRow()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
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.invTypesTableAdapter.FillByIDs(invTypesDataTable dataTable, String itemIDs)
at EveMarketMonitorApp.DatabaseClasses.Items.GetItems(String ids)
at EveMarketMonitorApp.DatabaseClasses.Items.AddItem(Int32 itemID, String itemName)
Inner Exception: Value was either too large or too small for an Int16.
Stack Trace: at System.Convert.ToInt16(Int32 value)
at System.Int32.System.IConvertible.ToInt16(IFormatProvider provider)
at System.Data.Common.Int16Storage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)
Syster Sweet
Sebiestor Tribe
Minmatar Republic
#46 - 2012-07-27 19:56:36 UTC
Got a problem setting it up:

Quote:

=====================================================================================
EXCEPTION REPORT
=====================================================================================
27.07.2012 21:54:50 Critical - EveMarketMonitorApp.Common.EMMAException - Error connecting to database
Inner Exception: Die 'C:\USERS\FARAMI\APPDATA\ROAMING\EMMA\DATA\EMMA DATABASE.MDF'-Datenbank kann nicht geöffnet werden, weil sie die Version 706 aufweist. Dieser Server unterstützt Version 655 und früher. Ein Herabstufungspfad wird nicht unterstützt.
Die neue 'C:\USERS\FARAMI\APPDATA\ROAMING\EMMA\DATA\EMMA DATABASE.MDF'-Datenbank konnte nicht geöffnet werden. CREATE DATABASE wird abgebrochen.
Fehler beim Anfügen einer automatisch benannten Datenbank für die Datei C:\Users\Farami\AppData\Roaming\EMMA\Data\EMMA Database.mdf. Eine Datenbank mit diesem Namen ist bereits vorhanden, die angegebene Datei kann nicht geöffnet werden, oder sie befindet sich in der UNC-Freigabe.
Stack Trace: bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
bei System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
bei System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
bei System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
bei System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
bei System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
bei System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
bei System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
bei System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
bei System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
bei System.Data.SqlClient.SqlConnection.Open()
bei EveMarketMonitorApp.DatabaseClasses.Updater.WaitForAcknowledge()
bei EveMarketMonitorApp.GUIElements.Main.waitForSQLAcknowledge()
=====================================================================================
EXCEPTION REPORT
=====================================================================================
27.07.2012 21:54:50 Critical - EveMarketMonitorApp.Common.EMMAException - EMMA is unable to connect to the database.


This translates roughly to "Couldnt open database as it is version 706. This server only supports version 655 and earlier".

Thing is I've installed Microsoft SQL 2008, just as it was stated in the readme.
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#47 - 2012-07-28 07:04:39 UTC
Raven Ballhammer wrote:
=====================================================================================
EXCEPTION REPORT
=====================================================================================
7/27/2012 1:11:50 PM Error - EveMarketMonitorApp.Common.EMMADataException - Problem adding item to database.
Inner Exception: Value was either too large or too small for an Int16.Couldn't store <32772> in typeID Column. Expected type is Int16.


Thanks for that. I shall investigate.


Syster Sweet wrote:

This translates roughly to "Couldnt open database as it is version 706. This server only supports version 655 and earlier".

Thing is I've installed Microsoft SQL 2008, just as it was stated in the readme.


706 is SQL 2012, 655 is 2008 r2.
If the database is 706 then something must have upgraded it. Did you open it in 2012 to see what was in there or something like that?
flakeys
Doomheim
#48 - 2012-07-28 08:50:43 UTC
planetside 2 allready in beta ambo? Blink

We are all born ignorant, but one must work hard to remain stupid.
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#49 - 2012-07-28 15:55:25 UTC
Yes. Applied for beta so fingers crossed. :)
flakeys
Doomheim
#50 - 2012-07-28 16:28:20 UTC
Ambo wrote:
Yes. Applied for beta so fingers crossed. :)



Don't forget to throw me a mail about how it is IF you're in please mate as i am RRRRRRRRRRrreally looking forward to this one .

We are all born ignorant, but one must work hard to remain stupid.
Kendra Prime
Signal Cartel
EvE-Scout Enclave
#51 - 2012-08-05 03:03:17 UTC
I am unable to get EMMA to connect to EVE-Central. Any Ideas?
I have allowed access through Windows Firewall, and am running EMMA in Admin mode.

Running Windows 7 x64

=====================================================================================
EXCEPTION REPORT
=====================================================================================
8/4/2012 11:00:50 PM Error - EveMarketMonitorApp.Common.EMMAException - Failed to contact www.eve-central.com
Status - DestinationPortUnreachable
Robin Dupont
Hunter Holdings
#52 - 2012-08-18 20:12:00 UTC
this keeps cropping up when doing fresh installs of both the sql server and EMMA.

EXCEPTION REPORT
=====================================================================================
18/08/2012 4:08:44 PM 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)
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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject, Boolean withFailover)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at EveMarketMonitorApp.DatabaseClasses.Updater.WaitForAcknowledge()
at EveMarketMonitorApp.GUIElements.Main.waitForSQLAcknowledge()
=====================================================================================
EXCEPTION REPORT
=====================================================================================
18/08/2012 4:08:44 PM Critical - EveMarketMonitorApp.Common.EMMAException - EMMA is unable to connect to the database.

=====================================================================================
Any one make sense of this?
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#53 - 2012-08-28 18:33:31 UTC
Raven Ballhammer wrote:
Not to add to your work, but the field code for typeID was coded as int16 in EMMA. CCP, in their infinite wisdom, has added items with typeIDs greater than 32787 to the game, so it is throwing an error. Any chance of a fix?

Thanks


This has now been fixed in beta release 1.6.0.7
I can't test it fully at the moment but gave it a quick try and all seems fine.
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#54 - 2012-08-28 18:35:10 UTC
Robin Dupont wrote:
this keeps cropping up when doing fresh installs of both the sql server and EMMA.

EXCEPTION REPORT
=====================================================================================
18/08/2012 4:08:44 PM 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.

Any one make sense of this?


There are a ton of results online if you search for this error. Unfortunately, there are also a ton of possible causes. Try this one to start: http://stackoverflow.com/questions/281500/error-failed-to-generate-a-user-instance-of-sql-server
Molic Blackbird
Orion Faction Industries
Orion Consortium
#55 - 2012-08-30 18:11:57 UTC
I've been getting this error for a couple weeks:

=====================================================================================
EXCEPTION REPORT
=====================================================================================
8/30/2012 12:52:59 PM Error - EveMarketMonitorApp.Common.EMMADataException - Problem adding item to database.
Inner Exception: Invalid column name 'graphicID'.
Invalid column name 'graphicID'.
Stack Trace: at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
at EveMarketMonitorApp.DatabaseClasses.EveDataSetTableAdapters.invTypesTableAdapter.Update(invTypesDataTable dataTable)
at EveMarketMonitorApp.DatabaseClasses.Items.AddItem(Int32 itemID, String itemName)
=====================================================================================
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#56 - 2012-08-30 20:11:29 UTC
Just released 1.6.0.8 that should fix this problem.
It's just on beta release for now so to get it go to settings -> other settings, make sure 'check for beta updates' is ticked and then restart EMMA.
Any problems, let me know.
Molic Blackbird
Orion Faction Industries
Orion Consortium
#57 - 2012-08-31 04:11:33 UTC
It works now. Thanks.
Sapporo Uta
Science and Trade Institute
Caldari State
#58 - 2012-09-06 18:58:17 UTC
I apologize if this is a somewhat noobish thing to ask, but I am going to ask it anyways.

I am using Emma 1.6.0.8 (trial at this point), and have run into an issue where Emma seems to have lost data regarding the average buy price for several of my previously purchased items. I'm guessing that is the issue as the Item report lists the data for several of the items as greyed out (or some other very light color).

Am I missing something basic here? If not, and it appears that there is an issue with the data, is there an easy way to force EMMA to reload all the trading information from APi? I'd like to use this tool, but it is of limited use if the data isn't valid.
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#59 - 2012-09-08 11:39:33 UTC
Sapporo Uta wrote:
I apologize if this is a somewhat noobish thing to ask, but I am going to ask it anyways.

I am using Emma 1.6.0.8 (trial at this point), and have run into an issue where Emma seems to have lost data regarding the average buy price for several of my previously purchased items. I'm guessing that is the issue as the Item report lists the data for several of the items as greyed out (or some other very light color).

Am I missing something basic here? If not, and it appears that there is an issue with the data, is there an easy way to force EMMA to reload all the trading information from APi? I'd like to use this tool, but it is of limited use if the data isn't valid.


No problem, the only foolish question is one unasked.

The colours used in the reports are defined in settings -> report style settings.
So light grey could mean all sorts of things depending on how that's been configured.

There is no default for light grey. The only one I can think you might mean is the default 'warning value' colour. Which is a yellow colour (it looks light on the report, less so in settings but it IS the same colour ;))

The warning that it is giving you is simply that your average buy price (i.e. the cost of items bought in the report period) is more than 5% higher than the 'cost of units sold'. So it's just indicating that your buy price for that item is increasing.

e.g. You buy 10 things for 5 isk on 1st Jan. You then sell those 10 things for 20 isk on 1st Feb and buy 10 more things for 10 isk.
If you run a report for Feb, your cost of units sold will be 5 isk but your average buy price will be 10 isk - leading to this warning.

Hope that helps.
Sapporo Uta
Science and Trade Institute
Caldari State
#60 - 2012-09-15 01:49:23 UTC
I figured it was something like that, thanks for the clarifications on the report settings. I'll be sending off my cash the next time I log.

Thanks again!