Re: significance of marble_persist_1 table in profile database (284 Views)
Reply
Frequent Advisor
blselenium
Posts: 97
Registered: ‎06-28-2011
Message 1 of 11 (387 Views)

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.

HP Expert
Asaf Shechter
Posts: 1,333
Registered: ‎12-09-2008
Message 2 of 11 (384 Views)

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
blselenium
Posts: 97
Registered: ‎06-28-2011
Message 3 of 11 (373 Views)

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
Riya_Roy
Posts: 384
Registered: ‎12-23-2011
Message 4 of 11 (366 Views)

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
Mascotte_Thomas
Posts: 274
Registered: ‎07-02-2011
Message 5 of 11 (354 Views)

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
HP Expert
Asaf Shechter
Posts: 1,333
Registered: ‎12-09-2008
Message 6 of 11 (347 Views)

Re: significance of marble_persist_1 table in profile database

No, there isn't.

Frequent Advisor
blselenium
Posts: 97
Registered: ‎06-28-2011
Message 7 of 11 (340 Views)

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
blselenium
Posts: 97
Registered: ‎06-28-2011
Message 8 of 11 (331 Views)

Re: significance of marble_persist_1 table in profile database

Please Suggest

Honored Contributor
Sujith Kumar C.S
Posts: 868
Registered: ‎04-07-2010
Message 9 of 11 (314 Views)

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
Sujith Kumar C.S
Posts: 868
Registered: ‎04-07-2010
Message 10 of 11 (312 Views)

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.
Valued Contributor
SK_AmidamarU
Posts: 36
Registered: ‎05-02-2012
Message 11 of 11 (284 Views)

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

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.