Question

Unable to load column information for view in Query Builder.

  • 28 May 2021
  • 1 reply
  • 103 views

Userlevel 5
Badge +6

It is not possible to load column information for view in Query Builder.
The message: "Failed to load columns"is displayed, and can't create a query using the query builder.

Following are the steps followed to recreate the issue.
1. Login to IFS Enterprise Explorer as Application Owner
2. Execute new creation on the "Query Builder" screen.
3. Enter the Title name as "Test Query".
4. Enter "SITE" or any other LU at Search views to see a list of views.
5. Unable to refer to view column. The message: "Failed to load columns …" appears.
6. An error occurs when selecting a view, right-clicking, and executing "Add All to Columns".

We have tried refreshing the following cache elements and still the result is same.
1. Dictionary Cache
2. Reference Cache. 


This topic has been closed for comments

1 reply

Userlevel 7
Badge +16

Hi @Jagath Kandambi ,

 

Please check whether is there any specific error in debug consol. I found 2 bugs.

134473 this for app9 and binary patch - 155716 for app10


However in these scenarios there was a below kind of error in the debug console

The client name [XXXXX] is too long to be converted into a 30 character database name