Unable to view data from a Sequential File Stage

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
deepa_shenoy
Participant
Posts: 95
Joined: Thu Sep 24, 2009 12:15 am
Location: India

Unable to view data from a Sequential File Stage

Post by deepa_shenoy »

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
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: Unable to view data from a Sequential File Stage

Post by chulett »

deepa_shenoy wrote:I have given NULL Field value as '\xAB' for NULL handling.
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?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
deepa_shenoy
Participant
Posts: 95
Joined: Thu Sep 24, 2009 12:15 am
Location: India

Post by deepa_shenoy »

Hi,

Do you know what this error means?

Sequential_File_9,0: Field "Customer" with 'delim=end' did not consume entire input, at offset: 187

Thanks in advance.

Regards,
Deepa
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

It means you have a CHAR field defined, but there aren't enough characters in the file to fill it.
Top
deepa_shenoy
Participant
Posts: 95
Joined: Thu Sep 24, 2009 12:15 am
Location: India

Post by deepa_shenoy »

But both source and target clumns are Varchar with length 1.
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

Field "Customer" is not a varchar, that data type does not give that error message.
Top
deepa_shenoy
Participant
Posts: 95
Joined: Thu Sep 24, 2009 12:15 am
Location: India

Post by deepa_shenoy »

It is the last column of the source file. 90% of the records have moved to the target file from the source file. 10% are getting rejected.
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

Is "Customer" in the source Sequential_File_9 file declared as VarChar(1)?
Top
deepa_shenoy
Participant
Posts: 95
Joined: Thu Sep 24, 2009 12:15 am
Location: India

Post by deepa_shenoy »

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.
Top
deepa_shenoy
Participant
Posts: 95
Joined: Thu Sep 24, 2009 12:15 am
Location: India

Post by deepa_shenoy »

Finally I was able to VIEW DATA!!!

I changed the Null Field Value to '\xAB' and Quote to 'double' for each column in the Columns tab by double clicking on its serial number.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

And how is that a 'workaround'? Sure sounds resolved to me. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
deepa_shenoy
Participant
Posts: 95
Joined: Thu Sep 24, 2009 12:15 am
Location: India

Post by deepa_shenoy »

Well, I was not very sure about my approach.If it is equivalent to being resolved then great! :o
Top
Post Reply

Return to “General”