Centric CRM 4.1 (Stable and Released)

Core Team

PUBLIC PROFILE

Assignment

Priority: Next
Assigned To: unassigned

Ticket # 143

This ticket is open
Severity: Critical
Category: Blocker
Entered by: Matt Rajkowski 4/12/2007, 1:14 PM
Last modified: Matt Rajkowski 4/12/2007, 1:16 PM

Description

Using Oracle, inserting data sometimes fails. This occurs when a non-required Centric CRM field is left empty and the database does not allow NULLs for that field. (Oracle treats empty strings as NULLs).

For example:
Product Option insertion (text field or list or checkbox): ORA-01400: cannot insert NULL into ("CENTRIC_CRM"."PRODUCT_OPTION"."OPTION_NAME")

2007-04-02 12:17:32,065 INFO [STDOUT] java.sql.SQLException: ORA-01400:
cannot insert NULL into ("CENTRIC_CRM"."PRODUCT_OPTION"."OPTION_NAME")
2007-04-02 12:17:32,066 INFO [STDOUT] at
org.aspcfs.modules.products.base.ProductOption.insert(Unknown Source)
2007-04-02 12:17:32,066 INFO [STDOUT] at
org.aspcfs.modules.products.configurator.StringConfigurator.saveProperties(Unknown
Source)
2007-04-02 12:17:32,066 INFO [STDOUT] at
org.aspcfs.modules.products.actions.ProductCatalogOptions.executeCommandInsertOption(Unknown
Source)

Solution

A solution hasn't been entered

File Attachments

There are no file attachments

Ticket Activity

Date	Event
Matt Rajkowski 4/12/2007, 1:14 PM	[ Ticket Opened ]
Matt Rajkowski 4/12/2007, 1:14 PM	[ Ticket is unassigned ]
Matt Rajkowski 4/12/2007, 1:14 PM	[ Priority set to Next ]
Matt Rajkowski 4/12/2007, 1:14 PM	[ Severity set to Normal ]
Matt Rajkowski 4/12/2007, 1:16 PM	[ Severity changed from Normal to Critical ]

Distribution List
Matt R.