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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to resolve the err...
Microsoft Dynamics AX (Archived)

How to resolve the error "RetailDatabaseUtility.exe Error: 0 : DBUtilityCore<ProvisionDatabasesForSynchronizationAsync>b__7: Offline-Profile not found" in AX 2012 for Retail?

(0) ShareShare
ReportReport
Posted on by Branislav Petkovic 1,330

RetailDatabaseUtility cannot finish pos database creation because of this error.

Offline profile has been previously created at Retail > Setup > POS > Profile > Offline profile.

 

*This post is locked for comments

I have the same question (0)
  • Branislav Petkovic Profile Picture
    Branislav Petkovic 1,330 on at

    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: 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_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 : 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:  - POSISINFO -> done.

    RetailDatabaseUtility.exe Error: 0 : DBUtilityCore<ProvisionDatabasesForSynchronizationAsync>b__7: Offline-Profile not found

  • Branislav Petkovic Profile Picture
    Branislav Petkovic 1,330 on at

    Did anybody successfully created POS database and what is the content of RetailDatabaseUtility.log file for that operation?

  • Abdullah Al-Nunu Profile Picture
    Abdullah Al-Nunu 50 on at

    I am facing the same problem guys. Any luck?

  • Branislav Petkovic Profile Picture
    Branislav Petkovic 1,330 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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.

  • Andrew Clift Profile Picture
    Andrew Clift 185 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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

  • Verified answer
    Abdullah Al-Nunu Profile Picture
    Abdullah Al-Nunu 50 on at

    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>

  • Andrew Clift Profile Picture
    Andrew Clift 185 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    It works! 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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans