RE: SAMLSP* database entries in 6.2

Yannik Horndt, modified 5 Years ago. New Member Posts: 9 Join Date: 1/31/19 Recent Posts
Hi everybody,
We're doing a migration from 6.2 to 7.2 and in the original db, there are tens of GB's of SAMLSP* (samlspauthrequest, session entries etc.) entries.
They've never purged those entries, so they go back years..
I've notices that the saml plugin has been introduced around the 6.1 time. The javadocs only have classes for saml cleanup in the dxp time.
Before upgrading, I want to delete those useless entries from the db.
Is it just as easy as deleting those entries via sql commands, or is there a more Liferay way, to do this via a groovy script?
I ask this, because I can't seem to find the 6.2 classes responsible for this in the javadocs.

Thanks and hope everyone is doing well!
Sincerely,
Yannik
thumbnail
Alberto Chaparro, modified 5 Years ago. Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts
Hi Yannik,
Can you specify the table where those entries are stored?
Thanks
Yannik Horndt, modified 5 Years ago. New Member Posts: 9 Join Date: 1/31/19 Recent Posts
Hi Alberto,
SamlSpAuthRequest (+- 20 million rows),  SamlSpMessage (+- 17 million rows), SamlSpSession (+- 3.5 million rows).