IT Management Suite

Good morning all,

Trust you are well.

I have been trying to add all my CMDB's to my ITA server for cube processing. I have added all of them but no luck with adding the last.

Everytime I completed the detail of the DB and click add, i get the popup showing the connection has been added, then i click Close and the Update Dependencies Starts and then fails with the following error:

Exception: Conversion failed when converting the varchar value '*' to data type int.

I hit Close and displayed with the following:

Any ideas?

I am running SMP 7.5 SP1 with HF4 on Server 2008 R2 SP1, however this issue has been ongoing since the upgrade to 7.5.

Thanks 

Eugene

Hi EugeneDisc,

You can try to get more detailed log output, when this problem occurs, using Altiris Profiler.

Open Altiris Profiler on NS ⇒ start profiling ⇒ reproduce this issue ⇒ stop profiling ⇒ find in profiled data errors related to this problem.

During updating dependencies, it should trigger stored procedure and you will see it in Altiris Profiler on "SQL Trace" tab:

EXECUTE spITAnalytics_CSMP_CreateViews

Thanks,

IP.

Hi IP,

This looks better, but im not sure how to execute the SP as mentioned below.

Exception: System.Data.SqlClient.SqlException: Could not find server 'ITANALYTICS_CMDB_SYMANTEC_CMDB_SQLSERVER\MSSQLINST_SYMANTEC_CMDB' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

________________________________________________________________________________________

Exception: System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value '*' to data type int.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

________________________________________________________________________________________

Thanks again for the help,

Eugene

I've specified sp below to know exact name of what stored procedure to catch in a sql code output in Altiris Profiler (using a find, mark, etc).

All other previous databases, which didn't throw such problems, also have same SQL server address?

'ITANALYTICS_CMDB_SYMANTEC_CMDB_SQLSERVER\MSSQLINST_SYMANTEC_CMDB'

Is it a correct hostname "ITANALYTICS_CMDB_SYMANTEC_CMDB_SQLSERVER" of Windows Server, where this SQL Server is running? (I don't think that this is a correct address to SQL Server, since its name contains 40 symbols, even without SQL Instance name).

Hi Igor,

As in the error message, i am not sure where the first portion of the DB is read from:

Exception: System.Data.SqlClient.SqlException: Could not find server "ITANALYTICS_CMDB_SYMANTEC_CMDB_SQLSERVER\MSSQLINST_SYMANTEC_CMDB' in"

My ITA DB Name is only SYMANTEC_CMDB_SQLSERVER\MSSQLINST_SYMANTEC_CMDB

where SQLSERVER\MSSQLINST_SYMANTEC_CMDB after that is my CMDB of the environment i am trying to add.

Eugene