Merge Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 13
- Joined: Thu Jun 16, 2005 6:44 am
Merge Stage
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
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
-
- Participant
- Posts: 13
- Joined: Thu Jun 16, 2005 6:44 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 13
- Joined: Thu Jun 16, 2005 6:44 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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.
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.
-
- Participant
- Posts: 13
- Joined: Thu Jun 16, 2005 6:44 am
-
- Participant
- Posts: 13
- Joined: Thu Jun 16, 2005 6:44 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
.. 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