E-mail Integration
Showing results for 
Search instead for 
Do you mean 

Import Outlook Links not working (Outlook2007 and TRIM 7.1)

Advisor

Import Outlook Links not working (Outlook2007 and TRIM 7.1)

Hi Everyone,

 

We are having a problem importing Outlook links. Exporting seems to run perfectly but when importing links back into TRIM. We only ever seem to get one linked folder imported  before the follwoing error.

 

Anyone else having difficulties with importing linked folders back into outlook or know what this error means ?

 

 

Function request (Execute Transaction) for HP TRIM Workgroup Server 'Context.csiro.au' failed. An attempt to insert a row into the database caused a referential integrity problem. You tried to add a row that has a field that must be unique and it is not.
The SQL was: INSERT INTO TSDOCQUEUE (uri,dqName,dqMachineName,dqDOSPath,dqType,dqNode,dqUsername,dqPassword,dqAccessLoc,dqLastProcessed,dqOutTo,dqOutOn,dqOutMachine,dqRecordType,dqContainer,dqShowHidden,dqShowSystem,dqShowTRIMRefs,dqShowBinaries,dqShowRenditions,dqShowOtherMask,dqConfirmCheckIn,dqDisplayEntryForm,dqKeepCheckedOut,dqDelAfterCheckIn,dqCheckForLinks,dqIgnoreOriginal,dqAutoProcess,dqAutoView,dqKeepForDays,sysLastUpdated,dqDisplayName,dqClassification) VALUES (30006,'[KEI-CL] test folder','KEI-CL',' ',2,' ',' ',' ',10281,' ',0,' ',' ',2,944992,'F','F','F','F','F',' ','T','T','T','F','F','T','F','F',0,'201304120325381',' ',0) ; INSERT INTO TSACCESSCO (uri,axObject,axObjectUri,axType,axSubType,axLocUri,axRefType) VALUES (24877603,54,30006,0,2,10281,5) ; INSERT INTO TSACCESSCO (uri,axObject,axObjectUri,axType,axSubType,axLocUri,axRefType) VALUES (24877604,54,30006,1,2,10281,5) ; INSERT INTO TSACCESSCO (uri,axObject,axObjectUri,axType,axSubType,axLocUri,axRefType) VALUES (24877605,54,30006,2,2,10281,5) ; INSERT INTO TSACCESSCO (uri,axObject,axObjectUri,axType,axSubType,axLocUri,axRefType) VALUES (24877606,54,30006,3,2,10281,5) ; INSERT INTO TSEVENTDAT (uri,edDateTime,edEventType,edObjectType,edObjectUri,edRelObjectType,edRelObjectUri,edFromMachine,edFromTimeZone,edLoginId,edLoginUri,edEstoreUri,edEstoreId,edEventDetails,edForWorkgroupId,edForProcessType) VALUES (144890425, '201304120325381', 0, 54, 30006, 0, 0, 'KEI-CL.nexus.csiro.au', -36000, 'ogr011', 10281, 0, ' ', ' ', 2, 1)
The error was: Cannot insert duplicate key row in object 'dbo.TSDOCQUEUE' with unique index 'dqDOSPath'. The duplicate key value is ( , KEI-CL).

 Detailed ADO Errors
 Number  = 0x80040e2f
 Source  = Microsoft OLE DB Provider for SQL Server
 Description = Cannot insert duplicate key row in object 'dbo.TSDOCQUEUE' with unique index 'dqDOSPath'. The duplicate key value is ( , KEI-CL).
 SQLState  = 23000
 NativeError = 2601
 Number  = 0x80040e2f
 Source  = Microsoft OLE DB Provider for SQL Server
 Description = The statement has been terminated.
 SQLState  = 01000
 NativeError = 3621

 

 

Tim O'Grady

1 REPLIES
HPE Expert

Re: Import Outlook Links not working (Outlook2007 and TRIM 7.1)

It may be caused by this issue that was fixed in 7.1.2.1879:

 

QCCR2D45057 - Linked folders in outlook - User cannot remove and re-create linked folders in Outlook

 

 


Neil


Note: Any posts I make on this forum are my own personal opinion and do not constitute a formal commitment on behalf of HPE.

(Please state the version of TRIM/HPRM/HPERM you're using in all posts)

HPE Software Support Online (SSO): https://softwaresupport.hp.com/