Error while using the Schema File in Sequential file as Tgt

shivakumar · Post by **shivakumar** » Wed Jul 01, 2009 1:45 am

Hi,

My PX job contains Oracle Stage --> Transformer ---> Sequential file stage.In the Oracle stage I am using the RCP so that the columns are propagated up to Sequential file.In the sequential file I am using the schema file for meta data.The schema file is as follows.

(record
name:string[255];
BPH:nullable int32;
CPH:nullable int32;
HPH:nullable int32)

the same meta data is present in the Source table also.

When I run the job itis giving the following error.

main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: Error parsing schema: Expected record, got: "(", line 1)

Can anyone help me to resolve this.

Thanks in advance..
Siva[/b]

Sreenivasulu · Post by **Sreenivasulu** » Wed Jul 01, 2009 3:01 am

1.Move record outside braces.
2.semicolon to the last record

Then it will surely work

record
(name:string[255];
BPH:nullable int32;
CPH:nullable int32;
HPH:nullable int32;)

Regards
Sreeni

shivakumar · Post by **shivakumar** » Wed Jul 01, 2009 4:17 am

Hi ,

Thanks for your suggestion.

The job is working fine after the modification in the schema file.But I am unable to see the content of the sequential file.

3 Records are coming from the source and I am unable to see the records in the Output.In the sequential file stage the RCP Property is checked and I am using the schema file.

I have given the File name in the sequential file stage ,When I am trying to open from the datastage the View Data Option is Disabled and When I try to open the file in the Unix path the file is Empty.

Can you please help me regarding this.

Thanks in advance.

Siva

Sreenivasulu · Post by **Sreenivasulu** » Wed Jul 01, 2009 4:48 am

View data is disabled for schema loads. Rest is a coding issue

Regards
Sreeni

shivakumar · Post by **shivakumar** » Wed Jul 01, 2009 6:15 am

Hi ,

I am not using any meta data (Columns) in the entire job.While writing in to the Sequential file it is giving the Warnings as Null handling is not handling.For that I set the property in the Sequential file stage in the format tab Null Field value=0.

But still I am unable to get the data in the sequential file.

Can anyone help me regarding this.

Thanks
Siva

ArndW · Post by **ArndW** » Wed Jul 01, 2009 6:20 am

The null handling warning is your problem. If the sequential stage gets a null that it cannot handle, the record is dropped and not written to the sequential file. This applies for all columns.