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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Journal/Transaction ID's Different
Author
Previous Topic Next Topic
Mr Grape Drink
Doomheim
#1 - 2015-11-05 14:54:50 UTC
For some reason, in my second corp wallet division, there are some differences between the RefID in the Journal and the journalTransactionID in the transactions when looking at the API.

The ID in the transactions is 2 higher in the cases where they don't match, but some do match, so I cant cheat and just add 2 to ID from the journal :(

Thoughts?
Hel O'Ween
Men On A Mission
#2 - 2015-11-05 17:33:42 UTC
Are you by any chance buying to/selling from yourself?

EVEWalletAware - an offline wallet manager.
Mr Grape Drink
Doomheim
#3 - 2015-11-05 17:54:47 UTC  |  Edited by: Mr Grape Drink
Hel O'Ween wrote:
Are you by any chance buying to/selling from yourself?


I'm sure I've done a few where I put up an order for corp and fill it with the account that set up the order. Other than that, nope.

An example:

Corp Journal:

row date="2015-11-05 07:43:13" refID="11855652155" refTypeID="2" ownerName1="strapping" ownerID1="1456595819" ownerName2="Triage Trogdor" ownerID2="90005521" argName1="4118932237" argID1="0" amount="719838052.04" balance="3762182568.68" reason="" owner1TypeID="1385" owner2TypeID="1379"/>

Transaction:

row transactionDateTime="2015-11-05 07:43:13" transactionID="4118932237" quantity="2" typeName="ORE Expanded Cargohold" typeID="34489" price="359919026.02" clientID="1456595819" clientName="strapping" characterID="90005521" characterName="Triage Trogdor" stationID="60003760" stationName="Jita IV - Moon 4 - Caldari Navy Assembly Plant" transactionType="sell" transactionFor="corporation" journalTransactionID="11855652157" clientTypeID="1385"/>
Hel O'Ween
Men On A Mission
#4 - 2015-11-06 16:05:53 UTC
Damn it. This "is 2 off" with WJ <-> WT rings some bells, but for the life of it, I don't remember what exactly.

So I'm going to point out some obvious things from the XML excerpts you have posted in an attempt to hint you onto the right track:

* Check the XML, not your database. You may have missed a line

* Is there a journal entry with refID 11855652157? If so, what's in it?

* Look at all journal entries xxx55, xxx56, xxx57. There's something with taxes/fees in between.

* Check for indentical transactionIDs/refIDs in char and corp XML. At least for transactionID I know that its guaranteed to be unique - for transactions. Meaning: both involved parties (buyer/seller) share the same transactionID

For example my EWA does check for the existance of a transaction by doing.

"SELECT COUNT(ID) AS RecCount FROM myTransTable WHERE transactionID = (value of transactionID) AND transactionFor =(value of transactionFor) AND transactionType = (value of transactionType);

I keep all transactions across characters/corps in one table. Leaving out the transactionFor and transactionType would otherwise report false positives. (Was a bug of EWA back then Oops).

EVEWalletAware - an offline wallet manager.