I am using the ReadFileRecord from file connector to read the csv file which
has tilde as a separator but I am getting error as Error reading configurations
from location /Cordys/ftpconnector/config/reader-config.xml
File which I'm reading is:
--------------------------
13438~1278~399~9266~01-JAN-96~~PLL~UNIT_PRICE~LINE~03-MAR-15
51922716~326669~219060~1116660~01-JAN-14~~PLL~UNIT_PRICE~LINE~03-MAR-15
51922746~326669~10000~1645388~01-JAN-14~~PLL~UNIT_PRICE~LINE~26-FEB-15
File configuration which I have placed in the xml store:
--------------------------------------------------------
<configuration xmlns="http://schemas.cordys.com/1.0/xmlstore">
<filetype name="csv-sample" recordsequence="line">
<record name="line" pattern="([^\n\r]*)[\n\r]+" index="0">
<field name="lineId" pattern="([^\~]*)\~" index="0" />
<field name="priceListId" pattern="([^\~]*)\~" index="0" />
<field name="material" pattern="([^\~]*)\~" index="0" />
<field name="currencyCode" pattern="([^\~]*)\~" index="0" />
<field name="validFrom" pattern="([^\~]*)\~" index="0" />
<field name="validTo" pattern="([^\~]*)\~" index="0" />
<field name="lastModificationDate" pattern="([^\~]*)\~" index="0" />
<field name="levelCode" pattern="([^\~]*)\~" index="0" />
<field name="updateDate" pattern="([^\~]*)\~" index="0" />
</record>
</filetype>
</configuration>
soap request which I am sending is:
-----------------------------------
<SOAP:Envelope xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP:Body>
<ReadFileRecords xmlns="http://schemas.cordys.com/1.0/ac/FileConnector">
<filename>D:\Cordys\OpenText Cordys\defaultInst\FTPDownloads\APCX_ATG_PRICING_DATA.txt</filename>
<filetype>csv-sample</filetype>
<numrecords>-1</numrecords>
<offset>0</offset>
<validateonly>false</validateonly>
<usetupleold>false</usetupleold>
<continueonerror>false</continueonerror>
</ReadFileRecords>
</SOAP:Body>
</SOAP:Envelope>
soap response which I am getting is:
------------------------------------
<data>
<SOAP:Fault xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode xmlns:ns0="http://schemas.xmlsoap.org/soap/envelope/">ns0:Server</faultcode>
<faultstring xml:lang="en-US">FileConnector transaction failed.</faultstring>
<faultactor>http://schemas.cordys.com/1.0/ac/FileConnector</faultactor>
<detail>
<cordys:FaultDetails xmlns:cordys="http://schemas.cordys.com/General/1.0/">
<cordys:LocalizableMessage xmlns:cordys="http://schemas.cordys.com/General/1.0/">
<cordys:MessageCode xmlns:cordys="http://schemas.cordys.com/General/1.0/">com.cordys.coe.ac.fileconnector.LogMessages.TransactionFailed</cordys:MessageCode>
<cordys:Insertion xmlns:cordys="http://schemas.cordys.com/General/1.0/">com.cordys.coe.ac.fileconnector.exception.FileException: Error reading configurations from location /Cordys/ftpconnector/config/reader-config.xml
</cordys:Insertion>
</cordys:LocalizableMessage>
</cordys:FaultDetails>
</detail>
</SOAP:Fault>
</data>
Please find the attached images which has file connector config details and
container details.
Original issue reported on code.google.com by singhpad...@gmail.com on 20 Mar 2015 at 12:49
Original issue reported on code.google.com by
singhpad...@gmail.com
on 20 Mar 2015 at 12:49Attachments: