Can't display IRs which created via console

Steffen_Dobritz

Hello there,

I created an IR via console. Then I switched to Portal and can't opened it. But I can open any IR in the Portal, which is created via Portal. I also restarted Cireson services.

Shane_White

Hi Steffan,

Thanks! Interesting, do you have any errors in the Cachebuilder log?

If you have SQL permissions can you run this query against the ServiceManagement DB:

Select * From dbo.WorkItem

Where WorkItemId = 'IR19867'

Thanks,

Shane

Shane_White

Hi Steffen,

Do you get any errors in the webconsole.log file?

Thanks,

Shane

Steffen_Dobritz

Hi Shane,

thx for quick response:

2020-12-22 16:10:54,548, ERROR [ 31]: Unable to retrieve ID for work item: IR19867

2020-12-22 16:11:34,512, ERROR [ 45]: Unable to retrieve ID for work item: IR19867

I also tried this.

Shane_White

Hi Steffan,

Thanks! Interesting, do you have any errors in the Cachebuilder log?

If you have SQL permissions can you run this query against the ServiceManagement DB:

Select * From dbo.WorkItem

Where WorkItemId = 'IR19867'

Thanks,

Shane

Steffen_Dobritz

I don't have a table called dbo.WorkItem on ServiceMnagement DB. No errors today in Cache Builder Log.

Shane_White

Hi @Steffen_Dobritz

You should...t this is where all the workitem data in the portal is stored. Is your Database called ServiceManagement or have you named it to something else?

Thanks,

Shane

Steffen_Dobritz

Hi @Shane_White

sorry I thought u meant the serviceManager DB and sorry for the delayed reply. The result of your query was empty. But everthing works fine after restart the Cireson services. The issue is solved now. Can't reproduce it at the moment.