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.
Yahoo! Groups Sponsor ADVERTISEMENT
Click to learn more...
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
