Error: No process is on the other end of the pipe

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Error: No process is on the other end of the pipe

Postby lkeith » Mon Sep 17, 2012 8:26 pm

I am using SQL Compare 8. When trying to synch a script repository with a SQL DB I am getting this:

Comparing database Scripts.Rex with database Rollout.rex_beta_dev...
Registering data sources
Error: Comparison of 'Scripts.Rex' and 'Rollout.rex_beta_dev' failed: A
connection was successfully established with the server, but then an error
occurred during the login process. (provider: Shared Memory Provider, error: 0 -No process is on the other end of the pipe.)

I get a return code of 126. Your list of return codes does not go this high. Where do I find info on this and other return codes?

Lee
lkeith
lkeith
 
Posts: 6
Joined: Tue Aug 21, 2012 5:48 pm

Postby lkeith » Wed Sep 19, 2012 9:06 pm

I have resolved on part of the issue; the DB being synched did not exist at the time. But I would like to know where I could have found any explanation for a return code of 126 or any other code.
lkeith
lkeith
 
Posts: 6
Joined: Tue Aug 21, 2012 5:48 pm

Postby Manfred.Castro » Wed Sep 19, 2012 9:40 pm

Exit Codes
==========
0 - Success.
1 - General error code.
3 - Illegal argument duplication. Some arguments may not appear more than
once in a command-line. If such arguments appear more than once this
exit code will be returned.
8 - Unsatisfied argument dependency or violated exclusion when user runs
command line. E.g. /arg2 depends on /arg1 but you have specified /arg2
without specifying /arg1, or alternatively /arg2 cannot be used with
/arg1 but you have tried to use them both.
32 - Value out of range. Numeric value supplied for an argument that is
outside the range of valid values for that argument.
33 - Value overflow. The magnitude of a value supplied for an argument is too
large and causes an overflow.
34 - Invalid value. The value supplied for an argument is invalid.
35 - No / invalid software license or trial period has expired.
61 - SQL Compare encountered serious warnings that apply to the
synchronization.
62 - Syntax errors were found in a script folder that was being compared. To
ignore this error, use the 'ignoreParserErrors' option.
63 - The databases being compared are identical with respect to any
constraints on objects being compared.
64 - General command-line usage error.
65 - Data error. Some input data required by the tool is invalid or corrupt.
69 - A resource or service required to run the tool is unavailable.
73 - Failed to create report
74 - IO error occurred. Generally returned if the program attempts to write
to a file that already exists without the user having specified the
/force option.
77 - Action cannot be completed because the user does not have permission.
79 - When used with /assertidentical this value is returned for non-identical
DBs
126 - Execution failed because of an error.
130 - Execution stopped because Ctrl+Break.

This information could have been found in the verbose help file generated by SQL Compare command line.
sqlcompare /v /?
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Postby lkeith » Wed Sep 19, 2012 9:45 pm

I was looking at this page,
https://www.red-gate.com/supportcenter/ ... Exit_Codes

which includes codes only up to 73.
lkeith
lkeith
 
Posts: 6
Joined: Tue Aug 21, 2012 5:48 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests