Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Error in p-0001 jobs

Posted on by 1,260

Hi,

I am getting the following error on the p-0001 job - where should I look into for this kind of error?

Is it coming from HQ/Calculation/Posting - Appreciate your help in advance.

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out

 

   --- End of inner exception stack trace ---

 

   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)

 

   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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

 

   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()

 

   at Dynamics.Ax.Application.RetailCDXMetadataSync.syncUploadSession(String _jobId, Int64 _dataGroup) in RetailCDXMetadataSync.syncUploadSession.xpp:line 72

 

   --- End of inner exception stack trace ---

 

Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.

 

   at Dynamics.Ax.Application.RetailCDXMetadataSync.syncUploadSession(String _jobId, Int64 _dataGroup) in RetailCDXMetadataSync.syncUploadSession.xpp:line 201

 

   at Dynamics.Ax.Application.RetailCDXDataUpload_AX63.Run() in RetailCDXDataUpload_AX63.run.xpp:line 24

 

   at Dynamics.Ax.Application.BatchRun.runJobStaticCode(Int64 batchId) in BatchRun.runJobStaticCode.xpp:line 54

 

   at Dynamics.Ax.Application.BatchRun.runJobStatic(Int64 batchId) in BatchRun.runJobStatic.xpp:line 13

 

   at BatchRun::runJobStatic(Object[] )

 

   at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)

 

   at BatchIL.taskThreadEntry(Object threadArg)

*This post is locked for comments

  • Ferremundo Profile Picture
    Ferremundo 10 on at
    RE: Error in p-0001 jobs

    How do I check the availability and parameterization of the message database asynchronous server (retail parameters form)?

  • RE: Error in p-0001 jobs

    a. Check the availability and parameterization of the mesage  DB async Server (Retail Parameters Form)

    b. Try Initialize Retail without errors.

    > Retail >Setup >Parameters > Retail parameters > Initialize button

    c. Try Sync Metadata

    > Retail >Setup >Parameters > Retail Scheduler Parameters > Sync Metadata button

     

    I Hope this Helps,

    Regards,

    Rodolfo Recalde.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans