SAP B1 HANA Autokey Not get updated

[former_member183246]

Hello Experts,

I have SAP HANA 9.2 PL 03.

While adding first record in UDO get correct AutoKey Number 1 but next number is not getting updated in ONNM table next time it same 1 number. this issue gets for all user defined form in addon. but it works on my development server. so i dont get what is the actual issue and how can i resolved it ?

I am using the following query for get the next Autokey

select "Autokey" from ONNM where "ObjectCode"='CBF_FARM'

Help me experts if any one get the solution.

- Thanks

Vikas

[pedro_magueija]

Hi Vikas,

How is the data being added? Did you link your form with a UDO and let the UDO save the data?

Are you using SQL (not recommended)?

Note that, sometimes the numbering file gets corrupted, and there is an option you can use to fix it: Help -> Support Desk -> Restore -> Restore Numbering File.

Good luck.

Pedro Magueija

LinkedIn | Twitter | Blog

[former_member183246]

Hello Pedro,

Thanks for reply. I am Adding record by attaching UDO to Form.

I have tried your solution by restoring Numbering File but still same issue AutoKey not get updated in ONNM table.

- Thanks

Vikas