03-10-2014 09:08 PM
We have upgraded our Service Manager 7.11 to 9.33 by running the upgrade utility. Post upgrade in the View/Merge Upgrade Results we see 4 errors listed which are related to inbox. Please suggest how to go about resolving these. Thanks in advance.
The errors are listed below.
24 28/02/14 12:12:01 Error adding to inbox On Query : container.id=226 and inbox.name="Assigned to My Groups" and inbox.type="cm3r" and operator.name="%NONE%"
24 28/02/14 12:12:02 Error adding to inbox On Query : container.id=290 and inbox.name="My active Surveys" and inbox.type="SurveyDefinition" and operator.name="%NONE%"
24 28/02/14 12:12:02 Error adding to inbox On Query : null(container.id) and inbox.name="Business Service - Email" and inbox.type="device" and operator.name="%NONE%"
24 28/02/14 12:12:02 Error adding to inbox On Query : null(container.id) and inbox.name="Closed Incidents opened by group Service Desk" and inbox.type="probsummary" and operator.name="%NONE%"
03-11-2014 12:10 AM
When you are getting this error ?
check whether same combination of inbox exists or not in system, new might be added by system OOB during upgrade having same unique containing as of your old views.
Assign Kudo, if found post useful and mark it accepted if solves the issue.
03-11-2014 04:15 AM
Thanks for your response.
We have completed running the upgrade utility and the SM version now is 9.33. Following the upgrade guide , the next step is to resolve exceptions and conflicts. When checking the Upgrade results we see 4 errors related to inbox as mentioned before. I searched for these in the upgraded 9.33 system but they are not present , also a backup of the old 7.11 version does not have these inbox records.
03-11-2014 05:23 AM
From errors it seems update on table "inbox" is trying to add query to view mentioned but if you are saying view are not present then these errors should not affect your system.
Check from To Do queue wheather these views are present in system.
03-11-2014 08:19 PM - edited 03-11-2014 08:20 PM
Abhijit, thanks for the reply. The views are not present in the To Do queue as well.
I checked on a different 9.3x HPSM and found that these missing views are out of the box views. Maybe I'd do a unl upload of the missing views and it should resolve these errors.
03-11-2014 10:22 PM - edited 03-11-2014 10:23 PM
All of the views listed appear to be new views that are related to the Survey functionality added as of 9.32+. Not sure why they weren't added, but they have the same names as those views.
(Note: it is not the ability to do surveys from SM--the survey component is a sampling engine where you can define sampling frequency and survey parameters to generate surveys in either 1. the external MarketTools Survey product or 2. an external web survey site, such as survey monkey).
03-12-2014 12:12 AM
Please check the inbox table with container id mentioned in the eror messages. There must be some other views with the same container ID in the upgraded system .
03-12-2014 04:53 AM
Yes Arpit even my first step was to search for inbox records with those container ids but there werent any. I have loaded these 4 OOTB inboxes using unl