Page 1 of 1
IMPORT&EXPORT ERROR
Posted: Thu May 18, 2006 3:22 pm
by mail2krishna79
Hi Folks
Need Advice on Import and export error
i am tring to export the individual job from DEVL and trying to import to PROD it says
NO OBJECTS FOUND FOR IMPORT
text file along with it says EXPORT ABORTED
Any advice regarding this issue is much appreciated
Thanks
Kris
Posted: Thu May 18, 2006 4:16 pm
by ray.wurlod
Welcome aboard. :D
When importing are you referring to a valid DataStage export file? If you exported in XML format, for example, you will need to choose the XML import option.
Posted: Thu May 18, 2006 8:35 pm
by mail2krishna79
Thanks Ray for your quick response,
actually last nite when i ran FTPing job it ran successfuly but in the director it left all the log as warning message with 45k logs(data got 45k rows)
during that time i am adding the sequence jobs to the master sequencer the following error came
Record J\5192\V0S1P9 in file DS_JOBOBJECTS does not exist
the time it came after that i had done couple of sequence jobs they dissapeared and i took the count as it was said in the forum
the count for the DS_JOBOBJECTS is 122008 records counted(i made this count in administrator command window)
NEXT DAY i tried to do this export and import it shows this error
Sorry for the long message just to give clear description of the error
I would appreciate any help regarding this issue
Thanks
Kris
Posted: Thu May 18, 2006 9:21 pm
by ray.wurlod
There may be some corruption in DS_JOBOBJECTS or DS_JOBS, or they may need to be re-indexed.
Because you can count DS_JOBOBJECTS I will assume for now that that hashed file is not corrupted. Can you count DS_JOBS?
At a time when no-one is using DataStage, login with administrator privileges and execute the command DS.REINDEX ALL. This may correct your problem.
In Designer can you check whether you can open the job whose number is 5192? To determine which job this is, execute this query:
Code: Select all
SELECT NAME FROM DS_JOBS WHERE JOBNO = '5192';
Posted: Fri May 19, 2006 9:54 am
by mail2krishna79
Thanks Ray
i executed the query it shows
0 RECORDS LISTED
i more thing i need to mention to to earlier to that i got RT_LOGXXX error
so i deleted theat number log from the unix server still the problem is not resolved
so i had exportyed jobs deleted the jobs and again tried to import it gave error but imported the jobs
then i executed reindexedall from the administror command
i deletde the 2 sequential jobs after i get the error message of Record J\5192\V0S1P9 in file DS_JOBOBJECTS does not exist
iam in big confusion state rite now
I really need a great help from you guys
Thanks
Kris
Posted: Sat May 20, 2006 2:08 am
by ray.wurlod
Looks like you may have some orphaned components - you should never delete from UNIX, since it does not remove the VOC entries. Execute the command
to search for and remove orphaned components, and let us know if that has fixed the problem. If you can get exclusive access to the project, you might also like to try
Posted: Sat May 20, 2006 5:35 am
by kumar_s
Also make sure you DS_JOBOBJECTS are in the safer side by executing
Posted: Tue May 23, 2006 8:14 am
by pmadhavi
I hope the DS_JOBOBJECTS file got corrupted.
One of the reasons can be there was no space left when the job ran into warnings and the file got corrupted.
The only thing you need to do is contact the IBM Ascential support desk.
they will help u out in resolving the issue.
We had the exact problem couple of weeks back and we took the help of Ascential.
Posted: Wed May 24, 2006 9:45 am
by mail2krishna79
Thanks a Million to all you guys who showed me right path and guidance
the issue got resolved
i cleared all the orphaned components and with the administrator privileges i ran DS.REINDEXALL and it took care about all the issue
I really appreciate all you folks from bottom of my heart
Thanks
Kris
NB:Appologies for the late reply
Posted: Mon Sep 10, 2007 3:29 am
by hexa
i too got the same problem but i don not know wat is that orphaned components .can u please let me know about it