topic Re: %CONVERT-F-CREA_ERR, error creating work file CONVWORK in Operating System - OpenVMS

%CONVERT-F-CREA_ERR, error creating work file CONVWORK

Pradeep Nair_1 — Mon, 28 May 2007 04:37:21 GMT

I have a .com file, which has the following entries.

$conv/fdl=sys$input/fast XX$ABC_DATA:auto_upd.dat XX$ABC_DATA:auto_upd_idx.dat

FILE
ORGANIZATION indexed
BUCKET_SIZE 4

KEY 0
DUPLICATES yes
SEG0_LENGTH 11
SEG0_POSITION 513

But when i try to execute this com file, i'm getting the following error.

%CONVERT-F-CREA_ERR, error creating work file CONVWORK
-RMS-E-CRE, ACP file create failed
-SYSTEM-F-EXDISKQUOTA, disk quota exceeded.

I checked the XX$ABC_DATA device and there is no disk quota enabled. From the error i could see that the command gives me error in creating a Work file. I would like to take help from someone to resolve this error and where to check the location of CONWORK file.

Re: %CONVERT-F-CREA_ERR, error creating work file CONVWORK

labadie_1 — Mon, 28 May 2007 05:02:56 GMT

What is the size in blocks of your file XX$ABC_DATA:auto_upd.dat ?

how much free space do you have on the device XX$ABC_DATA, and how much contiguous free space ?

Can you post
$ show logical conv*
$ show logical sort*

You should have 3 to 4 times more free space than the size of your input file.

Re: %CONVERT-F-CREA_ERR, error creating work file CONVWORK

Pradeep Nair_1 — Mon, 28 May 2007 05:21:43 GMT

Hi,

The file is 425 blocks and the device has more than 6 GB space. The logicals are as follows.

show logi conv*

(LNM$SYSTEM_TABLE)

"CONVSHR_TV" = "CONVSHR"

show logi sort*

(LNM$SYSTEM_TABLE)

"SORTSHR_TV" = "SORTSHR"

Thanks in advance.

Re: %CONVERT-F-CREA_ERR, error creating work file CONVWORK

Robert Gezelter — Mon, 28 May 2007 05:28:07 GMT

Pradeep,

I would also recommend checking the setting of SYS$SCRATCH. CONVERT (which makes internal use of SORT) places the sort work files in SYS$SCRATCH.

- Bob Gezelter, http://www.rlgsc.com

Re: %CONVERT-F-CREA_ERR, error creating work file CONVWORK

Jan van den Ende — Mon, 28 May 2007 06:12:38 GMT

Pradeep,

Bob wrote:
>>>
I would also recommend checking the setting of SYS$SCRATCH.
<<<
"the setting" might be better worded as "the definition"

The simplest solution with the least side effects would be to enter into A.COM, in the line _JUST_ before $conv ...

$ DEFINE/USER SYS$SCRATCH XX$ABC_DATA:

(this will allways work, as long as the device that holds XX$ABC_DATA: has at least free space double the size of the file to be sorted. For really BIG files it may not provide maximum performance)

hth

Proost.

Have one on me.

jpe

Re: %CONVERT-F-CREA_ERR, error creating work file CONVWORK

Robert Gezelter — Mon, 28 May 2007 09:15:47 GMT

Pradeep,

As Jan correctly noted, it would be more precise to say "the value of the logical name SYS$SCRATCH".

The posting does not mention whether XX$ABC_DATA is the login device for this account. By default, the value of SYS$SCRATCH is set to the login device/directory.

As Jan noted, doing an ASSIGN/USER of a suitable scratch area to SYS$SCRATCH will likely resolve the problem.

- Bob Gezelter, http://www.rlgsc.com

Re: %CONVERT-F-CREA_ERR, error creating work file CONVWORK

Joseph Huber_1 — Mon, 28 May 2007 10:17:05 GMT

> The file is 425 blocks

And with this little free space/quota on sys$scratch or the disk where Your home directory is located, You will most likely soon encounter similar problems with other applications as well.
Better cleanup or ask the system manager to increase Your quota !

Re: %CONVERT-F-CREA_ERR, error creating work file CONVWORK

Hein van den Heuvel — Mon, 28 May 2007 11:08:39 GMT

Most likely this is simply a failure to assign SYS$SCRATCH correctly.

This may be a problem with directory ownership and resource identifiers.

A temporary file, such as CONVWORK, is not associated with any directory. It has no directory backlink. The file system therefore has no way of associating the resource identifier on the directory with the file it creates.

What is the EXACT OpenVMS version?
Detail have changed in this area.

btw... Does the KEY specified in the FDL match the sort order of the input file? In that case you can use /NOSORT and not use CONVWORK at all!

Btw... similar issues in SORT may cause error message, yet convert succesfully.
See.

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=950248

Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting

Re: %CONVERT-F-CREA_ERR, error creating work file CONVWORK

Pradeep Nair_1 — Thu, 28 Jun 2007 01:17:21 GMT

Thanks for all the support.