February 27, 2008 at 4:14 pm
I have been trying to pinpoint this error for 6 months... We have a trigger(9 pages long) that assigns customer invoices to three separate batches depending on a customer's billing type (EFT, credit card, or manual bill). The nice thing is that an EFT payment is made also for the EFT customers and we then attach the payments to a bank portal.
Every once in a while during the billing process an error message will appear, "An error occurred with this document. 17" The invoice header disappears, but the line items remain in a table. The thing is that only EFT invoices disappear along with the payment. I have run a trace through SQL profiler and still don't know what is happening. I have attached a screenshot of where I think the error is happening...
Any suggestions would be more than appreciated! Thank you!!!
February 27, 2008 at 4:25 pm
This isn't a SQL Server error message - it's a message from Microsoft Dynamics. I recommend you post this (but post a *link* to your bitmap, not the actual bitmap) in the MSDN Dynamics forums on http://forums.microsoft.com/Dynamics/default.aspx?SiteID=27
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply