Lookup Stage Erroe
Moderators: chulett, rschirm, roy
Lookup Stage Erroe
Hi,
I am struggling with an error message on a lookup stage I never seen before
My job is simply doing a range ookup on a dataset and I get the following error message:
lkp_STIPTHEID: Error when checking operator: Caught unknown exception during wrapDescribeOperator().
lkp_STIPTHEID: Error when checking operator: setInputInterfaceSchema() was not called by describeOperator() for input: 1.
Error when checking operator: setInputInterfaceSchema() was not called by describeOperator() for input: 2.
The range lookup is done and is using integer fields ...
Any idea or help is more than welcome.
Thanks
Christophe
I am struggling with an error message on a lookup stage I never seen before
My job is simply doing a range ookup on a dataset and I get the following error message:
lkp_STIPTHEID: Error when checking operator: Caught unknown exception during wrapDescribeOperator().
lkp_STIPTHEID: Error when checking operator: setInputInterfaceSchema() was not called by describeOperator() for input: 1.
Error when checking operator: setInputInterfaceSchema() was not called by describeOperator() for input: 2.
The range lookup is done and is using integer fields ...
Any idea or help is more than welcome.
Thanks
Christophe
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
For testing can you please add environment variable $APT_DUMP_SCORE to the job parameters and set its value to True when you re-run the job? This will place the "score" into the job log - an entry captioned "this step has N data sets". Please post the score so we can see what is really happening.
For testing can you please add environment variable $APT_DUMP_SCORE to the job parameters and set its value to True when you re-run the job? This will place the "score" into the job log - an entry captioned "this step has N data sets". Please post the score so we can see what is really happening.
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.
Hi ray,
I tried what you suggest but there is no difference in the log I get.
Maybe some more info:
- We are using version 8.1 with the first critical pack installed
- I have tried to recreate other simple lookup jobs and I get the same problem
- We have two independent environment (2 servers) newly installed and I get the same error so maybe it is an installation issue but I don't see what (I did the installation myself).
Thanks again for your help.
I tried what you suggest but there is no difference in the log I get.
Maybe some more info:
- We are using version 8.1 with the first critical pack installed
- I have tried to recreate other simple lookup jobs and I get the same problem
- We have two independent environment (2 servers) newly installed and I get the same error so maybe it is an installation issue but I don't see what (I did the installation myself).
Thanks again for your help.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I can insure you that I did exactly what you described in your first post.
Is the score supposed to appear as a new entry or as part of an existing one ?
I will post the entire log tomorrow so you can see it but I have the feeling that error is occurring during the initialization phase of the job. That could explain why the score is not in the log ?
Thanks again for your help.
christophe
Is the score supposed to appear as a new entry or as part of an existing one ?
I will post the entire log tomorrow so you can see it but I have the feeling that error is occurring during the initialization phase of the job. That could explain why the score is not in the log ?
Thanks again for your help.
christophe
-
- Participant
- Posts: 111
- Joined: Thu Jun 01, 2006 5:12 am
- Location: Detroit
why don't you try first normal lookup if it works fine then you can range lookup.
I guess normal lookup will tell you exact error where it's going wrong, if it's related to Input schema or some thing else.
basically it might be due to column names are not defined properly, Try with some sample column names and create a new job.
If you can debug in this way and post your error if any.
I guess normal lookup will tell you exact error where it's going wrong, if it's related to Input schema or some thing else.
basically it might be due to column names are not defined properly, Try with some sample column names and create a new job.
If you can debug in this way and post your error if any.
I have done all that already. I have recreated a very simple job and the range lookup is not working better. If I switch to a normal lookup then it works without any problem in the 2 jobs.
Here are the log messages I get ...
- main_program: orchgeneral: loaded
orchsort: loaded
orchstats: loaded
- main_program: Requesting delayed metadata.
Requesting delayed metadata.
- lkp_STIPTHEID: Error when checking operator: Caught unknown exception during wrapDescribeOperator().
- lkp_STIPTHEID: Error when checking operator: setInputInterfaceSchema() was not called by describeOperator() for input: 1.
Error when checking operator: setInputInterfaceSchema() was not called by describeOperator() for input: 2.
- main_program: Could not check all operators because of previous error(s)
- main_program: Creation of a step finished with status = FAILED.
segmentation fault
- Contents of phantom output file
[1] + Done(139) C:/IBM/InformationServer/Server/DSEngine/bin/NT_OshWrapper.exe //./pipe/DWH-RT_SC582-TestLookup RT_SC582/OshExecuter.sh R DUMMY -f RT_SC582/OshScript.osh -monitorport 13400 -pf RT_SC582/jpfile -impexp_charset ASCL_MS1252 -string_charset ASCL_MS1252 -input_charset UTF-8 -output_charset UTF-8 -collation_sequence OFF
6572 Segmentation violation C:/IBM/InformationServer/Server/DSEngine/bin/NT_OshWrapper.exe
Here are the log messages I get ...
- main_program: orchgeneral: loaded
orchsort: loaded
orchstats: loaded
- main_program: Requesting delayed metadata.
Requesting delayed metadata.
- lkp_STIPTHEID: Error when checking operator: Caught unknown exception during wrapDescribeOperator().
- lkp_STIPTHEID: Error when checking operator: setInputInterfaceSchema() was not called by describeOperator() for input: 1.
Error when checking operator: setInputInterfaceSchema() was not called by describeOperator() for input: 2.
- main_program: Could not check all operators because of previous error(s)
- main_program: Creation of a step finished with status = FAILED.
segmentation fault
- Contents of phantom output file
[1] + Done(139) C:/IBM/InformationServer/Server/DSEngine/bin/NT_OshWrapper.exe //./pipe/DWH-RT_SC582-TestLookup RT_SC582/OshExecuter.sh R DUMMY -f RT_SC582/OshScript.osh -monitorport 13400 -pf RT_SC582/jpfile -impexp_charset ASCL_MS1252 -string_charset ASCL_MS1252 -input_charset UTF-8 -output_charset UTF-8 -collation_sequence OFF
6572 Segmentation violation C:/IBM/InformationServer/Server/DSEngine/bin/NT_OshWrapper.exe
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: