You’re offline. This is a read only version of the page.
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
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.
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!
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.
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!!!
Hi Clint,
Have you checked the language for unicode under Region and Language and change it to English (country)
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (