cancel
Showing results for 
Search instead for 
Did you mean: 

Generic datasource

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

The field name is SYS_TIME and the datatype is NUMC length 21. The SYS_TIME hold the system timestamp.

TIA

RamanKorrapati
Active Contributor
0 Kudos

What about Date field? there is no one?

that length 21 it may includes date and time. so you need to have date.

former_member182516
Active Contributor
0 Kudos

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

former_member182516
Active Contributor
0 Kudos

Time stamp field will be a single field with the format "YYYYMMDDhhmmss".


There won't be any separate date n time fields. This field holds the information "Time at which data was created(date n time).


Regards

KP

RamanKorrapati
Active Contributor
0 Kudos

Got it. Thank You prashanth.

Answers (8)

Answers (8)

Former Member
0 Kudos

Hi,

Solved..

Thanks Prasanth

Former Member
0 Kudos

Hi Prasanth,

PFA the screenshot for reference.

And the entries are like

20140109141210

20140109141620.

So this object cannot be used as TIMESTAMP?

Could please confirm.

TIA


Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

RamanKorrapati
Active Contributor
0 Kudos

Hi,

For Time stamp your data source need to have date and time fields then only time stamp delta will work.

Can we know the field name which you used for time stamp.

Thanks

former_member182196
Contributor
0 Kudos

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 

jaigupta
Product and Topic Expert
Product and Topic Expert
0 Kudos

Have u given anything in safety interval?

Regards,

Jai

RamanKorrapati
Active Contributor
0 Kudos

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