ETL load for Project Analytics has many Errors
716953Aug 20 2009 — edited Aug 21 2009Shyam
I created new thread for the ETL load error we are having. Our ETL loaded with the followign status
Total Number of Tasks 302
Number of Succesful Tasks 82
Number of Failed Tasks 214
I went to the failed tasks at the bottom and looked at the log files and the target tables. For many of them there dont seem to be any problem.
For example the task SDE_ORA_Project had the status as Failed. When I clicked Details for the line , it said
Truncate table W_PROJECT_DS - Completed
SDE_ORA_Project - Completed
Analyze W_PROJECT_DS - Failed
And I opened the log file ORA_R12.DATAWAREHOUSE.SDE_ORAR12_Adaptor.SDE_ORA_Project.log under folder SessLog. I just took few lines to show you the status
Read [178] rows, read [0] error rows for source table [mplt_SA_ORA_Project.LKP_PROJ_CUST{{DSQ}}]
Read [326] rows, read [0] error rows for source table [HR_ALL_ORGANIZATION_UNITS]
Read [3] rows, read [0] error rows for source table [mplt_SA_ORA_Project.LKP_PROJECT_TYPE_CLASS_CODE{{DSQ}}]
Read [2] rows, read [0] error rows for source table [mplt_SA_ORA_Project.LKP_PROJECT_FUNDING_LEVEL_CODE{{DSQ}}]
Read [3] rows, read [0] error rows for source table [mplt_SA_ORA_Project.LKP_PROJECT_SECURITY_LEVEL{{DSQ}}]
The session completed with [0] row transformation errors.
Then i went to the target table W_PROJECT_DS and it had 326 records. THis is the same for many of the failed ones. Remember , our first load failed due to accidental shutdown of the server. This is the second run after I did "Reset Data Sources"
So the otehr problem is our dashboad still shows sample data ( 1.Overview,2.Rankers&Toppers,3.History&Benching,4.Tiering&Distribution). Some of the Project Ananlytics loaded. So i dont know why it did not change. We are using Administrator user. SHould we use a different user.
Thanks