Import Outlook Links not working (Outlook2007 and TRIM 7.1) (348 Views)
Reply
Advisor
Tim O'Grady
Posts: 22
Registered: ‎03-24-2009
Message 1 of 2 (348 Views)

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

HP Expert
Neil Summers
Posts: 1,059
Registered: ‎10-08-2008
Message 2 of 2 (325 Views)

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 HP.

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

HP Software Support Online (SSO): http://support.openview.hp.com
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.