So in CHG:InfrastructureChange form you dont see any index?
In Logs what is the query? I am not in office today may be by tomorrow i can give you the screenshot . we also have 9.1.02.
I do have indexes and logging shows it trying to build the table on ASGRPID and ChgImpGrpID.
7.6 had index definitions ASGRPID;Change Request Status, ChgImpLoginID; Change Request Status, but I'm missing these now in Dev Studio along with 4 others.
While doing SQL logging and attempting to create one of the missing indexes I can see it exists in the the schema; just not showing in dev studio and being used.
I'll need to see if the dba can rebuild the indexes on the T table and fix any broken views.
I still remember in 7.6.04 there were 5 additional indexes which BMC suggested to build . it was mentioned in their KB. Seems these are missing or Its there but not coming in dev studio.
2 of 2 people found this helpful
Rebuilding the indexes did nothing, they never showed up in Dev Studio.
In this case we deleted the indexes via sql readded them in dev studio, and after that the change console loaded normally.
Thanks for the time and interest Rahul.