A save operation on table ‘syUserTasks’ (45)

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi All,

We are getting the below error for few users in GP.

A save operation on table ‘syUserTasks’ (45)

Please let us know if there is any solution to fix the same.

Regards,

Leodwin

*This post is locked for comments

All responses (10)

Answers (0)

hoshang 55 on at

Like (0)

Report

RE: A save operation on table ‘syUserTasks’ (45)

well done...

http://www.sora.edu.iq
Suggested answer

soma 24,406 on at

Like (0)

Report

RE: A save operation on table ‘syUserTasks’ (45)

How did you renamed the system database?

Have you followed the steps mentioned from the KB article 878449?

Also have a look on the below link.

blogs.msdn.com/.../using-the-named-system-database-feature-for-microsoft-dynamics-gp-2013.aspx

Hope this helps!!!
Community Member Microsoft Employee on at

Like (0)

Report

RE: A save operation on table ‘syUserTasks’ (45)

The issue started after we migrated from GP 2010 to GP 2013 and started hosting all the GP instance on asingle instance of SQL 2012(GP 2013 we renamed all the DYNAMICS db with Prefixing 3 letters of their organization name followed by DYN. (eg..ABCDYN ).
Jonathan Fear on at

Like (0)

Report

RE: A save operation on table ‘syUserTasks’ (45)

Any update on this?
Jonathan Fear on at

Like (0)

Report

RE: A save operation on table ‘syUserTasks’ (45)

What does a Dexsql.log show?
Community Member Microsoft Employee on at

Like (0)

Report

RE: A save operation on table ‘syUserTasks’ (45)

Hi leodwin

Make sure all the users are under DYNGRP role.

go into SQL Management Studio and add the corresponding SQL login to the DYNGRP in the DYNAMICS database.
Community Member Microsoft Employee on at

Like (0)

Report

RE: A save operation on table ‘syUserTasks’ (45)

Hi Nataraj,

The user gets this error after login. once the home screen loads.

I tried to delete the user and recreate but still the issue is reappearing.

Thanks
Community Member Microsoft Employee on at

Like (0)

Report

RE: A save operation on table ‘syUserTasks’ (45)

i did query this table and could not locate any blank record. I dont know to identify a damaged record.
Community Member Microsoft Employee on at

Like (0)

Report

RE: A save operation on table ‘syUserTasks’ (45)

Hi leodwin,

can you specify the point of error occurrence?
L Vail 65,271 on at

Like (0)

Report

RE: A save operation on table ‘syUserTasks’ (45)

Hi Leodwin,

Look at table SY01403 in your Dynamics database and check for a blank or damaged record.

Kind regards,

Leslie