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

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.

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  

---

Can we load the datatable directly using sql query ?

0 Answers  

---

what is cell formatting? and advantages?

0 Answers  

---

Why sap business one?

0 Answers  

---

Which are the dll’s used in sap business one sdk?

0 Answers  

---

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

0 Answers  

---

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

0 Answers  

---

WHERE DO YOU STORE THE MASTER DATA IN BI 7.0

8 Answers  

---

Difference between UNION and UNIONALL

1 Answers   Axtria, ITC Indian Tobacco Company, TCS,

---

What are the limitations of di server?

0 Answers  

---

hi 1.while monitoring process chains i got an error that "activation was failed"what is the reason for failure and how did u solve that problem? 2.Process chain is going on running but it is not completing ,stopping?what are the necessary steps we have to take to solve the problem? 3.If there is any duplication in the cube ,how to rectify it and how to solve the duplication in the cube? 4.we have created one new field in the extractions which is not presented in the communication structure ,but the problem is how to bring the created field in to the cube? 5.what is meant by compressin? here the problem is we are deleting the request id,s what about the data depending on the id? 6.For improving the query we will create aggregates ? how the internal process will takes place to improve the query? what is meant by aggregate? 7.how to schedule the process chain "in a month first five days "i have to schedule the process chain? how? 8.what is meant by archiving? Support question service level aggrement: If we are unable to solve the ticket with in the service level aggrement? what are the necesary steps we have to take? these are the question i have faced on ibm interview,ok byee thanks&regards suresh kumar

4 Answers   IBM,

---