.CSV - cannot view the data

PRIYARAJ · Post by **PRIYARAJ** » Fri Dec 04, 2009 8:56 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Dec 04, 2009 9:00 am

Is there any data in the underlying file ?

Does the metadata match ?

chulett · Post by **chulett** » Fri Dec 04, 2009 9:08 am

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.

PRIYARAJ · Post by **PRIYARAJ** » Fri Dec 04, 2009 9:16 am

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 !!

RAI ROUSES · Post by **RAI ROUSES** » Fri Dec 04, 2009 9:44 am

Try to use the decimal format.

Rai

chulett · Post by **chulett** » Fri Dec 04, 2009 10:26 am

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.

Sreenivasulu · Post by **Sreenivasulu** » Fri Dec 04, 2009 11:12 am

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

Regards
Sreeni

PRIYARAJ · Post by **PRIYARAJ** » Fri Dec 04, 2009 12:05 pm

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 !!!!!

ray.wurlod · Post by **ray.wurlod** » Fri Dec 04, 2009 1:57 pm

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

**Note: Topic Relocated by Content Editor **

DSXchange

.CSV - cannot view the data

.CSV - cannot view the data

Thanks everyone :)