Re: [Axapta-Knowledge-Village] RecId Generation

2009-06-22 Thread Sumit Loya
Hi, Read this article... http://sumit-theaxfactor.spaces.live.com/blog/cns!596957786228C73F!212.entry It may answer some of your questions. Regards, Sumit On Tue, Jun 23, 2009 at 12:14 AM, tkbsmanian wrote: > > > Hi All, > > 1. How to fetch the next RecId value from the SQL query > without c

[Axapta-Knowledge-Village] RecId Generation

2009-06-22 Thread tkbsmanian
Hi All, 1. How to fetch the next RecId value from the SQL query without calling AX APIs and without updating the 'NextVal' of 'SystemSequences' as well (as it is from in-memory pool)? 2. How does AOS handles RecId allocation/prevents RecId dupication, if multiple (<249)clients conn

Re: [Axapta-Knowledge-Village] Recid

2008-09-17 Thread Mukesh Kumar
Hi, By using systemsequence class and systemsequence table Axapta create recid's. Regards, Mukesh On Wed, Sep 17, 2008 at 7:34 AM, naveed ali <[EMAIL PROTECTED]>wrote: > Hi, >I need recid for salestable,salesline& inventtrans table,I > know recid is in the Syssequences

Re: [Axapta-Knowledge-Village] Recid

2008-09-17 Thread Sumit Loya
Hi, You can have a look in the below mentioned link. http://sumit-theaxfactor.spaces.live.com/blog/cns!596957786228C73F!212.entry Regards, Sumit On Wed, Sep 17, 2008 at 7:34 AM, naveed ali <[EMAIL PROTECTED]>wrote: > Hi, >I need recid for salestable,salesline& inventtrans

[Axapta-Knowledge-Village] Recid

2008-09-16 Thread naveed ali
Hi,    I need recid for salestable,salesline& inventtrans table,I know recid is in the Syssequences table but i don't know how to generate the recid for above tables.     Thanks

RE: [Axapta-Knowledge-Village] RecId Error when importing Data.

2007-10-25 Thread André Santos
-feira, 25 de outubro de 2007 10:43 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] RecId Error when importing Data. Which table are u trying to import data into? _ From: Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Vill

RE: [Axapta-Knowledge-Village] RecId Error when importing Data.

2007-10-25 Thread KamaRaju Vudata
Which table are u trying to import data into? _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of André Santos Sent: Thursday, October 25, 2007 4:22 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] RecId Error when

[Axapta-Knowledge-Village] RecId Error when importing Data.

2007-10-25 Thread André Santos
Hi everybody! I’m trying to import data in DAX40SP1, but when the procedure ends, it returns the following message: "An error occurred while obtaining new RecId value for the table." Has anyone passed through this? TIA, André Santos [Non-text portions of this message have

Re: [Axapta-Knowledge-Village] RecID

2006-01-02 Thread Matrish Mangal
Hi ,   Rec Id is being generated at kernel level by using system class's method  xrecord.insert. If you've started the Axapta client and do the first insert, the number comes from SystemSequences table column nextval (ID -1 name SEQNO) of the dataareaID the insert will go into. Within the first

[Axapta-Knowledge-Village] RecID

2006-01-02 Thread Siva kumar
Hi,       The RecID is generated sequentially from the Table "SystemSequences" from the System Documentation folder..       Siva.     We Born to Win... Yahoo! DSL Something to write home about. Just $16.99/mo. or less Sharing the knowledge on Axapta. Visit www.frappr.com/axapta

[Axapta-Knowledge-Village] RecID

2006-01-02 Thread Jayaprakash M.
Title: RecID Hi, Axapta generates Recid in a sequential order, i want to know which table and which field is involved to store the latest recid generated. Can any one give me the table name. Regards, jay Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta fri

RE : RE : RE : [Axapta-Knowledge-Village] RecId and SysRecIdRepair

2005-06-17 Thread Steeve Gilbert
ge-Village@yahoogroups.com Objet : RE: RE : RE : [Axapta-Knowledge-Village] RecId and SysRecIdRepair   Well,   We ran it 3 tier COnfig . but I really don't know what type of hardware ( like vendor , cluster etc etc ) the server is...   Actually, MS cautioned us to run it duri

RE: RE : RE : [Axapta-Knowledge-Village] RecId and SysRecIdRepair

2005-06-17 Thread Subrahmanyam, Mamidi
ependent on the hardware + configuration. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve GilbertSent: Friday, June 17, 2005 1:52 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE : RE : [Axapta-Knowledge-Village] RecId and SysRecIdRepair 20 mins

RE: RE : RE : [Axapta-Knowledge-Village] RecId and SysRecIdRepair

2005-06-17 Thread Jesper Kehlet
, June 17, 2005 1:52 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE : RE : [Axapta-Knowledge-Village] RecId and SysRecIdRepair 20 mins for 5GB, I like that better.  Thanks for your input Subbu. Steeve...   -Message d'origine-De : Axapta-Knowledge-Village@yahoogroup

RE : RE : [Axapta-Knowledge-Village] RecId and SysRecIdRepair

2005-06-17 Thread Steeve Gilbert
llage@yahoogroups.com Objet : Re: RE : [Axapta-Knowledge-Village] RecId and SysRecIdRepair   Hi Steeve, How are you doing today?.   Ok.   I asked my admin to get the details as we ran out of RecIds. On the recommendation of MS, we ran SysRecidRepair just for one co

Re: RE : [Axapta-Knowledge-Village] RecId and SysRecIdRepair

2005-06-17 Thread Subrahmanyam, Mamidi
gine-De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Jesper KehletEnvoyé : 17 juin 2005 11:13À : Axapta-Knowledge-Village@yahoogroups.comObjet : RE: [Axapta-Knowledge-Village] RecId and SysRecIdRepair   1.  I seriously doubt the performance increase will be

RE : [Axapta-Knowledge-Village] RecId and SysRecIdRepair

2005-06-17 Thread Steeve Gilbert
De la part de Jesper Kehlet Envoyé : 17 juin 2005 11:13 À : Axapta-Knowledge-Village@yahoogroups.com Objet : RE: [Axapta-Knowledge-Village] RecId and SysRecIdRepair   1.  I seriously doubt the performance increase will be significant.  All it does is to renumber the existing RecIDs in a company.  B

RE: [Axapta-Knowledge-Village] RecId and SysRecIdRepair

2005-06-17 Thread Jesper Kehlet
GilbertSent: Friday, June 17, 2005 8:28 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] RecId and SysRecIdRepair Hi everyone,       We're having performance problems with our installation.  We've had a couple of hints about what could be i

[Axapta-Knowledge-Village] RecId and SysRecIdRepair

2005-06-17 Thread Steeve Gilbert
Hi everyone,       We're having performance problems with our installation.  We've had a couple of hints about what could be improved and within that, we've been told that rebuilding/repair RecIds could help performance.  Couple of questions on that:   1 – Is it true?  Will i

[Axapta-Knowledge-Village] Recid runs negative

2005-05-16 Thread lourens1210
Can anybody shed some light urgently please!! We have a very young Axapta installation and have found that the recid's are already running negative and is being allocated towards Zero. This raises a few questions: 1 What can cause the positive id's to be 'used up' already? 2 If the recid's are n