Entries in TCOLL Table Missing after System Copy and ST03n Workload Data Not Available
Hi All, We have recently done System Migration. Our current Release is SAP Netweaver 7.00. OS: Windows Server 2012 and Database SQL Server 2012 Steps that we have preformed for troubleshooting. 1. Checked the System Time Zone. It is ok 2. Scheduled SAP_COLLECTOR_FOR_PERFMONITOR job on hourly basis from DDIC Client. The job is executing successfully. However no data is getting populated in TCOLL Table 3. Tried to execute RSSTAT83 and got the following Error "LOGDBSSCR NOT FOUND" 4. Tried to Execute SWSNCOLL report manually. Got the ST03n Work Load Statistical data but the issue is that the data is not getting updated. Just last 3 days Data available till the time I executed the report. Data not getting refreshed since then Can Anybody suggest an wayout, how to get back the entries in TCOLL Table Back. As a part of the post import steps we have also performed the below activities. We have deleted the old data by using the Activate and Adjusting the Table OSMON, PAHI, MONI Thanks and Regards Anurag
Ashutosh Chaturvedi replied
You are getting the error LOGDBSSCR NOT FOUND on running the report RSSTAT83 because SSCR table is not a part of ABAP Data dictionary.
You can export the content of TCOLL table from the system in the landscape where entries are present and then import in the other system.
So you can do it with the help of by creating transport of copies and adding the table TCOLL.
You can do it by R3trans export and import process by creating a script.