Symantec IGA

[SRGM] Failed to write table 'DataTypes' while using the DNA tools for bulk insert 

Aug 24, 2015 11:41 AM


There are many reasons to get this error:

Failed to write table 'DataTypes'

 

So I am starting a new document to list the possible reasons for this issue:

 

==============================================================

Full error:

Failed to write table 'DataTypes' data from BULK INSERT file '\\<your server name>\<your share name>\<bulk file name>_DataTypesTmp.tbl'

This error above us actually cased by this error before it:

Error: Bulk Log file '\\<your server name>\<your share name>\EUREKI~1.log not found

 

IF you are using windows 2008 server R2, then you have run into the issue where shortnames are disabled by default.

Windows disabled this for performance reasons, you can read more about it here:

Fsutil 8dot3name

 

The commands below change this setting for all volumes on the server.

 

First query your server to see what it is set at:

c:\>fsutil 8dot3name query

 

If the return is anything but 0

 

you can set it with:

c:\>fsutil 8dot3name set 0

 

==============================================================

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.