BPM Performance over time report not showing any data

APM 9.30
BPM 9.30

Created script in vuGen and imported the script in APM. Created EUM application in APM, selected the script and then running the application in BPM. The application runs fine in BPM and in BSM I am seeing the monitor runs fine but when I launch report in APM, report shows no data.

How to troubleshoot and solve this issue.

Parents
  • do you see "colors" for this Business App in Service Health (for example: TopView, 360 view)?

    if not then APM is not receiving samples from BPM. check WDE logs in GW.

    if yes then your issue is probably related to insert to DB. check db_loader logs in GW.

    if you still not able to resolve the issue then submit Support Case.

  • Verified Answer

    following a meeting we had it is clearly that we have DB insertion issues, however we could not understand why.

    We can open and view  the profile DB in BSM browser, and we can see the apps in Applications_dim table and so on. However not data at all.

    I have asked the customer to defien again a new DB and create a new applicaiton and check it out again.

    I agree that if it does not help he may need to open supoprt case.

     

  • Hi All

    I removed older PROFILE tablespace and created new PROFILE tablespace and ran Oracle database management as you had suggested. However it fails with error "DB allready exists". I am not sure I had given the correct option, but this is what I gave,

    User schema name           :                PROFILE
    User schema password     :                Password of PROFILE user
    Default admin user name  :                system
    Database admin password :               Password of system user
    Default tablespace             :               users ( Next time I provided PROFILE)

    Rest of the input, I provided as per my environment.

    When I run dbverify command against PROFILE DB, I see there are lot of missing tables like,

    name:[LOCK_RUM_TRANSACTIONS_2DAY].problem[missing table]
    name:[LOCK_RUM_TRANSACTIONS_2HR].problem[missing table]
    name:[LOCK_RUM_TRANSACTIONS_3DAY].problem[missing table]

    I believe I need to run DB schema to create PROFILE DB tables/views manually or through BSM console, not sure how.

    Please help.

  • Hi All

    I removed older PROFILE tablespace and created new PROFILE tablespace and ran Oracle database management as you had suggested. However it fails with error "DB allready exists". I am not sure I had given the correct option, but this is what I gave,

    User schema name           :                PROFILE
    User schema password     :                Password of PROFILE user
    Default admin user name  :                system
    Database admin password :               Password of system user
    Default tablespace             :               users ( Next time I provided PROFILE)

    Rest of the input, I provided as per my environment.

    When I run dbverify command against PROFILE DB, I see there are lot of missing tables like,

    name:[LOCK_RUM_TRANSACTIONS_2DAY].problem[missing table]
    name:[LOCK_RUM_TRANSACTIONS_2HR].problem[missing table]
    name:[LOCK_RUM_TRANSACTIONS_3DAY].problem[missing table]

    I believe I need to run DB schema to create PROFILE DB tables/views manually or through BSM console, not sure how.

    Please help.

  • Hi All

    I removed older PROFILE tablespace and created new PROFILE tablespace and ran Oracle database management as you had suggested. However it fails with error "DB allready exists". I am not sure I had given the correct option, but this is what I gave,

    User schema name           :                PROFILE
    User schema password     :                Password of PROFILE user
    Default admin user name  :                system
    Database admin password :               Password of system user
    Default tablespace             :               users ( Next time I provided PROFILE)

    Rest of the input, I provided as per my environment.

    When I run dbverify command against PROFILE DB, I see there are lot of missing tables like,

    name:[LOCK_RUM_TRANSACTIONS_2DAY].problem[missing table]
    name:[LOCK_RUM_TRANSACTIONS_2HR].problem[missing table]
    name:[LOCK_RUM_TRANSACTIONS_3DAY].problem[missing table]

    I believe I need to run DB schema to create PROFILE DB tables/views manually or through BSM console, not sure how.

    Please help.

  • Hello

    Finally I am able to resolve the issue and here is what I followed,

    1.    Went to Set up and maintenance->Manage Profile Database and created new DB with name PROFILESCHEMA and applied.
    2.    Go to GW:29000/mbean Manager
    3.    Navigate to method java.lang.String updateMetaData()
    4.    Click Invoke (it will take time)
    5.    Once done, completely stop the GW services
    6.    Completely stop DPS services
    7.     Start DPS services, wait till all of them are up
    8.     Start services on GW

    Now I am totally confused why I need to create PROFILE tablespace as per Database guide.

    And where does the data for BPM application gets stored, since I see the tablespace PROFILE has more free space.

  • Hello

    Finally I am able to resolve the issue and here is what I followed,

    1.    Went to Set up and maintenance->Manage Profile Database and created new DB with name PROFILESCHEMA and applied.
    2.    Go to GW:29000/mbean Manager
    3.    Navigate to method java.lang.String updateMetaData()
    4.    Click Invoke (it will take time)
    5.    Once done, completely stop the GW services
    6.    Completely stop DPS services
    7.     Start DPS services, wait till all of them are up
    8.     Start services on GW

    Now I am totally confused why I need to create PROFILE tablespace as per Database guide.

    And where does the data for BPM application gets stored, since I see the tablespace PROFILE has more free space.

  • Hi ramesh9

    the way to create a profile database for BSM when using Oracle is described in detail in the manual
    APM Platform Administration Guide for APM 9.30

    Chapter 13: Managing Databases

    Creating Databases
    - To create a profile database, select Admin > Platform > Setup and Maintenance > Manage Profile Databases.

    and
    How to Create a Profile User Schema on an Oracle Server

    Create a dedicated default tablespace for profile user schemas (and a dedicated temporary tablespace, if required).

    So when I do this, I simply create a new tablespace, and create a new profile DB via
    Admin > Platform > Setup and Maintenance > Manage Profile Databases.

    AND I check - described under
    Profile User Schema Properties — Oracle Server Page
    -> Create database and/or tables

    To create a new user schema, or connect to an existing, empty user schema
    and populate it with profile tables, select the check box.

    This does all the magic in the background (by executing various scripts).
    If all is done that way (and all worked as expected) there is no need for any manual work,
    like populating data to the profile database by manually invoking the Meta-Data Manager.

    Also there is no need to restart the DPS and/or GW afterwards.
    You created it via the GUI, it will take some time, and you are done.

    Regarding your follow-up question:
    ..
    And where does the data for BPM application gets stored, since I see the tablespace PROFILE has more free space.
    ..
    it is stored in the profile database you selected when you created the business application.

    Just by adding a new profile database this will not change.
    As a matter of fact you cannot change this anyway, you need to delete the BA and recreate it specifying the new profile database.

    Please also make sure that you have one profile database (if you plan to use multiple profile DBs) or the one (if you have one only) marked as Default Proflie Database (in the same screen as you use for creating the profile db, Admin > Platform > Setup and Maintenance > Manage Profile Databases),
    otherwise various things (alerts, SLAs, etc) will not work.

    Greetings
    Siggi

  • Hello Siggi

    So in order to have everything working perfect, we need to do following,

    1.    Create all tablespaces as mentioned in Oracle DB
    2.    Install APM
    3.    Run the configuration utility and provide RTSM, CMDB etc.
    4.    Login to BSM and go to Admin > Platform > Setup and Maintenance > Manage Profile Databases ->Add->Check Create
          Databases and/or tables->Give all other parameters->Apply
    5.    Once above is done it will get assosciated to PROFILE tablespace we had created.

    Please correct me if I am wrong with above steps.

    When I look at my tablespace freespace, I am seeing PROFILE tablespace is not occupied lot.

    SQL> select * from dba_tablespace_usage_metrics order by used_percent desc;

    TABLESPACE_NAME                USED_SPACE TABLESPACE_SIZE USED_PERCENT
    ------------------------------ ---------- --------------- ------------
    CMDB                               538392          670720   80.2707538
    MANAGEMENT                        1372456         1966080    69.806722
    USERS                              626080         4194302   14.9269175
    SYSAUX                             188680         4194302    4.4984839
    SYSTEM                             122536         4194302   2.92148729
    UNDOTBS1                              800         4194302   .019073495
    TEMP                                  256         4191289   .006107906
    PROFILE                               128         2621440   .004882813

    8 rows selected.

    Please advise.

Reply
  • Hello Siggi

    So in order to have everything working perfect, we need to do following,

    1.    Create all tablespaces as mentioned in Oracle DB
    2.    Install APM
    3.    Run the configuration utility and provide RTSM, CMDB etc.
    4.    Login to BSM and go to Admin > Platform > Setup and Maintenance > Manage Profile Databases ->Add->Check Create
          Databases and/or tables->Give all other parameters->Apply
    5.    Once above is done it will get assosciated to PROFILE tablespace we had created.

    Please correct me if I am wrong with above steps.

    When I look at my tablespace freespace, I am seeing PROFILE tablespace is not occupied lot.

    SQL> select * from dba_tablespace_usage_metrics order by used_percent desc;

    TABLESPACE_NAME                USED_SPACE TABLESPACE_SIZE USED_PERCENT
    ------------------------------ ---------- --------------- ------------
    CMDB                               538392          670720   80.2707538
    MANAGEMENT                        1372456         1966080    69.806722
    USERS                              626080         4194302   14.9269175
    SYSAUX                             188680         4194302    4.4984839
    SYSTEM                             122536         4194302   2.92148729
    UNDOTBS1                              800         4194302   .019073495
    TEMP                                  256         4191289   .006107906
    PROFILE                               128         2621440   .004882813

    8 rows selected.

    Please advise.

Children
  • Hi ramesh9,

    your steps 1-5 look good
    (while I always install APM first, then do the DB stuff, and then run the configuration / connection wizard, but that's up to you).

    Regarding
    ..
    When I look at my tablespace freespace, I am seeing PROFILE tablespace is not occupied lot.
    ..

    Do you have anything reporting to that profile database, SiteScope, BPM, RUM?
    If not, then no wonder.
    if yes, then you need to check the logs (dbloader, pmanager) for errors with the DB.

    If you do have data collectors setup and you can see data in BSM reports, all is fine.

    Greetings
    Siggi