Home Analyst Portal - Community

Can't display IRs which created via console

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.

Best Answer

  • Shane_WhiteShane_White Cireson Support Super IT Monkey ✭✭✭✭✭
    Answer ✓

    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

Answers

  • Shane_WhiteShane_White Cireson Support Super IT Monkey ✭✭✭✭✭

    Hi Steffen,

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

    Thanks,

    Shane

  • Steffen_DobritzSteffen_Dobritz Member IT Monkey ✭
    edited December 2020

    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_WhiteShane_White Cireson Support Super IT Monkey ✭✭✭✭✭
    Answer ✓

    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_DobritzSteffen_Dobritz Member IT Monkey ✭

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

  • Shane_WhiteShane_White Cireson Support Super IT Monkey ✭✭✭✭✭

    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_DobritzSteffen_Dobritz Member IT Monkey ✭
    edited December 2020

    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.

Sign In or Register to comment.