microsoft
Creating Timestamp Field Error
1. Describe the bug It is possible to create field with name "Timestamp". First time you compile, it will pass and timestamp field will be created. If you try to compile it again it will fail with message: Reason: Table 27 Item contains multiple fields that have the name Timestamp.
2. To Reproduce Create new field, name it "Timestamp" BigInteger, try to compile it at least twice.
- Go to '...'
tableextension 50100 Item_ext extends Item { fields { field(50100; Timestamp; BigInteger) { Caption = 'Timestamp'; } } }
3. Expected behavior System should not allow you to create field with name "Timestamp".
4. Actual behavior On second compile: [2021-05-11 12:02:03.06] The request for path /BC/dev/apps?tenant=default&SchemaUpdateMode=forcesync&DependencyPublishingOption=default failed with code UnprocessableEntity. Reason: Table 27 Item contains multiple fields that have the name Timestamp.
5. Versions:
- AL Language: 7.1.453917
- Visual Studio Code: 1.56.0
- Business Central: W1 18.1 (Platform 18.0.24800.25040 + Application 18.1.24822.25158)
This is a critical issue. I have reached this problem and I am now stuck.
Upgraded a client from NAV and they had a column called Timestamp on their own 50000 table. The first time it let me compile, publish, and install the PTE app to their BC online production environment. Now I am unable to install newer versions of the app because I get the issue "Could not upgrade the NAV extension due to the following error...contains multiple fields that have the name Timestamp." And I cannot remove or rename the field due to breaking changes. Therefore the app is now permanently stuck in one version and I cannot change it.
The client has used the PTE for many weeks, so unfortunately there is data in the PTE tables and table extensions.
