Skip to Content
avatar image
Former Member

Adapter is in stopped status in event stream processor cockpit

I am using design studio 1.6 with SAP ESP 5.1 SP11. when I am loggin in to cockpit I always see adapter is in always stopped status. I am attaching snapshots of the error.

Can someone please help. I have created odbc connection on the server where ESP is installed, I have studio also on the same server. Created odbc connection to conect to database. then in studio in data services I created the connection and have build the whole model.

after I published it on server when I logged, I see that error in cockpit. published project is always in running status.

Thanks

Happy

adp1.png (31.2 kB)
adp2.png (8.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 24, 2017 at 01:02 PM

    From Studio, are you able to Discover the database schema using that ODBC service?

    Is the ESP cluster running on the same machine where you are running ESP Studio?

    Can another application connection using the same ODBC DSN?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Robert,

      Adding dbo solved my issues, I could fetch the data and I had to add the same in input adapters.

      Input adapter stayed in running status only till it is fetching data once data is loaded they go back to stopped status. I realized when connected large table.

      output adapter always stays in running status.

      table = '\"dbo\".\"ESP_output_V2\"' ;
      

      Thanks a lot again for your help.