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

Process chain error "Data Source 3FI_GL_0L_TT must be activated"

Hi Experts,

I got Process chain error "Data Source 3FI_GL_0L_TT must be activated" and had done below steps by seeing some forums:

1. Run Program " RSDS_DATASOURCE_ACTIVATE_ALL" but i got following error message text " &,.Error when activating data source R3PCLNTXXX".

2.Right Click on data source and select Manage option in RSA1 and i got message as " Invalid data store object name /BIC/B0000102:Reason:No Valid entry in table RSTS" and i tried option "Replicate meta data" but still i am unable to solve the issue.

Please guide me step by step solution to solve my issue.

Thanks &Regards,

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    Posted on Oct 25, 2011 at 09:49 PM

    Hello,

    I suspect the problem is with the PSA table for datasource 3FI_GL_0L_TT.

    Please go to se14 and check the table status of /BIC/B0000102, it is

    most likely only 'partially active'.

    So the problem is that the datasource can't activate the PSA table, this

    is why it fails.

    Please try to activate it with the option:

    "Activate and adjust database"

    After activating the PSA table directly in se14, I think it will be

    possible to activate the datasource 3FI_GL_0L_TT once more.

    Best Regards

    Barry

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2011 at 07:03 AM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2011 at 07:14 AM

    Hi,

    You need to replicate the data source(if data source is already active) and then activate the transfer struture to rectify the issue.

    First right click on the datasource and then replicate it. Then execute program RS_TRANSTRU_ACTIVATE_ALL to activate the transfer structure of the data source. You will need to provide the source system name and info source name which exists for the data source.

    If data source is not in active state then first activate it by following the steps as mentioned in previous postings and then follow the steps mentioned above.

    Also first check if teh source system connectivity is fine byt doing the source system check from SM59 transaction.

    Navesh

    Edited by: navsamol on Oct 13, 2011 9:15 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2011 at 08:44 AM

    Hi,

    IF you are facing this error in Productions system first check is there any transports happned related to this data source(data flow) on that day or one day before.

    You can check this in table e070 and inform that person to collect all the active objects and transport it again.

    I think this is becaues of missing some objects while coolecting.

    Regards

    Venkat

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2011 at 12:30 AM

    Hi Narasimha,

    RSTS table store all the PSA table names related to data sources.

    It seems PSA related to this DS got corrupted.

    1)activate the data source in DEV and make sure PSA has been created for same and entry in RSTS.

    2) transport the same DS till Production

    Regards,

    Venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi All,

      My Data source is under BI 7.0 data flow hence there is no use to run "RS_TRANSTRU_ACTIVATE_ALL" to activate transfer rules.Please correct if i am wrong.

      I have checked R/3 client settings and we have only one R/3 client connected to BI system and data source is active in R/3 side and able to extract records but inactive in BI side but while activating in BI side i am getting error as " Data source 3FI_GL_0L_TT could not be activated" .Is this data source is obsolote now?

      I am looking how to activate the data source in BI 7.0 and data mentioned in data source definition seems to be fine.

      Please throw some light

      Thanks&Regards,

      narasimha.

  • Posted on Oct 14, 2011 at 06:12 AM

    Hi,

    This issue might be arising in case you have recently moved your transport related to this object.

    Just see source system is also connected correctly.

    If above is fine see you can carry out replication for transfer strcuture ,datasource etc again.

    RS_TRANSTRU_ACTIVATYE_ALL

    RSDG_TRFN_ACTIVATE etc.

    If still it doesn't solve your problem try to transport objects once again.See if there is any issue with transports,you can manually activate object in the system in case there is inconsistency.

    Thanks and regards

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2011 at 10:06 AM

    Hi,

    You can run the program "RS_TRANSTRU_ACTIVATE_ALL".If it does not work then you can do in this way: right click on DS-->Display Datasource In Source System.It will take some time.After that run the program "RS_TRANSTRU_ACTIVATE_ALL".

    Hope it will work.

    OR

    you can check this URL :

    how to activate a BW data source

    Regards,

    Koushik

    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.