unable to manually update stock prices after running sunriise-Build_20110706_31-app.jar

[GoogleCodeExporter]

Windows 7 Ultimate 64bit 
Money 2002 Financial Suite Version 10 (UK)
Java JRE6

After updating the stock prices using sunriise-Build_20110706_31-app.jar  I can 
no longer perform a manual update of the stock but can continue updating using 
sunriise-Build_20110706_31-app.jar  

If I repair the money file using m06 salvage then I can manually update the 
stock prices but I can no longer update using 
sunriise-Build_20110706_31-app.jar  errors with a java exception.

Step 1 (attached money2002-test-step1.mny) 
Create a money file with stock entries; manual update works

Step 2 (attached money2002-test-step2-Manual UpdateNotWorking.mny, 
QuotesImport.csv, sunriise -Build_20110706_31-app.jar, 04-02-2012_Quote 
Import.log  )
update the money file using sunriise -Build_20110706_31-app.jar  and attached 
stock  csv 

"C:\Program Files\Java\jre6\bin\java" -cp "sunriise-Build_20110706_31-app.jar" 
com.le.sunriise.quote.UpdateStockPrices  QuotesImport.csv money2002-test.mny

Manual updates now stop working you can enter a price but when you hit update 
then nothing happens

Step 3 (attached money2002-test -step3-AfterRepairManulUpdateWorking.mny , 
m06-repair.exe)
Carry out repair on the money file using m06-repair 
The repaired file  can now update the stock manually

Step 4

Repeat step 1 and the money file is not updated and the log file shows 
java.io.IOException: java.lang.IllegalStateException: Incorrect password 
provided :-
===================
04/02/2012 
15:00:58.05 
0 [main] INFO  
com.le.sunriise.quote.UpdateStockPrices.main(UpdateStockPrices.java:384) - 
quotesFile=\Users\Paul\Documents\!Finance\MSMoney\hleOfx\HandLimport\QuotesImpor
t.csv
0 [main] INFO  
com.le.sunriise.quote.UpdateStockPrices.main(UpdateStockPrices.java:385) - 
inFile=\Users\Paul\Documents\!Finance\MSMoney\TestMoneyFile\money2002-test.mny
15 [main] INFO  com.le.sunriise.Utils.openDb(Utils.java:88) - > Database.open, 
dbFile=\Users\Paul\Documents\!Finance\MSMoney\TestMoneyFile\money2002-test.mny
15 [main] INFO  com.le.sunriise.Utils.openDb(Utils.java:95) - Created db lock 
file=D:\Users\Paul\Documents\!Finance\MSMoney\TestMoneyFile\money2002-test.lrd
93 [main] INFO  com.le.sunriise.Utils.openDb(Utils.java:108) - < Database.open, 
dbFile=\Users\Paul\Documents\!Finance\MSMoney\TestMoneyFile\money2002-test.mny
93 [main] ERROR 
com.le.sunriise.quote.UpdateStockPrices.main(UpdateStockPrices.java:391) - 
java.io.IOException: java.lang.IllegalStateException: Incorrect password 
provided
93 [main] INFO  
com.le.sunriise.quote.UpdateStockPrices.main(UpdateStockPrices.java:393) - < 
DONE
15:00:58.45 
===================
=================== 

Regards

Paul

Original issue reported on code.google.com by progers...@hotmail.com on 4 Feb 2012 at 3:50

Attachments:

• TestMoneyFile.rar

[GoogleCodeExporter]

Will take look at this tonight.

Original comment by hle...@gmail.com on 5 Feb 2012 at 3:16

• Changed state: Accepted
• Added labels: Priority-High
• Removed labels: Priority-Medium

[GoogleCodeExporter]

Thanks,

Forgot to mention in step 3 that when I run the mo6-repair code (salv.exe) the 
results log contains:-

"No broken records in the original file."

However it does resolve the manual update problem but breaks the 
UpdateStockPrices code.

Original comment by progers...@hotmail.com on 5 Feb 2012 at 4:04

[GoogleCodeExporter]

Sorry. Have not been able to spend anytime on this. Will have to think about 
how to debug this.

Original comment by hle...@gmail.com on 9 Feb 2012 at 3:25

[GoogleCodeExporter]

Thats ok,

I revisited this code at Christmas and ran a whole load of test imports which 
worked ok so I went live with it, it was not until I needed to manually update 
a holding which I can not download that I discovered the problem, I can work 
around this by manually adding an entry in the csv file I download from my 
broker, this will continue to work as long as I don't have to repair the money 
file. 

I know I could also go back to just importing into a dummy share account but 
sunriise saves all this hassle as it can all handled by a macro in the excel 
worksheet that converts the quotes I download from my broker into the format 
sunriise requires, then runs the sunriise code.

Let me know if you need anything from me, I can supply the version of money I 
use if of any help

Original comment by progers...@hotmail.com on 9 Feb 2012 at 12:20

[GoogleCodeExporter]

Hello,

I have looked at this again and I believe there are two different problems:-

1) sunriise Java exception after repair has been run on money file
After experimentation if the money file is not compressed when closing money 
then this does not happen so it is something to do with the file being 
compressed after a repair has been performed.

2) after using sunriise  to update prices unable to perform a manual update of 
stock prices ie add a new date and price.

I thought I would try and give you some more information on this so I:-
a) ran an update on the moneyfile
b) ran repair on the moneyfile
c) exported the moneyfile to csv (attached Test-R directory) 
d) repeated step a) with the same update csv
e) exported the moneyfile to csv (attached Test-U directory) 
f) I then ran a binary compare between the contents of Test-R and Test-U 
directories to see what files had been changed (attached diff.pdf)  

I don't know if this is helpful to you, being optimistic you might recognise 
one of the files in diff.pdf as being out of place.

Regards

Paul

Original comment by progers...@hotmail.com on 16 Feb 2012 at 8:40

Attachments:

• Issue53.rar

[GoogleCodeExporter]

Hi
I'm experiencing the same behaviour using sunriise-Build_20110628_19-app.jar on 
my side (french environment).
Is there a newer version fixing this issue ?

Original comment by jean.rot...@gmail.com on 24 Jan 2014 at 7:29