Job Name: SAPSPOOLCONSISTENCYCHECK Report: RSPO1043 Variant: Standard Variant Frequency: Daily Job Description: Job is for Spool data (Temse) consistency check.The report can delete inconsistencies in the background and it only deletes inconsistencies if it has found them in repeated runs. SAP ABAP Program RSTS0020 (TemSe: Data Consistency Check) - SAP Datasheet - The Best Online SAP Object Repository. Consistency check, spool requests, temse objects, spool request, batch input, temse object, consistency checks, spool consistency, header entry, report rspo1043, table tst01, administration, memory allocation, transaction, medium exchange, genuine inconsistencies. Incorrect spool assignment for the background step: 406363: Spool error: START. RSTS0031 is a standard ABAP INCLUDE available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.
SAP TemSe consistency check is to check wether entries in the TemSe data store are consistent. The TemSe consistency checks the header entry in table TST01 (TemSe objects) and object associated with the header entry; it can be stored in the file system or in the database table TST03 (TemSe data of the object).
Skip to end of metadataGo to start of metadata
1, What does SM65 do?
-detecting inconsistencies between batch tables, e.g. find TBTCO entries without corresponding TBTCP entry
2, Where can SM65 help?
-checking server configuration
-finding and deleting incomplete job definitions
3, Where can‘t SM65 help?
-find out why job was aborted
-prevent short dumps in the coding
-fix problems with Temse
4, How to perform SM65 inconsistencies check ?
1) Simple mode test - initial screen of transaction code SM65
2) Expert mode test, select SM65 ->Goto -> Additional tests. Under system wide tests, you can choose options to determine all job servers, 'perform TemSe check','execute external programs', 'consistency check DB tables' and 'Remove Inconsistencies' function to remove any found inconsistencies. You can also set the authorizations under a specific user. Click execute to perform the test.
5, How to check batch table consistency regularly ?
RSBTCCNS performs the table consistency check. you can schedule SAP standard job SAP_BTC_TABLE_CONSISTENCY_CHECK to Check batch table consistency. Please refer to 1440439 - New Standard Jobs (2)
6, Why are there inconsistencies?
-For example,If applications do not delete jobs after JOB_SUBMIT fails, there will be an inconsistency
7, Is there any warning in transaction SM65 on the lower release system?
Before the introduction of note 1549293, the consistency check in SM65 locked the complete batch tables. This means, that batch jobs cannot be created, modified or executed during the run of the consistency check. After the implementation of 747798 sap note, there will be a warning message.
747798 - Missing warning in transaction SM65
8, Some known issues/improvements of SM65
Please keep in mind that there are following issues/improvements of SM65
1893670 - Problems with RSBTCCNS (SM65) 1268572 - Improvement to batch consistency check (SM65) 973411 - Consistency check of the batch system: Optimizations 704572 - SM65: 'Test all job servers' does not work
Caution
On lower release system(which lower than 1549293 SAP Note ), While SM65 is running, no jobs can be created or processed, Because the SM65 consistency check of the background processing database tables (TBTCO, TBTCP, TBTCS, BTCEVTJOB, TBTC_SPOOLID, TBTCCNTXT) completely locks the table TBTCO during its entire runtime. However, after implementing the improvements of 1549293 SAP Note by support package only, the consistency check does not lock the whole TBTCO any more and it also does not touch jobs that are currently created, which means that it is safe to run SM65 check.
1549293 - SM65: Improvements in consistency check
Perform a Consistency Check and Clean Temse Directory
I'm having problems with the STMS on the Development Box, from the look of things I need to clean the temse directory. What sought of routine can I perform as clean up routine regarding the same.
This is the procedure clear and test the consistency of temse objects in case of 3.1I.
So first excecute SPAD, where click on the consistency check button.
- this will display a list of objects. check to see the whether objects other than current day is displayed.
- then go SP12, here click on temse database button, where there is again consistency check.
Temse Consistency Check Background Image
- after the consistency checks are over, click on temsedatabase button, select reorganisation,
- here select the radio button that shows 'delete all objects older than'. Here enter the value and click on tick mark.
- this will display the number of objects. then delete it.
That's all the procedure.
Sudhakaran
Read also: Names of SAP Standard Admin Jobs
Temse Consistency Check Background Sheet
SAP Basis Reference Books: SAP Basis Components, System Administration, Security, ALE and iDoc Books
Back to Basis Menu: SAP BC (Basis Components) Hints and Tips
Return to :- SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips
(c) www.gotothings.com All material on this site is Copyright. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. All product names are trademarks of their respective companies. The site www.gotothings.com is in no way affiliated with SAP AG. Any unauthorised copying or mirroring is prohibited.