Error while opening the Channel database form in D365 F&O

Like (1) Share

Report

Posted on 10 Jun 2022 04:37:52 by MB Jain

Hi ,

Hope you are doing well.

we are getting error while opening the Channel database form in D365 F&O and due to this jobs are not getting applied when trying to do run the 9999 job.

Data encryption/decryption failed when trying to edit the Database connection profile table and the ConnectionString field. System.FormatException: The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters. at System.Convert.FromBase64_ComputeResultLength(Char* inputPtr, Int32 inputLength) at System.Convert.FromBase64CharPtr(Char* inputPtr, Int32 inputLength) at System.Convert.FromBase64String(String s) at Microsoft.Dynamics.Ax.Xpp.xApplication.DecryptFromStringForPurpose(String _cipher, String _purpose) at Dynamics.AX.Application.Global.`editEncryptedStringField(Common _common, String value, Int32 _fieldId, Boolean _set) in xppSource://Source/ApplicationPlatform\AxClass_Global.xpp:line 9984

Can anyone help this out please?

Thanks,

All responses (3)

Answers (1)

Suggested answer

CU03061412-0 2 on 11 Jun 2022 at 03:03:41

Like (1)

Report

RE: Error while opening the Channel database form in D365 F&O

Seems like you are missing retail schema - try running the quality update again as looks like you restored database.
MB Jain on 10 Jun 2022 at 08:10:22

Like (0)

Report

RE: Error while opening the Channel database form in D365 F&O

Thankyou for help..

We have followed the steps suggested by you , that problem solved but after running the 9999 job , its getting failed, below is error of job:

System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid object name 'crt.DOWNLOADSESSION'. 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.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__DisplayClass7.<GetResults>b__5() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) 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__0() at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source) at Microsoft.Dynamics.Retail.CommerceDataExchange.AsyncClient.DataManager.DownloadSessionDataManager.UpdateDownloadSession(Int64 id, String jobId, String jobDescription, Int64 fileSize, String checksum, DownloadSessionStatus status, String message) at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlTargetRequestHandler.UpdateLocalDownloadSession() at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlTargetRequestHandler.GetDataPackage() at Microsoft.Dynamics.Retail.CommerceDataExchange.SqlTargetRequestHandler.ApplyToTargetDatabase(SqlTargetRequestContext targetRequestContext)

Thanks,

Muskan
Verified answer

Roozbeh Shad 50 on 10 Jun 2022 at 06:35:42

Like (0)

Report

RE: Error while opening the Channel database form in D365 F&O

Well, I need more info about your environment like the application version, platform version. We had such a problem on local vm application version 10.0.24, platform update 48. In that case try the following:

1) Open windows powershell (administrator mode) and run RetargetRetailServer.ps1 located on your VM at drive:\RetailSDK\References\Dynamics.Servicing.RetailDeployment.72\1.0.30.90\ServiceModels\RetailServer\Scripts where "drive:" is the drive that AOSService resides

2) Go back to the Channel database and check the “Current batch status” on the “Data synchronization” section:

If it’s Cancelled, click on the “Default channel database batch job” link next to it on the left. You will be redirected to the “Batch job” form as shown in the image below.

3) Click on the “Change status” item on the menu bar and change it to “Waiting”.

After a while the job will be executed. This should fix the issue.