Home› Analyst Portal - Community
Options

Can't display IRs which created via console

Steffen_DobritzSteffen_Dobritz Member IT Monkey ✭
in Analyst Portal - Community

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

  • Options
    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

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

    Hi Steffen,

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

    Thanks,

    Shane

  • Options
    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.

  • Options
    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

  • Options
    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.

  • Options
    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

  • Options
    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.