Skip to main content

I am having trouble importing data from a table in a RM/Cobol database using the Relativity (32 bit) driver(s) into an SQL Server Database table. The source data has bad data in it and it will not let me select the data when a field with the bad data is included.  I am getting the 2 errors shown below.  In both cases I am trying something similar to:

 

SELECT * FROM OPENQuery([GROSSMAN],'Select TrustID,CONVERT(Property_RangeCD,SQL_CHAR) from Properties')

 

I am currently just trying the select query before trying to even insert it into a table.

 

OLE DB provider "MSDASQL" for linked server "GROSSMAN" returned message "[Liant][Relativity][SimbaLNA][Liant][Relativity Server]Expression evaluation error.".

OLE DB provider "MSDASQL" for linked server "GROSSMAN" returned message "[Liant][Relativity][Client][SimbaLNA][Liant][Relativity Server][CRDM]Day-of-month value is out of range (column Property_AcceptanceDate)".

 

 

OLE DB provider "MSDASQL" for linked server "GROSSMAN" returned message "[Liant][Relativity][SimbaLNA][Liant][Relativity Server]Expression evaluation error.".

OLE DB provider "MSDASQL" for linked server "GROSSMAN" returned message "[Liant][Relativity][Client][SimbaLNA][Liant][Relativity Server][CRDM]Numeric item in key contains nonnumeric characters (column Property_TownshipCd)".