Merge Stage

marcogonnelli · Post by **marcogonnelli** » Tue Jul 26, 2005 9:10 am

Hi there all !! I have a problem running a Merge Stage in LeftOuterJoin between two files errror codes are printed in log are the following:

Info : MergeFlussi..merge_flussi: Seek failed
Info : MergeFlussi..merge_flussi: Function 'put_row_to_page' failed
Fatal : MergeFlussi..merge_flussi: Function 'construct_hash_table' failed

...any suggestion will be appreciated.

ThnX in advance MarK

elavenil · Post by **elavenil** » Tue Jul 26, 2005 9:17 am

One possiblity to cause this issue is that the key columns having NULL value so check the key column values.

HTWH.

Regards
Saravanan

marcogonnelli · Post by **marcogonnelli** » Wed Jul 27, 2005 1:17 am

Checked KEY column values, they contains no NULL VALUES, also in the metadata definition for both files KEYCOLUMNS are set to Nullable -> NO

.....still having the same problem........

ray.wurlod · Post by **ray.wurlod** » Wed Jul 27, 2005 1:35 am

Check with your support provider.

Does this happen with every Merge stage you use? If so, it could be that you lack write permission in the temporary directory (which you specify in the stage properties).

Or it could be a problem within one of those temporary files.

marcogonnelli · Post by **marcogonnelli** » Wed Jul 27, 2005 3:39 am

I have checked my quota on Datastage server I have 200mb (approx.) of free space, where temporary files are created.

...still have the same problem....

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Jul 27, 2005 3:48 am

Try it with a small test file which you can trace easily.

LRenwick · Post by **LRenwick** » Fri Aug 26, 2005 9:46 am

I am also getting this error.

I have checked the permissions on the directories and files. I can view the data in the 2 files from the job that creates them and it looks like it should. The key columns for the merge are not null.

Any help or advice would be much appreciated, I've run out of ideas!

Thanks and Regards,
Louise.

marcogonnelli · Post by **marcogonnelli** » Wed Sep 07, 2005 8:21 am

still having problem with merge stage ... I'm getting very Angry

Is there another way to make a left outer join between two files without using merge stage... any help will be appreciated ... thnxxx in adv Marco

kaps · Post by **kaps** » Wed Sep 07, 2005 8:31 am

You can use the database left outer join function if you are source is table.

marcogonnelli · Post by **marcogonnelli** » Wed Sep 07, 2005 8:53 am

...ok I'll import the two text files in two temp tables..

.. u mean using ODBC stage and user defined SQL
(my server is Informix 9.4)
I'll divide in two job.
First job : will import the two flat files in two tables using the ODBC stage
Second job : using three ODBC stages two for read from the temp tables linked to the third which is the target tables with user defined SQl option on and Outer join sintax
...... ?? Is that correct ? LOL