DSXchange

HI,

Job is running fine without any errors/warning.The target is flatfile stored in .csv format. When I right click the file to view data it gives me error as

"No rows were returned from the view data server command.
would you like to view the commands output?.

If I click yes then it gives me "##E IIS-DSEE-TFOR-00089 08:51:51(026) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##E IIS-DSEE-TFOR-00089 08:51:51(028) <APT_CombinedOperatorController,0> The runLocally() of the operator failed.
##E IIS-DSEE-TFPM-00040 08:51:51(029) <APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally() did not return APT_StatusOk
##E IIS-DSEE-TFSC-00011 08:51:57(000) <main_program> Step execution finished with status = FAILED."

please help me

Is there any data in the underlying file ?

Does the metadata match ?

I doubt it does. The job may be 'running fine' but is it processing any records? Are all the fields in your flat file defined as Varchar?

That or the file is empty.

chulett wrote:I doubt it does. The job may be 'running fine' but is it processing any records? Are all the fields in your flat file defined as Varchar?

That or the file is empty. ...

Yes..there are records getting populated in the file. I see the warning message in log as "APT_CombinedOperatorController(1),0: Conversion error calling conversion routine decimal_from_string data may have been lost"

I have no idea about this warning !!

Try to use the decimal format.

Rai

You are converting a string to a decimal and your string can potentially hold more data than will fit in your decimal. It is alerting you to that fact.

Because of the warning you are not able to see the contents of the file.

Regards
Sreeni

Yes,I got the answer and I also set the Nullfield value for each coulmn in file thats when i was able to view the data.

Thanks a ton everybody !!!!!

Please mark this topic as Resolved using the green button at top.

**Note: Topic Relocated by Content Editor **