web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Error while opening th...
Supply chain | Supply Chain Management, Commerce
Answered

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

(1) ShareShare
ReportReport
Posted on 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

pastedimage1654835846366v1.png

Can anyone help this out please?

Thanks,

MB

I have the same question (0)
  • Verified answer
    Roozbeh Shad Profile Picture
    Roozbeh Shad 50 on at

    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

    pastedimage1654842573613v3.png

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

    pastedimage1654842636746v4.png 

    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.

    pastedimage1654842698231v5.png

    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.

  • MB Jain Profile Picture
    MB Jain on at

    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)

    pastedimage1654848619147v1.png

    Thanks,

    Muskan

  • Suggested answer
    CU03061412-0 Profile Picture
    CU03061412-0 2 on at

    Seems like you are missing retail schema - try running the quality update again as looks like you restored database.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 92 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 79 Super User 2026 Season 1

#3
Sagar Suman Profile Picture

Sagar Suman 64 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans