Page 1 of 1
Merge Stage
Posted: Tue Jul 26, 2005 9:10 am
by marcogonnelli
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
Posted: Tue Jul 26, 2005 9:17 am
by elavenil
One possiblity to cause this issue is that the key columns having NULL value so check the key column values.
HTWH.
Regards
Saravanan
Posted: Wed Jul 27, 2005 1:17 am
by marcogonnelli
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........
Posted: Wed Jul 27, 2005 1:35 am
by ray.wurlod
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.
Posted: Wed Jul 27, 2005 3:39 am
by marcogonnelli
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....
Posted: Wed Jul 27, 2005 3:48 am
by Sainath.Srinivasan
Try it with a small test file which you can trace easily.
Posted: Fri Aug 26, 2005 9:46 am
by LRenwick
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.
Posted: Wed Sep 07, 2005 8:21 am
by marcogonnelli
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
Posted: Wed Sep 07, 2005 8:31 am
by kaps
You can use the database left outer join function if you are source is table.
Posted: Wed Sep 07, 2005 8:53 am
by marcogonnelli
...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
