This forum has been disabled. Please visit our new Help Desk at help.jitterbit.com

Failed to retrieve history. Error

Questions and answers for configuring and deploying your integrations.

Failed to retrieve history. Error

Postby vinodravi on Mon Jan 28, 2008 9:06 pm

I am receiving this error. Can anyone please help?
Thanks

Failed to retrieve history.

Error on the server: get SourceFileHistoryLog(id=0,entity_type_id=0...) failed to get db connection!
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.


Details:
Unable to connect to database using DSN UID=jitterbit;PWD=<REMOVED>;SERVER=127.0.0.1;DRIVER={PostgreSQL Unicode};DATABASE=TranDb;Port=5432;!


SQL Errors:
(0) SQL Error! SQLSTATE = 08001 Native err = 113 msg = server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.


(1) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

(2) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed



Client version: 1.3.0.72
Server version: 1.3.0.87
Client platform: Windows XP - Java 1.6.0_03
Server platform: Windows_NT 5.1 SP 2.0 (Service Pack 2) Build 2600

org.jitterbit.integration.client.server.IntegrationServerException: Error on the server: get SourceFileHistoryLog(id=0,entity_type_id=0...) failed to get db connection!
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.


Details:
Unable to connect to database using DSN UID=jitterbit;PWD=<REMOVED>;SERVER=127.0.0.1;DRIVER={PostgreSQL Unicode};DATABASE=TranDb;Port=5432;!


SQL Errors:
(0) SQL Error! SQLSTATE = 08001 Native err = 113 msg = server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.


(1) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

(2) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed


at org.jitterbit.integration.server.implementation.webservice.WebServiceConfiguration.convertToIntegrationServerException(WebServiceConfiguration.java:176)
at org.jitterbit.integration.server.implementation.webservice.WebServiceServerCall.convert(WebServiceServerCall.java:51)
at org.jitterbit.integration.server.implementation.webservice.activity.impl.ActivityInfoProviderWsImpl.getSourceHistory(ActivityInfoProviderWsImpl.java:408)
at org.jitterbit.integration.client.ui.activity.component.history.GetSourceHistoryJob$1.run(GetSourceHistoryJob.java:70)
at org.jitterbit.integration.client.ui.core.DefaultUiWorker$RunnableWrapper.run(DefaultUiWorker.java:197)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: get SourceFileHistoryLog(id=0,entity_type_id=0...) failed to get db connection!
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.


Details:
Unable to connect to database using DSN UID=jitterbit;PWD=<REMOVED>;SERVER=127.0.0.1;DRIVER={PostgreSQL Unicode};DATABASE=TranDb;Port=5432;!


SQL Errors:
(0) SQL Error! SQLSTATE = 08001 Native err = 113 msg = server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.


(1) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

(2) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed


at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:223)
at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:130)
at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at javax.xml.parsers.SAXParser.parse(Unknown Source)
at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:695)
at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:807)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.client.AxisClient.invokeTransport(AxisClient.java:150)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:289)
at org.apache.axis.client.Call.invokeEngine(Call.java:2838)
at org.apache.axis.client.Call.invoke(Call.java:2824)
at org.apache.axis.client.Call.invoke(Call.java:2501)
at org.apache.axis.client.Call.invoke(Call.java:2424)
at org.apache.axis.client.Call.invoke(Call.java:1835)
at org.jitterbit.integration.server.implementation.webservice.activity.client.Konga_activity_infoproviderSoapBindingStub.getSourceFileHistoryLog(Konga_activity_infoproviderSoapBindingStub.java:468)
at org.jitterbit.integration.server.implementation.webservice.activity.impl.ActivityInfoProviderWsImpl.getSourceHistory(ActivityInfoProviderWsImpl.java:403)
... 8 more
vinodravi Bookmark and Share
Community Newbie
Community Newbie
 
Posts: 3
Joined: Tue Jun 05, 2007 6:35 am

Postby Henrik Nordberg on Tue Jan 29, 2008 9:57 am

Hi,

A server stability issue was detected in 1.3.0 and fixed in 1.3.1. Please upgrade to 1.3.1 and let us know if you still have a problem.

Thanks
Henrik
Henrik Nordberg Bookmark and Share
Jitterbit Hero
Jitterbit Hero
 
Posts: 783
Joined: Wed Dec 21, 2005 9:29 pm
Location: Walnut Creek, California

Thank you, but...

Postby vinodravi on Tue Jan 29, 2008 11:57 am

Hi,
I am seeing that the latest versions available for download are

Client version: 1.3.0.72
Server version: 1.3.0.87

Is that correct?

Thanks

Vinod
vinodravi Bookmark and Share
Community Newbie
Community Newbie
 
Posts: 3
Joined: Tue Jun 05, 2007 6:35 am

Postby Henrik Nordberg on Tue Jan 29, 2008 1:03 pm

Thanks for pointing that out. We will update the links.
In the meantime you can download 1.3.1 directly from SourceForge.net.

Cheers
Henrik
Henrik Nordberg Bookmark and Share
Jitterbit Hero
Jitterbit Hero
 
Posts: 783
Joined: Wed Dec 21, 2005 9:29 pm
Location: Walnut Creek, California

Thank you!

Postby vinodravi on Tue Jan 29, 2008 1:10 pm

Thanks. I will let you know how it goes.
vinodravi Bookmark and Share
Community Newbie
Community Newbie
 
Posts: 3
Joined: Tue Jun 05, 2007 6:35 am

Re: Failed to retrieve history. Error

Postby LazerWonder on Wed Jul 09, 2008 11:11 am

I'm getting this error on occasion as well.

Code: Select all
Error on the server: get OperationLog failed, server closed the connection unexpectedly
   This probably means the server terminated abnormally
   before or while processing the request.


Details:
Unable to connect to database using DSN UID=jitterbit;PWD=<REMOVED>;SERVER=127.0.0.1;DRIVER={PostgreSQL Unicode};DATABASE=TranDb;Port=5432;!


SQL Errors:
(0) SQL Error! SQLSTATE = 08001 Native err = 113 msg = server closed the connection unexpectedly
   This probably means the server terminated abnormally
   before or while processing the request.


(1) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

(2) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

Client version: 2.0.0.80-preview
Server version: 2.0.0.45-preview-trial
Client platform: Windows Vista - Java 1.6.0_06
Server platform: Microsoft Windows Vista Home Premium Edition, 32-bit 6.0 SP 1.0 (Service Pack 1) Build 6001
CPU: AuthenticAMD x86 AMD Athlon(tm) 64 X2 Dual Core Processor 4200+ - x86 Family 15 Model 75 Stepping 2, 2 cores total.
RAM: -2 GB in use, 1.801 GB available, 3.499 GB total.
Swap: 0.5238 GB in use, 1.44 GB available, 2 GB total.
Disk (where Jitterbit is installed): 58.03 GB in use, 55.17 GB available, 113.2 GB total.



Has this problem been fixed yet in version 2.0?
LazerWonder Bookmark and Share
Community Member
Community Member
 
Posts: 15
Joined: Thu Jun 26, 2008 11:50 am

Re: Failed to retrieve history. Error

Postby LazerWonder on Wed Jul 09, 2008 11:14 am

Here's the Java stack trace:

Code: Select all
org.jitterbit.integration.client.server.IntegrationServerException: Error on the server: get OperationLog failed, server closed the connection unexpectedly
   This probably means the server terminated abnormally
   before or while processing the request.


Details:
Unable to connect to database using DSN UID=jitterbit;PWD=<REMOVED>;SERVER=127.0.0.1;DRIVER={PostgreSQL Unicode};DATABASE=TranDb;Port=5432;!


SQL Errors:
(0) SQL Error! SQLSTATE = 08001 Native err = 113 msg = server closed the connection unexpectedly
   This probably means the server terminated abnormally
   before or while processing the request.


(1) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

(2) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed


   at org.jitterbit.integration.client.server.webservice.WebServiceConfiguration.convertToIntegrationServerException(WebServiceConfiguration.java:231)
   at org.jitterbit.integration.client.server.webservice.WebServiceServerCall.convert(WebServiceServerCall.java:51)
   at org.jitterbit.integration.server.implementation.webservice.activity.impl.ActivityInfoProviderWsImpl.getOperationLog(ActivityInfoProviderWsImpl.java:345)
   at org.jitterbit.integration.activity.ui.log.GetLogJob$1.run(GetLogJob.java:71)
   at org.jitterbit.application.worker.DefaultUiWorker$RunnableWrapper.run(DefaultUiWorker.java:194)
   at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
   at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
   at java.util.concurrent.FutureTask.run(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
Caused by: get OperationLog failed, server closed the connection unexpectedly
   This probably means the server terminated abnormally
   before or while processing the request.


Details:
Unable to connect to database using DSN UID=jitterbit;PWD=<REMOVED>;SERVER=127.0.0.1;DRIVER={PostgreSQL Unicode};DATABASE=TranDb;Port=5432;!


SQL Errors:
(0) SQL Error! SQLSTATE = 08001 Native err = 113 msg = server closed the connection unexpectedly
   This probably means the server terminated abnormally
   before or while processing the request.


(1) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

(2) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed


   at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:223)
   at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:130)
   at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
   at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
   at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
   at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
   at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
   at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
   at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source)
   at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
   at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
   at javax.xml.parsers.SAXParser.parse(Unknown Source)
   at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
   at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:695)
   at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
   at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:807)
   at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144)
   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
   at org.apache.axis.client.AxisClient.invokeTransport(AxisClient.java:150)
   at org.apache.axis.client.AxisClient.invoke(AxisClient.java:289)
   at org.apache.axis.client.Call.invokeEngine(Call.java:2838)
   at org.apache.axis.client.Call.invoke(Call.java:2824)
   at org.apache.axis.client.Call.invoke(Call.java:2501)
   at org.apache.axis.client.Call.invoke(Call.java:2424)
   at org.apache.axis.client.Call.invoke(Call.java:1835)
   at org.jitterbit.integration.server.implementation.webservice.activity.client.Konga_activity_infoproviderSoapBindingStub.getOperationLog(Konga_activity_infoproviderSoapBindingStub.java:332)
   at org.jitterbit.integration.server.implementation.webservice.activity.impl.ActivityInfoProviderWsImpl.getOperationLog(ActivityInfoProviderWsImpl.java:338)
   ... 8 more


Please advise. Thanks.
LazerWonder Bookmark and Share
Community Member
Community Member
 
Posts: 15
Joined: Thu Jun 26, 2008 11:50 am


Return to Using Jitterbit


SourceForge.net Logo  open source integration