no data found exception: no data found: [1299] error in Procedure

[Former Member]

Hi all,

I am getting "no data found exception: no data found:  [1299] " in SAP HANA procedure, even if data for the corresponding plant and material is present in the respective tables.

Can any-one suggest why I am getting this and what would be the resolution of the same.

Regards

dhinesh.

[Former Member]

see the thread for solution

[former_member186082]

Hi Dhinesh,

You can try executing each statement from Procedure in separate SQL console to find which statement is causing the issue.

Regards,
Chandra.

[Former Member]

Hi Dhinesh,

Ok. It seems you have some condition in your SQL and it gets fail. It is best practice to capture SQL exception in all your store procedure to avoid such errors .

Either you can capture the exception and write in a table if your procedure runs in background or simply throw the SQL exception message from dummy table.

Check exceptional handling in SAP Documentation

Thanks

Siva