JDBC to File scenario issue

[Former Member]

we are creating a scenario from JDBC table to text file. payload seems ok to us but at the time of writing file it's creating empty file.

[jagdishwar_b]

>Thando.Peter wrote:

>>we are creating a scenario from JDBC table to text file. payload seems ok to us

where did you check the payload.

In the pipeline steps in sxmb_moni, what is the payload before and after "Request message mapping" step.

[rajasekhar_reddy14]

QuickChecks

1)Check you message mapping,it is genarating output or not.

2)Monitor your receiver communication channel,see audtil log and check pay load in that,it is correct or not.,

3)Check yoiur file content conversion,it working or not.

4)Check your sender communicaltion channel it is able to pick up the data from DB.

Regards,

Raj

[Former Member]

hi Raj,

thnkx for quick reply.

all four steps are working fine we have checked in adapters and payloads are correct.

in auitd log it's saying about the successfully writing to the text filel but file is empty.

i hope there might be some issue in content conversion parameters. I have changed that as well.

pls let me know what would be exact parameters.

Edited by: Thando.Peter on May 7, 2010 1:49 PM

[rajasekhar_reddy14]

I beleive that some problem with the content conversion, post your expected out text file format so that we will help on content conversion parameters.

Regards,

Raj

[Former Member]

Hi there

We are reading directly from SQL table and trying to populate a TXT file, with the following structure:

AccountNumber

CoverStartDate

Status

IDNumber

Title

FirstName

Surname

Gender

DOB

ResidentialAddress1

ResidentialAddress2

ResidentialAddress3

ResidentialAddress4

ResidentialAddress5

PostalCode1

PostalAddress1

PostalAddress2

PostalAddress3

PostalAddress4

PostalAddress5

PostalCode2

Email

HomeTel

WorkTel

Cell

MarketingFlag

Thye Content Conversion parameters are as follows:

Recordset Structure : row

row.fieldSeparator: ,

row.endSeparator: 'nl'

Please let me know if you need any additional info?

Thanks

J

[Former Member]

okay

your text file structure should have a parent node named 'row' for this to work. so something like this

<row>

<field1>Name</field1>

<field2>>Address</field2>

</row>

so go to your Data Type change the root node to 'row'. And everything else should be sub-element of this node and you should be okay.

if you are expecting more than one row's back ensure to define the parent node as 0...N or 1...N what ever suits your needs.

and map the query header to row...

regards