SCOM 2012 SP1 Dataware house issue

Hi Experts,

               We are facing issue with one of our SCOM 2012 SP1 environment, we are using SQL2012 for OpsDB and DW. We have one more instance in the same SQL server for Service Manager 2012.

Environment:

2 vm's

1-SCOM2012 MS & Reporting

1-SQL2012 DB & DW

60 Agents

 Issue: Datawarehouse doesnot have any data.

Troubleshootings: We use to get lot of 2115 and 33333 and DW related errors we have managed to fix the same with the help of adding  the DW warehosue action account in DW, SQL and reporting  Run as profile. Currently we are not getting  any Data access layer errors in logs. but still didnt get any data in DW.

Tried the Script select * from InternalJobHistory order by InternalJobHistoryId with 0 as the process ID, so no Dataflow is not happening from DB to DW

Request Someone to help on this issue. Thanks a lot.

Regards,

June 21st, 2013 5:22pm


Hi,

To make the issue clear, please post the full error message you noticed. For the Event 2115, please refer to the following KB article to check it:

How to troubleshoot Event ID 2115 in Operations Manager
http://support.microsoft.com/kb/2681388

Thanks.

Free Windows Admin Tool Kit Click here and download it now
June 24th, 2013 11:16am

Thanks for your response Nicholas. Currently event ID 2115 and all DW related errors has been stopped, after the proper configuration of DW Run as account and profiles.

But still the Data insertion on DW is not happening as expected. I know its quite difficult to provide the suggestions without any Error logs.

So request you to share the tricky things to check out here on both MS and DW end.

Regards,
Sundar

June 24th, 2013 11:23am

Can please someone help me here.

Regards,
Sundar

Free Windows Admin Tool Kit Click here and download it now
July 9th, 2013 3:18am

Like you indicated it is hard to guess without too much info.

You can check accounts and passwords for the accounts you specified while installing SCOM. see if they are OK and have rights in SQL side.

Many perf collection rules and such write to both the operationsmanager database and the datawarehouse database simultaniously.
Would also check to make sure data is going into your opsdb (run performance view against a server in scom monitoring pane from the Windows Computers state view). Should give you performance data.

Next is checking event logs, rebooting the whole box (management server) and check again in the logs what it is going now. Run a report for availability of windows computer or something like that and see if it carries any data.

July 9th, 2013 6:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics