Running Checklinks on Finance Module - How Long is Too Long

(0) Share

Report

Posted on by Jim Lines

Greetings!
In my GP career, I've run Checklinks a million times and have never had an instance where it took more than 8 hours on a given module (usually Inventory, of course!). This weekend, our accounting department started processing their YE close and kicked off the Financial Checklinks (about 3M+ records) which it's still running. It's going on about 48 hours of processing as of this post. All weekend there were no users on GP nor on the terminal server clients (with the exception of the user processing). I've checked the activity monitor in SQL and confirmed the CL process is running. So I don't believe anything would have been interfering with the processes (but I could be wrong).

I'm not looking for a solution, per se, just curious if anyone has experienced the process taking this long. What about archiving data? I've not done this before, but would be curious if any of you have and what your experience has been.

Thanks in advance!

Jim

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

steveendow 2,281 on at

Like (0)

Report
Copy link

Link copied!

Hi Jim,

I believe it will vary significantly depending on which Check Links is run.

I had a client with a relatively large database (don't remember the size) who attempted to run the Multi-Currency check links after a GP license upgrade caused some problems. The MC Check Links ran for days. After 5 days they eventually killed the process (after getting the OK from Microsoft) and decided to never run MC check links again.

That client did eventually implement GP Archive by Professional Advantage, but I don't think they ever tried Check Links again.

Was this reply helpful? Yes No
Heather Roggeveen 9,150 on at

Like (0)

Report
Copy link

Link copied!

Archiving - highly recommend Company Data Archive from Professional Advantage.

Was this reply helpful? Yes No
Jim Lines 4 on at

Like (0)

Report
Copy link

Link copied!

Steve,

Thanks! This is (somewhat) reassuring. I appreciate your feedback!

Jim

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

Hey Jim, it is going on 5:00 Tuesday - what solution to your original question.

How long did the CL take? Did you finally and successful conclude the process?

Just asking for information.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!

I do agree with Steve, the answer is relatively related to which tables you are including. Additionally, it could definitely take a huge time when a huge amount of data is included.

Was this reply helpful? Yes No