web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Not able to activate M...
Microsoft Dynamics AX (Archived)

Not able to activate MPOS AX 2012 CU9

(0) ShareShare
ReportReport
Posted on by SumitPotbhare 2,890

On activation screen I am getting "There was a problem signing in.Try entering the operator ID and password"

I am getting below error in eventvwr-

Non-CommerceRuntimeException was thrown.System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ISPUBLISHEDTOLOCAL'.

User '000160' logon request (type - 'PasswordWithNoDevice') on device '' using 'LocalDatabase' threw an exception: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ISPUBLISHEDTOLOCAL'.

Exception occured: [7/8/2015 9:28:00 AM] Microsoft.Dynamics.Commerce.Runtime.UserAuthenticationException: Exception of type 'Microsoft.Dynamics.Commerce.Runtime.UserAuthenticationException' was thrown.

*This post is locked for comments

I have the same question (0)
  • SumitPotbhare Profile Picture
    SumitPotbhare 2,890 on at

    Now I am getting this error. Has anybody encountered this.

    In the Device form it is updating as Activated by then giving error.

    Exception occured: [07/10/2015 13:40:25] System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

      at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__1.MoveNext()

    --- End of stack trace from previous location where exception was thrown ---

      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

      at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

      at Microsoft.Dynamics.Retail.RetailServerLibrary.BufferResponseContentAttribute.<ExecuteActionFilterAsync>d__0.MoveNext()

    --- End of stack trace from previous location where exception was thrown ---

      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

      at System.Web.Http.Tracing.ITraceWriterExtensions.<TraceBeginEndAsyncCore>d__21`1.MoveNext()

    --- End of stack trace from previous location where exception was thrown ---

      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

      at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

      at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()

    --- End of stack trace from previous location where exception was thrown ---

      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

      at System.Web.Http.ApiController.<InvokeActionWithExceptionFilters>d__1.MoveNext()

  • tyhj Profile Picture
    tyhj 629 on at

    I'm having same error as your first post. How do you resolve it ?

  • SumitPotbhare Profile Picture
    SumitPotbhare 2,890 on at

    I did a lot of steps and was unable to fix it. So finally I copied the Retail server and Modern POS folder from VM and added the connection string in the Retail server Web.config file. It worked then. But now it is only working for my Houston Store DB.

    I tried to create another channel DB for FRRT for Paris Store and tried to activate the mPOS after deactivating from Houston, but I was not able to configure. I am still not able to find out the reason.

  • tyhj Profile Picture
    tyhj 629 on at

    What did you change in the connection string ? Did you use win 8.1 or win server 2012 R2 ? I see that my connection string already had the correct server and database. 

    I find very limited info on the internet, thanks to your reply that let me know I'm not the only one facing this issue :) 

  • Suggested answer
    Camilo Virguez Profile Picture
    Camilo Virguez 3 on at

    HI Sumit,  have you restarted IIS for the retail server.  that normally helps with refreshing the latest communication.  Also, from what i see you are doing all of this in an internal VM.  if you are doing it from an external you need to check your certificates and your routing.

  • Community Member Profile Picture
    Community Member on at

    Hi Sumit, all,

    I am encountering the same error message on Visual Studio while debugging the POS (Windows 8.1) solution. This error message was captured from Fiddler:

    VS_2D00_POS_2D00_KeyNotFoundException.png

    On the same machine I have installed the Retail POS (i.e. ePOS) and the Retail Modern POS clients and both of the applications were activated and logged in successfully. However when using Visual Studio to debug the solution which is hosted on the same machine, it is throwing the above error.

    How have you fixed the issue? And if yes, can you please send me the solution?

    Thanks,

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sanhthosh.Kumar.K Profile Picture

Sanhthosh.Kumar.K 2

#2
Raed Salah Bzour Profile Picture

Raed Salah Bzour 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans