tbarkdull

When trying to specify a new Package server, I click the "plus" sign and received this error... parameter query failed" in the Find Resiource dialog box. See attached

Attached Thumbnails

 

andykn

Anything in the NS log?

tbarkdull

Here is the log entry:

____________________________begin

Thread ID: 55328
Module: AltirisNativeHelper.dll
Source: DropdownParameter/Contents
Description: query for table parameter 'OS Name', query: 'exec sp_PSCandidates 1, @Culture='%_culture%'' exception: System.Data.SqlClient.SqlException: Could not find stored procedure 'sp_PSUnixCandidates'.
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCo mmand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Altiris.NS.StandardItems.Query.DropdownParameter.g et_Contents()

__________________________________________end

andykn

Can you find the stored procedure in your SQL database? have you uninstalled any UNIX solutions recently?

tbarkdull

Which stored procedure am I looking for? No to the recent uninstall of unix products. We do not use them

andykn

The one mentioned in the error log; "sp_PSUnixCandidates"

If you have never ever installed any Altiris Unix solutions you probably won't have it; it's a puzzle why the Package Server entry is trying to call it, unless someone else can cofirm it does on a system with no unix solutions, all ours here have, unfortunately.

tbarkdull

spPSUnixCandidates does not exist. How do I reinstall Unix clients?

andykn

Are you sure you looked in the right place? spPSUnixCandidates will be in a completely different part of the list to sp_PSCandidates

It depends on what you had installed before. If you had any UNIX solutions installed before then removed them, try installing them again. They might be in c:\program files\altiris\setup files.

If you have never installed any UNIX solution you can't "reinstall" them.

Brandon

https://kb.altiris.com/article.asp?article=2319&p=1

You may also want to verify the other stored procedures in the article above. It is possible a repair of the NS may correct it.

https://kb.altiris.com/article.asp?article=34383&p=1


Have a log window open while doing anything and make sure to note all the red errors. Start searching for them in the KB and you will probably get to something eventually.

__________________
Brandon

tbarkdull

I looked again and there is a Stored procedure named AltirisADM.sp_PSUnixCandidates.

andykn

This sounds like a problem with ownership of SQL items. Usually all SQL items relating to Altieris should be owned by "dbo", so they should all be prefixed "dbo."

So the sp shouild be dbo.sp_PSUnixCandidates.

If you change it, it should work - you'll probably need "sa" rights to do this.

Also there may be other objects incorrectly labelled, have a look an the Altiris kb for ideas as to what may have caused it and what might fix it.