Symantec Management Platform (Notification Server)

Hola,

He tenido algunos problemas con mi servidor, el mas persistente es el siguiente error:

This DataSource is not in a runnable state

Verificando el logViewer de Altiris encuentro la siguiente información:

Source: Altiris.NS.StandardItems.Collection.DeltaCollectionUpdateSchedule
Description: Error delta updating collection 'Windows Computers with no Symantec Management Agent Installed (74bac0f5-830a-4ee0-a362-5d36e03bfd1e)': Altiris.NS.StandardItems.Collection.AeXInvalidCollectionQueryException: Data Source failed to run. ---> Altiris.DataSource.Exceptions.DataSourceRunException: An unexpected SQL error occurred when running the RawSqlDataSource. ---> System.Data.SqlClient.SqlException: El nombre de columna 'OS Revision' no es válido.
 

Y si intento ejecutar el query en la consola de Msft SQL Server:

 SELECT vc.[Guid] FROM vComputer vc

WHERE vc.[Guid] NOT IN

( SELECT DISTINCT agent.[_ResourceGuid] FROM Inv_AeX_AC_Client_Agent agent

WHERE agent.[Agent Name]='Altiris Agent' OR agent.[Agent Name]='Altiris eXpress NS Client'

)

AND dbo.fnIsSupportedClientOS(vc.[OS Name], vc.[OS Revision]) = 1

AND (LOWER(vc.[System Type]) like '%win%' or len(vc.[System Type]) = 0)

AND vc.[IsLocal] = 1 

Obtengo el error:

Msg 208, Level 16, State 1, Line 1

El nombre de objeto 'vComputer' no es válido.

Si pudieran orientarme en cómo corregir el problema, no me permite instalar el cliente en equipos recientemente descubiertos.

Sin más agradezco la atención.

Saludos!

The most likely problem is that you are not using the Symantec_CMDB database when performing your query.  Instead, you have a database such as 'master' selected by default.  Make sure to run your query against the Symantec CMDB by selecting 'Symantec_CMDB' from the drop-down in SQL Studio.

Alternatively, at the beginning of your query, add the line "USE Symantec_CMDB"

Does this help?  Also, if you can respond in English, it would assist me greatly.  Otherwise I'll do my best with Google Translate.

If you upgraded recently, it could be an upgrade issue:
http://www.symantec.com/business/support/index?page=content&id=TECH145393

Now when the query is executed, i got this error:

Msg 207, Level 16, State 1, Line 8

El nombre de columna 'OS Revision' no es válido.

If i do SELECT * FROM vc

i can't see that column. how ever there is a similar column name: "OS Version"

what can i do?

I believe it's the upgrade issue I hinted at before:
http://www.symantec.com/business/support/index?page=content&id=TECH145393

I'd follow the instructions in that KB article, and if that doesn't work, I'd perform a repair using the Symantec Installation Manager (SIM) on the Symantec Management Platform (SMP).

mclemson thank you for your help, i'm trying to execute de solution query but i got this error:

Msg 2714, Level 16, State 3, Procedure vComputer, Line 4

Ya hay un objeto con el nombre 'vComputer' en la base de datos.

I think i need to force or overwrite the object but i don't know how...

i've just used ALTER VIEW [dbo].[vComputer] ....

Now my filter is working fine.

Thanks!