|
Posted by convoluted on March 25, 2008, 5:51 pm
Please log in for more thread options 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" wrote:
> Re-indexing an a db check were the first tings I did. They were unsuccessful
> of course.
>
> Any other suggestions?
>
> Lloyd
>
> "Daniel S." wrote:
>
> > I had this problem shortly after upgrading to 2.0.
> > Running a db re-index then a db check from HQ admin resolved it.
> >
> >
> > "LLoyd" wrote:
> >
> > >
> > > 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
> > >
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap