are you REALLY sure, that axapta STOPS on reaching the magic number ??
As far as I understand, Axapta DOES NOT STOP, beside it tries to insert a 0 value on recID (constraints on sql fields).
But following situation.:
you have roundabout 4.2 billion recids drawn already.
==> table SYSTEMSEQUENCE NextVal has a value of e.G. -2
you start the axapta client and do your first insert within the company we are speaking of.
- On trying the first insert this client knows: I've to cache 25 numbers starting with -2
it updates the systemsequenece table (setting nextval to +23).
- Now this client do ONE insert. The recID will have the value -2
- The (this) clients is terminated
- The next client is started. This client knows: I have to start with reciD +23 on insert and increases the nextval to 48.
- This second client inserts a record with recID 23 a a table X.
!!! this table can have a record for the given company with the newly inserted recID (+23) already.
!!! not every table has a UNIQUE dataareaid, recID index.
!!! only if createRecID index is set to yes or no other usable index is given on the table.
- effect is you have 2 records wth the same recid for the same company in ther same table
- now the problems starts -> exporting (mapping old-new) or tables which are linked using refTableID, refRecID
so if axapta WILL STOP (simply STOP - maybe with a message "game over") this would be GREAT.
so please (this is REALLY important)
Can you verify your statement that Axapta STOPS after reaching the magic number.
============================
regards / mfg / mvh / Kveğja
michael
p.p.s.: "tech is back"
__ __ ___ ___
\ / | |
\/ | | __________________ cut off here
/\ | |
/ \ | |
-- -- --- ---
-----Ursprüngliche Nachricht-----
Von: Kim Truelsen (MICROSOFT BUSINESS SOLUTIONS) [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 2. Juni 2004 12:58
An: [EMAIL PROTECTED]
Betreff: RE: [development-axapta] Negative RedIds & Custtable
Hi Tomasz
As everybody knows we have 4.2 billion recids per company to deal with. 2 billions above zero and 2 billions below. After these recids are used Axapta actually stops...
The problem is that we are using more recids than we use. We waste a lot of recids, because we draw a number of recids from SystemSequences every time we are going to insert some records. I have seen a lot of installations were the recids was used, because they had imported and delete a lot of records.
What you have to do is to run the
AOT/Classes/SysRecidRepair
But only use the version 3.0 Sp2 - sp3 and in version 2.5 SP4. The class will free up unused recids and reorganize your recids.
Med venlig hilsen / Best regards
Kim Truelsen
Escalation Engineer
Microsoft Business Solutions Axapta
EMEA Global Technical Support Center
Direct / mobile: +45 4489 0100 / +45 29499958
E-mail: [EMAIL PROTECTED] <BLOCKED::mailto:[EMAIL PROTECTED]>
Online support at: www.microsoft.com/support <BLOCKED::http://www.microsoft.com/support>
MBS Partnersource at: www.microsoft.com/BusinessSolutions/PartnerSource/default.mspx <BLOCKED::http://www.microsoft.com/BusinessSolutions/PartnerSource/default.mspx>
Security Updates at: www.microsoft.com/protect <BLOCKED::http://www.microsoft.com/protect>
Microsoft Denmark <BLOCKED::http://www.microsoft.dk/>
Tuborg Boulevard 12
DK-2900 Hellerup
Phone:+45 4489 0100 / Fax: +45 4468 5510
________________________________
If you have any feedback about my work, please let either myself or my manager Kenneth Stubban know at [EMAIL PROTECTED] <BLOCKED::mailto:[EMAIL PROTECTED]> or telephone +45 4498 0750
Note: This email may contain confidential information. If you are not named on the addressee list, please take no action in relation to this email, do not open any attachment and please contact the sender (details above) immediately.
________________________________
From: Tomasz Dudek [mailto:[EMAIL PROTECTED]
Sent: 2. juni 2004 12:14
To: [EMAIL PROTECTED]
Subject: [development-axapta] Negative RedIds & Custtable
RecId can be negative. OK. It is consequence of integer type of RecId. But after 2147483647 negative numbers integer has 0! What will be done with them? would it insert RecId = 0 ? Next problem: After '0' value integer has positive values. There would be inserted RecId, who exists in this table. What will be happen, if there are relations on "unique" Recid's?
Best regards.
Tomasz Dudek
Integris
[EMAIL PROTECTED]
----- Original Message -----
From: "Unger, Denis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 02, 2004 9:28 AM
Subject: AW: [development-axapta] Negative RedIds & Custtable
A valid RecId in Axapta can also be negative. With table.recid != 0 you can check a valid record.
Denis Unger
-----Ursprüngliche Nachricht-----
Von: Özgür Genç [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 1. Juni 2004 23:34
An: [EMAIL PROTECTED]
Cc: Ugur S. Taskin; Volkan Acar
Betreff: [development-axapta] Negative RedIds & Custtable
Hi everyone, I have two questions that I need your help.
1 - in our ERP project we have two companies. In the first company, all recIds in all tables are positive but in the other company some recIds in the table are negative. Do any of u know why that could happen? Is it normal? Most of our code that includes if (table.recId!=0) statement fails so we rearranged these codes. I will be very glad if any of u have any exprience on such an issue.
2- My other problem is that; in custtable account num can collabse with each other in these companies. A customer information can be changed with another customer information with a different accountnum. I have written this to partner source but maybe any of you may have a problem with custtable accountnum before.
thanks a lot.
Özgür
Lead Developer, Veripark
[Non-text portions of this message have been removed]
Yahoo! Groups Links
Yahoo! Groups Links
Yahoo! Groups Sponsor
ADVERTISEMENT
click here <http://rd.yahoo.com/SIG=1291kfl4s/M=295196.4901138.6071305.3001176/D=groups/S=1705006764:HM/EXP=1086259050/A=2128215/R=0/SIG=10se96mf6/*http:/companion.yahoo.com>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=897756411>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Links
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
