Application Perf Mgmt (BAC / BSM) Support and News Forum
Showing results for 
Search instead for 
Do you mean 

significance of marble_persist_1 table in profile database

Frequent Advisor

significance of marble_persist_1 table in profile database

Hi Experts,

 

  We have installed HP BSM 9.01 in our environment with database as oracle 10g.But now the table "marble_persist_1" from profile databse is corrupted .And DBA is suggesting to delete that table and create newer one

 

  What will be the impact of this?Please suggest

 

Regards,

Blselenium.

10 REPLIES
HPE Expert

Re: significance of marble_persist_1 table in profile database

You will lose the current statuses for your CIs in Service Health and all the KPIs will have "No Data" status until the next sample/event will arrive.

Frequent Advisor

Re: significance of marble_persist_1 table in profile database

If i delete marble_persist_1 table from database will this affect my all BPM ,RUM and custom views created or any admin related configuration.

 

Regards,

Blselenium

Respected Contributor

Re: significance of marble_persist_1 table in profile database

No any impact on your views & SLAs . you only loose current status on dashboard.
Regards,
Riya Roy

Ship in harbor is safe -- but that is not what ships are built for …
Valued Contributor

Re: significance of marble_persist_1 table in profile database

Hi Asaf,Riya

 

Is there any doc wherein we can have the some information related to tables of profile DB's ?

 

Regards,

Mascotte

-/-\- Mascotte
"Assign the Kudos to the kind fellas to shew the appreciation"
http://h30499.www3.hp.com/t5/custom/page/page-id/hp.rulespage
HPE Expert

Re: significance of marble_persist_1 table in profile database

No, there isn't.

Frequent Advisor

Re: significance of marble_persist_1 table in profile database

Hi Experts,

 

  We are trying to create new profile database as our current profile db got corrupted and setting that profile database as default but we are getting an error as "Database operation failed" .As far as credentials are concerned they are confirmed with DBA .Please find the screenshot attached for detailed understanding.

 

Regards,

Bharat Lahori

Frequent Advisor

Re: significance of marble_persist_1 table in profile database

Please Suggest

Honored Contributor

Re: significance of marble_persist_1 table in profile database

Can you stop BSM services and re-run the DB config utility and use option "connect to existing database" and try recreating profile DB again. Do they have same system time including timezone?

 

If BSM is using windows/NTLM authentication, BSM services should be running under that user and it should have local admin priveleges on DB server.

 

--Sujith

Close the thread if your issue is resolved to make the thread meaningful and complete. Do show gratitude to people who helped you by assigning points.
Honored Contributor

Re: significance of marble_persist_1 table in profile database

I mean run DB utility on both servers (DPS followed by GW). All servers must have same system time.

 

--Sujith

Close the thread if your issue is resolved to make the thread meaningful and complete. Do show gratitude to people who helped you by assigning points.
Highlighted
Valued Contributor

Re: significance of marble_persist_1 table in profile database


blselenium wrote:

Hi Experts,

 

  We are trying to create new profile database as our current profile db got corrupted and setting that profile database as default but we are getting an error as "Database operation failed" .As far as credentials are concerned they are confirmed with DBA .Please find the screenshot attached for detailed understanding.

 

Regards,

Bharat Lahori


Hi,

 

The reasons for this error message could be many. However, I suspect that you don't have Partitioning enabled on your Oracle database - or you are using Oracle Standard (should be Enterprise).

Another way of varyifying what's wrong with your Profile database is by using the DbVerify tool, that comes with the BSM installation. It will perform basic database integrity checks to your Management and Profile databases. What you need to do:

* Access the BSM 9.01 file system. Doesn't matter if it is Gateway or DPS

* Navigate to HPBSM\dbverify\bin\

* Execute run_db_verify.bat

* If asked for DB credentials, provide them

* Wait for the check to finish

* Provide a snapshot from the result

* Provide DbVerify log file from HPBSM\dbverify\log\ directory.

 

 

BR,
Stanislav