Could not open external entity

Questions and answers for configuring and deploying your integrations.

Moderator: emanuel

Could not open external entity

Postby davidq on Thu Mar 11, 2010 6:38 am

Hi guys,

Having had a brreak from JB, we're back to it now and trying to load OAG purchase orders.

The transform seems to pick up all the OAG DTD's needed but when we try to test load an OAG test purchase order file, we get:-

Failed to load source data for the transformation "OSN_NEP_T1".

Error on the server: Failed to load the source data. Reason:
Failed to read and validate XML source using DTD "003_process_po_007.dtd".
Fatal SAX error occurred while parsing the document "C:/Windows/Temp/jitterbit/3053dd9c-8186-40e3-8683-249365246274". Reason:
An exception occurred! Type:RuntimeException, Message:Could not open external entity 'C:/Windows/Temp/jitterbit/oagis_resources.dtd'


Client version: 2.1.0.51
Server version: 2.1.0.48
Client platform: Windows Server 2008 - Java 1.6.0_13
Server platform: Microsoft Windows Server 2008 Standard Edition, 32-bit 6.0 SP 1.0 (Service Pack 1) Build 6001
CPU: GenuineIntel x86 Intel(R) Xeon(R) CPU E5430 @ 2.66GHz - x86 Family 6 Model 23 Stepping 10, 8 cores total.
RAM: 1.58 GB in use, 2.207 GB available, 3.999 GB total.
Swap: 0.4247 GB in use, 1.827 GB available, 2 GB total.
Disk (where Jitterbit is installed): 2.784 GB in use, 485.5 GB available, 488.3 GB total.


org.jitterbit.integration.client.server.IntegrationServerException: Error on the server: Failed to load the source data. Reason:
Failed to read and validate XML source using DTD "003_process_po_007.dtd".
Fatal SAX error occurred while parsing the document "C:/Windows/Temp/jitterbit/3053dd9c-8186-40e3-8683-249365246274". Reason:
An exception occurred! Type:RuntimeException, Message:Could not open external entity 'C:/Windows/Temp/jitterbit/oagis_resources.dtd'

at org.jitterbit.integration.client.server.webservice.WebServiceConfiguration.convertToIntegrationServerException(WebServiceConfiguration.java:245)
at org.jitterbit.integration.client.server.webservice.WebServiceServerCall.convert(WebServiceServerCall.java:51)
at org.jitterbit.integration.server.implementation.webservice.interchange.treemapper.impl.TreeMapperInfoProviderWsImpl.loadSourceDataTree(TreeMapperInfoProviderWsImpl.java:191)
at org.jitterbit.integration.client.ui.interchange.entity.transformation.advanced.LoadSourceDataJob.runImpl(LoadSourceDataJob.java:61)
at org.jitterbit.application.ui.job.UiJob$1.run(UiJob.java:449)
at org.jitterbit.application.worker.DefaultUiWorker$RunnableWrapper.runSafely(DefaultUiWorker.java:200)
at org.jitterbit.application.worker.DefaultUiWorker$RunnableWrapper.run(DefaultUiWorker.java:192)
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: Failed to load the source data. Reason:
Failed to read and validate XML source using DTD "003_process_po_007.dtd".
Fatal SAX error occurred while parsing the document "C:/Windows/Temp/jitterbit/3053dd9c-8186-40e3-8683-249365246274". Reason:
An exception occurred! Type:RuntimeException, Message:Could not open external entity 'C:/Windows/Temp/jitterbit/oagis_resources.dtd'

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.interchange.treemapper.client.Konga_treemapper_infoproviderSoapBindingStub.loadSourceDataTreeWithWarning(Konga_treemapper_infoproviderSoapBindingStub.java:353)
at org.jitterbit.integration.server.implementation.webservice.interchange.treemapper.impl.TreeMapperInfoProviderWsImpl.loadSourceDataTree(TreeMapperInfoProviderWsImpl.java:172)
... 10 more



So, tried adding the other DTD's to Windows\Temp\Jitterbit and re-loaded. Different problem:-

Failed to load source data for the transformation "OSN_NEP_T1".

Error on the server: The XPath expression "@(ACCOUNTING | ACTEND | ACTSTART | APPREQ | APPROVAL | AVAILABLE | BKTEND | BKTSTART | CANCEL | CHANGEDATE | COMPDATE | CONSUME | CREATION | CUMULATIVE | DELIVACT | DELIVSCHED | DISCNT | DOCUMENT | DUE | EARLSTEFF | EARLSTSHIP | EFFECTIVE | ENGCHG | EXECFINISH | EXECSTART | EXPIRATION | FAILDATE | FORECASTF | FORECASTS | FROM | GENERATION | IMPL | INVOICE | JOBDUE | LABORFINSH | LABORSTART | LASTUSED | LOADING | MATCHING | MSMENTDATE | NEEDDELV | OPFINISH | OPSTART | PAYEND | PLANEND | PLANSTART | PO | PROMDELV | PROMSHIP | PYMTTERM | RECEIVED | REPORTDATE | REPORTNGFN | REPORTNGST | REQUIRED | RESORCDWNF | RESORCDWNS | RSPDDATE | RSPDOCGEN | SCHEND | SCHSTART | SETUPFINSH | SETUPSTART | SHIP | SHIPSCHED | STATUSDATE | TEARDOWNF | TEARDOWNS | TO | OTHER)" is not valid. The function '{0}' was not found.
expression = '@(ACCOUNTING | ACTEND | ACTSTART | APPREQ | APPROVAL | AVAILABLE | BKTEND | BKTSTART | CANCEL | CHANGEDATE | COMPDATE | CONSUME | CREATION | CUMULATIVE | DELIVACT | DELIVSCHED | DISCNT | DOCUMENT | DUE | EARLSTEFF | EARLSTSHIP | EFFECTIVE | ENGCHG | EXECFINISH | EXECSTART | EXPIRATION | FAILDATE | FORECASTF | FORECASTS | FROM | GENERATION | IMPL | INVOICE | JOBDUE | LABORFINSH | LABORSTART | LASTUSED | LOADING | MATCHING | MSMENTDATE | NEEDDELV | OPFINISH | OPSTART | PAYEND | PLANEND | PLANSTART | PO | PROMDELV | PROMSHIP | PYMTTERM | RECEIVED | REPORTDATE | REPORTNGFN | REPORTNGST | REQUIRED | RESORCDWNF | RESORCDWNS | RSPDDATE | RSPDOCGEN | SCHEND | SCHSTART | SETUPFINSH | SETUPSTART | SHIP | SHIPSCHED | STATUSDATE | TEARDOWNF | TEARDOWNS | TO | OTHER)' Remaining tokens are: ('@' '(' 'ACCOUNTING' '|' 'ACTEND' '|' 'ACTSTART' '|' 'APPREQ' '|' 'APPROVAL' '|' 'AVAILABLE' '|' 'BKTEND' '|' 'BKTSTART' '|' 'CANCEL' '|' 'CHANGEDATE' '|' 'COMPDATE' '|' 'CONSUME' '|' 'CREATION' '|' 'CUMULATIVE' '|' 'DELIVACT' '|' 'DELIVSCHED' '|' 'DISCNT' '|' 'DOCUMENT' '|' 'DUE' '|' 'EARLSTEFF' '|' 'EARLSTSHIP' '|' 'EFFECTIVE' '|' 'ENGCHG' '|' 'EXECFINISH' '|' 'EXECSTART' '|' 'EXPIRATION' '|' 'FAILDATE' '|' 'FORECASTF' '|' 'FORECASTS' '|' 'FROM' '|' 'GENERATION' '|' 'IMPL' '|' 'INVOICE' '|' 'JOBDUE' '|' 'LABORFINSH' '|' 'LABORSTART' '|' 'LASTUSED' '|' 'LOADING' '|' 'MATCHING' '|' 'MSMENTDATE' '|' 'NEEDDELV' '|' 'OPFINISH' '|' 'OPSTART' '|' 'PAYEND' '|' 'PLANEND' '|' 'PLANSTART' '|' 'PO' '|' 'PROMDELV' '|' 'PROMSHIP' '|' 'PYMTTERM' '|' 'RECEIVED' '|' 'REPORTDATE' '|' 'REPORTNGFN' '|' 'REPORTNGST' '|' 'REQUIRED' '|' 'RESORCDWNF' '|' 'RESORCDWNS' '|' 'RSPDDATE' '|' 'RSPDOCGEN' '|' 'SCHEND' '|' 'SCHSTART' '|' 'SETUPFINSH' '|' 'SETUPSTART' '|' 'SHIP' '|' 'SHIPSCHED' '|' 'STATUSDATE' '|' 'TEARDOWNF' '|' 'TEARDOWNS' '|' 'TO' '|' 'OTHER' ')')

Client version: 2.1.0.51
Server version: 2.1.0.48
Client platform: Windows Server 2008 - Java 1.6.0_13
Server platform: Microsoft Windows Server 2008 Standard Edition, 32-bit 6.0 SP 1.0 (Service Pack 1) Build 6001
CPU: GenuineIntel x86 Intel(R) Xeon(R) CPU E5430 @ 2.66GHz - x86 Family 6 Model 23 Stepping 10, 8 cores total.
RAM: 1.58 GB in use, 2.207 GB available, 3.999 GB total.
Swap: 0.4247 GB in use, 1.827 GB available, 2 GB total.
Disk (where Jitterbit is installed): 2.784 GB in use, 485.5 GB available, 488.3 GB total.


org.jitterbit.integration.client.server.IntegrationServerException: Error on the server: The XPath expression "@(ACCOUNTING | ACTEND | ACTSTART | APPREQ | APPROVAL | AVAILABLE | BKTEND | BKTSTART | CANCEL | CHANGEDATE | COMPDATE | CONSUME | CREATION | CUMULATIVE | DELIVACT | DELIVSCHED | DISCNT | DOCUMENT | DUE | EARLSTEFF | EARLSTSHIP | EFFECTIVE | ENGCHG | EXECFINISH | EXECSTART | EXPIRATION | FAILDATE | FORECASTF | FORECASTS | FROM | GENERATION | IMPL | INVOICE | JOBDUE | LABORFINSH | LABORSTART | LASTUSED | LOADING | MATCHING | MSMENTDATE | NEEDDELV | OPFINISH | OPSTART | PAYEND | PLANEND | PLANSTART | PO | PROMDELV | PROMSHIP | PYMTTERM | RECEIVED | REPORTDATE | REPORTNGFN | REPORTNGST | REQUIRED | RESORCDWNF | RESORCDWNS | RSPDDATE | RSPDOCGEN | SCHEND | SCHSTART | SETUPFINSH | SETUPSTART | SHIP | SHIPSCHED | STATUSDATE | TEARDOWNF | TEARDOWNS | TO | OTHER)" is not valid. The function '{0}' was not found.
expression = '@(ACCOUNTING | ACTEND | ACTSTART | APPREQ | APPROVAL | AVAILABLE | BKTEND | BKTSTART | CANCEL | CHANGEDATE | COMPDATE | CONSUME | CREATION | CUMULATIVE | DELIVACT | DELIVSCHED | DISCNT | DOCUMENT | DUE | EARLSTEFF | EARLSTSHIP | EFFECTIVE | ENGCHG | EXECFINISH | EXECSTART | EXPIRATION | FAILDATE | FORECASTF | FORECASTS | FROM | GENERATION | IMPL | INVOICE | JOBDUE | LABORFINSH | LABORSTART | LASTUSED | LOADING | MATCHING | MSMENTDATE | NEEDDELV | OPFINISH | OPSTART | PAYEND | PLANEND | PLANSTART | PO | PROMDELV | PROMSHIP | PYMTTERM | RECEIVED | REPORTDATE | REPORTNGFN | REPORTNGST | REQUIRED | RESORCDWNF | RESORCDWNS | RSPDDATE | RSPDOCGEN | SCHEND | SCHSTART | SETUPFINSH | SETUPSTART | SHIP | SHIPSCHED | STATUSDATE | TEARDOWNF | TEARDOWNS | TO | OTHER)' Remaining tokens are: ('@' '(' 'ACCOUNTING' '|' 'ACTEND' '|' 'ACTSTART' '|' 'APPREQ' '|' 'APPROVAL' '|' 'AVAILABLE' '|' 'BKTEND' '|' 'BKTSTART' '|' 'CANCEL' '|' 'CHANGEDATE' '|' 'COMPDATE' '|' 'CONSUME' '|' 'CREATION' '|' 'CUMULATIVE' '|' 'DELIVACT' '|' 'DELIVSCHED' '|' 'DISCNT' '|' 'DOCUMENT' '|' 'DUE' '|' 'EARLSTEFF' '|' 'EARLSTSHIP' '|' 'EFFECTIVE' '|' 'ENGCHG' '|' 'EXECFINISH' '|' 'EXECSTART' '|' 'EXPIRATION' '|' 'FAILDATE' '|' 'FORECASTF' '|' 'FORECASTS' '|' 'FROM' '|' 'GENERATION' '|' 'IMPL' '|' 'INVOICE' '|' 'JOBDUE' '|' 'LABORFINSH' '|' 'LABORSTART' '|' 'LASTUSED' '|' 'LOADING' '|' 'MATCHING' '|' 'MSMENTDATE' '|' 'NEEDDELV' '|' 'OPFINISH' '|' 'OPSTART' '|' 'PAYEND' '|' 'PLANEND' '|' 'PLANSTART' '|' 'PO' '|' 'PROMDELV' '|' 'PROMSHIP' '|' 'PYMTTERM' '|' 'RECEIVED' '|' 'REPORTDATE' '|' 'REPORTNGFN' '|' 'REPORTNGST' '|' 'REQUIRED' '|' 'RESORCDWNF' '|' 'RESORCDWNS' '|' 'RSPDDATE' '|' 'RSPDOCGEN' '|' 'SCHEND' '|' 'SCHSTART' '|' 'SETUPFINSH' '|' 'SETUPSTART' '|' 'SHIP' '|' 'SHIPSCHED' '|' 'STATUSDATE' '|' 'TEARDOWNF' '|' 'TEARDOWNS' '|' 'TO' '|' 'OTHER' ')')
at org.jitterbit.integration.client.server.webservice.WebServiceConfiguration.convertToIntegrationServerException(WebServiceConfiguration.java:245)
at org.jitterbit.integration.client.server.webservice.WebServiceServerCall.convert(WebServiceServerCall.java:51)
at org.jitterbit.integration.server.implementation.webservice.interchange.treemapper.impl.TreeMapperInfoProviderWsImpl.loadSourceDataTree(TreeMapperInfoProviderWsImpl.java:191)
at org.jitterbit.integration.client.ui.interchange.entity.transformation.advanced.LoadSourceDataJob.runImpl(LoadSourceDataJob.java:61)
at org.jitterbit.application.ui.job.UiJob$1.run(UiJob.java:449)
at org.jitterbit.application.worker.DefaultUiWorker$RunnableWrapper.runSafely(DefaultUiWorker.java:200)
at org.jitterbit.application.worker.DefaultUiWorker$RunnableWrapper.run(DefaultUiWorker.java:192)
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: The XPath expression "@(ACCOUNTING | ACTEND | ACTSTART | APPREQ | APPROVAL | AVAILABLE | BKTEND | BKTSTART | CANCEL | CHANGEDATE | COMPDATE | CONSUME | CREATION | CUMULATIVE | DELIVACT | DELIVSCHED | DISCNT | DOCUMENT | DUE | EARLSTEFF | EARLSTSHIP | EFFECTIVE | ENGCHG | EXECFINISH | EXECSTART | EXPIRATION | FAILDATE | FORECASTF | FORECASTS | FROM | GENERATION | IMPL | INVOICE | JOBDUE | LABORFINSH | LABORSTART | LASTUSED | LOADING | MATCHING | MSMENTDATE | NEEDDELV | OPFINISH | OPSTART | PAYEND | PLANEND | PLANSTART | PO | PROMDELV | PROMSHIP | PYMTTERM | RECEIVED | REPORTDATE | REPORTNGFN | REPORTNGST | REQUIRED | RESORCDWNF | RESORCDWNS | RSPDDATE | RSPDOCGEN | SCHEND | SCHSTART | SETUPFINSH | SETUPSTART | SHIP | SHIPSCHED | STATUSDATE | TEARDOWNF | TEARDOWNS | TO | OTHER)" is not valid. The function '{0}' was not found.
expression = '@(ACCOUNTING | ACTEND | ACTSTART | APPREQ | APPROVAL | AVAILABLE | BKTEND | BKTSTART | CANCEL | CHANGEDATE | COMPDATE | CONSUME | CREATION | CUMULATIVE | DELIVACT | DELIVSCHED | DISCNT | DOCUMENT | DUE | EARLSTEFF | EARLSTSHIP | EFFECTIVE | ENGCHG | EXECFINISH | EXECSTART | EXPIRATION | FAILDATE | FORECASTF | FORECASTS | FROM | GENERATION | IMPL | INVOICE | JOBDUE | LABORFINSH | LABORSTART | LASTUSED | LOADING | MATCHING | MSMENTDATE | NEEDDELV | OPFINISH | OPSTART | PAYEND | PLANEND | PLANSTART | PO | PROMDELV | PROMSHIP | PYMTTERM | RECEIVED | REPORTDATE | REPORTNGFN | REPORTNGST | REQUIRED | RESORCDWNF | RESORCDWNS | RSPDDATE | RSPDOCGEN | SCHEND | SCHSTART | SETUPFINSH | SETUPSTART | SHIP | SHIPSCHED | STATUSDATE | TEARDOWNF | TEARDOWNS | TO | OTHER)' Remaining tokens are: ('@' '(' 'ACCOUNTING' '|' 'ACTEND' '|' 'ACTSTART' '|' 'APPREQ' '|' 'APPROVAL' '|' 'AVAILABLE' '|' 'BKTEND' '|' 'BKTSTART' '|' 'CANCEL' '|' 'CHANGEDATE' '|' 'COMPDATE' '|' 'CONSUME' '|' 'CREATION' '|' 'CUMULATIVE' '|' 'DELIVACT' '|' 'DELIVSCHED' '|' 'DISCNT' '|' 'DOCUMENT' '|' 'DUE' '|' 'EARLSTEFF' '|' 'EARLSTSHIP' '|' 'EFFECTIVE' '|' 'ENGCHG' '|' 'EXECFINISH' '|' 'EXECSTART' '|' 'EXPIRATION' '|' 'FAILDATE' '|' 'FORECASTF' '|' 'FORECASTS' '|' 'FROM' '|' 'GENERATION' '|' 'IMPL' '|' 'INVOICE' '|' 'JOBDUE' '|' 'LABORFINSH' '|' 'LABORSTART' '|' 'LASTUSED' '|' 'LOADING' '|' 'MATCHING' '|' 'MSMENTDATE' '|' 'NEEDDELV' '|' 'OPFINISH' '|' 'OPSTART' '|' 'PAYEND' '|' 'PLANEND' '|' 'PLANSTART' '|' 'PO' '|' 'PROMDELV' '|' 'PROMSHIP' '|' 'PYMTTERM' '|' 'RECEIVED' '|' 'REPORTDATE' '|' 'REPORTNGFN' '|' 'REPORTNGST' '|' 'REQUIRED' '|' 'RESORCDWNF' '|' 'RESORCDWNS' '|' 'RSPDDATE' '|' 'RSPDOCGEN' '|' 'SCHEND' '|' 'SCHSTART' '|' 'SETUPFINSH' '|' 'SETUPSTART' '|' 'SHIP' '|' 'SHIPSCHED' '|' 'STATUSDATE' '|' 'TEARDOWNF' '|' 'TEARDOWNS' '|' 'TO' '|' 'OTHER' ')')
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.interchange.treemapper.client.Konga_treemapper_infoproviderSoapBindingStub.loadSourceDataTreeWithWarning(Konga_treemapper_infoproviderSoapBindingStub.java:353)
at org.jitterbit.integration.server.implementation.webservice.interchange.treemapper.impl.TreeMapperInfoProviderWsImpl.loadSourceDataTree(TreeMapperInfoProviderWsImpl.java:172)
... 10 more



Any ideas what JB is not liking here and why?

Many thanks,

David Q
davidq Bookmark and Share
Community All-Star
Community All-Star
 
Posts: 250
Joined: Tue Apr 10, 2007 9:34 am
Location: UK

Re: Could not open external entity

Postby davidq on Thu Mar 11, 2010 9:33 am

Just tried it on 3.0.0.125/3.0.0.126 and got similar errors:-

Failed to load source data for the transformation "OSN_NEP_T1". Error on the server: Failed to load the source data. Reason:
Failed to read and validate XML source using DTD "003_process_po_007.dtd".
Fatal SAX error occurred while parsing the document "C:/WINDOWS/Temp/jitterbit/e68087e5-508f-4188-901e-fc70fd47cf33". Reason:
An exception occurred! Type:RuntimeException, Message:Could not open external entity 'C:/WINDOWS/Temp/jitterbit/oagis_resources.dtd'


Error on the server: Failed to load the source data. Reason:
Failed to read and validate XML source using DTD "003_process_po_007.dtd".
Fatal SAX error occurred while parsing the document "C:/WINDOWS/Temp/jitterbit/e68087e5-508f-4188-901e-fc70fd47cf33". Reason:
An exception occurred! Type:RuntimeException, Message:Could not open external entity 'C:/WINDOWS/Temp/jitterbit/oagis_resources.dtd'


Client version: 3.0.0.125-enterprise
Server version: 3.0.0.126
Client platform: Windows XP - Java 1.6.0_18
Server platform: Microsoft Windows XP Professional, 32-bit 5.1 SP 3.0 (Service Pack 3) Build 2600
CPU: GenuineIntel x86 Intel(R) Pentium(R) D CPU 3.00GHz - x86 Family 15 Model 4 Stepping 7, 2 cores total.
RAM: 1.593 GB in use, 2.403 GB available, 3.498 GB total.
Swap: 0.1935 GB in use, 1.872 GB available, 2 GB total.
Disk (where Jitterbit is installed): 69.76 GB in use, 79.19 GB available, 149 GB total.


org.jitterbit.integration.client.server.IntegrationServerException: Error on the server: Failed to load the source data. Reason:
Failed to read and validate XML source using DTD "003_process_po_007.dtd".
Fatal SAX error occurred while parsing the document "C:/WINDOWS/Temp/jitterbit/e68087e5-508f-4188-901e-fc70fd47cf33". Reason:
An exception occurred! Type:RuntimeException, Message:Could not open external entity 'C:/WINDOWS/Temp/jitterbit/oagis_resources.dtd'

at org.jitterbit.integration.client.server.webservice.WebServiceConfiguration.convertToIntegrationServerException(WebServiceConfiguration.java:274)
at org.jitterbit.integration.client.server.webservice.WebServiceServerCall.convert(WebServiceServerCall.java:51)
at org.jitterbit.integration.server.implementation.webservice.interchange.treemapper.impl.TreeMapperInfoProviderWsImpl.loadSourceDataTree(TreeMapperInfoProviderWsImpl.java:191)
at org.jitterbit.integration.client.ui.interchange.entity.transformation.data.LoadSourceDataJob.runImpl(LoadSourceDataJob.java:65)
at org.jitterbit.application.ui.job.UiJob$2.run(UiJob.java:512)
at org.jitterbit.application.worker.DefaultApplicationWorker$RunnableWrapper.runSafely(DefaultApplicationWorker.java:200)
at org.jitterbit.application.worker.DefaultApplicationWorker$RunnableWrapper.run(DefaultApplicationWorker.java:192)
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: Failed to load the source data. Reason:
Failed to read and validate XML source using DTD "003_process_po_007.dtd".
Fatal SAX error occurred while parsing the document "C:/WINDOWS/Temp/jitterbit/e68087e5-508f-4188-901e-fc70fd47cf33". Reason:
An exception occurred! Type:RuntimeException, Message:Could not open external entity 'C:/WINDOWS/Temp/jitterbit/oagis_resources.dtd'

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.interchange.treemapper.client.Konga_treemapper_infoproviderSoapBindingStub.loadSourceDataTreeWithWarning(Konga_treemapper_infoproviderSoapBindingStub.java:466)
at org.jitterbit.integration.server.implementation.webservice.interchange.treemapper.impl.TreeMapperInfoProviderWsImpl.loadSourceDataTree(TreeMapperInfoProviderWsImpl.java:176)
... 10 more
davidq Bookmark and Share
Community All-Star
Community All-Star
 
Posts: 250
Joined: Tue Apr 10, 2007 9:34 am
Location: UK

Re: Could not open external entity

Postby davidq on Thu Mar 11, 2010 9:43 am

Hi....again,

Okay, copied the other DTD's into the \windows\temp\jitterbit folder and tried again and it worked in 3.0.0.125/3.0.0.126.

So, looks like a problem in the 2.1 version? I guess our customer needs to upgrade.

Regards,

David Q
davidq Bookmark and Share
Community All-Star
Community All-Star
 
Posts: 250
Joined: Tue Apr 10, 2007 9:34 am
Location: UK

Re: Could not open external entity

Postby emanuel on Thu Mar 11, 2010 7:13 pm

Could you tell me where to get that DTD so I can try it out. I don't see why we would look in C:/WINDOWS/Temp/jitterbit for any DTDs so this may be a bug.

/Emanuel
Emanuel Norrbin
Software Engineer, Jitterbit Inc.
Jitterbit Open Source Integration
emanuel Bookmark and Share
Jitterbit Hero
Jitterbit Hero
 
Posts: 1224
Joined: Mon Feb 13, 2006 12:16 pm
Location: Alameda, CA

Re: Could not open external entity

Postby davidq on Fri Mar 12, 2010 4:05 am

Hi Emanuel,

We got it from OAG Archives http://www.oagi.org/dnn2/Downloads/OAGISArchives.aspx fopr which you have to register (simple registration).

However, here's a copy of the zip that we got from OAG so you don't have the bother!

Best regards,

DQ
Attachments
oagis_release_7.2.1_dtd_with_xml.zip
(508.33 KiB) Downloaded 12 times
davidq Bookmark and Share
Community All-Star
Community All-Star
 
Posts: 250
Joined: Tue Apr 10, 2007 9:34 am
Location: UK

Re: Could not open external entity

Postby emanuel on Fri Mar 19, 2010 2:23 pm

Jitterbit doesn't seem to support the following DTD construct

<!ENTITY % RESOURCES SYSTEM "oagis_resources.dtd">
%RESOURCES;

This file is not transferred to the server so it's not there when it's needed. You could try to just edit the main DTD and paste in the actual text of the DTD where it's included. You may have to do this recursively.

/Cheers
Emanuel
Emanuel Norrbin
Software Engineer, Jitterbit Inc.
Jitterbit Open Source Integration
emanuel Bookmark and Share
Jitterbit Hero
Jitterbit Hero
 
Posts: 1224
Joined: Mon Feb 13, 2006 12:16 pm
Location: Alameda, CA


Return to Using Jitterbit

SourceForge.net Logo  open source integration