I am trying to port few keywords but the export is stuck at Expanding user selection and preparing list of items to export.
We have been seeing this issue from past few days. On good day it exports within normal time but on bad day it gets stuck in this step for 4 to 12 hours. Eventually it does export. The parent category of keywords I am trying to port has around thousand of keywords but either it should always have this issue or never.
At the same time if I try to port a simple component without any dependencies it gets exported.
enter image description here I have tried service host, com+ and app pool restart.

  • Is that scale-out CME environment? If yes, In 8.5 content porter not supported to use LB URL, it needs to use one of the box direct URL.
    – Velmurugan
    Feb 21 '19 at 13:42
  • Can you try running the Content Porter client on the Content Manager server? Does that produce the same problem? Is there anything in the log files on the server? (I can't remember off the top of my head where the Import/Export service logs to - apologies) Feb 21 '19 at 14:15
  • Server-side logging is done to the Windows Event Log (“Tridion”). Feb 21 '19 at 18:29
  • @Velmurugan I am using the direct URL. Feb 25 '19 at 14:57
  • @JonathanWilliams No nothing in event viewer logs. Feb 25 '19 at 14:58

This got resolved when we rebuild the SDL Web DB indexes.

  • Interesting! In general, it is worth taking a look at the DB maintenance tasks. In your case, was it a bad query plan that was causing the impact?
    – Shiva
    Mar 13 '19 at 23:17
  • It was to do with large previous portings as far as we know. Mar 14 '19 at 4:30
  • You should also look to clean up the import export temp folders in the CME servers.The values are available in the Tridion.ContentManager config.
    – Shiva
    Mar 14 '19 at 15:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.