Skip to main content
Solved

Alliance Customer Center module - QBE Metadata Error


Forum|alt.badge.img+6

We have one user that is experiencing this error when trying to access the Customer center module. It occurs on any machine we try to use her credentials on. It is not something we have ever encountered. Any suggestions before I issue a support ticket?

 

 

Best answer by Phil Seifert

There is a table cp_application_view which if you have DB access where you can find all the views for that user and it also has which modules, etc.

Perhaps you can find the views for that user and module and delete those row(s) from a DB level?

Deleting a view with the method described by Reid normally would just delete the row but if you can’t get that far….

 

 

View original
Did this topic help you find an answer to your question?

8 replies

Reid Gilbert
Superhero (Employee)
Forum|alt.badge.img+15
  • Superhero (Employee)
  • 342 replies
  • August 22, 2024

Can you try deleting the current view?  If you click on the arrow for the view and then select a DIFFERENT view option that should enable the Delete button so try to get the view back to the standard default view and see if that helps…
 

 


Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • 20 replies
  • August 22, 2024

HI Reid, I cant get that far. The module does not open. When I try the drop arrow for the view options, this is what I get

 

 


Reid Gilbert
Superhero (Employee)
Forum|alt.badge.img+15
  • Superhero (Employee)
  • 342 replies
  • August 22, 2024

I suspect this one might require a cleanup script at the database level, so I would suggest that you log a support ticket for it at this time…
Thanks,
Reid


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+24
  • Ultimate Hero (Employee)
  • 1317 replies
  • Answer
  • August 22, 2024

There is a table cp_application_view which if you have DB access where you can find all the views for that user and it also has which modules, etc.

Perhaps you can find the views for that user and module and delete those row(s) from a DB level?

Deleting a view with the method described by Reid normally would just delete the row but if you can’t get that far….

 

 


Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • 20 replies
  • August 22, 2024

Thanks guys. I will issue a ticket. I would like to determine the root cause if possible. 


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+24
  • Ultimate Hero (Employee)
  • 1317 replies
  • August 23, 2024

Hi Sean,

I know you logged the case in our portal but I am unclear whether the solution we proposed resolved the issue or not as you flagged the question as answered.

It should be an issue with data in the database as you reported this occurs regardless what client the user operates thus is not a caching issue.


Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • 20 replies
  • August 23, 2024

What Reid proposed is not an option as I the module does not even open to a point where I can delete a view.

What you proposed, I have no access to. So no, the issue is not Resolved. I clicked “like” believing it would simply end this string with no further action. I issues temporary alternate credentials to the user as a work around and issued the ticket.

 

Thanks again for the quick responses. 


Forum|alt.badge.img+10
Smstovall wrote:

We have one user that is experiencing this error when trying to access the Customer center module. It occurs on any machine we try to use her credentials on. It is not something we have ever encountered. Any suggestions before I issue a support ticket?

 

 

Deleting the view is one way of solving the issue, but I found that sometimes an invalid character (Form Feed) gets saved into the XML.  The view can be fixed with this query (replacing {person_id} with the user’s ID)
 

update cp_application_views set view_data = replace(view_data, '', '') where created_by = '{person_id}' and view_data like '%%';

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings