Getting this error on login from kinetic. Does anyone know how to get around it or fix it. This is a new install with converted data also we are on prem.
Message says invalid column COPACode and i looked up knowledge base articale and it say install CSF-UK does not make sense
Are you sure the error isnāt āCOACodeā ? Thatās a pretty common column name.
How was the data conversion done? I hope it wasnāt by building the tables yourself, with SQL and one of the tables column names got misspelled.
I would regen the database. Iāve gotten weird errors like that in the past when Views were not created correctly.
I used the normal process to do a database conversion through the database upgrade Utility.
Just did that and that did not solve that issue.
did you review server event viewer log? what is the full error stack there?
Ice.Common.EpicorServerException: Invalid column name āCOPACCodeā.
ā> System.Data.SqlClient.SqlException (0x80131904): Invalid column name āCOPACCodeā.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Ice.TablesetBound`3.<>c__DisplayClass36_1.b__2() in C:_releases\ICE\ICE4.2.200.7\Source\Server\Framework\Epicor.Ice\Services\TablesetBound.cs:line 681
at Ice.Services.Trace.TablesetProfilingCollector.DoStoredProcedureTrace[TResult](String storedProcedureName, Func`1 action) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Framework\Epicor.Ice\Services\TablesetProfilingCollector.cs:line 145
at Ice.TablesetBound3.InnerGetByID(IceDataContext dataContext, Int32 pageSize, Int32 absolutePage, Boolean& morePages, TFullTableset tableset, IEnumerable1 queryParameters) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Framework\Epicor.Ice\Services\TablesetBound.cs:line 630
at Erp.Services.BO.CompanySvc.GetByID(String company) in C:_releases\ERP\ERP11.2.200.0\Source\Server\Services\BO\Company\Company.Designer.cs:line 6019
at Erp.Services.BO.CompanySvcFacade.GetByID(String company) in C:_releases\ERP\ERP11.2.200.0\Source\Server\Services\BO\Company\CompanySvcFacade.cs:line 3197 at Ice.Hosting.RestApi.OperationInvokeHelper.CallInvoker(Type svcType, MethodInfo mi, Object[] inputs, Boolean isRoot, IceDataContext dataContext) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Framework\Epicor.Ice\Hosting\RestApi\OperationInvokeHelper.cs:line 409
at Ice.Hosting.RestApi.OperationInvokeHelper.CallInvoker(TypeEntry svcTe, String serviceMethod, Object[] inputs, Boolean isRoot, IceDataContext dataContext) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Framework\Epicor.Ice\Hosting\RestApi\OperationInvokeHelper.cs:line 379
at Ice.Hosting.RestApi.OperationInvokeHelper.MakeServiceCall(IceDataContext dataContext, TypeEntry svcTe, String serviceMethod, Object[] parameters) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Framework\Epicor.Ice\Hosting\RestApi\OperationInvokeHelper.cs:line 331
at Ice.Hosting.RestApi.OperationInvokeHelper.GetByID(IceDataContext dataContext, String serviceName, NameValueCollection queryParams) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Framework\Epicor.Ice\Hosting\RestApi\OperationInvokeHelper.cs:line 80
at Ice.Hosting.RestApi.OperationInvokeHelper.GetByID(String serviceName, NameValueCollection queryParams) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Framework\Epicor.Ice\Hosting\RestApi\OperationInvokeHelper.cs:line 49
at Epicor.OData.V3.DataSources.IceODataServiceCaller.LoadItem(TypeData typeData, HttpCallContext httpCallContext, String[] keys, IQueryOptions options) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Hosting\AspNetCore\RestApi\Epicor.OData.AspNetCore.V3\DataSources\Main\IceODataServiceCaller.cs:line 65
at Epicor.OData.V3.DataSources.DataSourceProvider.GetChildCollection(TypeMapping typeMapping, HttpCallContext httpCallContext, String[] parentKeys, IEdmCollectionType collectionType, IQueryOptions queryOptions) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Hosting\AspNetCore\RestApi\Epicor.OData.AspNetCore.V3\DataSources\Main\DataSourceProvider.cs:line 105
at Epicor.OData.V3.Controllers.HandleODataV3Controller.GetNavigationTable(String key) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Hosting\AspNetCore\RestApi\Epicor.OData.AspNetCore.V3\Controllers\HandleODataV3Controller.cs:line 135
at lambda_method1434(Closure , Object , Object[] )
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
ā End of stack trace from previous location ā
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
ā End of stack trace from previous location ā
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker)
at Microsoft.AspNetCore.Routing.EndpointMiddleware.g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
at Ice.Hosting.AspNetCore.Middleware.DynamicAssemblyPartMiddleware.Invoke(HttpContext context, CurrentCallInformationService currentCallInformation, ControllerLoader controllerLoader) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Hosting\AspNetCore\Ice.Hosting.AspNetCore\Middleware\DynamicAssemblyPartMiddleware.cs:line 33
at Ice.Hosting.AspNetCore.Middleware.IPEnforcerMiddleware.Invoke(HttpContext httpContext) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Hosting\AspNetCore\Ice.Hosting.AspNetCore\Middleware\IPEnforcerMiddleware.cs:line 44
at Ice.Hosting.AspNetCore.Middleware.AuthorizationMiddleware.ProcessAuthenticatedUser(HttpContext context, IPrincipal user) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Hosting\AspNetCore\Ice.Hosting.AspNetCore\Middleware\AuthorizationMiddleware.cs:line 53
at Ice.Hosting.AspNetCore.Middleware.AuthorizationMiddleware.Invoke(HttpContext context, CurrentCallInformationService currentCallInformation) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Hosting\AspNetCore\Ice.Hosting.AspNetCore\Middleware\AuthorizationMiddleware.cs:line 44
at Ice.Hosting.AspNetCore.ETags.ETagMiddleware.Invoke(HttpContext httpContext) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Hosting\AspNetCore\Ice.Hosting.AspNetCore\ETags\ETagMiddleware.cs:line 110
at Ice.Hosting.AspNetCore.ETags.ETagMiddleware.Invoke(HttpContext httpContext) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Hosting\AspNetCore\Ice.Hosting.AspNetCore\ETags\ETagMiddleware.cs:line 110
at Ice.Hosting.AspNetCore.Middleware.DecompressRequestMiddleware.Invoke(HttpContext context) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Hosting\AspNetCore\Ice.Hosting.AspNetCore\Middleware\DecompressRequestMiddleware.cs:line 42
at Epicor.RESTApi.Middleware.ApiKeyEnforcerMiddleware.Invoke(HttpContext context) in C:_releases\ICE\ICE4.2.200.7\Source\Server\Hosting\AspNetCore\Ice.Hosting.AspNetCore\Middleware\ApiKeyEnforcerMiddleware.cs:line 79
at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)
ClientConnectionId:2213acb8-f31d-4b77-b851-78e59dd9aee7
Error Number:207,State:1,Class:16
ā End of inner exception stack trace ā
looks like stored procedure is failing. Maybe try to use SQL profiler or events to find what exact procedure is failing. either standard _ZFW_Company_GetByID or you really have some CSF extension installed incorrectly and its procedure is failed because of misssing column
For me the message was related to not installing CSF correctly following an upgrade, reinstalled the CSF and message went away.
Do i need to install the United States CSF if we are only need US?
Yes
I also dont have access to download the CSF for the United States.
I donāt believe there is anything to install for US CSF. You do however need to enable it in the Administration Console in the Licensing Section of your App:
Right click Properties
yes that is installed and has been while we have been on 10 for the longest time. Also this is an upgrade from 10.2.700 to 11.2.200.7
We upgraded from 10.1.600 and we had to enable it.
In the beginning you mentioned UK CSF. Is it possible that you enabled some features or a reused a field intended for UK CSF? Do you have customers in the UK for example?
Which part about the CSF-UK doesnāt make sense? You still need the CSF UK. Chances are you had it installed at some point and it create the COPA Records and now you need it again, or you need to work with Epicor to remove the UK CSF Setup Data.