Problems importing jobs

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
JeroenDmt
Premium Member
Premium Member
Posts: 107
Joined: Wed Oct 26, 2005 7:36 am

Problems importing jobs

Post by JeroenDmt »

When I try to import a job in a new project, I get an error message:

Code: Select all

Line 413: The folder \Jobs\MyJobs does not exist..
Object=ROOT.
Class=CJobDefn.
The job cannot be imported because the MyJobs folder (the folder where the original job comes from) does not exist.

The job is exported from another project on the same server.


After I try to import a job and get this error message, when I manually try to create a new folder under the Jobs folder, I get another error message

Code: Select all

Unable to create new folder.
The Folder 'Jobs' is locked by user 'xmeta'
(SessionID 'xmeta-1')
The server is newly setup, so I assume it's a problem in the installation or setup or something like that.

Does anyone know how to fix this? (other than creating all necessary folders by hand of course )

(when I do manually create the folder before the import, the import will go successfully. So the problem is in the import creating new folders).
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Are you able to re-start the XMETA database (the common Repository)? Non-existent categories should be created as part of importing.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
bobyon
Premium Member
Premium Member
Posts: 200
Joined: Tue Mar 02, 2004 10:25 am
Location: Salisbury, NC

Import Error: Folder does not exist

Post by bobyon »

ray.wurlod wrote:Are you able to re-start the XMETA database (the common Repository)? Non-existent categories should be created as part of importing. ...
Ray, In searching for a solution to my import troubles I found your post. I amreceiving the following error when attempting to import MDMQS.dsx as part of the installation process:

Code: Select all

Line 82935: The folder \MDMQS\Table Definitions does not exist..
Object=Data Set\MDMQS\QS_Match_Columns.
Class=CMetaTable.
I'm trying to contact our DBA to get the DB restarted as you suggest. I expect this has something to do with the repository but if not, I do not know how to diagnose and resolve from here. Please help.
bobyon
Premium Member
Premium Member
Posts: 200
Joined: Tue Mar 02, 2004 10:25 am
Location: Salisbury, NC

Re: Import Error: Folder does not exist

Post by bobyon »

I found the solution elsewhere on DSXchange:
viewtopic.php?t=122009

Thought it might help others to place the link here
Bob
bobyon
Premium Member
Premium Member
Posts: 200
Joined: Tue Mar 02, 2004 10:25 am
Location: Salisbury, NC

Re: Import Error: Folder does not exist

Post by bobyon »

I found the solution elsewhere on DSXchange:
viewtopic.php?t=122009

Thought it might help others to place the link here
Bob
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Good, thanks for that. You did it before I could get back to you.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply