SmartsIntegrator Support and Discussion Forums

Flat file mapping error

Share/Bookmark: Add this Thread to Digg Digg   Add this Thread to StumbleUpon Stumble Upon   Add this Thread to Del.icio.us Del.icio.us   Add this Thread to Reddit Reddit   Add this Thread to Facebook Facebook
RE: Flat file mapping error
by benj on Mon, Jul 21 2008 10:58 AM
Hi P

I guess you were getting the ‘You must select a schema for flat-file output error’? Now resolved, see attachment and build 1.3.09 to be uploaded shortly.

Note that you have the length field set to 99999999 in your schema which results in huge output files and could lead to out of memory errors depending on your server spec and load – this is almost certainly wrong.

Thanks,

Ben.
Ben Jackson
SmartsIntegrator Technical Support
Quote This Reply
benj
benj
Joined: Thu, Feb 7 2008
Posts: 96
RE: Flat file mapping error
by portedquery on Mon, Jul 21 2008 10:57 AM
Ben,

I think your mapping engine is not working correctly. I have attached the flat file schema, very simple(one element) and mapping into another flat file with one element (no processing/functioids). Please try creating a simple File receive and send port to move file from one folder to another and you will see the exception.

I have attached the sample flat file along with the (in and out) schemas. Let me know if you are able to make it work.

Regards,
P
Quote This Reply
portedquery
Joined: Wed, Jul 2 2008
Posts: 72
RE: Flat file mapping error
by benj on Tue, Jul 15 2008 12:32 PM
Thanks - version 1.3.08 will resolve this, to be published shortly.

Ben.
Ben Jackson
SmartsIntegrator Technical Support
Quote This Reply
benj
benj
Joined: Thu, Feb 7 2008
Posts: 96
Flat file mapping error
by portedquery on Tue, Jul 15 2008 12:31 PM
I am encountering another error while trying to map Flat files:

Suspending Message for Receive Port SimpleFileF...

MessagingException, Error executing map 6df479da-984b-490e-8b50-b552eaf064f0 for Receive Port 'SimpleFileFolderGet' : --> Data at the root level is invalid. Line 1, position 1. <- System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlTextReader.Read()
at SmartsIntegrator.Schemas.SchemaDisassembler.GetMessageSchemaType(DALBase dal, Stream msgContents)
at SmartsIntegrator.Messaging.ReceivePort.ReceiveMessage(Stream msgContents, Hashtable msgParameters, Boolean sub)

I have attached the In file, the export of
1) in and out schemas and
2) the map file.

Please let me know if you need more information.

Regards,
P
Quote This Reply
portedquery
Joined: Wed, Jul 2 2008
Posts: 72
Page 1 of 1