Search
-
Re: Portal Giving Access Denied errors
Hi Bryan, What Errors are you seeing in the Webconsole Log file located in (C:\inetpub\CiresonPortal\bin\Logs)? Have you tried rebuilding the User Table First stop the Cache Builder service and then run the following commands against the ServiceManagement DB: * TRUNCATE TABLE CI$User * TRUNCATE TABLE LastModified Then… -
Re: Related Work Item Status Broken with Custom Incident.js
Hi Chris, There's a change to the way the multipleObjectPicker works in v6+. It can now pick up any property from a object in the view model and bring to the grid. For Enums, like Status, you therefore now have to specify you want the name property with "Status.Name". So that whole picker object should look like { name:… -
Re: How do you deal with the lag between Console changes and Portal?
If you are referring to updating the request offerings we noticed the lag also, the solution we used was to simply truncate the request offerings, last modified (and serviceoffering when new ones are added) table then restart the cache builder. There is a Cireson KB on clearing all the cache. the parts we use when… -
Re: WI status in Portal won't get updated unless do a recycle on application pool
-
Re: Convert IR to PR
One quick note on this script - if you care about keeping the Billable Time records on the original Incident, you'll need to modify it slightly. When working with an Incident, all of the Billable Time records are stored in the "AppliesToWorkItem" array. That array gets overwritten by the part of this script that adds an… -
Re: ServiceManagement database issue
Hi @alex_kokin I would suggest increasing the logging for CacheBuilder and investigating if there are any issues. When you truncate the LastModified" table, does the Workitem value get re-entered? If so, cachebuilder thinks it has done a check and everything is OK. The CacheBuilder log file should have some errors in it.… -
Re: Categories have gone!
There are a few things to check. * Have the catalog groups been changed recently? * Has the End User group in the console been changed recently? * Has the End User group definition in the portal been changed recently (admin settings)? * Have any of the underlying AD security groups been changed recently? * Have you tried… -
Re: Import not scoping users on first import
The LastModifed will provide that last time the sync ran. The config file shows the time frame in minutes until the next time its ran. Since I restart the cache builder at a specific time every week I know that value. Meaning if you stop the builder,truncate lastmodified and start the service at Noon, then you know each… -
Re: Cireson service manager portal not syncing with service manager
More detail: We added the bold line below to the Cireson Update Existing Service Requests SQL agent job. Basically it’s processing only service requests and ignoring other type of requests now. Without this line it fails. Our emails are submitted as service requests and not incidents so this change doesn't affect us but it… -
Re: How to create custom views on Analyst portal contain both Incident and Service Requests
@Ibrahim_Hamdy This query should be close to what you want: SELECT WorkItemId AS [Id] ,Title ,sds.DisplayString AS 'Status' ,AssignedUser ,AffectedUser ,CdS.DisplayString AS 'Category' ,tds.DisplayString AS 'SupportGroup' ,LastModified ,Created FROM [ServiceManagement].[dbo].[WorkItem] wi LEFT JOIN DisplayString SdS ON…