SmartList won't open for a specific user

(0) Share

Report

Posted on by Community Member

We are using GP 2013 on a terminal server. I think this should eliminate DEX.INI as the culprit. Other users are unaffected and I do not see SmartList running in the task manager on this user's machine.

I tried to use a script I found in another forum post but it did not resolve the issue:

update sy01402 set SYUSERDFSTR = 'TRUE~506~792~1~1~177~' where USERID = 'affecteduser' and syDefaultType = '96'

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

soma 24,410 on at

Like (0)

Report

Please have a look on the below link.

community.dynamics.com/.../120847.aspx

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for the reply! That is the other forum post that I was working from. However, following the steps did not resolve my issue.

Was this reply helpful? Yes No
KirkLivermont 5,985 on at

Like (0)

Report

Hi Clint,

I am not sure if that value was unique to my environment or not. What is the result of running select * from SY01402 where syDefaultType = '96'? Can you update the value to match that of a user that you know smartlist is working for?

Regards,

Kirk Livermont

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Clint,

Have you checked the language for unicode under Region and Language and change it to English (country)

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

If the users machine smartlist list window open with empty, then follow the Mr.Babu suggestion.

If users not able to open the smartlist window, run the below query to check the result values and update the table with appropriate match values.

select * from SY01402 where syDefaultType = '96'

Hope this helps!!!

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Clint,

If the problem user logs in as someone else can he open the SmartList window?

Leslie

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

Something happened yesterday that makes me make this post.

I had a client for whom we created a specific TEST database - assigned only to one user.

When we were done with the TEST work - the IT managers asked us to remove the database - we used the DELETE database from within the application and to remove the company and encountered the error that the database was not available.

We looked at the SQL Server and learned that the IT tech decided that the note from her boss meant, REMOVE the database from SQL Server - so ....

Now we have to use Clear Company to get the database reference removed.

Having done this we now encounter an error for the Smartlist where it will not load.

There is a post on the forum that discusses this - if this is your issue - if not, sorry to take your time with this post.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Everyone,

I changed the value in SY01402 where syDefaultType = '96' several times with no luck. The user was able to open SmartList when logged in as someone else, so I ended up creating a new user and copying the user's security. When logged in as the new SQL user, they are now able to open SmartList.

Thanks everyone for your time!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Did you ever resolve this issue? I'm having the same problem...I change the value for this user in sy01402, but as soon as they open/log into GP the setting goes back to it's original crazy value.

Was this reply helpful? Yes No