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

Start or Stop PI Channels with SAP system down

Hello how are you?

I'm trying to change the status of all channels del Adapter Engine SAP PI 7.11 using a Oracle SQL statement to put all the communication channels (soap, file, rfc, jdbc, etc) into a "stopped" state with the system shutdown.

update SAPSR3DB.XI_AF_ADM_STATE set ACTIVATION_STATE = 'STOPPED'

update SAPSR3DB.XI_AF_ADM_STATEHIS set ACTIVATION_STATE = 'STOPPED'

This statements works but not completely because some channels will remain in status "started"

Anyone can tell me some XI tables (JAVA SCHEMA) where does PI store detail info on "states" of communication channels?

Please dont tell me tables for cache like XI_AF_CPA_CHANNEL, SSRVCHANNEL, and so on...

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Sep 05, 2016 at 03:09 PM

    Hello Gaby,

    Please notice that it is unsupported from SAP point of view.

    This is problematic as in DB the representation is more complicated.


    There are actually 3 tables involved. Table XI_AF_CPA_CHANNEL contains all channels. To manually stop a channel, you need to update the respective entry in table XI_AF_ADM_AUTO to status MANUAL and then create an entry in table XI_AF_ADM_STATE with status STOPPED.


    Best regards,

    Bence

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Bence for your procedure!, I think that is not really safe and can cause problems.

      The true is: my idea to stop channels from a SQL statemens... sucks 😔

      So,the best way to solve my problem will be to put the server behind a firewall and then start SAP system. So, there is not posibility that any channels can connect outside.

      But if anyone have more ideas step by step it will be received with pleasure in order to share this with the SAP community.:)

      I found other workaround about why I could not see all channels from XI_AF_ADM_AUTO table:

      First at all SAP must be UP and runnning, then you have to set all channels in "stopped" and MANUAL status from RWB. Then execute sql statement (count) over XI_AF_ADM_AUTO table and you will see it now contains all channels that we have defined in SAP PI

      Thanks!

  • Posted on Sep 02, 2016 at 02:26 PM

    Dear Gabriel,

    I do not know what tables are stored this data, but what if you use the tool described here:

    Mass Processing of Communication Channel status in SAP PI

    I hope it helps.

    Best regards,

    Bence

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Bence, thanks for you suggestion. I already knew about this blog.

      But my point mandatory is: Make the changes of Channels state with the SAP system off. Only the database is up and runnning.

      Gaby

  • Posted on Sep 05, 2016 at 03:51 PM

    Hello Gaby

    I think is better Planning Availability Times

    see this link

    Planning Availability Times - Process Integration Monitoring - SAP Library

    Then you can configure your channel to be stoped at a defined time

    Then the channel will start in other defined time.

    I suggest no to access databesa tables directly.

    regards

    Juan

    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.