datastage import error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
datastage import error
Hi All,
when i try to re-import a job into designer it is giving me a message;
" No objects found for import!".
the job does not exist in the designer repository
However I can see the job already existing in the director. when i try to delete the job from the director it is giving me a message
"the following objects do not exist, and can not be used as a source "
DId anyone encountered such weird data stage behaviour. please suggest me.
Thanks
Mark
when i try to re-import a job into designer it is giving me a message;
" No objects found for import!".
the job does not exist in the designer repository
However I can see the job already existing in the director. when i try to delete the job from the director it is giving me a message
"the following objects do not exist, and can not be used as a source "
DId anyone encountered such weird data stage behaviour. please suggest me.
Thanks
Mark
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
datastage import error
[quote="keshav0307"]try this query
SELECT * FROM DS_JOBS WHERE NAME='<exact job name>'
what does it return?[/quote]
I am trying to re-import the error from datastage designer (v.8.0.1) then gives me a mesg "No objects found for import!"
but I can see the job already exisitng in the repository from the directory. i tried to delete the job from the director but i could not since it is giving me a message "the objects do not exist, and can not be used as a source".
Thanks
Mark
SELECT * FROM DS_JOBS WHERE NAME='<exact job name>'
what does it return?[/quote]
I am trying to re-import the error from datastage designer (v.8.0.1) then gives me a mesg "No objects found for import!"
but I can see the job already exisitng in the repository from the directory. i tried to delete the job from the director but i could not since it is giving me a message "the objects do not exist, and can not be used as a source".
Thanks
Mark
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This suggests that the export file from which you are trying to import has job executables only, not design-time information.
Create a new export, WITH design-time information, and import from that. This will override the run-only executable that you currently have imported.
Create a new export, WITH design-time information, and import from that. This will override the run-only executable that you currently have imported.
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.
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
datastage import error
[quote="keshav0307"]try this query
SELECT * FROM DS_JOBS WHERE NAME='<exact job name>'
what does it return?[/quote]
where do I type this SQL stmt. from oracle.
can you please explain.
Thanks
Mark
SELECT * FROM DS_JOBS WHERE NAME='<exact job name>'
what does it return?[/quote]
where do I type this SQL stmt. from oracle.
can you please explain.
Thanks
Mark
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
datastage import error
[quote="ray.wurlod"]This suggests that the export file from which you are trying to import has job executables only, not design-time information.
Create a new export, WITH design-time information, and import from that ...[/quote]
Actually I am re-importing the job with actual design job. I re-tried what you have suggested me and i got the same error message.
thanks
Mark
Create a new export, WITH design-time information, and import from that ...[/quote]
Actually I am re-importing the job with actual design job. I re-tried what you have suggested me and i got the same error message.
thanks
Mark
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
datastage import error
[quote="keshav0307"][quote]where do I type this SQL stmt. from oracle. [/quote]
in datastage administrator command[/quote]
i was able to execute the stmt SELECT * FROM DS_JOBS WHERE NAME='<exact job name>'
and it is showing me the job exist.
however i am not able to find the job in the repository from the designer.
thanks
mark
in datastage administrator command[/quote]
i was able to execute the stmt SELECT * FROM DS_JOBS WHERE NAME='<exact job name>'
and it is showing me the job exist.
however i am not able to find the job in the repository from the designer.
thanks
mark
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
datastage import error
[quote="keshav0307"]DELETE FROM DS_JOBS WHERE NAME='<exact job name>
and then import the job[/quote]
I executed the following
i was able to execute the stmt SELECT * FROM DS_JOBS WHERE NAME='<exact job name>'
it is giivng me a message no records exist.
I imported the job again from the designer (v.8.0.1). import was successful but I could not find the job in the designer. I dunno why v8.0.1 is acting funky.
any suggestions please
Thanks
mark
and then import the job[/quote]
I executed the following
i was able to execute the stmt SELECT * FROM DS_JOBS WHERE NAME='<exact job name>'
it is giivng me a message no records exist.
I imported the job again from the designer (v.8.0.1). import was successful but I could not find the job in the designer. I dunno why v8.0.1 is acting funky.
any suggestions please
Thanks
mark
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 291
- Joined: Wed Sep 26, 2007 11:23 am
- Location: Madrid, Spain
I am having the same problem!!!
I did the following query:
and it returned me results, but the job cannot be spotted in Designer, but perfectly visible in Director (and I can even watch detailed log for this job)
I dont dare to do DELETE FROM DS_JOBS from command, as I am not sure this is deleting either in Universe and DB2 (or alternative) repository
Reindexing the project did not help neither
Any idea on the solution to this???
I did the following query:
Code: Select all
SELECT * FROM DS_JOBS WHERE NAME='JB_Extract_S_ACT_CONTACT'
I dont dare to do DELETE FROM DS_JOBS from command, as I am not sure this is deleting either in Universe and DB2 (or alternative) repository
Reindexing the project did not help neither
Any idea on the solution to this???