Skip to main content
 
developerWorks
AIX and UNIX
Information Mgmt
Lotus
New to Lotus
Products
How to buy
Downloads
Live demos
Technical library
Training
Support
Forums & community
Events
Rational
Tivoli
WebSphere
Java™ technology
Linux
Open source
SOA and Web services
Web development
XML
My developerWorks
About dW
Submit content
Feedback



developerWorks  >  Lotus  >  Forums & community  >  Enterprise Integration Forum

Enterprise Integration Forum

developerWorks

  

Sign in to participate PreviousPrevious NextNext


Eric Forte 8.May.14 01:44 PM a Web browser
LEI LEI - 8.0 Windows


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






LEI truncating values after upgrade... (Eric Forte 8.May.14)
. . RE: LEI truncating values after upg... (Daniel W Heiche... 8.May.14)
. . . . RE: LEI truncating values after upg... (Eric Forte 9.May.14)





  Document options
Print this pagePrint this page

 Search this forum

  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Author
Category
Platform
Release
Advanced search

 Sign In or Register
Sign in
Forgot your password?
Forgot your user name?
Create new registration

 RSS feedsRSS
All forum posts RSS
All main topics RSS
More Lotus RSS feeds

Resources

 Resources
Forum use and etiquette
Native Notes Access
Web site Feedback

Lotus Support

 Lotus Support
IBM Support Portal - Lotus software
Lotus Support documents
Lotus support by product
Lotus support downloads
Lotus support RSS feeds

Wikis

 Wikis
IBM Composite Applications
IBM Mashup Center
IBM Connections
IBM Connections Cloud Developers
IBM Docs
IBM Forms
IBM Mobile Connect
IBM Sametime
IBM SmartCloud for Social Business
IBM Web Experience Factory
Lotus Domino
Lotus Domino Designer
Lotus Expeditor
Lotus Foundations
Lotus iNotes
Lotus Instructor Community Courseware
Lotus Notes
Lotus Notes & Domino Application Development
Lotus Notes Traveler
Lotus Protector
Lotus Quickr
Lotus Symphony
IBM Web Content Manager
WebSphere Portal

Lotus Forums


 Lotus Forums
Notes/Domino 9.0
Notes/Domino 8.5 + Traveler
Notes/Domino XPages development forum
Notes/Domino 8
Notes/Domino 6 and 7
IBM Connections
IBM Mobile Connect
IBM Sametime
IBM SmartCloud Notes
Lotus Enterprise Integration
Lotus Protector
Lotus Quickr
Lotus SmartSuite