nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DD converting spaces to NULLs?!?!?

jase

Hiya,
this is a doozy.

have a look at the iwddd.log snippet below:

INSERT:INSERT INTO SLS_HEADER_IMAGE__WORKAREA(path,image,image_content_item_identifier,link_content_item_identifier,display_order,slsid) VALUES (?,?,?,?,?,?)
Column: path, field: path, Index: 1,Converting 'templatedata\corporate_buy_emea\category\data\eng\eng.pnt' to VARCHAR
Column: image, field: category/0/static-link-set/0/header-image/0/image, Index: 2,Converting ' ' to VARCHAR
Column: image_content_item_identifier, field: category/0/static-link-set/0/header-image/0/image-content-item-identifier, Index: 3,Converting '' to INTEGER
Column: link_content_item_identifier, field: category/0/static-link-set/0/header-image/0/link-content-item-identifier, Index: 4,Converting '' to INTEGER
Column: display_order, field: category/0/static-link-set/0/header-image/0/display-order, Index: 5,Converting '4' to INTEGER
Column: slsid, field: category/0/static-link-set/0/display-order, Index: 6,Converting '3' to INTEGER

*******************************************************
SQLException occured in TDbSchemaGroupCfg
Exception Message: [D1\EUROSQL]Cannot insert the value NULL into column 'image', table 'DataDeploy.dbo.SLS_HEADER_IMAGE__WORKAREA'; column does not allow nulls. INSERT fails.
Vendor Error Code: 515
SQL state: 23000
*******************************************************

You'll notice that there is a space char in the image data above. (Converting ' ' to VARCHAR )
Bug or "feature"? I can't imagine why automatic whitespace trimming would be advantageous.

Anyone else?

Cheers
Jase

Find more posts tagged with

Comments

nipper

What is actually in the DCR ? Is it a single space ? Tab ?

I assume this does work with a true value in there.

jase

Yeah, a single space.

And yes, it does work with a true value (although in the context of this problem, a space IS a true value)

Jase

Migrateduser

change the table column to "not Nulls" using the DB alter cmd, otherwise ensure it has a required value.

Interwoven Certified Technical Support Engineer
shegg@Interwoven.com "> Email: shegg@Interwoven.com

Migrateduser

Hi Steve see customer reply to your posting:

They need to check the log snippet again. There IS a value for image, it is a space character.

It seems that the space is converted to a NULL and then inserted into a non-NULL field.
The question is, why is it converted to a NULL?

INSERT:INSERT INTO SLS_HEADER_IMAGE__WORKAREA(path,image,image_content_item_identifier,link_content_item_identifier,display_order,slsid) VALUES (?,?,?,?,?,?)
Column: path, field: path, Index: 1,Converting 'templatedata\corporate_buy_emea\category\data\eng\eng.pnt' to VARCHAR
Column: image, field: category/0/static-link-set/0/header-image/0/image, Index: 2,Converting ' ' to VARCHAR
Column: image_content_item_identifier, field: category/0/static-link-set/0/header-image/0/image-content-item-identifier, Index: 3,Converting '' to INTEGER
Column: link_content_item_identifier, field: category/0/static-link-set/0/header-image/0/link-content-item-identifier, Index: 4,Converting '' to INTEGER
Column: display_order, field: category/0/static-link-set/0/header-image/0/display-order, Index: 5,Converting '4' to INTEGER
Column: slsid, field: category/0/static-link-set/0/display-order, Index: 6,Converting '3' to INTEGER

*******************************************************
SQLException occured in TDbSchemaGroupCfg
Exception Message: [D1\EUROSQL]Cannot insert the value NULL into column 'image', table 'DataDeploy.dbo.SLS_HEADER_IMAGE__WORKAREA'; column does not allow nulls. INSERT fails.
Vendor Error Code: 515
SQL state: 23000
*******************************************************