Hi Karsten
I don’t know much about your installation, but when the record is missing in the database it can be 3 things 1. The record was never inserted 2. The record was deleted 3. The user thought he had inserted the record, but the record was rolled back by the database. If so you probably have unbalanced TTSBegin/TTSCommits Med venlig hilsen / Best regards Kim Truelsen Microsoft Business Solutions Tuborg Boulevard 12 DK-2900 Hellerup Phone + 45 44 89 01 00 Mobile + 45 29 49 99 58 mailto:[EMAIL PROTECTED] _____ From: Karsten Rasch [mailto:[EMAIL PROTECTED] Sent: 28. november 2003 09:01 To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Missing records in tables InventTrans, ProdBOM, ProdRoute etc. 'Missing' as in not in the database when the user discovers the problem from the application. Don't know whether the records never got inserted or they were deleted later on - the former seems most likely. Best regards HOB Business Solutions A/S Karsten Rasch -----Original Message----- From: Harry [mailto:[EMAIL PROTECTED] Sent: 27. november 2003 20:12 To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Missing records in tables InventTrans, ProdBOM, ProdRoute etc. hi Karsten, A bit confused by what do you mean by 'missing records'. Do you mean that records are in the database but cannot be viewed in the form? or records never got inserted into database and user did not get any error? regards harry deshpande -----Original Message----- From: Karsten Rasch [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 November 2003 11:01 p.m. To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Missing records in tables InventTrans, ProdBOM, ProdRoute etc. Both installations are 3.0 - one is SP1 and one is SP2. The methods look the same in 2.5 SP3 but the problems with missing records haven't been reported before. Since the SQL version (2000), the use patterns, the workload etc. is as in 2.5, the naive conclusion is that it is triggered by some new 'feature' in 3.0 - possibly in the kernel. Best regards HOB Business Solutions A/S Karsten Rasch -----Original Message----- From: Svein Tore Hanssen [mailto:[EMAIL PROTECTED] Sent: 27. november 2003 10:53 To: [EMAIL PROTECTED] Subject: SV: [development-axapta] Missing records in tables InventTrans, ProdBOM, ProdRoute etc. Hi Is this Axapta 2.5 or in Axapta 3.0? Regards Svein T. Hanssen -----Opprinnelig melding----- Fra: Karsten Rasch [mailto:[EMAIL PROTECTED] Sendt: 26. november 2003 17:51 Til: [EMAIL PROTECTED] Emne: [development-axapta] Missing records in tables InventTrans, ProdBOM, ProdRoute etc. Hi, Have any of you experienced missing records in tables InventTrans, ProdBOM, ProdRoute, ReqRoute and ReqTrans? Two of our customers are missing several records in some of these tables. These situations occurs without any signs of errors (error messages, Axapta break downs etc.). The odd thing (at first) is that when the customers run into one of these missing records, it is impossible to recreate the erroneous situation. There are of course no alterations by us and no parameters that can explain this. MBS then pointed us towards the methods ViewRecordCache() (and similar in the tables mentioned above) that have return-type RecordCache. Their reply is to insert an "return NULL"-statement prior to the return of the recordCache (apparently only a problem with SQL). The more I look at the methods and the ways in which they are called, the more the explanation makes sense... ...but one question then pops up: There must be A LOT of installations that have experienced this?!?!? Best regards HOB Business Solutions A/S Karsten Rasch Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Sponsor ADVERTISEMENT click here Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
