Problem in Table System UPDATE

[fajarnrm]

Hi Everyone,

I have some problem with update table. table that I updated is CE1I100 (table system in SAP). before found problem my code program success to update data. but after some time I try to run, i have some error database like below

i try to ask for help with basis database administrator (in my company) for update partition table CE1I100. it's done update but i still have error like that. my code :

is there something wrong with my code? what should i do to solve this error?

addition, even i do edit with se16n using /h (edit manual) i get error that same.

Thanks a lot.

[moshenaveh]

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[Sandra_Rossi]

First, tell us what you have found and what you have tried.

Search: sql code 2055 maximum number of rows per table or partition reached

[fajarnrm · Accepted solution]

thanks all for a question. this problem solved. the process in the program that I made turned out to be so heaped up (maybe i could say the cache) so that the CE1I100 table couldn't make any transactions. the solution to overcome this is to UNLOAD the tables on the HANA database server side. after unloading, transactions related to table CE1I100 can return to normal. Hope you can help

[Sandra_Rossi · Accepted solution]

Thanks for the feedback.

Could you recommend any official documentation to help future visitors?

I see this one which explains loads and unloads:

2127458 - FAQ: SAP HANA Loads and Unloads - SAP for Me

But I couldn't find one which relates SQL error 2055 and loads/unloads.

Thank you.

[Dominik_Tylczynski]

Hello fajarnrm

See the note 3216228 - SQL error 2055 accessing : maximum number of rows per table or partition reached

You can also consider archiving unnecessary CO-PA data Archiving in CO-PA

Best regards

Dominik Tylczynski