Cannot Import Metadata into new project
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 46
- Joined: Wed May 16, 2007 1:54 am
- Location: Paris
- Contact:
Cannot Import Metadata into new project
Hi,
I just installed IIS 8.1.0. The problem I have is that I cannot import medatada in a -new project-.
I mean that I can import metadata (File structure, Jobs from .dsx file ...) in the project I created during the installation, but I cannot do the same with a new project.
Thanks for any info or clue.
Regards,
Fredj
I just installed IIS 8.1.0. The problem I have is that I cannot import medatada in a -new project-.
I mean that I can import metadata (File structure, Jobs from .dsx file ...) in the project I created during the installation, but I cannot do the same with a new project.
Thanks for any info or clue.
Regards,
Fredj
Last edited by NSIT-DVP-01 on Fri Jan 11, 2008 9:25 am, edited 1 time in total.
Hello and welcome to DSXchange, NSIT-DVP-01
a) "pb" is the accepted symbol for the element "lead" but not a word in English.
b) What version are you exporting from?
c) What error(s) do you get when importing into version 8?
d) Can you import single element types (tables, routines, jobs) or does everything fail
e) have you tried XML export and import?
a) "pb" is the accepted symbol for the element "lead" but not a word in English.
b) What version are you exporting from?
c) What error(s) do you get when importing into version 8?
d) Can you import single element types (tables, routines, jobs) or does everything fail
e) have you tried XML export and import?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 46
- Joined: Wed May 16, 2007 1:54 am
- Location: Paris
- Contact:
Thanks for helping.ArndW wrote:Hello and welcome to DSXchange, NSIT-DVP-01
a) "pb" is the accepted symbol for the element "lead" but not a word in English.
b) What version are you exporting from?
c) What error(s) do you get when importing into version 8?
d) Can you import single element types (tables, routines, jobs) or does everything fail
e) have you tried XML export and import?
a) "pb" is suposed to be a shortcut for "problem". Sorry about that.
b) exporting from version 6
c) Here's the errors I got :
Line 122860: The folder \Table Definitions\ODBC\ATRIUM does not exist..
Object=ODBC\ATRIUM\ADRESS.
Class=CMetaTable.
d) It fails even for a single element
e) I didin't tried XML as far as I DOES WORK when I do the import in the "first project". The "first project" is the project that we have created when doing the installation.
-
- Premium Member
- Posts: 46
- Joined: Wed May 16, 2007 1:54 am
- Location: Paris
- Contact:
Thanks for your help Ray.ray.wurlod wrote:Check that you have write permission to all objects in the DataStage project directory, and are credentialled to update the common IIS Repository. ...
It sems that the permissions are the sames on both project directories. The thing is that I used the sames User Account to create the project and to try to import a .DSX
Fredj
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 46
- Joined: Wed May 16, 2007 1:54 am
- Location: Paris
- Contact:
-
- Premium Member
- Posts: 46
- Joined: Wed May 16, 2007 1:54 am
- Location: Paris
- Contact:
-
- Premium Member
- Posts: 46
- Joined: Wed May 16, 2007 1:54 am
- Location: Paris
- Contact:
Re: Cannot Import Metadata into new project
The workaround is to restart the service :
Then, the problem doesn't occur.
after the creation of a new job.IBM WebSphere Application Server V6 - repmprdNode01
Then, the problem doesn't occur.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you have a user called xmeta (probably as owner of the database instance) as well as a database instance called XMETA? I can't see why that user would have the Job folder locked, unless it were in the middle of doing some other task, but such a lock should only be held transiently. Have you involved your support provider?
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.
Re: Cannot Import Metadata into new project
Hi NSIT-DVP-01,NSIT-DVP-01 wrote:The workaround is to restart the service :after the creation of a new job.IBM WebSphere Application Server V6 - repmprdNode01
Then, the problem doesn't occur.
IBM supplies a script to cleanup the locks:
viewtopic.php?t=122009
many greetings from the beautiful City of Hamburg
Roland
Roland