[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

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 tkbsman...@yahoo.com wrote: Hi All, 1. How to fetch the next RecId value from the SQL

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

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 table

[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

[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 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

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-Village

[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

[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 for

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 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 it really help

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

2005-06-17 Thread Jesper Kehlet
, 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 improved and within that, we've been told that rebuilding

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

2005-06-17 Thread Steeve Gilbert
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. But it will get rid

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

2005-06-17 Thread Subrahmanyam, Mamidi
-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 significant. All it does

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

2005-06-17 Thread Steeve Gilbert
@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 company. 1

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@yahoogroups.com

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

2005-06-17 Thread Subrahmanyam, Mamidi
+ 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 for 5GB, I like

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

2005-06-17 Thread Steeve Gilbert
@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 during week ends as it may take

[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