Topic Options
#2661 - 09/04/02 11:45 AM Re: Invoice Erro @ Printing
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11616
Loc: Vancouver, BC Canada
Hi bsa,

The only time we have heard of a similar 'pipe' error printing specs (though not identical to what you reported), it was do to the Specific Printer setting in File | Options. What happened was that a Specific Printer (driver) was chosen instead of the Default printer, and the user who was trying to print a specification did not have that driver on their machine. As a result, printing was unsuccessful.

My suggestion for now (if the above is similar to your situation) is to set the File | Options for printing invoices to the Default Printer. If you need to print to a certain printer other than default, this can be changed at the time of printing via the Setup button.

If you must print to a non-default printer, make sure you have the proper printer driver installed and set up through Windows.

Regards,


Top
#2663 - 09/09/02 07:19 PM Re: Invoice Erro @ Printing
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11616
Loc: Vancouver, BC Canada
Hi bsa,

I noticed you posted a similar question about a year age (Sept 7, 2001 to be precise) involving this error. Searching Google.com led me to this link on the Microsoft Knowledge base:

Pipe error 231

This would lead me to believe the error has to do with the setup of the Terminal Server and the volume of printing being done, and not with Adagio in particular. Here are a couple quotes from that link:

quote:
When SQL Server receives many simultaneous Named Pipes connection requests, some connection requests may fail if the pipe is busy. In the SQL Server error log, multiple "17832 Unable to read login packet" errors are typically logged. On the client side, error 231 "connection busy" or "pipe busy" may be generated.

quote:
There is only one thread that handles incoming SQL Server Named Pipes connection open requests. In an environment where multiple simultaneous named pipes connection requests are issued, it is very likely that no pipe instance is available to service the next pipe open request at any particular moment. In this case, a pipe busy status is returned to the client and the client retries the connection within the specified timeout period until the pipe is available. From a network sniffer trace, on the Windows NT Server Create response, error code (172) STATUS_PIPE_NOT_AVAILABLE is returned to the client. In case of a 16-bit client connection, code (231) ERROR_PIPE_BUSY is returned to the client.

quote:
Increase the application logon timeout value. In this interval, DB-Library and the ODBC driver manager will retry connecting to SQL Server, thereby increasing the chance of a successful connection. Configure SQL Server to listen on multiple pipes. Doing this will increase the number of threads available to process incoming Named Pipes connections. Different client workstations must be configured to use alternate pipes to evenly distribute the load on each pipe.

You can configure SQL Server to listen on multiple pipes by using the registry editor.


Regards,


Top
#2665 - 09/11/02 11:37 AM Re: Invoice Erro @ Printing
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11616
Loc: Vancouver, BC Canada
Hi bsa,

If you don't use SQL Server, then fair enough, Let me at least point out that the error noted there is due to more volume over the Terminal server than can be handled by the system.

Here's something to try. Can you print invoices from within the office (ie not over the Terminal server)? Give this a try for 1, 2 or 4 users simultaneously. If you do not get the Named Pipe errors, then you can be sure your Terminal server setup cannot handle the increased volume, and some settings will have to be modified. We cannot advise what possible settings will be affected or require changes.

Also make sure that every station that chooses to print invoices has the correct printer driver installed, and that if the 'Specific Printer' option is used in File Options, then all workstations should have that driver installed as well.

Regards,


Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 54 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1872 Members
5 Forums
14527 Topics
70937 Posts

Max Online: 432 @ 01/20/25 10:17 PM
August
Su M Tu W Th F Sa
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31