Unable to view data from a Sequential File Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
Unable to view data from a Sequential File Stage
Hi All,
I am loading data from an SQL Server DB(using an ODBC Stage) to a Sequential File(.txt) through a Copy Stage.
I am unable to view data from the SEQ File.
I have given APT_DISABLE_COMBINATION as True,still it throws the following error:
##I IIS-DSEE-TFCN-00006 06:36:01(001) <main_program> conductor uname: -s=Linux; -r=2.6.9-78.0.1.ELlargesmp; -v=#1 SMP Tue Jul 22 18:11:13 EDT 2008; -n=hermes1.citnet.cit.com; -m=x86_64
##I IIS-DSEE-TOSH-00002 06:36:02(000) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 06:36:02(001) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 06:36:02(002) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 06:36:02(003) <main_program> Parameter specified but not used in flow: _APT_DISABLE_COMBINATION
##W IIS-DSEE-TOSH-00049 06:36:02(004) <main_program> Parameter specified but not used in flow: _envLANDINGFILEPATH
##W IIS-DSEE-TOSH-00049 06:36:02(005) <main_program> Parameter specified but not used in flow: JAXExtractParamSet
##W IIS-DSEE-TOSH-00049 06:36:02(006) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I IIS-DSEE-TFSC-00001 06:36:02(012) <main_program> APT configuration file: /datastage/IBM/InformationServer/Server/Configurations/CFDI_Config_1Node.apt
##W IIS-DSEE-TFIG-00169 06:36:02(000) <SEQL_CUSTOMER_CurrentSnapshot,0> Short input record
##W IIS-DSEE-TOIX-00154 06:36:02(001) <SEQL_CUSTOMER_CurrentSnapshot,0> Import warning at record 0.
##W IIS-DSEE-TOIX-00018 06:36:02(002) <SEQL_CUSTOMER_CurrentSnapshot,0> Import unsuccessful at record 0.
##W IIS-DSEE-TFIG-00169 06:36:02(003) <SEQL_CUSTOMER_CurrentSnapshot,0> Short input record
##W IIS-DSEE-TOIX-00154 06:36:02(004) <SEQL_CUSTOMER_CurrentSnapshot,0> Import warning at record 1.
##W IIS-DSEE-TOIX-00018 06:36:02(005) <SEQL_CUSTOMER_CurrentSnapshot,0> Import unsuccessful at record 1.
##W IIS-DSEE-TFIG-00169 06:36:02(006) <SEQL_CUSTOMER_CurrentSnapshot,0> Short input record
##W IIS-DSEE-TOIX-00154 06:36:02(007) <SEQL_CUSTOMER_CurrentSnapshot,0> Import warning at record 2.
##W IIS-DSEE-TOIX-00018 06:36:02(008) <SEQL_CUSTOMER_CurrentSnapshot,0> Import unsuccessful at record 2.
##W IIS-DSEE-TFIG-00169 06:36:02(009) <SEQL_CUSTOMER_CurrentSnapshot,0> Short input record
##W IIS-DSEE-TOIX-00154 06:36:02(010) <SEQL_CUSTOMER_CurrentSnapshot,0> Import warning at record 3.
##W IIS-DSEE-TOIX-00018 06:36:02(011) <SEQL_CUSTOMER_CurrentSnapshot,0> Import unsuccessful at record 3.
##W IIS-DSEE-TFIG-00169 06:36:02(012) <SEQL_CUSTOMER_CurrentSnapshot,0> Short input record
##W IIS-DSEE-TOIX-00154 06:36:02(013) <SEQL_CUSTOMER_CurrentSnapshot,0> Import warning at record 4.
##W IIS-DSEE-TOIX-00018 06:36:02(014) <SEQL_CUSTOMER_CurrentSnapshot,0> Import unsuccessful at record 4.
##I IIS-DSEE-TOIX-00193 06:36:02(015) <SEQL_CUSTOMER_CurrentSnapshot,0> No further reports will be generated from this partition until a successful import.
##I IIS-DSEE-TOIX-00156 06:36:02(016) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 10 percent.
##I IIS-DSEE-TOIX-00156 06:36:02(017) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 20 percent.
##I IIS-DSEE-TOIX-00156 06:36:03(000) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 30 percent.
##I IIS-DSEE-TOIX-00156 06:36:03(001) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 40 percent.
##I IIS-DSEE-TOIX-00156 06:36:03(002) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 50 percent.
##I IIS-DSEE-TOIX-00156 06:36:03(003) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 60 percent.
##I IIS-DSEE-TOIX-00156 06:36:03(004) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 70 percent.
##I IIS-DSEE-TOIX-00156 06:36:03(005) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 80 percent.
##I IIS-DSEE-TOIX-00156 06:36:04(000) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 90 percent.
##I IIS-DSEE-TOIX-00163 06:36:04(001) <SEQL_CUSTOMER_CurrentSnapshot,0> Import complete; 0 records imported successfully, 707647 rejected.
##I IIS-DSEE-USBP-00001 06:36:04(000) <_EowGenerator,0> called postFinalRunLocally
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 06:36:04(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##I IIS-DSEE-TFOR-00163 06:36:04(001) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFPM-00040 06:36:04(002) <_ABORT_IDENT_,0> Operator terminated abnormally: runLocally() did not return APT_StatusOk
>##E IIS-DSEE-TFSC-00011 06:36:10(000) <main_program> Step execution finished with status = FAILED.
I have given NULL Field value as '\xAB' for NULL handling.
The job runs successfully but AM NOT ABLE TO VIEW DATA at all.
The Director gives this message:
Sequential_File_9,0: Export complete; 704692 records exported successfully, 0 rejected.
I have no clue where I am going wrong. Please help.
Thanks in advance.
Deepa
I am loading data from an SQL Server DB(using an ODBC Stage) to a Sequential File(.txt) through a Copy Stage.
I am unable to view data from the SEQ File.
I have given APT_DISABLE_COMBINATION as True,still it throws the following error:
##I IIS-DSEE-TFCN-00006 06:36:01(001) <main_program> conductor uname: -s=Linux; -r=2.6.9-78.0.1.ELlargesmp; -v=#1 SMP Tue Jul 22 18:11:13 EDT 2008; -n=hermes1.citnet.cit.com; -m=x86_64
##I IIS-DSEE-TOSH-00002 06:36:02(000) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 06:36:02(001) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 06:36:02(002) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 06:36:02(003) <main_program> Parameter specified but not used in flow: _APT_DISABLE_COMBINATION
##W IIS-DSEE-TOSH-00049 06:36:02(004) <main_program> Parameter specified but not used in flow: _envLANDINGFILEPATH
##W IIS-DSEE-TOSH-00049 06:36:02(005) <main_program> Parameter specified but not used in flow: JAXExtractParamSet
##W IIS-DSEE-TOSH-00049 06:36:02(006) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I IIS-DSEE-TFSC-00001 06:36:02(012) <main_program> APT configuration file: /datastage/IBM/InformationServer/Server/Configurations/CFDI_Config_1Node.apt
##W IIS-DSEE-TFIG-00169 06:36:02(000) <SEQL_CUSTOMER_CurrentSnapshot,0> Short input record
##W IIS-DSEE-TOIX-00154 06:36:02(001) <SEQL_CUSTOMER_CurrentSnapshot,0> Import warning at record 0.
##W IIS-DSEE-TOIX-00018 06:36:02(002) <SEQL_CUSTOMER_CurrentSnapshot,0> Import unsuccessful at record 0.
##W IIS-DSEE-TFIG-00169 06:36:02(003) <SEQL_CUSTOMER_CurrentSnapshot,0> Short input record
##W IIS-DSEE-TOIX-00154 06:36:02(004) <SEQL_CUSTOMER_CurrentSnapshot,0> Import warning at record 1.
##W IIS-DSEE-TOIX-00018 06:36:02(005) <SEQL_CUSTOMER_CurrentSnapshot,0> Import unsuccessful at record 1.
##W IIS-DSEE-TFIG-00169 06:36:02(006) <SEQL_CUSTOMER_CurrentSnapshot,0> Short input record
##W IIS-DSEE-TOIX-00154 06:36:02(007) <SEQL_CUSTOMER_CurrentSnapshot,0> Import warning at record 2.
##W IIS-DSEE-TOIX-00018 06:36:02(008) <SEQL_CUSTOMER_CurrentSnapshot,0> Import unsuccessful at record 2.
##W IIS-DSEE-TFIG-00169 06:36:02(009) <SEQL_CUSTOMER_CurrentSnapshot,0> Short input record
##W IIS-DSEE-TOIX-00154 06:36:02(010) <SEQL_CUSTOMER_CurrentSnapshot,0> Import warning at record 3.
##W IIS-DSEE-TOIX-00018 06:36:02(011) <SEQL_CUSTOMER_CurrentSnapshot,0> Import unsuccessful at record 3.
##W IIS-DSEE-TFIG-00169 06:36:02(012) <SEQL_CUSTOMER_CurrentSnapshot,0> Short input record
##W IIS-DSEE-TOIX-00154 06:36:02(013) <SEQL_CUSTOMER_CurrentSnapshot,0> Import warning at record 4.
##W IIS-DSEE-TOIX-00018 06:36:02(014) <SEQL_CUSTOMER_CurrentSnapshot,0> Import unsuccessful at record 4.
##I IIS-DSEE-TOIX-00193 06:36:02(015) <SEQL_CUSTOMER_CurrentSnapshot,0> No further reports will be generated from this partition until a successful import.
##I IIS-DSEE-TOIX-00156 06:36:02(016) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 10 percent.
##I IIS-DSEE-TOIX-00156 06:36:02(017) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 20 percent.
##I IIS-DSEE-TOIX-00156 06:36:03(000) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 30 percent.
##I IIS-DSEE-TOIX-00156 06:36:03(001) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 40 percent.
##I IIS-DSEE-TOIX-00156 06:36:03(002) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 50 percent.
##I IIS-DSEE-TOIX-00156 06:36:03(003) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 60 percent.
##I IIS-DSEE-TOIX-00156 06:36:03(004) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 70 percent.
##I IIS-DSEE-TOIX-00156 06:36:03(005) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 80 percent.
##I IIS-DSEE-TOIX-00156 06:36:04(000) <SEQL_CUSTOMER_CurrentSnapshot,0> Progress: 90 percent.
##I IIS-DSEE-TOIX-00163 06:36:04(001) <SEQL_CUSTOMER_CurrentSnapshot,0> Import complete; 0 records imported successfully, 707647 rejected.
##I IIS-DSEE-USBP-00001 06:36:04(000) <_EowGenerator,0> called postFinalRunLocally
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 06:36:04(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##I IIS-DSEE-TFOR-00163 06:36:04(001) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFPM-00040 06:36:04(002) <_ABORT_IDENT_,0> Operator terminated abnormally: runLocally() did not return APT_StatusOk
>##E IIS-DSEE-TFSC-00011 06:36:10(000) <main_program> Step execution finished with status = FAILED.
I have given NULL Field value as '\xAB' for NULL handling.
The job runs successfully but AM NOT ABLE TO VIEW DATA at all.
The Director gives this message:
Sequential_File_9,0: Export complete; 704692 records exported successfully, 0 rejected.
I have no clue where I am going wrong. Please help.
Thanks in advance.
Deepa
Re: Unable to view data from a Sequential File Stage
I'm assuming this is the issue, the use of extended ascii for null fields. I doubt the viewer supports them, does the file look correct from the O/S?deepa_shenoy wrote:I have given NULL Field value as '\xAB' for NULL handling.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
It means you have a CHAR field defined, but there aren't enough characters in the file to fill it.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
Field "Customer" is not a varchar, that data type does not give that error message.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
Is "Customer" in the source Sequential_File_9 file declared as VarChar(1)?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
Yes... "Customer" is declared as Varchar(1) in the Source Seq File.
Last edited by deepa_shenoy on Sun Nov 22, 2009 12:44 am, edited 3 times in total.
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India