Hi,
We're using ZEN Desktop Management 7.0 SP1 having Oracle 9.2.0.7 database.
When trying to collect inventory from desktops, then with about 10% of
desktops we get the following Oracle errors on procedures execution:

ORA- 01401: inserted value too large for column.

This error occures on 2 procedures:
"MW_DBA.C$FILE"
"MW_DBA.C$DIRECTORY"

What measures shall we perform to avoid these errors?

Any help is appreciated

Please see the full log below
-----------------
> [10/23/06 15:57:13.065] ZENInv - Storer: ProcessOtherSection is failing
> in databaseexception
> com.novell.zenworks.desktop.inventory.storer.Datab aseException:
> ORA- 01401: inserted value too large for column
> ORA- 06512: at "MW_DBA.C$FILE", line 21
> ORA- 06512: at line 1
>
> at
> com.novell.zenworks.desktop.inventory.storer.Insta lledFile.addBaseFile

(Insta
> lledFile.java:754)
> at
> com.novell.zenworks.desktop.inventory.storer.Insta lledFile.getBaseFileId

(Ins
> talledFile.java:653)
> at
> com.novell.zenworks.desktop.inventory.storer.Insta lledFile.<init>

(InstalledFil
> e.java:369)
> at
> com.novell.zenworks.desktop.inventory.storer.Insta lledFile.<init>

(InstalledFil
> e.java:295)
> at
> com.novell.zenworks.desktop.inventory.storer.Parse .addInstalledFile

(Parse.ja
> va:5226)
> at
> com.novell.zenworks.desktop.inventory.storer.Parse .handleInstalledFiles

(Pars
> e.java:5152)
> at
> com.novell.zenworks.desktop.inventory.storer.Parse .processOtherSection

(Parse
> .java:1524)
> at
> com.novell.zenworks.desktop.inventory.storer.Parse .parse(Parse.java:4038)
> at
> com.novell.zenworks.desktop.inventory.storer.MainT hread.run

(MainThread.java:
> 976)
>
> [10/23/06 15:57:13.100] ZENInv - Storer: Scantype set to - 1
> [10/23/06 15:57:13.176] ZENInv - Storer: cleanUp:Full Scan will be
> initiated on
>

CN=AndreevAA172_16_20_150CZC5360M89WIN2000.OU=ws.O U=ngp2.OU=angdu.O=mng.C=r
u
> [10/23/06 15:57:13.176] ZENInv - Storer: ParseException:Could not
> process 000FFE22B7CF_1143446329000_15.STR due to Database
> operation(related to data or schema) exception- >ORA- 01401: inserted
> value too large for column
> ORA- 06512: at "MW_DBA.C$FILE", line 21
> ORA- 06512: at line 1
>
> Database operation(related to data or schema) exception- >ORA- 01401:
> inserted value too large for column
> ORA- 06512: at "MW_DBA.C$FILE", line 21
> ORA- 06512: at line 1
>
> at
> com.novell.zenworks.desktop.inventory.storer.Parse .parse(Parse.java:4104)
> at
> com.novell.zenworks.desktop.inventory.storer.MainT hread.run

(MainThread.java:
> 976)
>
>
> [10/24/06 08:08:32.043] ZENInv - Storer: ProcessOtherSection is failing
> in databaseexception
> com.novell.zenworks.desktop.inventory.storer.Datab aseException:
> ORA- 01401: inserted value too large for column
> ORA- 06512: at "MW_DBA.C$DIRECTORY", line 9
> ORA- 06512: at line 1
>
> at
>

com.novell.zenworks.desktop.inventory.storer.Insta lledProduct.addDirectory
(I
> nstalledProduct.java:1833)
> at
> com.novell.zenworks.desktop.inventory.storer.Insta lledFile.getLocationId

(Ins
> talledFile.java:866)
> at
> com.novell.zenworks.desktop.inventory.storer.Insta lledFile.<init>

(InstalledFil
> e.java:352)
> at
> com.novell.zenworks.desktop.inventory.storer.Insta lledFile.<init>

(InstalledFil
> e.java:295)
> at
> com.novell.zenworks.desktop.inventory.storer.Parse .addInstalledFile

(Parse.ja
> va:5226)
> at
> com.novell.zenworks.desktop.inventory.storer.Parse .handleInstalledFiles

(Pars
> e.java:5152)
> at
> com.novell.zenworks.desktop.inventory.storer.Parse .processOtherSection

(Parse
> .java:1524)
> at
> com.novell.zenworks.desktop.inventory.storer.Parse .parse(Parse.java:4038)
> at
> com.novell.zenworks.desktop.inventory.storer.MainT hread.run

(MainThread.java:
> 976)
>
> [10/24/06 08:08:32.103] ZENInv - Storer: Scantype set to - 1
>
> [10/24/06 08:08:34.057] ZENInv - Storer: ParseException:Could not
> process 00110A3A7B04_1147679577000_141.STR due to Database
> operation(related to data or schema) exception- >ORA- 01401: inserted
> value too large for column
> ORA- 06512: at "MW_DBA.C$DIRECTORY", line 9
> ORA- 06512: at line 1
>
> Database operation(related to data or schema) exception- >ORA- 01401:
> inserted value too large for column
> ORA- 06512: at "MW_DBA.C$DIRECTORY", line 9
> ORA- 06512: at line 1
>
> at
> com.novell.zenworks.desktop.inventory.storer.Parse .parse(Parse.java:4104)
> at
> com.novell.zenworks.desktop.inventory.storer.MainT hread.run

(MainThread.java:
> 976)

-----------------------

Thanks in advance