Question

1
Replies
59
Views
JeremyR4 Member since 2019 14 posts
Segue Technologies Inc
Posted: 9 months ago
Last activity: 9 months 3 weeks ago

Pega Platform 8.2.1 - Import application hanging

Hello,

I put in a support request a while back regarding very slow application import speed and was referred to the article noted below which basically said to change the isolation level in the db to READ_COMMITTED_SNAPSHOT. I tried doing so by running the query in MSSQL:

ALTER DATABASE <DB NAME> SET READ_COMMITTED_SNAPSHOT ON;

The query never finished executing, I let it run for 2 days but it would never successfully execute the query. I created an empty test DB and ran the same command and it instantly executed the query.

I then tried running:

ALTER DATABASE <DB NAME> SET ALLOW_SNAPSHOT_ISOLATION ON;

executed successfully within a few minutes. Tried altering the DB again to read_committed_snapshot and again it just hung.

The application I am trying to upload it only 250MB, last time I tried importing it said it would take over 200 hours to import.

I tried again today and same thing. Not sure what is going on. Attached are the PegaRules log. Any help is greatly appreciated.

https://community.pega.com/support/support-articles/users-are-experiencing-extreme-slowness-after-pega-7-upgrade

Pega Platform
Share this page LinkedIn