Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
RecId Negatives!!
pedroparra
Member Posts: 58
Hi all,
I have a question about my axapta installation. I have noticed that in one of our company accounts we have recId negatives like '-119728071'.
In all other accounts the recIds seems to be positive so this seem a bit strange.
I am a bit scared about something going wrong. Is the fact of recId being negatives a dangeraous thing? Actually our Axapta application is working well without problems.
Thank you
Pedro
I have a question about my axapta installation. I have noticed that in one of our company accounts we have recId negatives like '-119728071'.
In all other accounts the recIds seems to be positive so this seem a bit strange.
I am a bit scared about something going wrong. Is the fact of recId being negatives a dangeraous thing? Actually our Axapta application is working well without problems.
Thank you
Pedro
0
Comments
I had the same problem and for us was very dangerous because
we have Galaxy (interface done by Columbus) and extrains
things happened. We decided run "Check rec Id" (in menu
Administration, Periodic, SQL administration) and it solved
the issue (we use an non-productive hour for that).
If you want run it, make a backup first!.
\:D/
having negative recId's is not dangerous. The RecId is a 32 bit integer which leaves approx. 2.1 billion positive number and 2.1 billion negative number for the RecId.
In the "old days" (read: in the time of XAL - before Axapta) I believe that recId's could only be positive - this caused a number of issues in partner developed Axapta modules because they only checked if recId > 0 instead of recId != 0. This was 5+ years ago, so I don't know if this is what happened with JoseQ and his experience with Galaxy?
Cheers,
H. Jaeger
Edenbrook Ltd.
Cheers.
It is fairly common in large installations and not so large installations to see negative rec ids. If you haven't already done so, please try running "Check record Id" from Administration -> Periodic -> SQL administration.
Before running this in production server do please make sure to run this in test environment.
Just curious - how big is your installation?
Hope this helps,
Long way to go before I sleep..
A while back Helmut posted about renumbering RecIds in his blog which makes an interesting read - http://axaptafreak.blogspot.com/2005/08 ... ecids.html
Long way to go before I sleep..
Our Axapta installation is medium size I think. About 30-40 users and our data base is about 12 gigabytes.
Futhermore Harish, was you who made me the phone test at Howden in Glasgow?
I was there for a job interview and someone called Harish made me the Axapta skills interview by phone!
Best Regards
Pedro Rodriguez