Error using the Export Database Wizard to export store database in

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

 

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

 

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

Any other suggestions?

Lloyd

 

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.

 

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

 

I was getting this error in inventorytransferlog table and check the ITL table there was custom trigers.due to which SOA genrating this problem.