Reply to topic

Search and Process fails

janko
Registered Member
Posts
6
Karma
0

Search and Process fails

Fri Mar 01, 2019 9:53 pm
Hi,

The update rules I had for ages recently started to fail with the error:

[ERR-5]: Process execution failed
[ERR-5]: Rule 3 failed
[ERR-10019]: UNIQUE constraint failed: category.t_name, category.rd_category_id Unable to fetch row
[ERR-10019]: UPDATE category SET rd_category_id=0 WHERE rd_category_id IS NULL OR rd_category_id=''

I'm on Skrooge 2.18.0

Any ideas what may be going on?

Thanks,
Janko
User avatar smankowski
Moderator
Posts
953
Karma
7
OS

Re: Search and Process fails

Sat Mar 02, 2019 11:08 am
Hi,

Could you post here a screen capture of your 3th rule ?


Skrooge, a personal finances manager powered by KDE
Image
janko
Registered Member
Posts
6
Karma
0

Re: Search and Process fails

Sat Mar 02, 2019 12:36 pm
Hi Stephane,

Sent you an email with the screenshot. BTW, I used 10th rule instead of 3rd one as an example because it gives the same error while being less sensitive to share.

Thanks again for your help,
Janko
User avatar smankowski
Moderator
Posts
953
Karma
7
OS

Re: Search and Process fails

Mon Mar 04, 2019 9:20 am
Thank you for the screenshot.
I have an idea. I will analyze and come back to you.
Regards.


Skrooge, a personal finances manager powered by KDE
Image
User avatar smankowski
Moderator
Posts
953
Karma
7
OS

Re: Search and Process fails  Topic is solved

Wed Mar 06, 2019 9:01 pm
Could you check in "Category" page if you have some categories duplicated (Same name + same parent)?
If yes, could you remove that and try again the "Search & Process" ?


Skrooge, a personal finances manager powered by KDE
Image
janko
Registered Member
Posts
6
Karma
0

Re: Search and Process fails

Wed Mar 06, 2019 10:52 pm
Hi,

Thanks, I managed to find 2 different categories with identical names (not sure how I ended up in this situation, I didn't even have any operations in either category). After removing them ,"Search and Process" started working again.

Thanks again for your help!

 
Reply to topic

Bookmarks



Who is online

Registered users: Baidu [Spider], Bing [Bot], boudewijn, davide445, everwaerde, Google [Bot], hiteshshah, madkhoram, Mamarok, millaan, philippea, raphaelra, Sanette