Developer forum

Forum » Integration » Error creating indexes for the table AccessUserSecondaryRelationTempTableForBulkImport1

Error creating indexes for the table AccessUserSecondaryRelationTempTableForBulkImport1

E-mail notifications
Anders Ebdrup
Anders Ebdrup
Reply
Posted on 18/12/2017 19:13:00

Hi Dynamicweb,

 

We experience this error when importing into: AccessUserSecondaryRelation

Error creating indexes for the table AccessUserSecondaryRelationTempTableForBulkImport1: ExecuteNonQuery: CommandText property has not been initialized   

 

It seems to be caused in: CreateTempTableIndexes as your are missing a check if valid keys are found in the index as indexes can not be created for the nvarchar(max) columns.

 

Best regards, Anders


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 19/12/2017 15:25:12
Reply
This post has been marked as an answer

Hi Anders,
That is a bug. TFS# 43704 created.Thanks for finding.
Regards, Dmitrij

Votes for this answer: 1

 

You must be logged in to post in the forum