Troubleshooting OnCommand Insight Report DFM Server Access

[mferris]

I have just installed OnCommand Insight Report 1.0 and am working to setup the DFM server connection. I have tried

various accounts I use to log into the DFM server with, but keep getting denied - "Invalid Login Credentials:

JZ00L: Login Failed." Not sure what other logins to use since even Administrator with full privs was not working.

Looking for how to troubleshoot this.

[mferris]

Here is the log info:

2012-03-09 00:04:55,250 ERROR [pool-2-thread-2] com.onaro.sanscreen.acquisition.framework.datasource.BaseDataSource (DataSourceErrorException.java:224) - opsmgr [Invalid login credentials] - JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s). ([Device name opsmgr]: Failed to connect to database. Invalid user credential)

com.onaro.sanscreen.acquisition.framework.datasource.DataSourceErrorException: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).

          at com.onaro.sanscreen.acquisition.framework.datasource.DataSourceErrorException.createWithEnhanced(DataSourceErrorException.java:50)

          at com.onaro.sanscreen.acquisition.datasource.netapp_dfm.transport.db.RecordingDBConnection.connect(RecordingDBConnection.java:88)

          at com.onaro.sanscreen.acquisition.datasource.netapp_dfm.NetappDFMDataSource.createDBConnection(NetappDFMDataSource.java:198)

          at com.onaro.sanscreen.acquisition.datasource.netapp_dfm.NetappDFMDataSource.doFoundation(NetappDFMDataSource.java:68)

          at com.onaro.sanscreen.acquisition.nerfoundation.datasource.NERFoundationPackage.pollNow(NERFoundationPackage.java:162)

          at com.onaro.sanscreen.acquisition.framework.datasource.BaseDataSource.run(BaseDataSource.java:247)

          at com.onaro.sanscreen.acquisition.framework.mgmt.DataSourceManager$PollLogic.run(DataSourceManager.java:592)

          at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

          at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

          at java.util.concurrent.FutureTask.run(Unknown Source)

          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

          at java.lang.Thread.run(Unknown Source)

[mferris]

Here is the answer. OnCommand Insight Report requires a DFM database account which is different than accounts used to work with DFM/OM which may have GlobalRead for database access. The steps to create the required Database account are:

•Create a specific database account on the DFM server by running the following on the DFM server itself:

            dfm database user create –u dbuser –p password

dfm database access enable –u dbuser

Then use those credentials in OCIR and you are set.

[SISTEMI_SOSTORAGE]

Great Job !! This solve unknown issue

[MIRANKREUZER]

i wish i would have googled your answer earlier. Thanks a lot!

[maiorino]

In the Install\Admin Guide pg. 20 reads

Logging in to the OnCommand Insight Report

Administration Console

You can access the OnCommand Insight Report Administration Console through a Web browser.

You can use the Administration Console to configure OnCommand Insight Report.

Before you begin

Web browser requirements must be met.

About this task

OnCommand Insight Report ships with the following default user account:

• User name: admin

• Password: admin123

Use this user account when you log in to the Administration Console for the first time. You should

change the password for this user account after you log in.

Steps

1. Enter the following URL in your Web browser: http://host:http_port

host is the IP address or host name of the host where OnCommand Insight Report is installed.

http_port is the port that uses an HTTP connection. This port is known as the portal port. The

default port is 80.

2. At the login screen, enter your user name and password.

The Administration Console appears.