PPM and ALM integration

[RyanTran]

Hello,

I'm currently working integrating PPM Center with HP Qualtiy Center, using ALM. I have the integration currently working but when I checked history tables in ALM, I noticed the integration user has opened 140,000 sessions over the life of the program(2 weeks). I've looked at the dates/time and noticed that it would at some moments log in and out of ALM 4 times a second to perform the integration's rest calls. Is there a way to keep the user logged during the integration? Thank you for the help!

Regards,

Ryan

[Alonso_A_PPM]

Hey Ryan,

Why don't you try to modify the PPM timeout parameters?

Maybe those can help you.

Regards,

Alonso

[Oscar_Pereira]

Hello,

There is no specific table storing the integration sessions in PPM side.

So all the sessions belong to an integration user? Do you see a pattern on the amount of time for each session?

This requires some analysis on the ALM logs to see the Rest requests. qc and sa logs by enabling those in the Site administrator under server. Attach the logs where you saw the Rest requests…

Best regards,

Oscar Pereira

[Etienne_Canaud]

Hi Ryan,

There is currently no way to keep the ALM Session and reuse it. The current PPM / ALM integration will create a new session for each REST call between PPM and ALM (and subsequently properly close it once the REST call is done), which indeed results in a very large number of sessions created for the ALM integration user.

If this results in performance issues on ALM side, you should definitely open a defect.

If this only results in suspicious eyebrows raised on the ALM admins side, you might want to open an Enhancement Request if that becomes an administration concern. 

Kind Regards,

Etienne.

[RyanTran]

Hello,

Everyone thank you for the info. 

May I ask if there is a way to reduce the number of rests call that the integration will create? Space the Rest Calls farther apart?

-Ryan

[Etienne_Canaud]

Hi Ryan,

There's no way I know of except maybe reduce the value of QUALITY_CENTER_SYNC_MAX_RETRY_TIMES (number of time PPM will retry to sync upon failure), however I doubt it will result in a noticeable change.

Does this heavy session load creates performance issue on ALM side?

[RyanTran]

Hello Etienne,

The integration is currently not creating any performance issue with ALM, but the ALM's database will fill up. It is currently at about 170,000 sessions within a couple of weeks. 

-Ryan