SmartList won't open for a specific user

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (9)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: SmartList won't open for a specific user

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: SmartList won't open for a specific user

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!
Bill Campbell 22,647 on at

Like (0)

Report

RE: SmartList won't open for a specific user

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.
L Vail 65,271 on at

Like (0)

Report

RE: SmartList won't open for a specific user

Clint,

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

Leslie
Suggested answer

soma 24,406 on at

Like (0)

Report

RE: SmartList won't open for a specific user

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!!!
Suggested answer

babubaskaran@outloo... on at

Like (0)

Report

RE: SmartList won't open for a specific user

Hi Clint,

Have you checked the language for unicode under Region and Language and change it to English (country)
KirkLivermont 5,985 on at

Like (0)

Report

RE: SmartList won't open for a specific user

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: SmartList won't open for a specific user

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.
soma 24,406 on at

Like (0)

Report

RE: SmartList won't open for a specific user

Please have a look on the below link.

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

Hope this helps!!!