Error using the Export Database Wizard to export store database in

Discussion in 'Microsoft Point Of Sale' started by LLoyd, Mar 9, 2008.

  1. LLoyd

    LLoyd Guest

    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
     
    LLoyd, Mar 9, 2008
    #1
    1. Advertisements

  2. LLoyd

    Daniel S. Guest

    I had this problem shortly after upgrading to 2.0.
    Running a db re-index then a db check from HQ admin resolved it.
     
    Daniel S., Mar 9, 2008
    #2
    1. Advertisements

  3. LLoyd

    LLoyd Guest

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

    Any other suggestions?

    Lloyd
     
    LLoyd, Mar 9, 2008
    #3
  4. LLoyd

    convoluted Guest

    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.
     
    convoluted, Mar 25, 2008
    #4
  5. 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
     
    Jeff @ Check Point Software, Apr 3, 2008
    #5
  6. LLoyd

    tahir.javed

    Joined:
    Jul 17, 2014
    Messages:
    1
    Likes Received:
    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.
     
    tahir.javed, Jul 17, 2014
    #6
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.