Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Dexterity Test Mode Error

(0) ShareShare
ReportReport
Posted on by 725

Hi,

I have recently gotten a new machine.  Whenever I try to to go to test mode in Dexterity, I receive the following messages:

"A get/change operation on  table 'syUserDefaults' cannot find the table"

click more info and get:

"Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'SY01402'."

If I click OK and try to log in again I receive the following error:

"Your attempt to log into the serve failed because the user ID you entered is already logged in. Remove the log in record from the server and attempt to log in again".

I cannot figure out what is wrong.  I have copied the dex.ini file from my GP2010 folder to the data folder in the Microsoft Dexterity folder with the same result.  The only thing I can think of is that Dex is installed in Program Files (x86) folder but that makes no sense since I am receiving a SQL error.  Perhaps it is something to do with the ODBC connection?  It is the same one I use to connect to GP normally and I have no problems unless going through Dex.

Any help would be appreciated,

Catherine

*This post is locked for comments

  • Verified answer
    Cath Profile Picture
    Cath 725 on at
    RE: Dexterity Test Mode Error

    Hi Leslie,

    I just figured it out!  I was installing Dex from a network drive.  Worked just fine, or so I thought.  I removed dexterity completely and ran the setup from my machine and it eliminated the problem.  I guess the install was not completing properly.

    But thanks so much for your help!  I really appreciate your answer,

    Cath

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Dexterity Test Mode Error

    Hi Catherine,

    I've saw this error message last two week. I can't recall what I did to fix it just now, but tell me a little about your environment. What version of Dynamics are you running? Do you have more than one instance installed? If you're using any modified forms or reports, rename the dictionary. Are you running Mekorma MICR? I think you answered this from your comments, but can you launch Dynamics on its own just fine?

    Kind regards,

    Leslie

    PS In the mean time, I'll hunt my head trying to remember what solved it.

    LVail

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans