on 10-29-2015 4:34 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.