Installation Error @ Save External Data

From re-reading the Service Desk 7 Implementation Guide, is the SQL server for Service Desk required to be off-box? Right now, I put it on the same test box-- that may be what's going on with my error? 

SQL can be on the box, I run mine on a Windows 2003 standard x64 SP2. Are you using Windows 2003 and SQL 2005?

Any insight????

An error has occurred at: Save External Data

Error Message: could not save object LogicBase.Core.Messaging.Implementations.RelationalMapperExchange+LastCheckTime

Stack Trace: System.Exception: could not save object LogicBase.Core.Messaging.Implementations.RelationalMapperExchange+LastCheckTime ---> System.Exception: Could not insert or update. insert error message: Invalid object name 'ObjectStructureCheck'. update error message: Invalid object name 'ObjectStructureCheck'. ---> System.Data.SqlClient.SqlException: Invalid object name 'ObjectStructureCheck'. 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 LogicBase.Core.Messaging.Implementations.InsertStatement.Execute(SqlConnection conn, SqlTransaction tr) at LogicBase.Core.Messaging.Implementations.InsertOrUpdateStatement.RunInsertStatement(SqlConnection conn, SqlTransaction tr) at LogicBase.Core.Messaging.Implementations.InsertOrUpdateStatement.Execute(SqlConnection conn, SqlTransaction tr) --- End of inner exception stack trace --- at LogicBase.Core.Messaging.Implementations.InsertOrUpdateStatement.Execute(SqlConnection conn, SqlTransaction tr) at LogicBase.Core.Messaging.Implementations.RelationalMapperExchange.SaveObject(Object o) --- End of inner exception stack trace --- at LogicBase.Core.Messaging.Implementations.RelationalMapperExchange.SaveObject(Object o) at LogicBase.Core.Messaging.Implementations.RelationalMapperExchange.CheckType(Type t, IRelationalMappingDriverInfo driverInfo, Boolean fix) at LogicBase.Core.Messaging.Implementations.RelationalMapperExchange.BuildSaveStatement(AbstractRelationalMappingObject armo, List`1& statements, List`1& savedObjects) at LogicBase.Core.Messaging.Implementations.RelationalMapperExchange.SaveObject(Object o) at LogicBase.Core.Messaging.Implementations.RelationalMapperExchange.Put(Message message) at LogicBase.Core.Data.ExternalReference.Commit(IData d) at LogicBase.Core.Data.OrchestrationData.Commit() at LogicBase.Components.Default.Process.SaveExternalDataComponent.Run(IData data) at LogicBase.Core.ExecutionEngine.SinglePathProcessComponentExecutionDelegate.Execute(IData data, IOrchestrationComponent comp, String& outputPath, IExecutionEngine engine, TLExecutionContext context) at LogicBase.Core.ExecutionEngine.AbstractExecutionEngine.DoRunComp(IOrchestrationComponent comp, IData data, TLExecutionContext context)

I had this issue: I forgot to add the Machine Account to the local admin group on the remote SQL box.

Hi All,

I got this error too.

This is my testing environment

1. Workgroup environment for both NS7 and SD 7 server
2. SQL 2005 SP1, windows 2003 64 bits install in the same box for SD 7

any idea or hints to solve this error, because of this error, when I launch the process manager portal, I can create the ticket, but I have error such as invalid object name servicedeskchangemanagement...and I cannot save the incident ticket.

Many thanks!

Wallace Lam

I had the error posted above and was able to get past it by adding the computer account to the local admin group of the remote SQL server. However, a new error comes up through the install now... Any ideas on what is causing this??

An error has occurred at: AddProfileValueDefinitions

Error Message: Server was unable to process request. ---> Exception has been thrown by the target of an invocation. ---> could not save object ProfileServiceDeskSettings ---> Could not insert or update. insert error message: String or binary data would be truncated. The statement has been terminated. update error message: String or binary data would be truncated. The statement has been terminated. ---> String or binary data would be truncated. The statement has been terminated.

Stack Trace: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Exception has been thrown by the target of an invocation. ---> could not save object ProfileServiceDeskSettings ---> Could not insert or update. insert error message: String or binary data would be truncated. The statement has been terminated. update error message: String or binary data would be truncated. The statement has been terminated. ---> String or binary data would be truncated. The statement has been terminated. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at LogicBase.Core.Ensemble.Profile.ProfileService.SaveProfileValueDefinitionsWithInitialValues(String sessionID, ProfileValueDefinition[] profileValueDefinitions, KeyValuePair[] nameValuePairs) at LogicBase.Components.Ensemble.Profile.AddProfileValueDefinitions.Run(IData data) at LogicBase.Core.ExecutionEngine.SinglePathProcessComponentExecutionDelegate.Execute(IData data, IOrchestrationComponent comp, String& outputPath, IExecutionEngine engine, TLExecutionContext context) at LogicBase.Core.ExecutionEngine.AbstractExecutionEngine.DoRunComp(IOrchestrationComponent comp, IData data, TLExecutionContext context)

The step this error came up in was  Creating Hierarchy Categories.  I skipped the step and install the install claims to have completed successfully. We will see...

Hi Chris,

Similar case, i got error at initialized database and create application setting...

I have created a domain, and put the NS7 and SD7 server in this domain...

but still, i got these error...

Is there anyone can successfully install and get SD7 running? I wonder...

Regards,

Wallace Lam

Hi All,

I finally managed to solve the installation issues. Here is my finding.

I need these additional settings to solve the installation issues.

Put all the NS7, SD7 server into Active Directory environment.

Since I do not have 64 bits SQL 2005 media, I put the ensemble database into NS7 SQL database (32 bits), and install MS SQL 2005 managemnet object collection on SD7 (64 bits).

Before setup the SD 7 application on SD7 server, I have added SD7 server computer name to SQL server administrators group.

Then the overall installation of SD7 application, and the configuration of SD 7 after the application installation does not have any issue. :)

Actually, I find that, all installation requirement has been listed in installation guide, somehow I just overlook them. :)

Regards,

Wallace

Have you tried using SQL Authentication during the install.  I was using Windows Authentication and was receiving similar errors when SQL is off-box.

Hi All
i have the same error using both sql authentication and windows authentication
my configuration is
  windows 2003 64 bit enterprise edition ( frensh)
  sql 2005 32 bit sp3 ( frensh)
 any idea how to resole this issue
Thanks

Hi All
i found the issue,
you must install SQL server 2005 management object collection
issue resolved