
I am creating POS offline database from retail database utility.
Getting error : An error occurred while creating offline database on POS counter system.
When i navigate RetailDataBaseUtility log file i found this error :
Creating Tracking Table [RetailAssortmentExploded_tracking]
Populating from base table.
Caught Exception : System.Data.SqlClient.SqlException (0x80131904) : Timeout Exception.
*This post is locked for comments
I have the same question (0)Hi Kumar,
Double check if there are missing indexes in channel DB. (timeout errors may relate to this scenario. Special attention to RetailAssortmentExploded table). Try reorganize/rebuild index.
https://technet.microsoft.com/en-us/library/ms345417(v=sql.105).aspx
http://blog.sqlauthority.com/2011/01/03/sql-server-2008-missing-index-script-download/
I Hope this Helps!
Regards,
Rodolfo Recalde.