How to Identify PI-JDBC (Syncronous )PW expiry Scenareo

[tharaka_fernando]

Dear All Gurus,

We have developed some PI Interfaces (JDBC Synchronous) with legacy systems.Is there any way that we could identify/monitor when the JDBC password is expired or JDBC User Name is deleted from Legacy System ?

Ex : T-codde: using SXMB_MONI

[former_member184720 · Accepted solution]

Hi Tharu - If the credetials doesn't work then your channel would fail to connect. (communication channel monitoring - http://help.sap.com/saphelp_nw04/helpdata/en/44/2a1a8620323f0ee10000000a114a6b/content.htm)

You should configure alerts to get notified for such failures so that you can capture date&time and the error details too

[Former Member · Accepted solution]

Dear Hareesh ,

Can u please guide me how to configure alert for this kind of error.

how to get alert's for adapter engine error?

Thanks,

Arjun

[former_member184720 · Accepted solution]

What is your PI version?

If you are on >7.3 and if you want to use component based alerting then

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/03/25/michals-pi-tips-component-based-m...

else

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00e97ba2-85ce-2b10-20bc-bc05cd172...

[Former Member · Accepted solution]

HI

Thanks for ur reply.

I m using pi 7.31.

I have configured alert according to  below link.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00e97ba2-85ce-2b10-20bc-bc05cd172...

for Mapping error i m getting alert mail.but channel level error not getting alert mail.

[former_member184720 · Accepted solution]

which alerting did you choose during post installation? Is it component based alerting or classical ?

You can check it

NWA Configuration Infrastructure JAVA System Properties XPI Services: AF Core

•   Set the value of the alerting.target service property to 1. 

  and alerting.isActive (value true).

•   Set the value of the alerting.target service property in one of the following ways: 

  • Set 1 to switch on component-based message alerting. SAP recommends this option.

  •   Set 0 in case you want to use the "classic" Alert Framework mechanism. SAP does not recommend this option.

source :http://help.sap.com/saphelp_nw73ehp1/helpdata/en/b2/58b14b70744d0db55599230d2c5bce/content.htm

[iaki_vila]

Hi Tharu,

My few cents, if you want to test the credentials, if the database is running or  well-formedness of XML file you can use a tool provided by SAP and you can download it from the note 1085539 - XI JDBC/FTP connection Test and XML Validation Application

Regards.

[tharaka_fernando]

Further to above , How do we identify the exact error in PI in a scenario like this? Bcos When I check SXMB_MONI for messages, nothing is shown as "Failed due to UN/PW or User name doesn not exist" like this.

Need your advice on this...I'm bit new for this

[former_member184720]

Hi Tharu - As i mentioned earlier, you can find this error in the communication channel monitoring if the credentials are invalid.

http://host:port/mdt/channelmonitorservlet

[Former Member]

Hello Tharu,

I think the answer is "no". User management is usually entirely in the hands of the legacy system. How would it communicate this information to PI? If the system is under your control you could check expiry date and set an alarm for that date, but if it is out of control there is not much you can do. Be nice to the legacy system admins, maybe. 🙂

Regards,

Jörg