Eric Forte 8.May.14 08:44 PM a Web browser LEILEI - 8.0Windows
Our previous configuration was LEI 7 sending data to SQL Server 2000. As part of another project, we tested LEI 7 sending data to SQL Server 2012 and confirmed that all was fine. We recently upgraded LEI, Domino to send data to the new SQL 2012 server and one CHAR(1) parameter in a stored procedure is being sent as a NULL. I have tried all sorts of data transformation formulas, even changed the width of the CHAR(1) to VARCHAR(10) and still nothing.
One last thing I tried was changing the CHAR(1) parameter to take INT, but then I received too many errors complaining about the source connection being text and the target being I4. And I tried to resolve those with transformation formulas, but no luck.
So, back to the original issue where a text value from a radio button of "0", "1" or "2" is getting sent to SQL as NULL.
I've tried to set up traces, but don't have access to the filesystem and the logging to the activity log is not too helpful (below).
Thanks,
Eric
======================================
05/08/2014 11:43:36 AM returning status=0
05/08/2014 11:43:36 AM 11:43:36.46
05/08/2014 11:43:36 AM LCXConnect
05/08/2014 11:43:36 AM returning status=0
05/08/2014 11:43:40 AM 11:43:40.33
05/08/2014 11:43:40 AM LCXGetProperty
05/08/2014 11:43:40 AM lcPropertyToken=65541
05/08/2014 11:43:40 AM lcDestField (721), TEXT
05/08/2014 11:43:40 AM Single VALUE of (NULL)
05/08/2014 11:43:40 AM 11:43:40.33
05/08/2014 11:43:40 AM LCXSetProperty
05/08/2014 11:43:40 AM lcPropertyToken=65552
05/08/2014 11:43:40 AM lcSrcField (722), TEXT
05/08/2014 11:43:40 AM Single VALUE of "dbo.spu_upload_data;1"
05/08/2014 11:43:40 AM returning status=0
05/08/2014 11:43:40 AM 11:43:40.35
05/08/2014 11:43:40 AM LCXSetProperty
05/08/2014 11:43:40 AM lcPropertyToken=65558
05/08/2014 11:43:40 AM lcSrcField (723), INT
05/08/2014 11:43:40 AM VALUE of 1
05/08/2014 11:43:40 AM returning status=0
05/08/2014 11:43:40 AM 11:43:40.43
05/08/2014 11:43:40 AM LCXCall - full trace not available.
05/08/2014 11:43:40 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:40 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:40 AM returning status=12325
05/08/2014 11:43:40 AM 11:43:40.58
05/08/2014 11:43:40 AM LCXCall - full trace not available.
05/08/2014 11:43:40 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:40 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:40 AM returning status=12325
05/08/2014 11:43:40 AM 11:43:40.77
05/08/2014 11:43:40 AM LCXCall - full trace not available.
05/08/2014 11:43:40 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:40 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:40 AM returning status=12325
05/08/2014 11:43:40 AM 11:43:40.96
05/08/2014 11:43:40 AM LCXCall - full trace not available.
05/08/2014 11:43:41 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:41 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:41 AM returning status=12325
05/08/2014 11:43:41 AM 11:43:41.49
05/08/2014 11:43:41 AM LCXCall - full trace not available.
05/08/2014 11:43:41 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:41 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:41 AM returning status=12325
05/08/2014 11:43:41 AM 11:43:41.64
05/08/2014 11:43:41 AM LCXCall - full trace not available.
05/08/2014 11:43:41 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:41 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:41 AM returning status=12325
05/08/2014 11:43:41 AM 11:43:41.82
05/08/2014 11:43:41 AM LCXCall - full trace not available.
05/08/2014 11:43:42 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:42 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:42 AM returning status=12325
05/08/2014 11:43:42 AM 11:43:42.13
05/08/2014 11:43:42 AM LCXCall - full trace not available.
05/08/2014 11:43:42 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:42 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:42 AM returning status=12325
05/08/2014 11:43:42 AM 11:43:42.49
05/08/2014 11:43:42 AM LCXCall - full trace not available.
05/08/2014 11:43:42 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:42 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:42 AM returning status=12325
05/08/2014 11:43:42 AM 11:43:42.63
05/08/2014 11:43:42 AM LCXCall - full trace not available.
05/08/2014 11:43:42 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:42 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:42 AM returning status=12325
05/08/2014 11:43:42 AM 11:43:42.86
05/08/2014 11:43:42 AM LCXCall - full trace not available.
05/08/2014 11:43:43 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:43 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:43 AM returning status=12325
05/08/2014 11:43:43 AM 11:43:43.08
05/08/2014 11:43:43 AM LCXCall - full trace not available.
05/08/2014 11:43:43 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:43 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:43 AM returning status=12325
05/08/2014 11:43:43 AM 11:43:43.34
05/08/2014 11:43:43 AM LCXCall - full trace not available.
05/08/2014 11:43:43 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:43 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:43 AM returning status=12325
05/08/2014 11:43:43 AM 11:43:43.56
05/08/2014 11:43:43 AM LCXCall - full trace not available.
05/08/2014 11:43:43 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:43 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:43 AM returning status=12325
05/08/2014 11:43:43 AM 11:43:43.80
05/08/2014 11:43:43 AM LCXCall - full trace not available.
05/08/2014 11:43:43 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: The statement has been terminated.
SQLErrorInfo: 01000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:43 AM Error:
ErrorRecord: HResult: 0x80040e2f
Description: Cannot insert the value NULL into column 'rack_mount_yes_no', table 'products.dbo.tprod_common'; column does not allow nulls. INSERT fails.
SQLErrorInfo: 23000
Source: Microsoft OLE DB Provider for SQL Server
, Connector 'products-oledb-STAGE-SP', Method -Call- (12325)
05/08/2014 11:43:43 AM returning status=12325
Return to top
LEI truncating values after upgrade... (Eric Forte 8.May.14)
. . 
Print this page
