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 : ... 8 9 10 11 [12] 13 14 15 16 ... : last (30)

Author Topic

Razz XXX
Minmatar
Vashta Nerada Corp
Posted - 2010.04.17 11:21:00 - [331]
 

Need for speed - running into problems with reports that totals all isk takes 30+ min to finish and restarting it few times to finish. The Asset report takes forever to finish, I haven't done that for awhile. This is on Quad core, so I wished there some way speed up these reports are done.

Ambo
I've Got Nothing
Posted - 2010.04.17 16:41:00 - [332]
 

The speed of those reports is mostly limited by the calculation of item values.

If it hasn't been recalculated for a while then it means a couple of database queries and then possibly a trip to eve-central or eve-metrics to get pricing data. That's where the slowness comes from, not a lot I can do about it without also making it less accurate I'm afraid.

Do you have a lot of assets? I have thousands scattered across many systems and it still only takes a couple of minutes max (this is on a dual core E6400)

Lost Hamster
Hamster Holding Corp
Posted - 2010.04.17 18:49:00 - [333]
 

Ambo, any change to fix this?



Imuran
Zentor Industries
Posted - 2010.04.17 21:57:00 - [334]
 

Originally by: Lost Hamster
Ambo, I think it's the same as here:
http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1180576&page=4#114
"There is an issue with contracts which are accepted for Corp.
They appear twice in the income statement, As it is registered for personal, and for corporation entry as well.

If TypeID=79 then the SWalletID needs to be changed from 1000 to 0
Then in the income statement it will only appear as a corp expense, not as personal. "



Yep its the income statement - but its not limited to contracts. I have one character that all he does is buy and sell on behalf of the corp

Report 1 Corporation only
Market Transactions 14,109,154,743

Report 2 Corporation and Character
Market Transactions 27,266,349,849

Note I have other characters that sell for the corp so report 2 is not double report 1 but its close

Ambo
I've Got Nothing
Posted - 2010.04.18 06:25:00 - [335]
 

Thanks for the extra info. I'm afraid there is no fix yet. Although I have looked at it.

It's just far more complicated than it appears. I remember looking at it last time and deciding to leave it. However, now I've got a little more time on my hands, I'll take another look.

Having said that, getting a fix that actually resolves the problem without causing more issues is going to require some time and some serious thought.

Imuran
Zentor Industries
Posted - 2010.04.18 19:55:00 - [336]
 

I can appreciate that - I have written a quick VB app not undertanding c#) to do the job and ended up with 4 queries to build the data

Ambo
I've Got Nothing
Posted - 2010.04.19 10:04:00 - [337]
 

1.4.1.4 is now on general release, I've also updated the links in the OP to point to the new 1.4.1.4 installer package.


Julian Koll
The Kollektive
Posted - 2010.04.19 12:20:00 - [338]
 

Edited by: Julian Koll on 19/04/2010 12:49:59
Last update seems to want sql 2008 running on your system, at least mine would not run with 2005 (which it did just fine prior to the update). Unfortunately installing sql 2008 seems to be a major pain, and im still working on getting it running

Sad

Edit:

So far i have
- uninstalled sql 2005
- installed sql 2008
- installed sp1 for sql 2008
- uninstalled EMMA
- installed EMMA

it still wont connect to database

(thats on a win 7 x64 system)

Qintius
Posted - 2010.04.19 13:55:00 - [339]
 

Originally by: Julian Koll
Edited by: Julian Koll on 19/04/2010 12:49:59
Last update seems to want sql 2008 running on your system, at least mine would not run with 2005 (which it did just fine prior to the update). Unfortunately installing sql 2008 seems to be a major pain, and im still working on getting it running

Sad

Edit:

So far i have
- uninstalled sql 2005
- installed sql 2008
- installed sp1 for sql 2008
- uninstalled EMMA
- installed EMMA

it still wont connect to database

(thats on a win 7 x64 system)



I'm having the same problem, same OS.

offtopic, that microsoft web install interface is crap.

Ambo
I've Got Nothing
Posted - 2010.04.19 14:06:00 - [340]
 

It does now require SQL 2008, yes. (I knew this would be a headache...)

I actually tested this with both clean installs and old EMMA/SQL 2005 installs on both Win XP and Win 7. In ALL cases, I had no problems whatsoever so I had hoped that this would not be a traumatic change.

Have you tried the quick fixes mentioned in the version history and installer readme.txt files? (i.e. deleting those directories, checking the account being used to run SQL, etc)



Julian Koll
The Kollektive
Posted - 2010.04.19 17:16:00 - [341]
 

Point 2 in the readme.txt did the trick


2) Delete the following folder:
Windows Vista: C:\Users\[user]\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
Windows XP: c:\Documents and Settings\[user]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
You may have to stop and restart the SQL EXPRESS service (through control panel -> administrative tools -> services)


All seems to be working fine now

Ambo
I've Got Nothing
Posted - 2010.04.19 17:18:00 - [342]
 

Excellent, glad to hear it. Smile

Quintias
Posted - 2010.04.19 17:23:00 - [343]
 

Originally by: Julian Koll
Point 2 in the readme.txt did the trick


2) Delete the following folder:
Windows Vista: C:\Users\[user]\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
Windows XP: c:\Documents and Settings\[user]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
You may have to stop and restart the SQL EXPRESS service (through control panel -> administrative tools -> services)


All seems to be working fine now


This did the trick for me as well. Thanks for the help

clixoras
Posted - 2010.04.19 17:45:00 - [344]
 

lol. Emma is the only program i know where new versions almost give me a heart attack.

One major question, can i still use my 'old' (2005 sql) data? or do i need to start fresh (again)?

Qintius
Posted - 2010.04.19 17:51:00 - [345]
 

Should check which character I use. Shocked

Julian Koll
The Kollektive
Posted - 2010.04.19 17:56:00 - [346]
 

Originally by: clixoras
lol. Emma is the only program i know where new versions almost give me a heart attack.

One major question, can i still use my 'old' (2005 sql) data? or do i need to start fresh (again)?


copying the old data folder in the freshly installed emma worked fine here

Lost Hamster
Hamster Holding Corp
Posted - 2010.04.19 20:37:00 - [347]
 

I know this is a pain, however the datadump what CCP is releasing is in SQL 2008 format, which is as well a pain to transfer to 2005 format. So from my point it's a good move. :)

Ambo
I've Got Nothing
Posted - 2010.04.19 20:46:00 - [348]
 

Originally by: clixoras
One major question, can i still use my 'old' (2005 sql) data? or do i need to start fresh (again)?


Yes indeedy, 2008 will just auto-convert your old 2005 databases to 2008 format, you won't even realise it happening.

The only difference is that the active database files are no longer kept in the program files directory (or wherever you installed it) Instead, they'll live in %appdata%/emma/data

Originally by: Lost Hamster
I know this is a pain, however the datadump what CCP is releasing is in SQL 2008 format, which is as well a pain to transfer to 2005 format. So from my point it's a good move. :)


Exactly, it was making things difficult for us so I figured it was time to make 2008 a requirement. Plus 2008 seems much more stable and the installation process in particular is less prone to screw ups.

Shandas
Gallente
Garoun Investment Bank
Posted - 2010.04.20 07:19:00 - [349]
 

Edited by: Shandas on 21/04/2010 00:50:56
Edited by: Shandas on 20/04/2010 07:43:36
Looks good, the issue I was going to put here looks fixed in the newer version Nice Job.

Edited to add this question:
When doing an Item Report I can't select a end day it's greyed out and unselectable. It would be nice to be able to select a range of dates instead of having it always end at the current time.

For instance, I want to see what I did yesterday total and not include the current day.

Just a idea/thought.

carmo pereira
Perkone
Posted - 2010.04.21 14:15:00 - [350]
 

Originally by: Grayclay
Ok, I had originally unchecked readonly from the Database file, but then I just unchecked read only for the entire folder and I think when the auto_update file was unchecked it started working. Everything is good now =)


u are my hero!

Ambo
I've Got Nothing
Posted - 2010.04.21 15:30:00 - [351]
 

Originally by: Shandas

Edited to add this question:
When doing an Item Report I can't select a end day it's greyed out and unselectable. It would be nice to be able to select a range of dates instead of having it always end at the current time.

For instance, I want to see what I did yesterday total and not include the current day.

Just a idea/thought.


This is another one that is far more difficult than it sounds. I couldn't think of a way around it without completely redesigning how the report works. That was a long time ago though so I'll have another think about it...

Version 1.4.1.5 Beta is now available.

  • Corrected a bug that caused that list of characters available on an account to not be updated in the report group setup screen (Where you choose eve accounts, characters and corps to be included in a group).

  • Corrected a bug in the autocontractor that detected an infinite loop when there wasn't one. (Issue 31 on the google project page).

  • Added some notifications that make it clearer what's going on when the autocontractor rejects contracts because they don't meet some criteria.


Dariah Stardweller
Gallente
NO U111 Enterprises
Posted - 2010.04.21 19:54:00 - [352]
 

Having a problem with retrieving API information on 'journal'.

I got an account where I linked 2 chars together. They are both on a different Eve account.

One of them updates the journal fine, the other char always get's an error on the journal update. "EVE API error. Code 0. A general error has occured, please try again later.".

Been that way ever since I installed EMMA.

My questions:
1) can I fix this and if yes, how?
2) how does this affect functionality? Are my items reports still accurate for instance? Or Income reports?

Ambo
I've Got Nothing
Posted - 2010.04.21 20:34:00 - [353]
 

Originally by: Dariah Stardweller
Having a problem with retrieving API information on 'journal'.

I got an account where I linked 2 chars together. They are both on a different Eve account.

One of them updates the journal fine, the other char always get's an error on the journal update. "EVE API error. Code 0. A general error has occured, please try again later.".

Been that way ever since I installed EMMA.

My questions:
1) can I fix this and if yes, how?
2) how does this affect functionality? Are my items reports still accurate for instance? Or Income reports?


Actually, this problem is due to an error in the Eve API.

The journal API retrieves the last 1000 journal entries.
If you have more than 1000 journal entries in one week then you can retrieve another 1000 until you get to at least one week ago.
This works by the calling application (i.e. EMMA) supplying a 'beforeRefID' parameter. The API then returns journal entries before that ID.

This worked fine until CCP changed the journal ID from 32 bit to 64 bit.
Unfortunately, they forgot to change the beforeRefID parameter to 64 bit as well. Consequently, every retrieval after the first now always fails.

TLDR You can get the most recent 1000 journal entries but not more. The error just indicates that trying to get more than the most recent 1000 has failed.

Kazuo Ishiguro
House of Marbles
Posted - 2010.04.23 15:07:00 - [354]
 

Edited by: Kazuo Ishiguro on 23/04/2010 15:10:39
Originally by: Ambo
This worked fine until CCP changed the journal ID from 32 bit to 64 bit.
Unfortunately, they forgot to change the beforeRefID parameter to 64 bit as well. Consequently, every retrieval after the first now always fails.


I suppose you've bug-reported this? Any response from CCP?

Also, thanks for this tip:

Quote:
1) Ensure that the following setting is correct:
Start -> Programs -> SQL 2008 -> Config -> config manager.
SQL Server Services -> SQL Server (SQLEXPRESS) -> Properties -> Change login to use 'Local System'


After uninstalling 2005 and installing 2008 on windows 7 it was set to 'network login'. I suspect I might have avoided this if I'd attempted an upgrade, but I just wanted a clean install.

Lost Hamster
Hamster Holding Corp
Posted - 2010.04.23 15:55:00 - [355]
 

Originally by: Kazuo Ishiguro

After uninstalling 2005 and installing 2008 on windows 7 it was set to 'network login'. I suspect I might have avoided this if I'd attempted an upgrade, but I just wanted a clean install.


I doubt, as you can have sql 2005, and 2008 next to each other. I don't think that during the install it gives you the option to upgrade. Rolling Eyes

Santana IV
Heavy Risk...
Posted - 2010.04.24 09:17:00 - [356]
 

Edited by: Santana IV on 24/04/2010 09:30:13
This is the exact message I get with the newest version and SQL 2008:

"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 changed SQL Server (SQLEXPRESS) in Properties to log in to local system, like you said, Ambo. It says in Config Manager: Log on As "LocalSystem", but can't get EMMA to get past the error on startup.

EDIT: Should also say that I restarted my computer, restarted the SQL Express service via control panel and properties (it says it's running) and there are no recent error messages in ExceptionLog.txt (only previous ones that were resolved).

Ambo
I've Got Nothing
Posted - 2010.04.24 09:27:00 - [357]
 

Originally by: Kazuo Ishiguro

Originally by: Ambo
This worked fine until CCP changed the journal ID from 32 bit to 64 bit.
Unfortunately, they forgot to change the beforeRefID parameter to 64 bit as well. Consequently, every retrieval after the first now always fails.


I suppose you've bug-reported this? Any response from CCP?


I personally haven't but plenty of others have. There was a thread in the tech lab about it a while back. I assume it's on CCP's to do list.

Originally by: Santana IV
This is the exact message I get with the newest version and SQL 2008:

"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 changed SQL Express in Properties to log in to local system, like you said, Ambo.


Have you also tried deleting the SQL data folder?

(Windows Vista: C:\Users\[user]\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
Windows XP: c:\Documents and Settings\[user]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS)




Santana IV
Heavy Risk...
Posted - 2010.04.24 09:31:00 - [358]
 

I'm running 7 x64. Is there anything for me to delete, or does that step only apply to XP/Vista?

Mme Pinkerton
The pink win
Posted - 2010.04.24 10:44:00 - [359]
 

Originally by: Santana IV
I'm running 7 x64. Is there anything for me to delete, or does that step only apply to XP/Vista?

applies to Windows 7 as well

(in general: if some advice is true for Windows Vista, it is probably also true for Windows 7)

Santana IV
Heavy Risk...
Posted - 2010.04.24 20:10:00 - [360]
 

Thanks a lot! I deleted and EMMA works :D


Pages: first : previous : ... 8 9 10 11 [12] 13 14 15 16 ... : 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