Error using the Export Database Wizard to export store database in


L

LLoyd

I'm trying to create a store database for a new store in HQ. When the
process is exporting the data, it gets as far as the Item table and I receive
the error:


Export Database Wizard: An error was encountered while exporting data.
Your Store Operations database is not complete and may not work correctly.
Error 0:

I have tried it twice and I get the same error.
Any clue what is going on here?

I am using RMS/HQ 2.0 SP1 and SQL Server Standard 2005 SP2 with WinXP SP2
 
Ad

Advertisements

D

Daniel S.

I had this problem shortly after upgrading to 2.0.
Running a db re-index then a db check from HQ admin resolved it.
 
L

LLoyd

Re-indexing an a db check were the first tings I did. They were unsuccessful
of course.

Any other suggestions?

Lloyd
 
C

convoluted

Lloyd did you ever get this resolved? I ran into this same issue today.
Reindex and Check did not solve the problem. My workaround was creating a
store ops template db from a blank store ops db instead of an actual store
ops backup; the way I understand the process is the template sends to your
exported db "store specific" info like register settings, templates,
security, etc., - whereas the HQ db sends "centrally maintained data" like
items, departments, suppliers, etc to the exported db. Using MS Access we
then copied contents of security table into the blank security table in our
exported db....seemed to do the trick but made a two minute process feel like
two hours......

Later I found KB862876 that indicates this may be caused by three key fields
in the itemdynamic table being null (taxid, reorder point and restock
level)....I'll try to confirm this at a later time but I figured this may
help you for now - good luck.
 
J

Jeff @ Check Point Software

Lloyd and convoluted,

Be sure to use 2.0.0115 as there are some bugs with earlier versions with importing/creating new stores.





I'm trying to create a store database for a new store in HQ. When the
process is exporting the data, it gets as far as the Item table and I receive
the error:


Export Database Wizard: An error was encountered while exporting data.
Your Store Operations database is not complete and may not work correctly.
Error 0:

I have tried it twice and I get the same error.
Any clue what is going on here?

I am using RMS/HQ 2.0 SP1 and SQL Server Standard 2005 SP2 with WinXP SP2
 
Ad

Advertisements

Joined
Jul 17, 2014
Messages
1
Reaction score
0
I was getting this error in inventorytransferlog table and check the ITL table there was custom trigers.due to which SOA genrating this problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top