Adding new Folders in a new Project impossible
Moderators: chulett, rschirm, roy
Adding new Folders in a new Project impossible
Hello everybody,
I just set up a new project within DataStage Administrator and tried to import content from another project. Import fails with messages telling me that the folders I try to import the content to are missing. I then tried to create a folder manually and got the message:
'Unable to create new folder.
The Folder 'Jobs' is locked by user 'xmeta'
(SessionID 'xmeta-1')'
I tried to stop the DataStage Server and the repository database but the error recurs after restart.
I've never seen the error on any of the other three Projects we use. The new project is not a protected project.
Has anyone got an idea what might be the matter?
I just set up a new project within DataStage Administrator and tried to import content from another project. Import fails with messages telling me that the folders I try to import the content to are missing. I then tried to create a folder manually and got the message:
'Unable to create new folder.
The Folder 'Jobs' is locked by user 'xmeta'
(SessionID 'xmeta-1')'
I tried to stop the DataStage Server and the repository database but the error recurs after restart.
I've never seen the error on any of the other three Projects we use. The new project is not a protected project.
Has anyone got an idea what might be the matter?
many greetings from the beautiful City of Hamburg
Roland
Roland
Adding new Folders in a new Project - another thread
Hello chulett,chulett wrote:Something new with 8.x it seems, and I don't recall anyone ever posting this problem before. Involve your official support provider if no-one here has anything to add.
I'll do that, but experimenting with other search terms I just found another thread reporting exactly the same problem:
"Cannot Import Metadata into new project" by NSIT-DVP-01.
many greetings from the beautiful City of Hamburg
Roland
Roland
-
- Participant
- Posts: 82
- Joined: Tue Jan 22, 2008 10:37 am
- Location: UK
Hi Chulett,chulett wrote:Link? Was there any resolution in the thread? ...
Sorry: here the link:
viewtopic.php?t=115716&highlight=Cannot ... ew+project
The resolution proposed is to restart the Service of the WebSphere Application Server in Windows after creation of a new job. Problem is: Creation of a new job is impossible under AIX. New jobs cannot be saved because all categories are locked.
many greetings from the beautiful City of Hamburg
Roland
Roland
Hi Chulett,chulett wrote:Link? Was there any resolution in the thread? ...
Sorry: here the link:
viewtopic.php?t=115716&highlight=Cannot ... ew+project
The resolution proposed is to restart the Service of the WebSphere Application Server in Windows after creation of a new job. Problem is: Creation of a new job is impossible under AIX. New jobs cannot be saved because all categories are locked.
many greetings from the beautiful City of Hamburg
Roland
Roland
Hi Dean,deanwalker wrote:Count the rows in XMETALOCKINFO in the xmeta database, there has been an intermittent issue where all the items create when installing the product are left locked.
Punch! There are 1606 items locked by user XMETA.
Is it possible (and advisable) to solve the problem by deleting the rows from XMETALOCKINFO?
many greetings from the beautiful City of Hamburg
Roland
Roland
-
- Participant
- Posts: 82
- Joined: Tue Jan 22, 2008 10:37 am
- Location: UK
Hi Dean,deanwalker wrote:It is if nobody has logged on since the system started, or at least nobody is actively using the system.
I also got a reply from DS Support now:
"Go to the default IS installation (/IBM/InformationServer/ASBServer/bin) directory and run the cleanup_abandoned_locks.sh script from a telnet session while logged in as root. Please make sure that all users are logged out before you do this.
$ ./cleanup_abandoned_locks.sh
Please enter the IS admin user and password when prompted. Once the process has completed, you will be returned to the UNIX command line and may not see any informational messages."
Running the Script solves the problem.
many greetings from the beautiful City of Hamburg
Roland
Roland