Corrupt Customer record

Yahoo Archive
1
Does this customer have alot of ship to's? There is an issued with the
number of ship to's. Can you get the data out another may to look at.
There are some characters that if used as the ship to id will lock up
the customer maintenance ? for one.

Jim

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bruce Ordway
Sent: Thursday, January 29, 2009 10:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Corrupt Customer record



Hi,

I have ended up with a customer record that won't open.

I called Epicor & was told to try running conversion 5460, Reset DB
Sequence Controls.

The file would open in customer maintenance after that.
However, after trying to open with customer tracker it would fail and
become unuseable again.

Now I'm getting "dump and load" instructions from Epicor.
They say this is my only option now.

This is my first experience with record corruption like this.
Dump and load seems extreme.
Is there any other way to approach this?

OE 10.0B05.
Vantage 8.03.305f

Thanks,

Bruce Ordway





--------------------------------------------------------------------------

William Frick & Co's SmartMarkT RFID Named to 2008 Top Ten Products List


[Non-text portions of this message have been removed]
2
Yes, that does sound extreme to me. Reminds me of HP desktop support
telling me the other day that a complete system recovery/restore was the
only way to fix it.

It's not the only way. It's the easiest way for them to resolve our
issue.

Can you not attach via ODBC to your database and try manually deleting
that customer record? I'm not sure of the age of this customer and how
many dependencies they may have established in your system, but I would
sure try that first. Play in a *test* environment with a clone of your
current problematic database. Use Access and ODBC to poke around and
delete records in your test environment first to learn of any
repercussions.

Check the dependant tables, too. The Vantage Data Dic says:
Customer Master. This is the primary file to the Shipto, and CustCnt
files.
DELETING - Not allowed if any invoices (InvcHead), Sales Orders
(OrderHed), records exist for the specific customer. Be sure to delete
all the ShipTo and CustCnt records associated with the specific
customer.

Is this a new customer by chance?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bruce Ordway
Sent: Thursday, January 29, 2009 11:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Corrupt Customer record

Hi,

I have ended up with a customer record that won't open.

I called Epicor & was told to try running conversion 5460, Reset DB
Sequence Controls.

The file would open in customer maintenance after that.
However, after trying to open with customer tracker it would fail and
become unuseable again.

Now I'm getting "dump and load" instructions from Epicor.
They say this is my only option now.

This is my first experience with record corruption like this.
Dump and load seems extreme.
Is there any other way to approach this?

OE 10.0B05.
Vantage 8.03.305f

Thanks,

Bruce Ordway



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links