How you approach when you find that your process chain take a lots of time for

How you approach when you find that your process chain take
a lots of time for loading,tell me the step to increase the
loading performance,

Question Posted / sekhar02.info

2 Answers
16674 Views
Accenture, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How you approach when you find that your process chain take a lots of time for loading,tell me the ..

Answer / guest

1) change log clean up.
In RSPC > Use process type 'Deletion of request from change log'. In process chain variant options > enter no of days for data in change log to be cleaned.

2)Use RSPC_LOG_DELETE to delete old logs.>> specify the time period for the old logs to be deleted.

3) if "delete index" and "create index" process types are there in process chain then remove those process types and create a separate chain with them.Schedule this chain when the load is low.

4) Check for table space in DB02/DB02OLD and contact basis.

5)Kill the long running backend jobs in sm66/sm50

Is This Answer Correct ?

7 Yes

0 No

How you approach when you find that your process chain take a lots of time for loading,tell me the ..

Answer / saravana

Data load has to be checked through RSMO. In which, data
load status to be monitored.

It might be problem with connectivity b/w BI and Source
system or it might be because of data load package size. If
it takes longer than normal load time, then mostly package
load will fail.

For that, data load has to be started manually.

NOTE: Data load mustn't be stopped in middle for ETL
process through PC.

Tocheck for connectivity we use SM59.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More SAP Business One Interview Questions

what is concept behind incoming payment and outgoing payment?

2 Answers Wipro,

What are the different objects in di api ?

0 Answers

Which property of matrix gives the total number of rows in the matrix ?

0 Answers

AFTER A PURCHASE ORDER HAS BEEN APPROVED, AND PRINTED, AND THERE IS NEED TO MAKE CHANGES ON THE P O, DO I CANCEL THE OLD P O OR DO I JUST EDIT AND SEND FOR APPROVAL?

4 Answers

Which table saves the details of country ?

0 Answers

What are three dimensions provided by SAP?

4 Answers TCS,

how to get certification for SAP B1? What are all the institutes in mylapore and T-Nagar for SAP B1?

1 Answers SAP Labs,

What is difference between matrix and grid in sap business one?

0 Answers

What is di api in sap business one?

0 Answers

Can we load the datatable directly using sql query ?

0 Answers

What are the different types of transactions supported by di api ?

0 Answers

If we are Extracting Data From SD Application component.ie Ex:- sales and billing 2lis_11_vahdr & 2lis_13_vdhdr Data Sources.Can I load From These 2 Data Sources to sales overview Cube 0sd_c03.Can you Explain the procedure.

0 Answers

For more SAP Business One Interview Questions Click Here