Error creating a content instance with a nested relator widget

Havva_Ozgul

 We are building a site with VCM 7.3.0.5.  We have a content type with a contained 1--to-many relationship.  (i.e.  1 Department  many Employees).  We created the following tables:

 

For employee:

CREATE TABLE VGNADMIN.NDEMPLOYEES

   (EMPID VARCHAR2(40) NOT NULL, FNAME VARCHAR2(100), LNAME VARCHAR2(100), 

       DEPID VARCHAR2(40) NOT NULL, PRIMARY KEY (EMPID)) ;

 

For the department:

CREATE TABLE VGNADMIN.NDDEPARTMENTS

(DEPID VARCHAR2(40) NOT NULL,

DEPNAME VARCHAR2(100),

PRIMARY KEY (DEPID)) ;

 

We define the Content Type "department" with adat source attributes from NDDEPARTMENTS, and then add the additional attributes from NDEMPLOYEES.

We changed the type of the widget for the NDEMPLOYEES.DEPID to relator and match it with NDDEPARTMENTS.DEPID.  We made the widget "nested".  Everything seems OK at this point.

 

When we proceed to creating a content instance, the content properties dialog is opened but displays an error message:

"Failed to marshal relator data A minimum of 1 column objects(s) are required"

 

We are stuck.  We tried with different table design, etc but ended up with the same message over and over again.  

 

Any ideas?

Shilpa Vodapalli

Could you try marking atleast one attribute from the ‘NDEMPLOYEES’ table as SummaryVisible. That’d resolve the error you’re seeing.

 

Thanks,

Shilpa

 

From: eLink Entry: Vignette V7 Web ContentManagement [mailto:v7webcontentmanagement@elinkkc.opentext.com]
Sent: Friday, April 30, 2010 3:15 PM
To: eLink Recipient
Subject: Error creating a content instance with a nested relator widget

 

Error creating a content instance with a nested relator widget

Posted by havva.ozgul@eteration.com (Ozgul, Havva) On 2010/04/30 05:40

 

We are building a site with VCM 7.3.0.5.  We have a content type with a contained 1--to-many relationship.  (i.e.  1 Department  many Employees).  We created the following tables:   For employee: CREATE TABLE VGNADMIN.NDEMPLOYEES    (EMPID VARCHAR2(40) NOT NULL, FNAME VARCHAR2(100), LNAME VARCHAR2(100),         DEPID VARCHAR2(40) NOT NULL, PRIMARY KEY (EMPID)) ;   For the department: CREATE TABLE VGNADMIN.NDDEPARTMENTS (DEPID VARCHAR2(40) NOT NULL, DEPNAME VARCHAR2(100), PRIMARY KEY (DEPID)) ;   We define the Content Type "department" with adat source attributes from NDDEPARTMENTS, and then add the additional attributes from NDEMPLOYEES. We changed the type of the widget for the NDEMPLOYEES.DEPID to relator and match it with NDDEPARTMENTS.DEPID.  We made the widget "nested".  Everything seems OK at this point.   When we proceed to creating a content instance, the content properties dialog is opened but displays an error message: "Failed to marshal relator data A minimum of 1 column objects(s) are required"   We are stuck.  We tried with different table design, etc but ended up with the same message over and over again.     Any ideas?

---

[To post a comment, use the normal reply function]
Forum:	Vignette V7 Web Content Management
Livelink Server:	knowledge-wlweb01