vaishali_sftdev
25th August 2008, 12:02
Hi,
I am doing CRRT for a table in which i changed index fields. It is giving me error "Error -13 during seq.open file "/baan/dict/x/x/dtablename.old". What can be the reason behind it? What is the solution for this? Reply ASAP.
satish_pabathi
25th August 2008, 12:14
once u try create run time i hope it may work.
norwim
25th August 2008, 12:43
Hi there,
have a closer look at the file "/baan/dict/x/x/dtablename.old"
a) if it exists, change it's permissions so that the user running the CRTDD (usually bsp) has write permission
b) if it doesn't exist, you'll have to report closer details.
What basically happens when you change a table and make these changes active, the old description is used to create a seq. dump, which will be read into the new table using the new description.
hth
norbert
vaishali_sftdev
26th August 2008, 06:22
Thank you for reply. I saw permissions dlptfl003.old. Its -rw-r----. And all the files for other tables have this permissions -rw-rw---. How does it affect? Because, in my case, if CRRT is done by bsp login then error doesnt come. But when user gets login then error is shown. So, should i change permission of this file?
sprasad
26th August 2008, 11:32
Hi
Yeah change the permission of the file your problem should get solved.
Han Brinkman
26th August 2008, 12:16
Depends on who has done it the last time and what the umask has been set to.
Regards,
Han
vaishali_sftdev
26th August 2008, 12:53
Thanks a lot sprasad and han.. It worked by changing permissions . But what made change in permission of this file? Since, all other files have same permissions except this one.
Han Brinkman
26th August 2008, 15:03
Who's the owner of the .old file? Perhaps that can give you an idea?
vaishali_sftdev
27th August 2008, 07:04
Yes, u are right. Initially it was created by my login. But due to some error it was recreated through bsp login keeping backup of file under different name. And therefore, bsp became the owner and i had only read access on this file. Thanks a lot for all inputs.