on 04-04-2014 12:48 PM
Hi Experts,
I am performing Database export for TDMS Shell Creation for SAP ERP. I am able to see in Migration Monitor, all packages have been exported except SAPSSEXC. The export of package SAPSSEXC is still running and taking too long and is running from past two days. I have checked my DDL<DBtype>.TPL file , it is correct and it is not exporting complete database. Even no error can be viewed in the logs.
Please suggest how much time generally SAPSSEXC package takes to export.
Thanks in advance.
Regards
Megha Aggarwal
Hi Megha
Check SAPSSEXC.log for error or current status, on which object is running or error..
e.g, the log files will have entry for the objects completed as below;
>>>>
(DB) INFO: "OBJECTS_NAME" created #with timestamp
(IMP) INFO: import of OBJECTS_NAME completed (n rows) #with timestamp.
<<<<
You can check the object "OBJECTS_NAME" from task file SAPSSEXC.TSK, so you can see the progress for this package.
regards
Swami
Ps : OBJECT_NAME = table or index
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Megha,
Export of SAPSSEXC should not take that long. Check if it exporting huge cluster tables under this
package. Can you attach all the SASSEXC.* files here?
BR
Isha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Megha,
I looked into files, as suspected large system tables are being exported under this package.
As per the file details, as of now two tables which took time were DYNPSOURCE and INDTEXT.
and currently table REPOSRC is running since yesterday (as per the logs).
These are system tables and it is recommended to do table splitting for these tables.
There is an activity "View Size and Name of Largest Tables" in shell creation package which will give
you the largest tables and their size. You can review the list and do the table splitting.
BR
Isha
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.