Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Installation Error @ Save External Data

Updated: 21 May 2010 | 14 comments
Tenacious Geo's picture
0 0 Votes
Login to vote

 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)

discussion Filed Under:

Comments

Tenacious Geo's picture
10
Sep
2009
0 Votes 0
Login to vote

Question

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? 

-Geo

Rdutch12's picture
21
Sep
2009
0 Votes 0
Login to vote

SQL can be on the box, I run

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

Rob Hilberding Sr. Consultant ExpressAbility www.expressability.com

MRenfrow's picture
13
Oct
2009
0 Votes 0
Login to vote

Same issue here!

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)

JeffPeters's picture
16
Oct
2009
1 Vote +1
Login to vote

I had this issue: I forgot to

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

Wallace's picture
16
Oct
2009
0 Votes 0
Login to vote

Hi All, I got this error

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

Chris Akeroyd's picture
16
Oct
2009
0 Votes 0
Login to vote

Errors Continue

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)

Chris Akeroyd's picture
16
Oct
2009
0 Votes 0
Login to vote

The step this error came up

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

yabru's picture
17
Nov
2009
0 Votes 0
Login to vote

Hi Chris, Did you find a

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

Wallace's picture
16
Oct
2009
0 Votes 0
Login to vote

Hi Chris, Similar case, i got

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

Wallace's picture
18
Oct
2009
0 Votes 0
Login to vote

Hi All, I finally managed to

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

yabru's picture
17
Nov
2009
0 Votes 0
Login to vote

Hi Wallace,After two full

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

Bondo's picture
20
Oct
2009
0 Votes 0
Login to vote

SQL Authentication

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

anouar's picture
22
Oct
2009
0 Votes 0
Login to vote

same error

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

anouar's picture
27
Oct
2009
0 Votes 0
Login to vote

Hi All i found the issue, you

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