KB47669: Duplicate columns are not listed in Enterprise Manager using "RP Number of Jobs accessing DB table/column" metric in MicroStrategy Enterprise Manager 9.4.x.

• Strategy

An Enterprise Manage report with the “Column” attribute and the “RP Number of Jobs accessing DB table/column” does not return any data with duplicate columns.

SYMPTOM:
An Enterprise Manage report with the “Column” attribute and the “RP Number of Jobs accessing DB table/column” does not return any data with duplicate columns.
The SQL of the above report is as follow:


select  a11.IS_COL_ID  IS_COL_ID,
    max(a11.IS_COL_NAME)  IS_COL_NAME,
    count(a11.IS_JOB_ID)  WJXBFS1
from    IS_REP_COL_FACT a11
group by    a11.IS_COL_ID

And data for the duplicate columns are stored as below:

Data in IS_COL:

Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid
Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid
Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid

Data in IS_REP_COL_STATS (statistics table):

Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid
Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid
Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid
Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid	Replace folderID with the ID of the folder that you want to display. IS_COL_IDIS_COL_GUIDIS_COL_NAME7890032A1984AFD6BCA01E67DA92B177243itemid (1)79004362C804AD8441D4C09A19A3F60A800itemid (2)JOBIDCOLUMNIDCOLUMNNAME458830032A1984AFD6BCA01E67DA92B177243itemid458940032A1984AFD6BCA01E67DA92B177243itemid4592904362C804AD8441D4C09A19A3F60A800itemid

However, no data is retrieved for the IS_REP_COL_FACT view.
CAUSE:
This is a known issue with Strategy Enterprise Manager 9.4.x.

ACTION:
Strategy will continue to investigate and post updates as soon as they are available.

Comment

0 comments

Details

Knowledge Article

Published:

March 31, 2017

Last Updated:

March 31, 2017