mORMot Open Source

JerryC_ph

Member

Registered: 2013-03-11

Posts: 16

MSSQL OLEDB Error 80040E14

I'm getting this OLEDB Error 80040E14 with this code:

AssetDBProps := TOleDBMSSQLConnectionProperties.Create(
                      ASSET_DB_SERVER
                    , ASSET_DB_NAME
                    , ASSET_DB_USER
                    , ASSET_DB_PASSWORD
                  );

AssetModel := TSQLModel.Create(ASSET_TABLES,ASSET_ROOT);

VirtualTableExternalRegisterAll(AssetModel,AssetDBProps,false);

AssetRestServer := TSQLRestServerDB.Create(AssetModel,':memory:',true);
AssetRestServer.CreateMissingTables();

Portion of log file with error:

20140923 13244913 SQL   TOleDBStatement(01FF15A0) CREATE INDEX NDXLocationPartOfLocation ON dbo.Location(PartOfLocation)
20140923 13244913  +    TOleDBStatement(01FF15A0).005D1A7E 
20140923 13244913 ERROR 	"EOleDBException(02054560)":"OLEDB Error 80040E14 -   (line 1): The operation failed because an index or statistics with name 'NDXLocationPartOfLocation' already exists on table 'dbo.Location'.\r\n" stack trace API 004973E4 005D383F 005D39BB 005D1E9D 0054D18C 0054D8DC 004ECE02 004ED0D1 004DAC10 00559F62 005D5D32 005DBF50 7648338A 77849F72 77849F45 

Any ideas?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: MSSQL OLEDB Error 80040E14

AFAIK this exception is catched and ignored.
Index was not identified but it would not harm anything.