Re: significance of marble_persist_1 table in profile database (366 Views)
Reply
Frequent Advisor
Posts: 114
Registered: ‎06-28-2011
Message 1 of 11 (469 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
Posts: 1,743
Registered: ‎12-09-2008
Message 2 of 11 (466 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
Posts: 114
Registered: ‎06-28-2011
Message 3 of 11 (455 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
Posts: 384
Registered: ‎12-23-2011
Message 4 of 11 (448 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
Posts: 285
Registered: ‎07-02-2011
Message 5 of 11 (436 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
Posts: 1,743
Registered: ‎12-09-2008
Message 6 of 11 (429 Views)

Re: significance of marble_persist_1 table in profile database

No, there isn't.

Frequent Advisor
Posts: 114
Registered: ‎06-28-2011
Message 7 of 11 (422 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
Posts: 114
Registered: ‎06-28-2011
Message 8 of 11 (413 Views)

Re: significance of marble_persist_1 table in profile database

Please Suggest

Honored Contributor
Posts: 888
Registered: ‎04-07-2010
Message 9 of 11 (396 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
Posts: 888
Registered: ‎04-07-2010
Message 10 of 11 (394 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.
Highlighted
Valued Contributor
Posts: 36
Registered: ‎05-02-2012
Message 11 of 11 (366 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.