Cadet 1st Class
Cadet 1st Class
965 views

globallists list error during SM startup

Hi Experts,

 

I am getting the following errors when I start SM 9.40 services.

 

We have upgraded from sm 7.11 to sm.9.40

 

48560( 49321) 04/16/2015 08:40:38 RAD W Maximum of 100 entries in list for file: dept


48560( 49095) 04/16/2015 08:40:38 RTE A Mapping-3-globallists,application, SQL Query incomplete because field (application) not mapped in file (globallists) ; application(fillcombo), panel(select)
48560( 49095) 04/16/2015 08:40:38 RTE A Mapping-3-globallists,server.application, SQL Query incomplete because field (server.application) not mapped in file (globallists) ; application(fillcombo), panel(select)


48560( 49322) 04/16/2015 08:40:38 RAD W Maximum of 100 entries in list for file: dept
48560( 49324) 04/16/2015 08:40:38 RAD W Scheduler started for anubis class by anubis at 04/16/2015 08:40:38 GMT; sleep interval: 30 seconds; priority: -1
48560( 49324) 04/16/2015 08:40:39 RAD W Maximum of 100 entries in list for file: dept
49049( 49461) 04/16/2015 08:40:40 RTE I Using "utalloc" memory manager, mode [0]

48560( 49095) 04/16/2015 08:40:40 RTE A Performance-2-globallists, Partial File Scan for query involving fields {build.startup, application, server.application} ; application(fillcombo), panel(select)
48560( 49095) 04/16/2015 08:40:40 RTE A Performance-6-globallists, Hit Ratio not achieved on file globallists and query (build.startup=true and (not (null(application)) or not (null(server.application)))): Of 305 records checked, 303 did not match the query ; application(fillcombo), panel(next)
49049( 49462) 04/16/2015 08:40:41 RTE I Using "utalloc" memory manager, mode [0]

 

Would you please help as how to solve this.

 

Regards,

Madhan

0 Likes
3 Replies
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Hi,

 

Did you find solution?

 

Regards,

EP

0 Likes
Absent Member.. Absent Member..
Absent Member..

Hi Madhan

 

Yes, I have these messages too in OOB 9.40 system.

 

The latest release, 9.41, includes QCCR1E124604 which provides a reminder to use the "alertFilters" startup parameter to filter out these messages if you are not noticing any performance issues.

 

Regards

Matt

Absent Member.. Absent Member..
Absent Member..

Out of box, the globallists records are mapped as a binary objects*. If you look at the dbdict, you'll see that only a small number of fields are mapped to separate fields in the database.

 

The error indicates that one of those fields (server.application) is not mapped to the database as a field (it's in the binary object) and cannot be used in a query. But the application IS including it.

--You could add a mapping of the server.application field. this would remove the error.

--If the globallists are actually updating correctly, you could also just ignore the error. 

 

*There are several tables mapped similarly where the table is really only used by the SM application and does not need to be exposed for reporting (e.g. profiles, secRoleRights, datadict). 

----------------------------------------------------
Kudos - what, where, how, and why
Want Good Answers? Ask Good Questions...
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.