cancel
Showing results for 
Search instead for 
Did you mean: 

SCCL_Taking long time at one table_COEP_ECC6_Oracle10

Former Member
0 Kudos

Hi all,

I am doing local client copy. First I run testrun and added the space as mentoned in the output result.

I started client copy I took very long tme (>2hrs) for JSTO table when I check in /usersap/trans/log it is showing

Background job not running properly. Function: Q Jobcount: 16303000 Status: Y.

Please check the system. Use transactions SM21, SM37, SM50.

SM21: shows: Database error: TemSe->XRTAB(0)->1 for table TST01 key [500]JOBLGX02420500X20583,1

SM37 - showing only this job in active state

Standard jobs are running periodically

1. I run SP12 -> consistancy check and deleted the error requests.

2. In 000 client with DDIC client executed again RDDNEWPP with high priority

Then around 2000 tables processed.

But again struck at table COEP for the past 3hours. consistencycheck not showing any error requests.

/usersap/trans/log it is showing continuously showing the same error (right from the start of activity)

Background job not running properly. Function: Q Jobcount: 16303000 Status: Y.

Please check the system. Use transactions SM21, SM37, SM50.

Will the table COEP (contain more than 2,345,198 entries) takes that much time? or any wrong in the process??

Thanks in advance

S@PM@N

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Please perform the Consistancy check manually and run the Program PDDNEWPP with ddic user and client 000.

Please check that you have enough work and background process in the system.

Thanks

Rishi Abrol

Former Member
0 Kudos

Hi,

We also face the same issue in the table COEP.

Pls see the below note

Note 70290 - CC-INFO: Excluding tables with 'RSCCEXPT'

This will solve your issue. We excluded the top 10 tables while exporting and we did the import of those tables at database level.

Regards,

Raja. G

Former Member
0 Kudos

Hi Raja,

Very good stuff. But while the client copy going on how to exclude the tables

Do you mean we can stop the client copy and exclude the tables in RSCCEXPT report.

Can we stop and start Client copy activity if so will start from where we stopped???

REgards

S@PM@N

Former Member
0 Kudos

I think we can exclude the table while the client copy is running also. But check the log whether the particular table has already imported or not in SCC3.

If not we can go ahead. But check the note also to confirm this.

Regards,

Raja. G

Former Member
0 Kudos

Hi raja,

We have excluded EQUI, OBJK and IHPA tables from client copy in the report RSCCEXPT

How ever still my local client copy is running with one table JEST.

How to import these 3 tables from database level.

Thanks

S@PM@N