After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 677651 - Scheduled Transactions Disappear when set to Postponed
Scheduled Transactions Disappear when set to Postponed
Status: RESOLVED DUPLICATE of bug 672760
Product: GnuCash
Classification: Other
Component: Scheduled Transactions
2.4.x
Other Linux
: Normal normal
: ---
Assigned To: Christian Stimming
gnucash-core-maint
Depends on:
Blocks:
 
 
Reported: 2012-06-07 21:15 UTC by Tommy Trussell
Modified: 2018-06-29 23:09 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Tommy Trussell 2012-06-07 21:15:40 UTC
For at least the last couple of releases I have noticed that when I set scheduled transactions to "Postponed" they do not reappear on the next launch of the application. In previous releases, the transactions would remain with the "Postponed" status. (I have not read a specification for the feature but having the transactions revert to "To-Create" on the next run would be acceptably predictable behavior. Having them disappear is unexpected!)

P.S.: I just searched and saw a couple of other open (unconfirmed) bugs with Scheduled Transactions -- Bug 543212 and Bug 672760 -- HOWEVER I have NOT seen either of the behaviors listed in those bugs, so I cannot confirm them.
Comment 1 Tommy Trussell 2012-06-08 02:01:23 UTC
I just created a minimal data file with a minimal chart of accounts. I created a Utility Bill for $10, dated it the beginning of the month. After I entered it I scheduled it to recur weekly.

I chose Scheduled Transactions --> Since Last Run

the transaction showed up as "To Create."

I set it to "Postponed."

I chose Scheduled Transactions --> Since Last Run

The transaction showed as Postponed.

I quit the application and restarted it.

In this situation, the transaction still shows up as Postponed, however it shows the effective date as 12/31/1969.



I just noticed messages on the console when I open a copy of my regular data file (where the postponed transactions are missing). I don't get any unusual messages when I open my minimal TEST data file.

For the copy of my regular data file, I get the following messages on the console:


This is a development version. It may or may not work.
Report bugs and other problems to gnucash-devel@gnucash.org.
You can also lookup and file bug reports at http://bugzilla.gnome.org
The last stable version was GnuCash 2.4.10
The next stable version will be GnuCash 2.6

Found Finance::Quote version 1.17
<sx:deferredInstance>
    <sx:rem-occur>160211524</sx:rem-occur>
    <sx:instanceCount>168298164</sx:instanceCount>
  </sx:deferredInstance><sx:deferredInstance>
    <sx:rem-occur>161922732</sx:rem-occur>
    <sx:instanceCount>0</sx:instanceCount>
  </sx:deferredInstance><sx:deferredInstance>
    <sx:rem-occur>1667457325</sx:rem-occur>
    <sx:instanceCount>161677428</sx:instanceCount>
  </sx:deferredInstance><sx:deferredInstance>
    <sx:rem-occur>167353276</sx:rem-occur>
    <sx:instanceCount>161085780</sx:instanceCount>
  </sx:deferredInstance><sx:deferredInstance>
    <sx:rem-occur>1953524082</sx:rem-occur>
    <sx:instanceCount>7237481</sx:instanceCount>
  </sx:deferredInstance><sx:deferredInstance>
    <sx:rem-occur>167611476</sx:rem-occur>
    <sx:instanceCount>161217268</sx:instanceCount>
  </sx:deferredInstance><sx:deferredInstance>
    <sx:rem-occur>161993860</sx:rem-occur>
    <sx:instanceCount>162576068</sx:instanceCount>
  </sx:deferredInstance><sx:deferredInstance>
    <sx:rem-occur>0</sx:rem-occur>
    <sx:instanceCount>169057740</sx:instanceCount>
  </sx:deferredInstance><sx:deferredInstance>
    <sx:rem-occur>161467684</sx:rem-occur>
    <sx:instanceCount>161849396</sx:instanceCount>
  </sx:deferredInstance><sx:deferredInstance>
    <sx:rem-occur>159216948</sx:rem-occur>
    <sx:instanceCount>0</sx:instanceCount>
  </sx:deferredInstance><sx:deferredInstance>
    <sx:rem-occur>155283660</sx:rem-occur>
    <sx:instanceCount>0</sx:instanceCount>
  </sx:deferredInstance><sx:deferredInstance>
    <sx:rem-occur>166798124</sx:rem-occur>
    <sx:instanceCount>0</sx:instanceCount>
  </sx:deferredInstance>
Comment 2 Tommy Trussell 2012-06-08 02:33:34 UTC
Another data point... I made a FRESH copy of my actual gnucash data file with up-to-the-minute data and the above messages are gone. I suspect that whatever is going on with the missing scheduled transactions gets zeroed out after running the since-last-run and save process more than once. 

I will try to save a copy of the data file that created the messages above in case it's useful.
Comment 3 Volker Englisch 2012-06-08 04:23:51 UTC
Sounds to me that you're experiencing the same issue that I had reported in Bug 543212 but your transactions disappear into the past while mine were set to future dates.  As a workaround I never set my TX to 'Postponed' anymore, instead I'm setting them back to 'Reminder' which does work as expected.
Comment 4 Tommy Trussell 2012-06-08 17:39:40 UTC
@Volker Englisch: the past/future issue may be somewhat of a red herring here -- I am not an experienced programmer but when I see a 1969 date in Linux I believe it indicates a data storage issue -- I believe it means the stored digit representing the date is a small negative number. It might as well be hundreds or thousands of years in the future -- the bits all rolled over to zero or a negative number. Especially if you are running Windows or Macintosh (I couldn't tell immediately from your bug report), the underlying data may be being stored the same way in the data file but what to you is a future date on Windows or Macintosh for Linux could be a 1969 date.

OH and I didn't mention before -- I am using the "standard" XML data file, and you (Volker Englisch) may be using SQLite or another database for your storage. That could explain a difference in the way dates are displayed.

On my "actual" data (as opposed to the clean test file I created that shows the 1969 date) the Postponed items disappear from view on the next application launch, but I get messages on the console that seem to indicate they're still around. Then (apparently) on future launches they get purged, possibly by a separate process. (Possibly there's a sanity check on the XML data that automatically purges garbage data? I really don't know; I'm just speculating.)  

I looked through the sx code enough to see that it would take me a few hours to diagram out how the statuses get set and stored, but mostly because I'm not an experienced C programmer.
Comment 5 Volker Englisch 2012-06-08 17:55:34 UTC
(In reply to comment #4)
> OH and I didn't mention before -- I am using the "standard" XML data file, 

So am I running on Ubuntu 11.10.
Comment 6 Tommy Trussell 2012-06-09 04:17:59 UTC
SO we're both on Ubuntu, so that doesn't explain the date differences! (THAT would be too easy, wouldn't it! There COULD be a library difference between 10.04 and your 11.10, but my next upgrade on that system will be to Ubuntu 12.04 LTS.)

It sounds like there may be serious problems with the SX logic and/or how the data gets stored or represented in memory. Logically there shouldn't be any difference between the scheduled transactions in a newly-created minimal data file versus my gigantic file with transactions going back many years. But there seems to be.

I have not yet dug in to look at the actual XML that's getting stored on disk, but that's next, as soon as I get a chance. I'll also review Bug 543212 and see what I can replicate on mine. 

I suspect you are right and we ARE seeing consequences of the same underlying bug.
Comment 7 Geert Janssens 2015-02-11 10:14:53 UTC
This may be a duplicate of bug 672760 which will be fixed in 2.6.6.

Windowws users could already test this by downloading and installing a recent nightly build from http://code.gnucash.org/builds/win32/maint/
Comment 8 Geert Janssens 2015-02-11 10:15:29 UTC
Or if you know how to build gnucash on linux, you can build the maint branch to run the same test.
Comment 9 John Ralls 2015-09-21 22:55:00 UTC
Thanks for taking the time to report this.
This particular bug has already been reported into our bug tracking system, but please feel free to report any further bugs you find.

*** This bug has been marked as a duplicate of bug 672760 ***
Comment 10 John Ralls 2017-09-24 22:41:44 UTC
Reassign version to 2.4.x so that individual 2.4 versions can be retired.
Comment 11 John Ralls 2018-06-29 23:09:02 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=677651. Please update any external references or bookmarks.