Novell Home

My Favorites

Close

Please to see your favorites.

Receiving a 1001 error when trying to install Analysis Center DataWarehouse

This document (7012102) is provided subject to the disclaimer at the end of this document.

Environment

NetIQ Analysis Center 2.7.x
Microsoft SQL Server 200x

Situation

Receiving a 1001 error when trying to install the DataWarehouse on SQL Server 200x.  This can occur when 'query governor' is enabled on the Microsoft SQL Server

Resolution

To resolve this issue you need to do the following:
 
1- Connect to your Microsoft SQL Server you are wanting to install the DataWarehouse onto with SQL Server Management Studio
2- Right Click on SQL Server in treeview and select 'Properties'
3- Navigate to the 'Connections' page
4- Uncheck the box 'Use query governor to prevent long-running queries'
5- Click 'OK'
6- Restart the Analysis Center installation
 

Cause

'Query Governor' is used to not allow queries to run indefinetly.  By default when selected the value would be '300' seconds. Any query running over 300 seconds will be halted.

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7012102
  • Creation Date:09-APR-13
  • Modified Date:17-APR-13
    • NetIQAnalysis Center

Did this document solve your problem? Provide Feedback