Skip to Content
avatar image
Former Member

Audit Tables - Missing Value

Hello All,

I'm looking into building my own reports off the Auditing tables (BI 4.1 SP6).

I have found that many events have a Client_Type_ID on ADS_EVENT table that is equal to AbI5_LpMFxFLhxl7DV91KYY.

However when I pulled in Client Application Type these rows all disappeared.

Investigation showed that table ADS_CLIENT_TYPE_STR that ADS_EVENT joins to has 49 entries but AbI5_LpMFxFLhxl7DV91KYY is not one of them.

Does anyone know what this entry means ?

Something pretty generic given it's applied to all sorts of event types, but strange that there's no entry in ADS_CLIENT_TYPE_STR.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 02, 2015 at 04:18 PM

    Hi Nick,

    I'm not sure whether I understood your problem correctly.

    How did you investigate this further? Did you filter for the value "Abl5_*" and you did not receive any rows for that although there are some?

    Best regards,

    Dennis

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2016 at 04:19 PM

    Hello, Thank you for mentioning this.

    I've done some analysis and I've determined there are actually 4 missing values. They are AbI5_LpMFxFLhxl7DV91KYY, AeHuywedXKRPl6V1sOVZNtA, AUcgkU0CbV1Co0ujVEw_gSA, AXUaxM4wcwtLqqcn7.eB5bQ

    These should be in the lookup table ADS_APPLICATION_TYPE_STR. The missing values I've mentioned are for Application Type ID

    Please log a SAP Support incident for this issue. When you do please mention my name and reference this number CSS1670026096


    AbI5_LpMFxFLhxl7DV91KYY is Web_IntelligenceReportService

    AeHuywedXKRPl6V1sOVZNtA is Translation Management Tool

    AUcgkU0CbV1Co0ujVEw_gSA I think the Crystal Reports RAS server.

    AXUaxM4wcwtLqqcn7.eB5bQ is CentralManagementService


    Thank you

    Matthew


    PS you might be interested in Unlock the Auditing database with a new Universe and Web Intelligence Documents for BI4.1/BI4.2

    Add comment
    10|10000 characters needed characters exceeded