10.2.700 Test Setup

Epicor ERP 10
1

While setting up 10.2.700 in my Test, I received this error when I opened Epicor and selecte dYES for conversion workbench. And yes, I ahve upgrade the DB.

Ice.Common.EpicorServerException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid column name 'AttachNetworkRoot'.
Invalid column name 'AttachSharePointRoot'.
Invalid column name 'EnableFileSys'.
Invalid column name 'EnableSharePoint'.
Invalid column name 'AllowDefaultDoc'.
Invalid column name 'EnableDocStar'.
Invalid column name 'AttachDocStarSiteURL'.
Invalid column name 'CanViewDocStar'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   --- End of inner exception stack trace ---
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass41_0.<GetResults>b__0()
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__31_0()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
   at System.Data.Entity.Core.Objects.CompiledQuery.ExecuteQuery[TResult](ObjectContext context, Object[] parameterValues)
   at Epicor.Data.DBExpressionCompiler.GetResult[TDataContext,TQuery,TResult](Func`3 executeQuery, Cache cacheSetting, TDataContext dataContext, TQuery query) in C:\_releases\ICE\ICE3.2.700.3\Source\Framework\Epicor.System\Data\DBExpressionCompiler.cs:line 445
   at Epicor.Data.DBExpressionCompiler.InvokeSingle[TDataContext,TQuery,TResult](Expression expression, Cache currentCacheSetting, Boolean cacheQuery, TDataContext dataContext, Func`2 getDataCacheKey, Func`2 compileQuery, Func`3 executeQuery) in C:\_releases\ICE\ICE3.2.700.3\Source\Framework\Epicor.System\Data\DBExpressionCompiler.cs:line 306
   at Epicor.Data.DBExpressionCompiler.<>c__DisplayClass55_0`3.<Compile>b__0(TContext context, TArg1 arg1) in C:\_releases\ICE\ICE3.2.700.3\Source\Framework\Epicor.System\Data\DBExpressionCompiler.Generated.cs:line 1082
   at Ice.Services.Lib.SessionModSvc.SetTaskClientID(String environmentUserName, String& taskClientID) in C:\_Releases\ICE\ICE3.2.700.0\Source\Server\Services\Lib\SessionMod\SessionMod.cs:line 285
   at Ice.Services.Lib.SessionModSvcFacade.Sync(String clientDateFormat, String clientComputerName, Int32 clientTerminalID, String clientUserName, String appserver, String& userID, Boolean& replicatedDatabase, String& taskClientID) in C:\_Releases\ICE\ICE3.2.700.0\Source\Server\Services\Lib\SessionMod\SessionModSvcFacade.cs:line 626
   at SyncInvokeSync(Object , Object[] , Object[] )
   at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
   at Epicor.Hosting.OperationBoundInvoker.InnerInvoke(Object instance, Func`2 func) in C:\_releases\ICE\ICE3.2.700.3\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 59
   at Epicor.Hosting.OperationBoundInvoker.Invoke(Object instance, Func`2 func) in C:\_releases\ICE\ICE3.2.700.3\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 28
   --- End of inner exception stack trace ---
2

Did you upgrade the DB (in EAC) first?

image
image890×302 27 KB

3

Funny, these are the fields they Converted/moved from Ice.SysCompany to Ice.DmsStorageType to allow for new document storage endpoints. You’d think the update script would just handle it properly…

4

Yes, I did that already. It shows 10.2.700.3 as it should.

5

Looking through the error detail’s the different versions of ICE jumed out at me.

image
image721×457 30.3 KB

6

How in the world does that happen?!

7

Do both those directories even exist on the App server?

C:\_releases\ICE\ICE3.2.700.3\
and
C:\_releases\ICE\ICE3.2.700.0\

8

I do not see that on my C drive for either one. Note: this is my test environment and everything test is on this one server. So unless I am supposed to be looking some where else besides the literal location shown, its not there.

9

This problem is caused by the data model being out of sync. The DB upgrade handles the DB, but afterwards, you still need to do a regen so the data model is updated. Dont forget to recycle after regen.

Also those dirs wont be on your server, they are just the directory structure of the initial compile of Epicor.

1 Like