105
Dear All,
I have MPOS installed and working with the Online database. Setup is also done for the offline database option. The offline database name is available. In the SQL server, I have seen a database created,
If I want to connect offline, by switch option it is giving error 'you cant not switch to the offline mode. either the offline components are not installed or login failed. try to login again'
Please help me
Warm regards
Murthy
Hi Murthy,
You might have to enable the Offline toggle in the registers form as shown below.
And run 1090 Job for changes to get applied.
Hi
1. I am uninstalling and deleting database 'RetailOfflineDatabase' also
2. also downloaded from LCS asset ;libraries along with regular HQ version but both are same in size.
3. given all SQL roles to current Windows user on the PC
Do need to give more permissions to 'sa' user'??
Warm regards
As per the log, the creation of [crt].[RETAILOFFLINEPRODUCTSBYCHANNELVIEW] is failing as RETAILOFFLINEPROFILESETTINGSBYCHANNEL object doesn't exist. Are you doing a fresh installation of the offline database? If the offline DB already existed, try deleting the DB and running the installer again. If you are using an old installer, you could try the latest version as well. If the issue still persists, please raise a ticket with MS.
[View:/cfs-file/__key/communityserver-discussions-components-files/797/DeployMPosOfflineDB.log:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/797/Configure_2D00_RetailModernPOS.log:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/797/DeployMPosOfflineDB.log:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/797/DeployRetailModernPOS.log:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/797/error.log:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/797/Install_2D00_MsiRetailModernPOS.log:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/797/Install_2D00_RetailModernPOS.log:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/797/Install_2D00_RetailModernPOS.log:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/797/Register_2D00_PerfCounters.log:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/797/SelfService.Setup.App.PrerequisiteEvaluation.log:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/797/Uninstall_2D00_Msi.log:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/797/Uninstall_2D00_RetailModernPos.log:320:240]
Can you share the log files from this directory?
C:\ProgramData\Microsoft Dynamics AX\Retail Self-service\Logs\SetupApp\2023-01-01_18-51-57
Hi
This user has all privilege's. I can open database with this user..
As I was telling before there was error while installing MPOS, I have have closed and it was saying about some log files. I have copied one of the logfile hereunder.
=============================
[01/01/2023 18:53:12] :: Check if user is NT System
[01/01/2023 18:53:12] :: No. Skipping script execution prerequisites under NT System.
[01/01/2023 18:53:12] :: Environment information:
[01/01/2023 18:53:12] :: Is64BitOperatingSystem = True
[01/01/2023 18:53:12] :: Is64BitProcess = True
[01/01/2023 18:53:12] :: PSVersionTable
[01/01/2023 18:53:12] ::
Name Value
---- -----
PSVersion 5.1.19041.2364
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.19041.2364
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1
[01/01/2023 18:55:03] ::
PSMessageDetails :
Exception : System.Management.Automation.RuntimeException: 200061
TargetObject : 200061
CategoryInfo : OperationStopped: (200061:Int32) [], RuntimeException
FullyQualifiedErrorId : 200061
ErrorDetails :
InvocationInfo : System.Management.Automation.InvocationInfo
ScriptStackTrace : at Throw-Error, C:\Users\Pos-Ro3317\AppData\Local\Temp\ModernPosSetupOffline.content\content\ConfigureRetailComponents\ErrorHandling.psm1: line 69
at <ScriptBlock>, C:\Users\Pos-Ro3317\AppData\Local\Temp\ModernPosSetupOffline.content\content\ConfigureRetailComponents\DeployComponent.ps1: line 91
at <ScriptBlock>, <No file>: line 1
at <ScriptBlock>, <No file>: line 1
PipelineIterationInfo : {}
[01/01/2023 18:55:03] :: Exception stack trace:
at Throw-Error, C:\Users\Pos-Ro3317\AppData\Local\Temp\ModernPosSetupOffline.content\content\ConfigureRetailComponents\ErrorHandling.psm1: line 69
at <ScriptBlock>, C:\Users\Pos-Ro3317\AppData\Local\Temp\ModernPosSetupOffline.content\content\ConfigureRetailComponents\DeployComponent.ps1: line 91
at <ScriptBlock>, <No file>: line 1
at <ScriptBlock>, <No file>: line 1
[01/01/2023 18:55:03] :: script aborted with error code: 200061
[01/01/2023 18:55:03] :: Log target directory is [C:\ProgramData\Microsoft Dynamics AX\Retail Self-service\Logs\SetupApp\2023-01-01_18-51-57]
[01/01/2023 18:55:03] :: Moving logs [C:\Users\Pos-Ro3317\AppData\Local\Temp\ModernPosSetupOffline.content\content\ConfigureRetailComponents\*.log] to [C:\ProgramData\Microsoft Dynamics AX\Retail Self-service\Logs\SetupApp\2023-01-01_18-51-57] for [MPosOfflineDB], action: [Configure]
=============================
late wen i click on icon program started and asked for URL. and Register id and submitted as per XML file which i got while downloading.
If the download session still shows available, it means the data is not downloaded yet. Can you check the event viewer for any messages related to data sync in Modern POS? As sited in the previous comment, make sure that the windows user account has all the required access to read and write into the SQL database. You can start diagnosing the issue by providing sysadmin access to your windows account on MS SQL instance.
When I run batch job, it gives Status 'Available'
When Install MPOS it gave error siting to a log file. There are many text files. After closing when I ran MPOS it was asking URL, than Device etc. and able login to pos. after I started clicking connect offline operation button , it was showing above message
warm regards
You should be able to see the offline database names in the "Channel Database" screen in D365 FNO. Send a full sync of 9999 to the offline database. Please keep the MPOS/Store Commerce app open so that the system can download the jobs.
Use the "Database Connection Status" operation in POS to check if the jobs are getting applied. If you don't see any jobs there, click "Sync Data" to force the POS to check for new jobs.
Note: Azure AD sign-in is not supported in offline. Make sure that you are using a user ID and password combination. Also make sure that the windows account you are logged in with has access on the SQL offline database.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (