.CSV - cannot view the data
Moderators: chulett, rschirm, roy
.CSV - cannot view the data
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
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
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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"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....
I have no idea about this warning !!
![Sad :(](./images/smilies/icon_sad.gif)
-
- Participant
- Posts: 176
- Joined: Wed Nov 15, 2006 5:48 am
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Thanks everyone :)
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 !!!!!
Thanks a ton everybody !!!!!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: