Cannot add new stages to canvas

Lindies · Post by **Lindies** » Mon Nov 14, 2005 3:22 am

Hi

Created new project
File/New Server Job
Drag a SEQ stage to canvas and this appears: "Record CSeqFileStage in file DS_STAGETYPES is locked by another user"

I cant create a new job.

Error 2:

Imported dsx to new project.
Can see jobs but cannot open stages. Errors like "Record DRS in file DS_Stagetypes is locked by another User" (WHERE DRS is the stage type, i.e. DB2 or ORA or SEQ stage.)

Cannot add new stages to canvas.

Help please,
Lindy

ArndW · Post by **ArndW** » Mon Nov 14, 2005 4:39 am

Did you have problems installing DS or the project? Might you still have a UNIX session open (installing plugins, for example) that has locks open? If you execute the UNIX command "list_readu EVERY" you might be able to see the process locking your file, or you can use the UNIX "fuser" command on the actual DS_STAGETYPES/DATA.30 unix file in your project directory to see who is locking the file.

Lindies · Post by **Lindies** » Tue Nov 15, 2005 5:43 am

No,i didnt have problem installing and i dont have any unix window session.
This is the output of the command you suggested:

etlprd01:$ list_readu EVERY

Active Group Locks: Record Group Group Group

Device.... Inode.... Netnode Userno Lmode G-Address. Locks ...RD ...SH ...EX

57933829 51109 0 60707 2 IN 800 1 0 0 0

57956834 18846 0 60707 9 IN 3800 4 0 0 0

57956834 18846 0 60707 20 IN 4000 6 0 0 0

57956834 18830 0 63701 30 IN E000 1 0 0 0

57956834 18846 0 60707 31 IN 4800 5 0 0 0

57956834 18846 0 60707 40 IN 800 3 0 0 0

57956834 18846 0 63701 42 IN 5000 3 0 0 0

57956834 18846 0 60707 51 IN 1000 3 0 0 0

57956834 18846 0 63701 53 IN 5800 3 0 0 0

57956834 18846 0 60707 62 IN 1800 2 0 0 0

57956834 18846 0 60707 64 IN 6000 4 0 0 0

57956834 18846 0 60707 73 IN 2000 5 0 0 0

57956834 18846 0 60707 75 IN 6800 6 0 0 0

57956834 18846 0 60707 84 IN 2800 4 0 0 0

57933829 56338 0 60707 90 IN 800 4 0 0 0

57956834 18846 0 63701 95 IN 3000 5 0 0 0

Active Record Locks:

Device.... Inode.... Netnode Userno Lmode Pid Login Id Item-ID.............

57956834 18830 0 60707 30 RU 4829 dsadm O_ACNT001HashDB2

Press any key to continue...

57933829 56338 0 63701 90 RU 1835 dsadm 08935F27-11C4-452F-A0E9-2C71B055C452-23360JNBGTE092:1835

57933829 56338 0 63645 90 RU 1891 dsadm 08935F27-11C4-452F-A0E9-2C71B055C452-23360JNBGTE092:1891

57933829 56338 0 60719 90 RU 4817 dsadm 8B1C080B-50D2-409C-BA54-1CC8EE215CB2-23360JNBGTE090:4817

57933829 56338 0 60707 90 RU 4829 dsadm 8B1C080B-50D2-409C-BA54-1CC8EE215CB2-23360JNBGTE090:4829

= LIST_MAGIC

! = LIST_MAGIC

! = LIST_MAGIC

! = LIST_MAGIC

! = LIST_MAGIC

! = LIST_MAGIC

! = LIST_MAGIC

! = LIST_MAGIC

! = LIST_MAGIC

! = LIST_MAGIC

! = LIST_MAGIC

! = LIST_MAGIC

! = LIST_MAGIC

....

Regards,

lindy

ArndW · Post by **ArndW** » Tue Nov 15, 2005 6:53 am

Out of the context of your environment this list isn't useful. It is better for you to use the unix fuser command on the file DS_STAGETYPES/DATA.30 in your project to see which other process might have the file open. Once you have that pid you can see what sort of process this is and take it from there.