Hello Folks,
Wishing you Happy New Year !!!
I am getting error while run the P-Job. Basically it has changed the status to read failed.
Error:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlSourceRequestHandler.ReseedLocalUploadSessionId(Int64 seedValue) at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlSourceRequestHandler.CreateLocalUploadSession(UploadSession uploadSessionToCreate) at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlSourceRequestHandler.CreateChannelData(String fullFilePath) at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlSourceRequestHandler.ProcessSourceRequest(SessionManager sessionManager) at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlSourceRequestHandler.GeneratePackageFromSourceDatabase(SqlSourceRequestContext sourceRequestContext) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) at Dynamics.AX.Application.ReflectionHelper.`tryInvokeStaticMethodFromAssembly(Assembly _assemblyInstance, String _typeName, String _methodName, Object[] _params, Boolean @_params_IsDefaultSet) at Dynamics.AX.Application.ReflectionHelper.tryInvokeStaticMethodFromAssembly(Assembly _assemblyInstance, String _typeName, String _methodName, Object[] _params, Boolean @_params_IsDefaultSet) at Dynamics.AX.Application.ReflectionHelper.tryInvokeStaticMethodFromAssembly(Assembly _assemblyInstance, String _typeName, String _methodName, Object[] _params) at Dynamics.AX.Application.RetailCDXJobUploadSourceContext.generatePackageFromSourceDatabase(Object _sourceRequestContextObject) at Dynamics.AX.Application.RetailCDXJobUploadSourceContext.execute()
Thanks !!!
