ServiceDesk

 View Only
Back to discussions
Expand all | Collapse all

Installation Error @ Save External Data

  • 1.  Installation Error @ Save External Data

    Posted Sep 10, 2009 12:45 PM
     Hi All,

    Anybody know why this would happen during the installation? I think it's during the "Initializing Databse" phase. Permissions I don't have setup correctly?

    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)


  • 2.  RE: Installation Error @ Save External Data

    Posted Sep 10, 2009 01:28 PM
    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? 


  • 3.  RE: Installation Error @ Save External Data

    Posted Sep 21, 2009 09:17 AM
    SQL can be on the box, I run mine on a Windows 2003 standard x64 SP2. Are you using Windows 2003 and SQL 2005?


  • 4.  RE: Installation Error @ Save External Data

    Posted Oct 13, 2009 11:20 AM
    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)


  • 5.  RE: Installation Error @ Save External Data

    Posted Oct 16, 2009 07:06 AM
    I had this issue: I forgot to add the Machine Account to the local admin group on the remote SQL box.


  • 6.  RE: Installation Error @ Save External Data

    Posted Oct 16, 2009 08:08 AM
    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


  • 7.  RE: Installation Error @ Save External Data

    Posted Oct 16, 2009 11:12 AM
    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)


  • 8.  RE: Installation Error @ Save External Data

    Posted Oct 16, 2009 11:25 AM

    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...



  • 9.  RE: Installation Error @ Save External Data

    Posted Oct 16, 2009 12:03 PM
    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


  • 10.  RE: Installation Error @ Save External Data

    Posted Oct 19, 2009 01:07 AM
    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


  • 11.  RE: Installation Error @ Save External Data

    Posted Oct 20, 2009 02:31 PM
    Have you tried using SQL Authentication during the install.  I was using Windows Authentication and was receiving similar errors when SQL is off-box.


  • 12.  RE: Installation Error @ Save External Data

    Posted Oct 22, 2009 06:09 AM
    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


  • 13.  RE: Installation Error @ Save External Data

    Posted Oct 27, 2009 11:01 AM
    Hi All
    i found the issue,
    you must install SQL server 2005 management object collection
    issue resolved


  • 14.  RE: Installation Error @ Save External Data

    Posted Nov 17, 2009 03:45 AM
    Hi Wallace,

    After two full days of getting the above error messages, i re-read your post here and realised i had over looked the MS SQL 2005 management object collection installation. (Why cant this be checked in the pre-requesits...)
    Once this was installed, EVERYTHING seemed to go through perfectly, well except the Categories part but i'm looking at that now....

    An error has occurred at: GetAllCategoriesViewableInTreeComponent

    Error Message: The request failed with HTTP status 404: Not Found



    Thanks!

    P.S. For those that arent aware Management Object Collection can be downloaded from http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

    Steve


  • 15.  RE: Installation Error @ Save External Data

    Posted Nov 17, 2009 08:39 AM
    Hi Chris,

    Did you find a resolution to this?

    I'm getting the same error, i think it has to do with IIS, but not sure.

    Steve