on 01-09-2014 2:23 AM
Hi All,
I have read so many docus. but i could not find any releavent answer.
I created a delta enabled generic datasource based on tables. When i executed the IP - With data transfer it says no data available but when i executed the FULL IP , it extracts the data.
The initailsation is not set and in RSA7 the datasource status is in yellow status.
Could you please help out in this
TIA
Hi,
The field name is SYS_TIME and the datatype is NUMC length 21. The SYS_TIME hold the system timestamp.
TIA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Acer,
SYS_TIME with NUMC and length 21 is not a time stamp field. This can be used as delta based on numeric pointer.
Time stamp : The field is a DEC15 field which always contains the time stamp of the last change to a record in the local time format.
Data element of time stamp field should be in the below format.
YYYYMMDDhhmmss
Could you check the format of data your SYS_TIME field is holding?
Share the sample entries of your field SYS_TIME, you can change the delta from TIME STAMP to Numeric Pointer. this will work.
Regards
KP
Hi,
Solved..
Thanks Prasanth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Acer,
Even if you create delta enabled generic data source, while creating IP itself we have an option called Initialize without data transfer and Initialize without data transfer.
When you executing the info package you may initialize with data transfer and Initialize without data transfer. When you execute the IP Initialize without data transfer , you may not able to see none of the records.
At the same time, If the execute the same info package Initialize with data transfer ( FULL IP ), it automatically pull whatever the records given by the Setup table.
RSA7 is a delta queue monitor, when your datasource will pick the delta records , automatically RSA7 become which set's green.
Regards,
Baskaran T R
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raman,
There are 4 options.
1. Timestamp UTC
2. TImestamp Local
3. Calday
4 Numeric Pointer.
AMong this i have choosed the Timestamp Local and delta enabled as SYS_TIME.
In my case, I need to use the TIMESTAMP not date field. Please correct me if im wrong
TIA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Acer,
It seem problem with initialization only. I think you have done init without data transfer. If this is the case then you wont get data posted before this init. While delta you will get only those records which are posted after init. So in this case you have to do the repair full and then reinit without data transfer.
Or delete this init and do the inti with data transfer.
I think this should resolve your problem. Please try this and lets know if its doesnt work.
Thanks,
Kamal
Hi All,
Its a Time based datasource.
i think its not necessary to do a full load first, we can directly run the init delta with data transfer.
i can able to run init. w/o data transfer and after that elta is not picking any record but the timestamp in ROOSGENDLM table theelta d timestamp is updating correctly.
One thing i found is that the timestamp which i used has a datatype NUMC length 21...
Is that causing a problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
First time you need to full load then initialized the data source then run for delta if your data source is enabled for delta based on time stamp, numeric pointer or calday its depends up to you.
Regards,
SM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have u given anything in safety interval?
Regards,
Jai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What type of delta you selected for your generic data source(RSO2)?
timestamp or calday?
Delete your init, go to your info pack--> menu scheduler--> initialization options for source system, there you can see init, select and delete it.
Again run your info pack , init without data transfer. later check at RSA7, your data source will be green.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.