Error trying to implement the Offline Database option on a store

(0) Share

Report

Posted on by Community Member

Im getting this error when trying to sync transaction on offline database to primary server.

some one cant help me to solve this issues, we need to do maintenance to the primary server and 1 day the online server need to be shutdown. But the offline server was getting that error. I check the database on Store Operations Administrator and not getting error about integrity of the tables.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

Solve

Easy a Reindex work for me. jejeje

Store Operations Manager > Database >Reindex

Was this reply helpful? Yes No
vijaya pandian 160 on at

Like (0)

Report

Are you using SQL 2005 Express Edtion if yes please enable Adhoc Remote queries in surface are configartion.

Was this reply helpful? Yes No
Suggested answer

Mian Sufian on at

Like (0)

Report

I have enabled this option and it works fine. My primary and offline databases are being synchronized when I execute z report on POS.

Follow these steps to enable

Start-> Microsoft SQL server 2005 -> Configurations Tools -> SQL Server Surface Area Configurations

Then Click

Surface area Configuration for features

Then select check box with the option of “Enable OPENROWSET and OPENDATASOURCE support”

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have a same problem, but i am using sql server 2008 r2.

where is the " Enable OPENROWSET AND OPENDATASOURCE SUPPORT" option for sql 2008 r2?

Was this reply helpful? Yes No
Jeff @ Check Point ... 13,382 on at

Like (1)

Report

There isn't one in 2k8; run this instead;

-- Turn on advanced options

EXECUTE SP_CONFIGURE 'show advanced options', 1

RECONFIGURE WITH OVERRIDE

-- Set max server memory = 6400MB for an 8g Server machine -- 1/2 for 4g

EXEC sp_configure'max server memory (MB)',6400;

RECONFIGURE WITH OVERRIDE

-- Turn on Ad Hoc Queries

EXECUTE SP_CONFIGURE 'Ad Hoc Distributed Queries', '1'

RECONFIGURE WITH OVERRIDE

-- Turn off advanced options

EXECUTE SP_CONFIGURE 'show advanced options', 0

RECONFIGURE WITH OVERRIDE

-- Change Recovery Mode to Simple to prevent log file growth

ALTER DATABASE "databasename" SET RECOVERY SIMPLE

-- Turn off AutoClose in Express versions

EXEC sp_dboption 'databasename', 'autoclose', 'FALSE'

You need modify the line ending in 6400 depending on the amount of RAM you have, its set for 8g, change to 3200 for 4g,1600 for 2g

Then modify the last two sections containing the databasename and change to your our database name.

Was this reply helpful? Yes No
Suggested answer

RMS Goddess 172 on at

Like (0)

Report

Thank you Jeff! This was perfect and solved my issue perfectly!

Was this reply helpful? Yes No