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 ? Aug 8 '20 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 '20 at 11:31

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.

  • The publishing service is meant to have a scheduled periodic task to clean up some of those records. Aug 8 '20 at 23:32

This is a confirmed issue in Publishing Module 9.3. Ticket number 381220.

Fixed in 10.0

​​The OperationCompleteTimestamp is set to null during a publishing job and this causes a nullable exception on the Sitecore side and empty data in the dashboard​.

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.