-
Title
Error: ”[810143] Database error 102: Incorrect syntax near 'd'.” -
Description
When a shop is removed from (or moved to) a shopping center, "VI_ESS_ITShopOrg_Update_ShoppingCenter" is generated and an error will occur:
[1025012] Object (SC-Shop-02) could not be saved!
[810306] Error during execution of 'OnGenerate' in logic module 'VI.DB.Entities.EventsEntityLogic'.
[810103] Error generating processes for event Update.
[810222] Error executing script 'Event_Update'.
[810108] Error generation process step event UPDATE.
[810109] Error generating process VI_ESS_ITShopOrg_Update_ShoppingCenter.
[810110] Error generating process step Event for Delete Boards of old ShoppingCenterTemplate.
[810155] Error executing prescript.
[810048] Error getting single property ITShopOrg.UID_OrgBoardTemplate.
[810023] Error during execution of statement: select * from (select UID_OrgBoardTemplate, UID_ITShopOrg from ITShopOrg where (a97344f7-212d-45bb-bc32-24a1659c1b9e = '806d0852-61ad-40b4-8b90-55c51d72c4d6')) as x ORDER BY (select null) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
[810143] Database error 102: Incorrect syntax near 'd'.
Incorrect syntax near 'OFFSET'.
Invalid usage of the option NEXT in the FETCH statement.
Incorrect syntax near 'd'.
Incorrect syntax near 'OFFSET'.
Invalid usage of the option NEXT in the FETCH statement.
-
Cause
This is a product defect (32999).
-
Resolution
WORKAROUND:
None.
STATUS:
This will be fixed on a future release of the product. If you require this immediately corrected, please contact support for a hotfix referencing the defect ID 32999.
-
Change Request
32999