Page 1 of 1

Financial Transfer Error for MLS

Posted: Sun Jan 23, 2011 6:27 pm
by edslack34
When we tried to transfer financial records this week we got the following error:

Unable to create the List record for (Batch). Reason: (Generic Oracle Error). Contact Administration Office: (26259501051) (ORA-20100: (Unit 262595) List Date 20110206 is not between 14-Jul-02 and 18-Jan-11 ORA-06512: at "LURBS2_ADMIN.TRG_LISTS", line 41 ORA 04088: error during execution of trigger 'LURBS2_ADMIN.TRG_LISTS')

If anybody has had similar problems or knows how to help out that would be greatly appreciated. Not sure if this is of any use, but a few weeks ago MLS skipped to a date in late December 2010 and has not changed since. Things have been somewhat strange with it for a while.

Thanks a ton

Posted: Sun Jan 23, 2011 7:27 pm
by jdlessley
What do you mean when you say you tried to transfer financial records? Do you mean you tried to do a send/receive? If it was a send/receive, then from the information provided, it looks like the date on the computer was 18 Jan 2011 and a date used in the batch or some other transaction was 6 Feb 2011.

I would first check to see that the computer system date has not been changed and reads to be the actual current date. If the system date had been changed some time in the past to a future date and then changed to the correct date later on you will have problems if any financial transactions were entered while the computer was on a future date.

If that is what happened then take a look at the section Changing the system datein the wiki article Member and Leader Services.

Another possibility is that the database has become corrupted. You will need to contact LUS to have this corrected.

Posted: Sun Jan 23, 2011 10:30 pm
by russellhltn
I'd check that the date for the donation batches are correct.