0

We have Sitecore 9.3 instance with installed Sitecore Publishing Service 4.1.0 and Sitecore Publishing Service Module 9.3.0.

Publish itself works fine to all targets: items are appeared in corresponding databases. But when we navigate to Publishing Dashboard - it is empty (no active/queued/compeleted jobs).

There is an error in browser conlose:

Requested URL: "https://mywebsite.com/sitecore/api/ssc/publishing/jobs/%7B00000000-0000-0000-0000-000000000000%7D/All?sourceDatabase=master"
Status: 500
Message: "Nullable object must have a value."

enter image description here We have a lot of environments for our solution and faced this issue many times. Almost always it was relolved by sitecore_master_index rebuilding. Now we have two CM servers with load balancer, each CM server has its own Publishing Service hosted at the same server.

What we try to do:

  1. Rebuild sitecore_master_index
  2. Clear browser cache and restart App pool/IIS
  3. Clear Temporary Asp.Net files from IIS

It did not help, issue is still present. Did you faces this issue or have any ideas how to fix it?

  • If there are 2 CM, is there an instance that is running as an indexing role ? – Vincent Lui Aug 8 at 11:22
  • No, we do not have separate instance for indexing. Both CM servers have single one common master database and index in Solr. – x3mxray Aug 8 at 11:31
1

We found a solution that worked - clear dbo.Publishing_JobQueue table in master database:

 delete from [mywebsite_Master].[dbo].[Publishing_JobQueue]

It is very strange, besause of all records in this database look fine:

enter image description here

After deleting this data, Publishing Dashboard starts to work as expected: tables on the page are populated with new publishing jobs statistics.

This solution works, but keep in mind that by clearing this table you lose statistics about past publishing jobs.

| improve this answer | |
  • The publishing service is meant to have a scheduled periodic task to clean up some of those records. – Vincent Lui Aug 8 at 23:32

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.