Mixing
ERROR [08S01] [IBM][System i Access ODBC Driver]Communication link failure. comm rc=1018 - CWB0999
I have a web service on c# with communication with AS400. "Randomly" I'm getting this error:
ERROR [08S01] [IBM][System i Access ODBC Driver]Communication link failure. comm rc=1018 - CWB0999 - Unexpected error: unexpected return
code 1018 at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle
hrHandle, RetCode retcode) at
System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection,
OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningObject) at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions
userOptions) at
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
owningConnection, TaskCompletionSource1 retry, DbConnectionOptions1 retry, DbConnectionOptions userOptions) at
userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
connection) at
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
outerConnection, DbConnectionFactory connectionFactory,
TaskCompletionSource
System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.Odbc.OdbcConnection.Open() at
Inaltec.EmisionNS.DALSIIF.CDALMain.ConsultarTarjetasImpresionFD(String
p_strCedula) at
Inaltec.EmisionNS.ReglasNegocio.CTxConsultaTarjetasImpresionFD.ConsultarTarjetasImpresionFD(CTxConsultaEstadoEmisionRequest
p_objRequest)
All connections are closed after the query is done, but the error is still on. The only solution is restart the web service. What can I do or where can I look this error root. This is the method where the error is being generated:
using (m_objConexion = new OdbcConnection(m_strCadenaConexion))
{
m_objConexion.ConnectionTimeout = 10;
if (System.Configuration.ConfigurationManager.AppSettings["ConnectTimeout"] != null)
m_objConexion.ConnectionTimeout = int.Parse(System.Configuration.ConfigurationManager.AppSettings["ConnectTimeout"].ToString());
m_objConexion.Open();
OdbcCommand l_odbcCommand = null;
OdbcParameter l_odbcParametro = null;
//Business Rules
OdbcDataReader l_odbcDataReader = l_odbcCommand.ExecuteReader();
l_dttRetorno.Load(l_odbcDataReader);
l_odbcDataReader.Close();
}
catch (Exception p_objExcepcion)
{
CDataAccessLayer.ManejarExcepcion(p_objExcepcion, CErrores.ERROR_EJECUTANDO_PROCEDIMIENTO_ALMACENADO, l_strNombreProcedimientoAlmacenado);
}
finally
{
l_odbcCommand.Dispose();
m_objConexion.Close();
m_objConexion = null;
}
I don't know exactly what is the meaning of the error code, beyond is a communication failure. If any can help in any way, I would appreciate it.
PS: sorry for my bad english
c# odbc driver ibm-midrange
asked Nov 19 '18 at 23:53
Juan David Cadavid QuinteroJuan David Cadavid Quintero
82
add a comment |
I have a web service on c# with communication with AS400. "Randomly" I'm getting this error:
ERROR [08S01] [IBM][System i Access ODBC Driver]Communication link failure. comm rc=1018 - CWB0999 - Unexpected error: unexpected return
code 1018 at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle
hrHandle, RetCode retcode) at
System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection,
OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningObject) at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions
userOptions) at
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
owningConnection, TaskCompletionSource1 retry, DbConnectionOptions1 retry, DbConnectionOptions userOptions) at
userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
connection) at
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
outerConnection, DbConnectionFactory connectionFactory,
TaskCompletionSource
System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.Odbc.OdbcConnection.Open() at
Inaltec.EmisionNS.DALSIIF.CDALMain.ConsultarTarjetasImpresionFD(String
p_strCedula) at
Inaltec.EmisionNS.ReglasNegocio.CTxConsultaTarjetasImpresionFD.ConsultarTarjetasImpresionFD(CTxConsultaEstadoEmisionRequest
p_objRequest)
All connections are closed after the query is done, but the error is still on. The only solution is restart the web service. What can I do or where can I look this error root. This is the method where the error is being generated:
using (m_objConexion = new OdbcConnection(m_strCadenaConexion))
{
m_objConexion.ConnectionTimeout = 10;
if (System.Configuration.ConfigurationManager.AppSettings["ConnectTimeout"] != null)
m_objConexion.ConnectionTimeout = int.Parse(System.Configuration.ConfigurationManager.AppSettings["ConnectTimeout"].ToString());
m_objConexion.Open();
OdbcCommand l_odbcCommand = null;
OdbcParameter l_odbcParametro = null;
//Business Rules
OdbcDataReader l_odbcDataReader = l_odbcCommand.ExecuteReader();
l_dttRetorno.Load(l_odbcDataReader);
l_odbcDataReader.Close();
}
catch (Exception p_objExcepcion)
{
CDataAccessLayer.ManejarExcepcion(p_objExcepcion, CErrores.ERROR_EJECUTANDO_PROCEDIMIENTO_ALMACENADO, l_strNombreProcedimientoAlmacenado);
}
finally
{
l_odbcCommand.Dispose();
m_objConexion.Close();
m_objConexion = null;
}
I don't know exactly what is the meaning of the error code, beyond is a communication failure. If any can help in any way, I would appreciate it.
PS: sorry for my bad english
c# odbc driver ibm-midrange
asked Nov 19 '18 at 23:53
Juan David Cadavid QuinteroJuan David Cadavid Quintero
82
I think the core of your issues is your exception handling. Even in that little showncode there area lot of mistakes, like going on after Fatal Exceptions. Here are two articles on exception handling I link often: blogs.msdn.microsoft.com/ericlippert/2008/09/10/… | codeproject.com/Articles/9538/…
– Christopher
Nov 20 '18 at 0:12
The exception is never triggered. The error occurs in m_objConexion.Open()
– Juan David Cadavid Quintero
Nov 20 '18 at 2:09
add a comment |
I have a web service on c# with communication with AS400. "Randomly" I'm getting this error:
ERROR [08S01] [IBM][System i Access ODBC Driver]Communication link failure. comm rc=1018 - CWB0999 - Unexpected error: unexpected return
code 1018 at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle
hrHandle, RetCode retcode) at
System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection,
OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningObject) at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions
userOptions) at
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
owningConnection, TaskCompletionSource1 retry, DbConnectionOptions1 retry, DbConnectionOptions userOptions) at
userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
connection) at
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
outerConnection, DbConnectionFactory connectionFactory,
TaskCompletionSource
System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.Odbc.OdbcConnection.Open() at
Inaltec.EmisionNS.DALSIIF.CDALMain.ConsultarTarjetasImpresionFD(String
p_strCedula) at
Inaltec.EmisionNS.ReglasNegocio.CTxConsultaTarjetasImpresionFD.ConsultarTarjetasImpresionFD(CTxConsultaEstadoEmisionRequest
p_objRequest)
All connections are closed after the query is done, but the error is still on. The only solution is restart the web service. What can I do or where can I look this error root. This is the method where the error is being generated:
using (m_objConexion = new OdbcConnection(m_strCadenaConexion))
{
m_objConexion.ConnectionTimeout = 10;
if (System.Configuration.ConfigurationManager.AppSettings["ConnectTimeout"] != null)
m_objConexion.ConnectionTimeout = int.Parse(System.Configuration.ConfigurationManager.AppSettings["ConnectTimeout"].ToString());
m_objConexion.Open();
OdbcCommand l_odbcCommand = null;
OdbcParameter l_odbcParametro = null;
//Business Rules
OdbcDataReader l_odbcDataReader = l_odbcCommand.ExecuteReader();
l_dttRetorno.Load(l_odbcDataReader);
l_odbcDataReader.Close();
}
catch (Exception p_objExcepcion)
{
CDataAccessLayer.ManejarExcepcion(p_objExcepcion, CErrores.ERROR_EJECUTANDO_PROCEDIMIENTO_ALMACENADO, l_strNombreProcedimientoAlmacenado);
}
finally
{
l_odbcCommand.Dispose();
m_objConexion.Close();
m_objConexion = null;
}
I don't know exactly what is the meaning of the error code, beyond is a communication failure. If any can help in any way, I would appreciate it.
PS: sorry for my bad english
c# odbc driver ibm-midrange
asked Nov 19 '18 at 23:53
Juan David Cadavid QuinteroJuan David Cadavid Quintero
82
I have a web service on c# with communication with AS400. "Randomly" I'm getting this error:
ERROR [08S01] [IBM][System i Access ODBC Driver]Communication link failure. comm rc=1018 - CWB0999 - Unexpected error: unexpected return
code 1018 at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle
hrHandle, RetCode retcode) at
System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection,
OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningObject) at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions
userOptions) at
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
owningConnection, TaskCompletionSource1 retry, DbConnectionOptions1 retry, DbConnectionOptions userOptions) at
userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
connection) at
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
outerConnection, DbConnectionFactory connectionFactory,
TaskCompletionSource
System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.Odbc.OdbcConnection.Open() at
Inaltec.EmisionNS.DALSIIF.CDALMain.ConsultarTarjetasImpresionFD(String
p_strCedula) at
Inaltec.EmisionNS.ReglasNegocio.CTxConsultaTarjetasImpresionFD.ConsultarTarjetasImpresionFD(CTxConsultaEstadoEmisionRequest
p_objRequest)
All connections are closed after the query is done, but the error is still on. The only solution is restart the web service. What can I do or where can I look this error root. This is the method where the error is being generated:
using (m_objConexion = new OdbcConnection(m_strCadenaConexion))
{
m_objConexion.ConnectionTimeout = 10;
if (System.Configuration.ConfigurationManager.AppSettings["ConnectTimeout"] != null)
m_objConexion.ConnectionTimeout = int.Parse(System.Configuration.ConfigurationManager.AppSettings["ConnectTimeout"].ToString());
m_objConexion.Open();
OdbcCommand l_odbcCommand = null;
OdbcParameter l_odbcParametro = null;
//Business Rules
OdbcDataReader l_odbcDataReader = l_odbcCommand.ExecuteReader();
l_dttRetorno.Load(l_odbcDataReader);
l_odbcDataReader.Close();
}
catch (Exception p_objExcepcion)
{
CDataAccessLayer.ManejarExcepcion(p_objExcepcion, CErrores.ERROR_EJECUTANDO_PROCEDIMIENTO_ALMACENADO, l_strNombreProcedimientoAlmacenado);
}
finally
{
l_odbcCommand.Dispose();
m_objConexion.Close();
m_objConexion = null;
}
I don't know exactly what is the meaning of the error code, beyond is a communication failure. If any can help in any way, I would appreciate it.
PS: sorry for my bad english
c# odbc driver ibm-midrange
c# odbc driver ibm-midrange
asked Nov 19 '18 at 23:53
Juan David Cadavid QuinteroJuan David Cadavid Quintero
82
asked Nov 19 '18 at 23:53
Juan David Cadavid QuinteroJuan David Cadavid Quintero
82
asked Nov 19 '18 at 23:53
Juan David Cadavid QuinteroJuan David Cadavid Quintero
82
asked Nov 19 '18 at 23:53
Juan David Cadavid QuinteroJuan David Cadavid Quintero
82
asked Nov 19 '18 at 23:53
Juan David Cadavid QuinteroJuan David Cadavid Quintero
82
82
I think the core of your issues is your exception handling. Even in that little showncode there area lot of mistakes, like going on after Fatal Exceptions. Here are two articles on exception handling I link often: blogs.msdn.microsoft.com/ericlippert/2008/09/10/… | codeproject.com/Articles/9538/…
– Christopher
Nov 20 '18 at 0:12
The exception is never triggered. The error occurs in m_objConexion.Open()
– Juan David Cadavid Quintero
Nov 20 '18 at 2:09
add a comment |
I think the core of your issues is your exception handling. Even in that little showncode there area lot of mistakes, like going on after Fatal Exceptions. Here are two articles on exception handling I link often: blogs.msdn.microsoft.com/ericlippert/2008/09/10/… | codeproject.com/Articles/9538/…
– Christopher
Nov 20 '18 at 0:12
The exception is never triggered. The error occurs in m_objConexion.Open()
– Juan David Cadavid Quintero
Nov 20 '18 at 2:09
I think the core of your issues is your exception handling. Even in that little showncode there area lot of mistakes, like going on after Fatal Exceptions. Here are two articles on exception handling I link often: blogs.msdn.microsoft.com/ericlippert/2008/09/10/… | codeproject.com/Articles/9538/…
– Christopher
Nov 20 '18 at 0:12
I think the core of your issues is your exception handling. Even in that little showncode there area lot of mistakes, like going on after Fatal Exceptions. Here are two articles on exception handling I link often: blogs.msdn.microsoft.com/ericlippert/2008/09/10/… | codeproject.com/Articles/9538/…
– Christopher
Nov 20 '18 at 0:12
The exception is never triggered. The error occurs in m_objConexion.Open()
– Juan David Cadavid Quintero
Nov 20 '18 at 2:09
The exception is never triggered. The error occurs in m_objConexion.Open()
– Juan David Cadavid Quintero
Nov 20 '18 at 2:09
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53384319%2ferror-08s01-ibmsystem-i-access-odbc-drivercommunication-link-failure-comm%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53384319%2ferror-08s01-ibmsystem-i-access-odbc-drivercommunication-link-failure-comm%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I think the core of your issues is your exception handling. Even in that little showncode there area lot of mistakes, like going on after Fatal Exceptions. Here are two articles on exception handling I link often: blogs.msdn.microsoft.com/ericlippert/2008/09/10/… | codeproject.com/Articles/9538/…
– Christopher
Nov 20 '18 at 0:12
The exception is never triggered. The error occurs in m_objConexion.Open()
– Juan David Cadavid Quintero
Nov 20 '18 at 2:09