Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
Invoice Settlements/Discounts/Reversals
SSRS and SSAS Integration
Workflow
RetailDatabaseUtility cannot finish pos database creation because of this error.
Offline profile has been previously created at Retail > Setup > POS > Profile > Offline profile.
Hi guys,
here are the steps to do that:
- Open the database configuration utility and mark the Configure Offline database
- Remove the offline database and server
- Mark the Configure store database and create the database
- Do not specify the offline database/server >>>>> Most important one
- Synch your store database from the HQ ( N-1095, N-1090. N-1070)
- Open the Database Utility again and create your offline POS database
The POS.exe config file should now be created corretly. It might be a problem with the offlinedatabaseconnectionstring. If so modify the configuration file manually like this
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="AxRetailPOS" type="LSRetailPosis.Settings.ConfigFile.AppConfiguration, SystemSettings, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
</configSections>
<AxRetailPOS OfflineDatabaseConnectionString="Data Source=DYNAX2012DK;Initial Catalog=AXRETAILPOS;Integrated Security=SSPI;Persist Security Info=false;Pooling=false;TrustServerCertificate=true;Encrypt=TRUE" StoreDatabaseConnectionString="Data Source=DYNAX2012DK;Initial Catalog=AXRETAILSTOREDB;Integrated Security=SSPI;Persist Security Info=false;Pooling=false;TrustServerCertificate=true;Encrypt=TRUE"
StoreId="S0001" TerminalId="0001" DATAAREAID="CEU" />
</configuration>
I have installed retail both as a minor upgrade from CU2 and clean from FP1 and if you are getting the off-line profile not found then you have yet to create the POS database, no POS config exists (you tried to create retail database and off-line at the same time - retail pos database created but utility failed) or the off-line profile has not be successfully sent to the POS database.
if you have not successfully run the database utility with the off-line database cleared out then you can get into a state where you have a POS database but no config. either create the config manually in the Retail POS folder, create a new retail pos database with a different name or delete the incomplete POS database installed and re-run the database utility without specifying the off-line information.
after re-runnning the database utility the first time to create the retail pos database only then you need to push the data from AX to the till - ensure that the assigned profile correctly points to the till database.
once the off-line profile has been pushed to the pos database then you can re-run the database utility specifying the off-line database information.
Note: The identification information used in the database utility must be present and should be the assigned ID's in AX not the names given.
Store database creation is just fine, but POS (offline) reports an error
STORE:
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Master connection string: Data Source=VM-RCLAX;Initial Catalog=master;Integrated Security=True;Persist Security Info=False;Pooling=False;Encrypt=True;TrustServerCertificate=True
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: database name: RCL_AX2012_STORE
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Database 'RCL_AX2012_STORE' is not found.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Creating database: RCL_AX2012_STORE to: VM-RCLAX
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Database filename: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\RCL_AX2012_STORE.mdf
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Database log filename: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\RCL_AX2012_STORE_log.mdf
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Database created successfully.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Compatibility level set to 90.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: AlterDatabase completed.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Running table creation script
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Tables successfully created.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Loading data into tables
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: - POSISINFO -> done.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: - LANGUAGETABLE -> done.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: - RETAILERRORS -> done.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: - RETAILSTORETABLE -> done.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: - RETAILTERMINALTABLE -> done.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: - RETAILHARDWAREPROFILE -> done.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: - RETAILFUNCTIONALITYPROFILE -> done.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: - RETAILVISUALPROFILE -> done.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Data successfully loaded
POS:
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: database name: RCL_AX2012_POS1
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Database 'RCL_AX2012_POS1' is not found.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Creating database: RCL_AX2012_POS1 to: VM-RCLAX
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Database filename: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\RCL_AX2012_POS1.mdf
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Database log filename: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\RCL_AX2012_POS1_log.mdf
RetailDatabaseUtility.exe Error: 0 : DBUtilityCore<ProvisionDatabasesForSynchronizationAsync>b__7: Offline-Profile not found
Did anybody successfully created POS database and what is the content of RetailDatabaseUtility.log file for that operation?
I am facing the same problem guys. Any luck?
Sorry I don't have time for that now - I'll be on a business trip until thursday march 1st. I expect that somebody will post some hint or at least log of a POS database creation. In case of no help from anybody, I will resolve that by tracing RetailDatabaseUtility. Perhaps until next monday.
Do you try to create an offline profile?
I have the same error with the offline database and I can't open the POS Retail.
The store database has been created but it's impossible with the offline database.
I have also had the same error when trying to create both online and offline databases at the same time - i got the online database to install fine by blanking out the offline information - you still need to fill in identify infomation though.
I try it without an offline database, as you say, but I still can't open the POS.
When I try to create both offline and online database I have this error.
RetailDatabaseUtility.exe Error: 0 : DBUtilityCore<ProvisionDatabasesForSynchronizationAsync>b__7: Store not found
try removing the original retail pos db created or running the RetailDatabaseUtility and specifying a different online database name, no offline database and the identity infomation that will be used. if the creation does not complete then ensure that you are running as admin or user that is able to create config file in Retail POS folder.
if retail pos does not have a config file then it will not start.
It works! Thanks!
MikS,
Error is reported by the same procedure but it is not exactly the same. My error is "Offline-Profile not found" and yours is "Store not found". Would you be so kind to send retail database utility log part for your last try to create offline pos database and I will try to help you to resolve the problem. Btw are you familiar with sql profiler?
I analyzed my "offline-profile not found" error thru sql profiler and found something interesting. Last statement before the error was:
exec sp_executesql N'SELECT TOP (1)
[Extent1].[RECVERSION] AS [RECVERSION],
[Extent1].[RECID] AS [RECID],
[Extent1].[DESCRIPTION] AS [DESCRIPTION],
[Extent1].[NAME] AS [NAME]
FROM [dbo].[RETAILOFFLINEPROFILE] AS [Extent1]
WHERE @p__linq__0 = [Extent1].[RECID]',N'@p__linq__0 bigint',@p__linq__0=0
Looks like IT'S TRYING TO FIND OFFLINE PROFILE WITH RECID=0 but I don't have one:
select * FROM [dbo].[RETAILOFFLINEPROFILE]
DESCRIPTION NAME RECVERSION RECID
Default offline database profile Default pr 1 5637144827
RCL offline database profile RCL profil 1 5637144828
I tried to insert offline profile with RECID=0 manually but got an error caused by check constraint on a RECID column BECAUSE IT'S NOT ALLOWED TO HAVE OFFLINE PROFILE WITH RECID=0:
This is the constraint:
ALTER TABLE [dbo].[RETAILOFFLINEPROFILE] WITH CHECK ADD CHECK (([RECID]<>(0)))
What is so special with offline profile with RECID=0? Why it can't be inserted? Is it some kind of internal identifier?
It could be a bug, but I don't know how to fill that as a bug to Microsoft Dynamics support. Does anybody have that kind of expirience?
Abdullah, please describe this step in details (what,where,how):
"Synch your store database from the HQ ( N-1095, N-1090. N-1070) "
Store Connect must be configured, up and running to do that?
p.s. On page 31 of Retail Deployment Guide there is no additional steps between store database and pos database creation. You only have to be carefull to enter proper store, pos and company IDs which can't be verified by this utility because synch is configuring AFTER the creation of POS database (see page 32).
Hi Branislav,
I got this whole thing from a Microsoft guy, and it worked with me. I am sure these manuals need to be revised.
Synchronization from AX is done in Retail --> periodic-->Retail Scheduler-->Distribution location
Before you can do this you need to setup all the data needed in AX like database profiles, store connect profiles... etc
Try to setup these profiles and test the connection for each one.
Trust me, it will work this way. Let me know if you have any problem.
Hi Bransilav,
Thanks for your help, but finally I can resolve my problem using the jobs N-1095, N-1090, N-1070, as it say Abdullah.
I suppose that the POS doesn't have information about the store, and maybe this is the reason for that I got the message "Store not found"
Now, I can create online and offline database.
Everything was setup (except POS database) and it is working just fine:
Retail Store Connect Profile: The connection tested successfully in 0,31 seconds.
Database Profile: The connection tested successfully in 0,06 seconds.
AOS Profile: The connection tested successfully in 0,05 seconds.
I didn't try those jobs, because there is no information about them in the Retail Configuration Guide. I hope that that will resolve my problem too.