2015-02-27 01:23 PM
I'm demoing Insight Perform right now and it looks great so far. I'm able to get some really good detailed information about the volumes. What I can't seem to figure out is how to run reports, or what reports are available to me.
I looked at the documentation and found this:
It seems pretty easy but I don't have a Reports button. What am I missing?
Thank you for your time and help
2015-02-27 10:51 PM
well, the documentation refers to the "OnCommand Insight portal". More acurately it should be the "OnCommand Insight reporting portal" which is being shipped with the data warehouse (dwh) and needs to be deployed on a dedicated VM. It needs some very basic configuration - specifying a connector and scheduling ETL (aka. builds), after which you should be able to use the reports. Have a look at the Data Warehouse Administration Guide on the NetApp Support site for more detailed infos.
Hope this helps.
2015-03-02 10:58 AM
It says failed, but when I attempt to test the test succeeds.
Unfortuantely I didn't set any of this up and the guy who did left the company last friday saying "hey I set this up, you should evaluate it before the Preform license expires at the end of March."
The preform part seems great, but I think it would be more useful if I could get the data into an ondemand or scheduled report.
2015-03-02 11:20 AM
Just to be sure, we're talking about a data source failing to collect inventory, right?
The test routine is just some basic things like ping and login, but does not actually attempt to collect any data.
If the test works though, it's a good sign.
But there has to be more in the error message than just "failed". If not, you need to dig into the log file to see if that is more verbose. You'll find the log files in %SANSCREEN_HOME%\acq\log
What kind of data source is this? What kind of device device are you trying to collect data from?
2015-03-02 12:14 PM
Yes as far as I know it's the data warhouse failing to collect inventory data from the Insight server.
I've uploaded a copy of the error that appears upon expanding the failed task. I don't seem to have a SANscreen/acq/log directory, I have a SANscreen/log but that doesn't seem to have any recently modified logs in it.
The data source that it's trying to collect from is a Windows 2008 R2 box with Insight running on it. Insight itself is connecting to three Netapp systems, two running Cluster mode and one on 7-mode.
Unfortuantely I didn't install any of this and am relatively new to OnCommand Insight so I'm learning much of this as I go.
2015-03-02 09:57 PM
I'm not entirely sure, but could it be that you first did a "Build now" on the Schedule page, after which you tried to "Build from history"?
Because that wouldn't work and could produce an error like this. In which case you should reset the database, rebuild the connector, skip "Build now" and go straight for "Build from history".
Else, if this error occurs if you just try to "Build now" or during the build of a regular schedule, my best guess is it's a bug and you should contact your responsible guy who started this POC and have him open a case about it.
These are the relevant lines in the error message in any case:
Caused by: com.netapp.sanscreen.dwh.applications.inventory.InventoryException: Failed to execute SQL script com/netapp/sanscreen/dwh/inventory/processors/chassis/ChassisAndMultipleChassisRelationProcessor.load.oneChassisRelation.sql
Caused by: com.netapp.sanscreen.dwh.util.SqlShellException: Failed to execute: UPDATE dwh_inventory.compute_resource public_chassis, dwh_inventory_staging.chassis_global global_chassis, dwh_inventory_staging.chassis_local local_chassis, dwh_inventory_staging.chassis_local local_ref, dwh_inventory_staging.tmp_compute_resource extracted SET public_chassis.vmId = local_ref.global_id WHERE public_chassis.id = local_chassis.global_id AND local_chassis.local_id = extracted.id AND local_chassis.connector_id = 1 AND local_chassis.type = 'COMPUTE_RESOURCE' AND global_chassis.id = local_chassis.global_id AND global_chassis.connector_id IS NOT NULL AND local_ref.local_id = extracted.vmId AND local_ref.connector_id = 1 AND local_ref.type = 'HV_VIRTUAL_MACHINE'
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`dwh_inventory`.`compute_resource`, CONSTRAINT `fk_compute_resource_vmId` FOREIGN KEY (`vmId`) REFERENCES `hv_virtual_machine` (`id`) ON DELETE CASCADE)
As you can see, there is a problem with updating foreign keys in the database.
Try to reset the database first and do a new "Build from history". If that works, you can configure a schedule to do the builds regularly on a daily basis.
I hope this helps.
2015-03-04 10:33 AM
Well things are definitely different now...
I reset the database, rebuilt the conector and set a build from history. I made it past inventory and dimensions but failed at datamart prepartations. I've included the error below if you're curious. Otherwise I'm going to open up a Netapp support request.
Thank you for all of your help.
2015-03-04 09:15 PM
did you adjust the date range for the "Build from history"? If you haven't please try again and choose a date range where the OCI database contains data about. Remember, the retention time of the OCI database is seven days.
Does this occur in the customer's environment, where data acquisition is ongoing or with a backup in a lab environment?
If his error still persists, I think the best course of action would be to open a case.
Thanks & regards,