cancel

RM 8.1 SQL Error message when import large data

SOLVED
Go to solution
Highlighted
Techgato6808
Super Contributor.

RM 8.1 SQL Error message when import large data

Good day all,

 

We have recenty upgraded to HP RM 8.1. We have a couple of users trying to load a large records. Our system admin is receiving multiple emails from TRIM Server with same message.  (Please see below)  Have anybody has this error yet or have advice. Its looks like a SQL Error about the size. Please advise.  Thanks

 

 

Regards,

 

Techgato

 

 

 

From: TRIM Service Administrator notification <
[mailto:TRIMWK@grc.usmcu.edu]
Sent: Tuesday, October 14, 2014 11:23 AM
Subject: HP Records Manager Notification - Service 'HP Records Manager
Workgroup Server' on 'MCUGRCSER1246.USMCU.EDU'

HP Records Manager Workgroup Server running on MCUGRCSER1246.USMCU.EDU
reported the following message:
 Error : 41  User: MCUGRCSER1246 -  The SQL transaction 'Record update '
failed for user MCUGRCDS1118:3668: String or binary data would be
truncated.
Details: Extended SQL Error Information:
        Number          = 0x80040e57
        Source          = Microsoft OLE DB Provider for SQL Server
        Description     = String or binary data would be truncated.
        SQLState        = 22001
        NativeError     = 8152
        Number          = 0x80040e57
        Source          = Microsoft OLE DB Provider for SQL Server
        Description     = The statement has been terminated.
        SQLState        = 01000
        NativeError     = 3621
SQL command: INSERT INTO TSONLINEAU
(uri,oaObjectType,oaObjectUri,oaEventType,oaEventDetails,oaOtherObjectTy
pe,oaOtherObjectUri,oaSecViolation,oaDoneAt,oaDoneBy,oaDoneByUri,oaDoneA
tTimezone,oaDoneOnMachine) VALUES (1032507,6,225394,26,'From: Command
Chronologies - Posts, Stations, Commands and Detachments - Marine Corps
Installations Command (MCI) - Marine Corps Installations East, Camp
Lejeune, NC (MCIE-CLNC) - Marine Corps Air Station Cherry Point, NC
(MCAS Cherry Point) - Marine Transport Squadron One (VMR 1) - 1 January
- 31 December 2013',0,0,'F','201410141522561','lylesjj',45392,0,' ')

7 REPLIES
Techgato6808
Super Contributor.

Re: RM 8.1 SQL Error message when import large data

Here is more of the story. Its looks like the users copied the record and are trying to change the title on the new. Here is the getting the error message they are receiving.  The original record was from TRIM 6.2 and we are trying change the title in Records Manager 8.1 and looks as though the SQL Server doesn't like the field length or something when they attempt to modify the title

 

Error message

 

Greg Fraser_1
HPE Expert

Re: RM 8.1 SQL Error message when import large data

I'm unable to see the picture below, did you want to have another crack at uploading it.

 

Question: how long is the title of the record

 

**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Hewlett Packard Enterprise**
Techgato6808
Super Contributor.

Re: RM 8.1 SQL Error message when importing large data

Greg,

 

We recently upgraded from TRIM 6.2 to RM 8.1. The catagory field types were over 300 characters in the old version. Well the users were attempting to copy a record with the afore mentioned field  and modify the title field, and received the attached error message. They then tried to edit the category field down to smaller number, but it NOW displays in the preview the old category field with the extra long category description, but when you go to properties, it displays the shorter character format, but the system still throws that same error message, when they try to save it under with shorter character limit. It also looks like the table is combining the title and category together in the table on the SQL Server DB 2008 R2.

EWillsey
Acclaimed Contributor.

Re: RM 8.1 SQL Error message when import large data

Yeah known issue. Already reported to HP
Techgato6808
Super Contributor.

Re: RM 8.1 SQL Error message when import large data

EWillsey

 

 

Do you have a bug ID or anything we can reference for fix date or ETA? Or a workaround? Thanks.

 

 

 

 

T

 

Diana McMullin
Trusted Contributor.

Re: RM 8.1 SQL Error message when import large data

I received a workaround from tech support yesterday.

 

ALTER TABLE TSONLINEAU ALTER COLUMN oaEventDetails varchar(350)

 

I tried it in my test environment and it seems to fix it.

EWillsey
Acclaimed Contributor.
Solution

Re: RM 8.1 SQL Error message when import large data

CRID 52373 for errors relating to TSONLINEAU table

 

Temporary fix for the above CRID is as below

                ALTER TABLE TSONLINEAU ALTER COLUMN oaEventDetails varchar(350);