datastage import error

[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

[keshav0307]

try this query
SELECT * FROM DS_JOBS WHERE NAME='<exact job name>'

what does it return?

[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

[keshav0307]

Mark
i understand your problem, me too have faced same problem.
did you try what i said.

[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.

[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

[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

[keshav0307]

where do I type this SQL stmt. from oracle.

in datastage administrator command

[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

[keshav0307]

DELETE FROM DS_JOBS WHERE NAME='<exact job name>

and then import the job

[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

[keshav0307]

in version 8 i think you have search job option. try that

[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???