on 07-14-2015 5:34 PM
Hi,
I am doing data integration for Time profiles by Web UI. I get rejection report with description as 'Check that first level period exist'.
My Time profile has 2 levels - Monthly (12 months in past & 24 months in future)
Yearly ( 1 year in past & 2 years in future)
Start date - 06/01/2014
End date - 07/31/2017
While creating csv template, Do I need to have 36 entries for monthly & 3 entries for Yearly ?
Please give me an example on this .
Thanx
Karthi.
Hi Karthi,
You do not have to necessarily upload data for the entrie range. However, for whatever time slot you are uploading the data, there should not be any gap.
From the error it looks like Month (child) is not perperly linked with Year (parent). Please review the data file again.
Best regards
Rinju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I have loaded data to Time profile by web UI, But load is failed with a blank Rejection report & Full report.
Also I have 42 records in my Csv file.
But log says Total records - 41, Successful records - 41.
Is it staging table has no sufficient space ?
Please suggest.
Thanx
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It is not possible the stagging table does not have space. So if I understood it correctly, log says, all 41 records are successful, but overall status of the job is 'Failed'?
Can you try to add an extra line at the end of the file and then try? Best would be to share the file.
Regards
Rinju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Karthi,
Given your start and end date, you will need to to have entries for 38 months and 4 years
Years: 2014, 2015, 2016 and 2017
Months: 2014 - 7 months (June to Dec), 2015 - 12 months (Jan to Dec), 2015 - 12 months (Jan to Dec) and 2017 - 7 months (Jan to July)
Hope this helps.
If you face more errors, please share your time profile data format.
Regards,
Aditya G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.