Home Page link  

Error trying to Export Store in HQ Administrator

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Error trying to Export Store in HQ Administrator dizz 05-18-2006
Posted by dizz on May 18, 2006, 8:22 pm
Please log in for more thread options
 I have HQ 1.2 and 38 stores running SO. I have exported new stores many
times before without problem. I created a few new stores and attempted to
export today, and I am having a problem. I connect to the DB in HQ Admin,
Choose Database, Export, select the store and the template DB as usual,
create the new store DB copy the tables and click to Export (the last step of
the process). It will begin the export process then then a dialog box
appears that says: "Export Database Wizard - An error was encountered while
exporting data. Your Store Operations database is not complete and may not
work correctly. Error 0:" and there is only an "OK" button.

I have tried a full reboot on the HQ server, tried to create the new store
DB on the same machine and other machines and I get the same result each
time. Any ideas?

Thanks,
Brandon

Posted by Jeff on May 18, 2006, 8:44 pm
Please log in for more thread options
 Brandon,

http://tinyurl.com/fyovv

If a new install on the machine you are using;
http://tinyurl.com/f9ymn

Must have access to CustomerSource to view these.
--
*
Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment. If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz

**********

I have HQ 1.2 and 38 stores running SO. I have exported new stores many
times before without problem. I created a few new stores and attempted to
export today, and I am having a problem. I connect to the DB in HQ Admin,
Choose Database, Export, select the store and the template DB as usual,
create the new store DB copy the tables and click to Export (the last step
of
the process). It will begin the export process then then a dialog box
appears that says: "Export Database Wizard - An error was encountered while
exporting data. Your Store Operations database is not complete and may not
work correctly. Error 0:" and there is only an "OK" button.

I have tried a full reboot on the HQ server, tried to create the new store
DB on the same machine and other machines and I get the same result each
time. Any ideas?

Thanks,
Brandon



Posted by dizz on May 19, 2006, 12:31 pm
Please log in for more thread options
Jeff,
Neither item solves my problem. I ran the selected query to see if NULL
values existed for Tax, ReorderPoint and Restock for ItemDynamic table and no
NULL values exist. The other item was suggesting that perhaps when SQL
and/or RMS were installed, that the "Only for Me" option had been chosen. I
am using the same server and workstation that I have successfully exported 38
other stores from and we don't use MSDE at HQ (Our DB is currently at 4.7GB
and growing by several hundred MB each day)...

Any other ideas? I looked at the table structure for the new SO database
that has been created by the process and all the tables and fields within
those tables seem to be there, just with no data. Any help you can give
would be MOST appreciated...
Thanks,
Brandon

"Jeff" wrote:

> Brandon,
>
> http://tinyurl.com/fyovv
>
> If a new install on the machine you are using;
> http://tinyurl.com/f9ymn
>
> Must have access to CustomerSource to view these.
> --
> *
> Get Secure! - www.microsoft.com/security
>
> You must be using Outlook Express or some other type of newsgroup reader to
> see and download the file attachment. If you are not using a reader, follow
> the link below to setup Outlook Express. Click on "Open with newsreader"
> under the MS Retail Management System on the right.
>
> http://tinyurl.com/75bgz
>
> **********
>
> I have HQ 1.2 and 38 stores running SO. I have exported new stores many
> times before without problem. I created a few new stores and attempted to
> export today, and I am having a problem. I connect to the DB in HQ Admin,
> Choose Database, Export, select the store and the template DB as usual,
> create the new store DB copy the tables and click to Export (the last step
> of
> the process). It will begin the export process then then a dialog box
> appears that says: "Export Database Wizard - An error was encountered while
> exporting data. Your Store Operations database is not complete and may not
> work correctly. Error 0:" and there is only an "OK" button.
>
> I have tried a full reboot on the HQ server, tried to create the new store
> DB on the same machine and other machines and I get the same result each
> time. Any ideas?
>
> Thanks,
> Brandon
>
>
>

Posted by Glenn Adams [MVP - Retail Mgmt on May 19, 2006, 7:02 pm
Please log in for more thread options
There are discrepancies in the schema between SO and HQ on other tables
besides ItemDynamic and Item. Does the wizard display the name of the
table it is exporting just before it fails?

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.


dizz wrote:
> Jeff,
> Neither item solves my problem. I ran the selected query to see if NULL
> values existed for Tax, ReorderPoint and Restock for ItemDynamic table and no
> NULL values exist. The other item was suggesting that perhaps when SQL
> and/or RMS were installed, that the "Only for Me" option had been chosen. I
> am using the same server and workstation that I have successfully exported 38
> other stores from and we don't use MSDE at HQ (Our DB is currently at 4.7GB
> and growing by several hundred MB each day)...
>
> Any other ideas? I looked at the table structure for the new SO database
> that has been created by the process and all the tables and fields within
> those tables seem to be there, just with no data. Any help you can give
> would be MOST appreciated...
> Thanks,
> Brandon
>
> "Jeff" wrote:
>
>> Brandon,
>>
>> http://tinyurl.com/fyovv
>>
>> If a new install on the machine you are using;
>> http://tinyurl.com/f9ymn
>>
>> Must have access to CustomerSource to view these.
>> --
>> *
>> Get Secure! - www.microsoft.com/security
>>
>> You must be using Outlook Express or some other type of newsgroup reader to
>> see and download the file attachment. If you are not using a reader, follow
>> the link below to setup Outlook Express. Click on "Open with newsreader"
>> under the MS Retail Management System on the right.
>>
>> http://tinyurl.com/75bgz
>>
>> **********
>>
>> I have HQ 1.2 and 38 stores running SO. I have exported new stores many
>> times before without problem. I created a few new stores and attempted to
>> export today, and I am having a problem. I connect to the DB in HQ Admin,
>> Choose Database, Export, select the store and the template DB as usual,
>> create the new store DB copy the tables and click to Export (the last step
>> of
>> the process). It will begin the export process then then a dialog box
>> appears that says: "Export Database Wizard - An error was encountered while
>> exporting data. Your Store Operations database is not complete and may not
>> work correctly. Error 0:" and there is only an "OK" button.
>>
>> I have tried a full reboot on the HQ server, tried to create the new store
>> DB on the same machine and other machines and I get the same result each
>> time. Any ideas?
>>
>> Thanks,
>> Brandon
>>
>>
>>

Posted by Jeff on May 20, 2006, 4:37 am
Please log in for more thread options
Brandon,

Did you create a new, new store template or use an existing? If existing,
try creating a new one.

--
=

Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader
to see and download the file attachment. If you are not using a reader,
follow the link below to setup Outlook Express. Click on "Open with
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz

==========

> Jeff,
> Neither item solves my problem. I ran the selected query to see if NULL
> values existed for Tax, ReorderPoint and Restock for ItemDynamic table and
> no
> NULL values exist. The other item was suggesting that perhaps when SQL
> and/or RMS were installed, that the "Only for Me" option had been chosen.
> I
> am using the same server and workstation that I have successfully exported
> 38
> other stores from and we don't use MSDE at HQ (Our DB is currently at
> 4.7GB
> and growing by several hundred MB each day)...
>
> Any other ideas? I looked at the table structure for the new SO database
> that has been created by the process and all the tables and fields within
> those tables seem to be there, just with no data. Any help you can give
> would be MOST appreciated...
> Thanks,
> Brandon
>
> "Jeff" wrote:
>
>> Brandon,
>>
>> http://tinyurl.com/fyovv
>>
>> If a new install on the machine you are using;
>> http://tinyurl.com/f9ymn
>>
>> Must have access to CustomerSource to view these.
>> --
>> *
>> Get Secure! - www.microsoft.com/security
>>
>> You must be using Outlook Express or some other type of newsgroup reader
>> to
>> see and download the file attachment. If you are not using a reader,
>> follow
>> the link below to setup Outlook Express. Click on "Open with newsreader"
>> under the MS Retail Management System on the right.
>>
>> http://tinyurl.com/75bgz
>>
>> **********
>>
>> I have HQ 1.2 and 38 stores running SO. I have exported new stores many
>> times before without problem. I created a few new stores and attempted
>> to
>> export today, and I am having a problem. I connect to the DB in HQ
>> Admin,
>> Choose Database, Export, select the store and the template DB as usual,
>> create the new store DB copy the tables and click to Export (the last
>> step
>> of
>> the process). It will begin the export process then then a dialog box
>> appears that says: "Export Database Wizard - An error was encountered
>> while
>> exporting data. Your Store Operations database is not complete and may
>> not
>> work correctly. Error 0:" and there is only an "OK" button.
>>
>> I have tried a full reboot on the HQ server, tried to create the new
>> store
>> DB on the same machine and other machines and I get the same result each
>> time. Any ideas?
>>
>> Thanks,
>> Brandon
>>
>>
>>



Similar ThreadsPosted
URGENT: Run Time Error '429' in Store Operations Administrator July 12, 2005, 10:27 am
Error using the Export Database Wizard to export store database in March 8, 2008, 9:02 pm
Administrator - Store Profile Quick Switch October 18, 2006, 7:49 pm
how to export the "item" from store operation system into HQ syste September 8, 2006, 1:49 am
Export Departments, Categories and Items from One Store To Import February 29, 2008, 2:06 pm
Administrator Log On/Off? August 16, 2005, 10:56 pm
Administrator CONNECTIONS With Log On/Off? August 18, 2005, 2:38 pm
Administrator Question August 24, 2005, 10:31 pm
Cannot to server in HQ administrator August 16, 2007, 9:05 pm
Administrator Rights September 4, 2007, 5:51 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap