Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Check Links running fo...
Microsoft Dynamics GP (Archived)

Check Links running for a week

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi All,

I have a site that runs check links each week. I know you cannot cancel check links, but my issue is it has been running for over a week. There is no way to go back to a backup. When running a trace I see that it is processing zDP_30200SS_1 and sometimes followed by zDP_30300N_1.

What are these stored procedures doing.

What would be the ramifications of cancelling check links, when no one is in the system?

I have not come across this issue before. Check links usually runs fine on this site each week on a Saturday night through to Sunday.

Unfortunately, with new staff, no one noticed it was still running until too late.

Any ideas would be appreciated.

*This post is locked for comments

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,926 Most Valuable Professional on at
    RE: Check Links running for a week

    SQL should be able to handle you doing these events.

    If the stored procedures are missing, the code reverts to select statements so it should not crash.

    David

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Check Links running for a week

    Hi David,

    Thank you for your quick reply.

    Looking into the trace, it is making progress and not in a loop as far as I can tell.

    The table for SOP30200 has 897,000 records approximately.

    Can I run the command below while Check Links is still running?

    I am concerned if I stop check links I will end up with a corrupt database.

    Would dropping the stored Procedures cause the Check Links to crash?

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,926 Most Valuable Professional on at
    RE: Check Links running for a week

    Hi Geoff

    From what I can tell, it is moving through SOP History.

    From the trace is it actually making progress moving through the tables, or is it in some sort of loop?

    Do you have a huge amount of data in those tables?

    I would suggest re-indexing and updating statistics.

    DBCC DBREINDEX ( 'SOP30200')

    GO

    UPDATE STATISTICS SOP30200 WITH FULLSCAN

    GO

    DBCC DBREINDEX ( 'SOP30300')

    GO

    UPDATE STATISTICS SOP30300 WITH FULLSCAN

    GO

    You could also drop and recreate the zDP stored procedures for those tables using SQL Maintenance.

    Just some thoughts

    David

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Check Links running for a week

    Hi Rosemary,

    Thank you for your reply.

    Sorry I have not replied sooner. I was waiting for a colleague to return from holidays.

    Are you suggesting to restore the old backup to a test database and locate an interrupted batch. Would the next step be, once found, to delete the transaction from the live database and hopefully check links will continue?

    The users post the batches. The system is still operating fine while Check Links is running. I can see in a SQL Profiler trace the records are progressing through the table.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Check Links running for a week

    Hi Geoff,

    Do you have a test environment where you can probably install the last backup prior to the check links? We know one of the dependencies is the SOP30200 table. 

    As Praveen indicated it could be a posting that could have been interrupted or corrupt data. Do you post batches or is it the users? I understand your concern about terminating the procedure when you are not too sure what is being updated.

    Regards,

    Rosemary

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Check Links running for a week

    Hi Praveen,

    Thank you for answering my question on the GP forum.

    My question remains, of what this particular stored procedure is performing on the data. I do realise it is working on the SOP tables, as the trace shows the records being processed are invoices and orders.

    This job is run every week on the weekend and has always finished successfully, sometimes listing small issues. However, 2 weeks ago it has not stopped. I do not want to cancel it if this stored procedure is updating the tables. The last good backup would be 2 weeks ago, so I cannot go back to it. Nightly backups are taken, but they would only put the data back to where it is, when cancelled.

    Am I understanding your answer correctly?

  • Suggested answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: Check Links running for a week

    Hi James,

    30200 an 30300 related to Sales Order Processing Historical Transactions and above Scripts related to them.

    The possible cause for this indefinite execution may be due to Posting Interruptions happened in past and Transactions not matching in certain Sales Tables.

    Hope you have planned backup strategy in place, so it is better to terminate the GP Process in that particular machine and in case if you have any difference in Data, then make use of recent best DB backup and restore on the same GP Company from Back-end.

    This will bring your system back in position.

    Thanks,

    Praveen

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans