Not getting the complete PDF

habarric

Active Member
At a client that is currently having a problem with invoice print. The ube goes through the whole process, updates all records with the proper status, loads all the proper records in the work table, but then when it comes time to output the PDF, it only does 6-8 pages of the report and ends normally...no errors. It should be 3700 pages or so. It cleans up all the records in the work table like it thinks its finished properly, so it's not just ending abruptly.

Eventually after re-running the reprint a few times, it will output them all. No rhyme or reason as to when it works or not. Anyone seen this before...any thoughts? Doesn't appear to be space related on the server.

SQL 2005 Windows x64 DB and Enterprise Server
8.11 SP1 - 8.96.1.1
 
Does this happen when you print 500 invoices or less?
Are you using a multi-thread queue ?
 
Yes and it happens whether single or multi threaded queue.

I actually think we found the problem. We had a couple of other jobs that were acting flaky. They were finishing successfully, but obviously weren't doing what they were designed to do.

Common denominator error in logs - "[SQL Native Client] Query timeout expired"

changed the JDE.INI on the enterprise server to increase the timeout by adding SSQueryTimeout=8 and SSQueryTimeoutRetries=3 to the DB SYSTEM SETTINGS stanza and it works now per a document on the knowledge garden...or whatever we call it these days.

Why JDE does not capture this as a critical error is a mystery.
 
Back
Top