Skip to Content
author's profile photo Former Member
Former Member

Generic datasource

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

9 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2014 at 08:55 AM

    Hi,

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

    TIA

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 02:32 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 04:29 AM

    Have u given anything in safety interval?

    Regards,

    Jai

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 04:56 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2014 at 08:12 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2014 at 09:12 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2014 at 09:28 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2014 at 12:25 PM

    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



    Datatype.jpg (28.9 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2014 at 08:28 PM

    Hi,

    Solved..

    Thanks Prasanth

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.