TM (Travel Management)
TM (Travel Management) Forum
I want to know that what are the delete step of SAP TM archiving is ending with a runtime error like DBIF_REPO_SQL_ERROR.
Kindly share your valuable views here.
Thanks in advance.
This runtime error points to a too big work load for the database when executing the delete step of SAP TM archiving. The default settings for SAP TM archiving objects do not define values for the Maximum Number of Data Objects. As result the system is collecting as many documents as possible, until the Maximum Size in MB (default: 500 MB) is reached for the archive file.
The recommendation is in general to not to collect more than 50,000 (fifty thousand) documents into one archive file. In addition, the system should do a COMMIT WORK after having deleted 25,000 (twenty five thousand) documents.
These two values need to be defined in the archiving objects of SAP TM:
Sign up for STechies
Ask Question From Our Experts
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.