x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 74 subscribers
  • Views 266 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
L.Stahel

Fixing a corrupted view

Posted By

We recently changed several things on the Opportunity detail view in our CRM. Moving some fields, deleting some we did no longer need and adding new ones.

Apparently, while doing so, we also accidentally added the "opit_productid" somehow. Now we can no longer look at any Opportunity and I cant seem to find a way to edit the view from the administrative tools. We get following error message, when trying to view an Opportunity:

Is there a way to delete this field from the view another way?

Any help would be much appreciated.

  • 0

    If it is the screen Opportunity Detail Screen you mean via Administration -> Customisation -> Opportunity you could always try the following via SQL Server Management Studio

    1) back up the SQL database

    2) run the following select statement

    select * from Custom_Screens where SeaP_SearchBoxName = 'OpportunityDetailBox' and SeaP_Component = 'changed'

    order by SeaP_Order

    this should show you everything in the form

    3) then if you see the opit_productid field in the list you could run the following

    delete from Custom_Screens

    where SeaP_ColName = 'opit_productid' and SeaP_SearchBoxName = 'OpportunityDetailBox' and SeaP_Component = 'changed'

    4) run a metadata refresh from Administration -> System

    this is the only way I can think of removing the column if you cannot edit the form via Administration -> Customisation -> Opportunity -> Screens and modifying the Opportunity Detail Screen.

    I would take great care in manually deleting files in this way!!

  • 0

    Thank you for the reply.

    In the end I had to delete the entry for 'opit_productid' in the tables : Custom_Edits, FieldSecurity and Custom_Screens.

*Community Hub is the new name for Sage City