Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Asset AQABAVIEW\SVR-SQL-03 is unavailable. Verify that it is available and reachable

Updated: 20 Jul 2010 | 3 comments
Ahmad Atteyah's picture
0 0 Votes
Login to vote

Good day

I have an issue when generate Collection-Evaluation-Reporting job, but before i explain this issue i will explain my CCS Tepology as below:

1- I have SVR-CCS-01 as reporting server that have the following Roles DPS and Application servers.
2- I have SVR-CCS-02 as RMS server (Information Server).

everything is OK when i importing assets or run Collection-Evaluation-Reporting job, but some times i have the following Error message when i run Collection-Evaluation-Reporting job as below:
"Asset AQABAVIEW\SVR-SQL-03 is unavailable.  Verify that it is available and reachable."

on the other hand, i guaranteed the following:
1- No firewall exist that prevent the traffic to pass.
2- The Remote Registry and Server services running on the target machine.
3- The CCS Admin has the full privileges on the target machine (Member of Domain Admin Group).
4- The system configured and communicated very well.

So please there is someone help to solve this issue

Best regards

discussion Filed Under:

Comments

CT-219's picture
24
Nov
2009
0 Votes 0
Login to vote

Have you recently upgraded your infrastructure?

I had a similar situation for a client wherein they had applied one of the quarterly hotfixes but did not get all of the SQE's upgraded. This caused us to get wildly variable results with a large number of them being "System not reachable." I recommend running the Health and Status Report from the RMS console and verify that all SQE's are at the same CHF as the BV-IS.

Ahmad Atteyah's picture
26
Nov
2009
0 Votes 0
Login to vote

What are you mean about CHF

What are you mean about CHF and BV-IS, on another hand I run the Health and Status Report as you asked me and it is as below:

Client Version Summary
Product: bv-Control for Windows - Client
Version: 9.0.3
Hot Fix: [None]
Schema Versions:
BindView Information Server: Local
File List:
9.0.14.10000 bvCount.exe
9.0.14.10000 bvCountW2kMisc.dll
9.0.1612.20300 BVNTConsoleInterface.dll
9.0.14.10000 BVNTDB_Access.dll
9.0.1612.20300 BVNTError.dll
9.0.1612.20300 BVNTObjects.dll
9.0.1612.20300 BVNTQuery.dll
9.0.14.10000 BVNTRpc32.dll
9.0.1612.20300 BVNTSetup.dll
9.0.14.10000 BVNTSysObjs.dll
9.0.14.10000 BVNTUninstall.exe
9.0.14.10000 BVPatchManagerUtils.dll
9.0.14.10000 BVQEADUtils.dll
9.0.14.10000 BVQEConfig.exe
9.0.14.10000 BVQESupportSvc.exe
9.0.1612.20300 BVVNTScopes.dll
9.0.1612.20300 CreateScopeFile.exe
9.0.14.10000 CreateScopeFileStub.exe
9.0.14.10000 EcsBase.dll
9.0.14.10000 EcsCommon.dll
9.0.14.10000 NTAASnapin.dll
9.0.14.10000 NTAESnapin.dll
9.0.1612.20300 NTBackEndSnapin.dll
9.0.14.10000 NTCommonUtils.dll
9.0.14.10000 NTDialogPages.dll
9.0.14.10000 NTEnvrStub.exe
9.0.1612.20300 NTFunctions.dll
9.0.14.10000 NTIcons.dll
9.0.1612.20300 NTProductModule.dll
9.0.1612.20300 NTSIQueryDispatcher.dll
9.0.14.10000 NTTIVExtensions.dll
9.0.14.10000 NTUISnapin.dll
9.0.14.10000 NTUIUtils.dll
9.0.14.10000 ProductIcon.exe
9.0.1612.20300 ScopeFileUtility.dll
9.0.14.10000 VirtualDatabase.dll
5.8.0.5 stConvertXML.dll
1.1.3.3850 bvMSSecure.xml
 

Server Version Summary
Product: bv-Control for Windows - Server
Version: 9.0
Hot Fix: [None]
Schema Versions:
4.4.0.0 FieldMetaData.mdb
4.4.0.0 BPM.mdb
4.4.0.0 IIS.mdb
4.4.0.0 ActiveDirectoryFieldsMetaData.mdb
4.4.0.0 WSUS.mdb
 
File List:
9.0.1612.20300 BVNTConsoleInterface.dll
9.0.1612.20300 BVNTObjects.dll
9.0.1612.20300 BVNTQuery.dll
9.0.14.10000 BVNTRpc32.dll
9.0.14.10000 BVNTSysObjs.dll
9.0.1612.20300 CreateScopeFile.exe
9.0.14.10000 CreateScopeFileStub.exe
9.0.14.10000 EcsCommon.dll
9.0.1612.20300 NTBackEndSnapin.dll
9.0.14.10000 NTCommonUtils.dll
9.0.14.10000 NTIcons.dll
9.0.1612.20300 NTSIQueryDispatcher.dll
9.0.14.10000 NTTIVExtensions.dll
9.0.14.10000 VirtualDatabase.dll
1.1.3.3850 bvMSSecure.xml
 

General Information Server Settings

Minimum Disk Space Settings
Minimum Free Disk Space: 100
Below Minimum Free Disk Space Time Out: 20

Skip License Options
Skip Servers: No
Skip Workstations: No

Information Server to MQE Communication Settings
Communication Buffer Size: 10485760
Query Poll Interval (in seconds): 1

Enterprise Configuration Service
Machine: SVR-CCS-DC-03
Host Name: SVR-CCS-DC-03.AqabaView.com
IP Address: 10.10.20.201
Port: None Configured
Major Version: 9
Minor Version: 0

Master Query Engines
Machine Domain / Workgroup Status Security Major Minor Hotfix Forest Principal Name Reporting Mode QE Information Scope Refining Agent
SVR-CCS-DC-03 AQABAVIEW Connected
* Accept queries only if client authenticated (allow to use RPC security)
9 0 None AqabaView.com LDAP/SVR-CCS-DC-03.AqabaView.com Domain no data 15

This data is from the Bindview Information Server's cache (connection.mdb) of Master Query Engines.

Slave Query Engines
Machine Domain / Workgroup Security Major Minor Hot Fix(es) Forest Principal Name QE Information Data Collection Agent ActiveAdmin Agent
SVR-CCS-DC-03 AQABAVIEW
* Accept queries only if client authenticated (allow to use RPC security)
9 0 None AqabaView.com LDAP/SVR-CCS-DC-03.AqabaView.com no data 6 6

This data is from Enterprise Configuration Service's list of Slave Query Engines.
The data in the agent count columns was obtained by submitting a query to the Query Engine(s) in this user's connection data base.

Slave Query Engine Assigments
 
Master Query Engine Slave Query Engine
SVR-CCS-DC-03
SVR-CCS-DC-03

This data is from Enterprise Configuration Service's list of Slave Query Engine assignments.

Query Engine Communication Settings
Machine Protocol Sequence Host Name IP Address Port
SVR-CCS-DC-03 ncacn_ip_tcp SVR-CCS-DC-03 10.10.20.201 <default>
SVR-CCS-DC-03 ncadg_ipx SVR-CCS-DC-03 SVR-CCS-DC-03 <default>
SVR-CCS-DC-03 ncacn_spx SVR-CCS-DC-03 SVR-CCS-DC-03 <default>

This data is from Enterprise Configuration Service's list of Query Engines Communication Settings.

Distribution Rules
 
Master Query Engine Rule Expression Type Rule Type Expression Split Type

This data is from Enterprise Configuration Service's Distribution Rules per Master Query Engine.

Support Services
Machine Domain Host Name IP Address Port DNS Domain
SVR-CCS-DC-03 AQABAVIEW no data no data <Default> no data

This data is from Enterprise Configuration Service's list of Support Services.

Administrative Share Selection
Use Default Administrative Shares: Yes
Auto Discover Administrative Shares: No
Apply Rule For Naming Administrative Shares: No

This data is from Enterprise Configuration Service's administrative share selection.

Connection Data base(s)
 
Connection Data Base Master Query Engines
connDB
SVR-CCS-DC-03

Default Connection Database
connDB

User Connection Data Base Assignments
 
User Connection Database
AQABAVIEW\Administrator connDB

User Options

Users that use credentials for queries
AQABAVIEW\Administrator

Domain / Workgroup Credential Configuration Summary

Credentials for the following domains/workgroups configured in bv-Control for Windows
Domain / Workgroup Account
AQABAVIEW AQABAVIEW\administrator

So if there is any error in above report please tell me.

Ahmad Atteyah
Technical Consultant
Tel. +966 1 473 5932 Ext. 121
Mobile +966 5 530 53849
ahmad.atteyah
CT-219's picture
20
Jan
2010
0 Votes 0
Login to vote

Have you installed Service

Have you installed Service Pack 1 and the November Hot Fix? If so, you will need to upgrade the ECS and your Query Engines as they are still showing the pre-SP1 level.