Page 1 of 1
datastage import error
Posted: Mon Jun 30, 2008 7:38 pm
by pavan_test
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
Posted: Mon Jun 30, 2008 7:57 pm
by keshav0307
try this query
SELECT * FROM DS_JOBS WHERE NAME='<exact job name>'
what does it return?
datastage import error
Posted: Mon Jun 30, 2008 8:16 pm
by pavan_test
[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
Posted: Mon Jun 30, 2008 8:21 pm
by keshav0307
Mark
i understand your problem, me too have faced same problem.
did you try what i said.
Posted: Mon Jun 30, 2008 8:26 pm
by 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. This will override the run-only executable that you currently have imported.
datastage import error
Posted: Mon Jun 30, 2008 8:37 pm
by pavan_test
[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
datastage import error
Posted: Mon Jun 30, 2008 8:40 pm
by pavan_test
[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
Posted: Mon Jun 30, 2008 8:51 pm
by keshav0307
where do I type this SQL stmt. from oracle.
in datastage administrator command
datastage import error
Posted: Mon Jun 30, 2008 9:32 pm
by pavan_test
[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
Posted: Mon Jun 30, 2008 9:35 pm
by keshav0307
DELETE FROM DS_JOBS WHERE NAME='<exact job name>
and then import the job
datastage import error
Posted: Tue Jul 01, 2008 8:51 am
by pavan_test
[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
Posted: Tue Jul 01, 2008 9:31 am
by keshav0307
in version 8 i think you have search job option. try that
Posted: Fri Oct 03, 2008 5:50 am
by manuel.gomez
I am having the same problem!!!
I did the following query:
Code: Select all
SELECT * FROM DS_JOBS WHERE NAME='JB_Extract_S_ACT_CONTACT'
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???