millennium.atrex
database error
Thread Starter: Nelson Started: 3/11/2010 6:55 AM UTC
Replies: 1
3/11/2010 6:55 AM UTC
database error
Reply Quote Delete

Nelson

hi,
   I got a problem with database.  My computer hung when I'm typing an order.  After done with batch processing, the order # jumps from #15045 to #750521559, now it stops at #750521612.  Every time when I want to create an order, the order # will be 750521612, and the error message says that the number was already exist.  I already done with the repair table process, still got the same error.


Nelson
3/11/2010 5:31 PM UTC
Re: database error
Reply Quote Delete

Terry Swiers

Nelson,

I got a problem with database.  My computer hung when I'm typing an order After done with batch processing, the order # jumps from #15045 to #750521559, now it stops at #750521612.  Every time when I want to create an order, the order # will be 750521612, and the error message says that the number was already exist.  I already done with the repair table process, still got the same error.

The number sequence is a search and increment, so the package looks for the maximum number in the table, retrieves that, and increments by one so what is happening is that the table has at least 1 corrupted record in it with those large numbers in it.

The damaged records probably don't have a valid date, so you need to see if you can actually "see" the damaged records and void them.  Use the "Sales - Void Order" function and click the search button.  Enter January 1st 1890 for the beginning date and display the results.  If you see any of the transactions with the large numbers, highlight the first large number and click OK to void it.  Repeat that process to get rig of all the large numbers.

Once they are all gone, it should continue on with the original number sequence.

If that does not resolve the issue, you can either restore from a backup taken prior to the damage, of you can get us a copy of your database and we will see if we can repair it.  We'll be able to get you an estimate of the time and cost once we see the data.

--  

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

 The Atrex 13 beta is now available.
 Visit http://v13beta.atrex.com for more information.

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------