cancel
Showing results for 
Search instead for 
Did you mean: 

Audit Tables - Missing Value

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Matthew_Shaw
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

I had a query that was pulling in Event Type, Event Time, Object Name and a few other things.

I noticed that for reports where I right click and select View that I was getting two View rows within seconds of each other so was trying to determine what they were.

I decided to pull in Client Application Type object to see if it might assist with my analysis and when I did this the majority of the rows were no longer returned.

So then I went to the universe in IDT to see where that object was coming from.

I saw it was located on table ADS_CLIENT_TYPE_STR via a join from ADS_EVENT.

Immediately I knew that if rows were being excluded it was because a value in ADS_EVENT did not have a corresponding value in ADS_CLIENT_TYPE_STR - basic SQL knowledge.

So then I added Client_Type_ID from ADS_EVENT as an object to the universe and pulled that into my original query and found the most common entry was AbI5_LpMFxFLhxl7DV91KYY and this was the one that disappeared when I also included Client Application Type.

So I went back to IDT and used the show values option to see what the entries on the ADS_CLIENT_TYPE_STR table were and it has 49 entries but AbI5_LpMFxFLhxl7DV91KYY is not one of them.

Hopefully that clarifies things.

FJPD
Explorer
0 Kudos

Hello Nick,

Are you using your own Auditing Universe or the sample Universe from http://scn.sap.com/docs/DOC-6175?

I just wanted to recommend you to use instead the redesigned Universe from here: http://scn.sap.com/community/bi-platform/blog/2015/07/15/unlock-the-auditing-database-with-a-new-uni...


This blog above is dedicated to Auditing and reporting issues that come from Auditing.

If this new Universe does not solve your issue, maybe there is a reported issues already on the same blog above.

I also recommend re-posting your question there if the modified Universe does not do the trick.

Kind Regards,

Javier Puig

SAP Product Support

---------------------------------------------------------------------------------------------------

SAP Support Contact details: https://service.sap.com/sap/support/notes/560499

SAP WIKI BI http://wiki.scn.sap.com/wiki/display/BOBJ/Business+Intelligence

SAP Discussion BI http://scn.sap.com/community/bi-platform