We have an issue that is driving me insane, and hope someone can help me with it.
When a DCT is opened an inline call-out retrieves a list of parameters from a database table. The user selects the desired parameters and when completed these parameters are sent back to the same database table, with other content using datadeploy.
It would be very helpful if someone could take a look and let me know if there is syntax error that I am missing. No matter which radio button is selected the deployment fails, deployment log shows [null] for value. This is the only field that has errors after extended testing. When I comment out this callout the deployment runs.
We are on TeamSite 6.1, Open Deploy 6 and a Solaris 8 platform. I did find some references to syntax in both the forms publisher and data deploy manuals but not enough to help me with this.
From Template:
<container name="eventType">
<description>Please select one location for the event </description>
<inline command="/obase/tools/perl/bin/perl /iw-home/TeamSite/local/bin/dev_type_lookup.ipl"/>
</container>
Snippet from dd_deploy_config.xml ( dd deploy script )
<dbschema>
<group name="CORPEVENT" root-group="yes">
<attrmap>
<column name="EVENTTYPE_ID" data-type="NUMBER(19,0)" value-from-field="eventType"/>
</attrmap>
Callout Script (dev_type_lookup.ipl )
my $st = $dbh->prepare($statement);
$st->execute() or die "cannot run query";
my %EventTypeHash;
while (my ($id,$label) = $st->fetchrow)
{
$EventTypeHash{$label} = "$id";
}
$output = "<?xml version='1.0' encoding='UTF-8'?><substitution><item name='eventType'><radio>";
foreach $eventType (sort keys %EventTypeHash) {
$output .= "<option value=\"$EventTypeHash{$eventType}\" label=\"$eventType\"/>\n";
}
#while(
@row = $st->fetchrow_array()) {
# $output .= "<item name='$row[0]'><radio><option value='$row[0]' label='$row[0]'/></radio></item> ";
#}
$output .= "</radio></item></substitution>";
$dbh->disconnect;
print($output);
Error Log DataDeploy:
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 <<< Concatenating database deployment log... >>>
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SerialDaemon dispatch
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| TWorkItem:
oIt --- sock=2345 id=38
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| msg [iwdd=ts-to-db myarea=/iwmnt/washington/main/engine/STAGING myFileList=/iw-home/TeamSite/tmp/deploy_fileList_24430.log cfg=/iw-home/OpenDeployNG/conf/dd_mxp_dev_mevnt_config.xml need-result=yes logfile=/iw-home/OpenDeployNG/log/src.dd_mxp_dev_mevnt_config.ts-to-db.uslcweb03.to.database.log.dd depuuid=37776520-b6f3-11d9-8dd0-a571e82cecb8 leglabel=database]
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| id=38 fDdArgs[0]=[iwdd=ts-to-db]
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| id=38 fDdArgs[1]=[myarea=/iwmnt/washington/main/engine/STAGING]
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| id=38 fDdArgs[2]=[myFileList=/iw-home/TeamSite/tmp/deploy_fileList_24430.log]
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| id=38 fDdArgs[3]=[cfg=/iw-home/OpenDeployNG/conf/dd_mxp_dev_mevnt_config.xml]
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| id=38 fDdArgs[4]=[need-result=yes]
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| id=38 fDdArgs[5]=[logfile=/iw-home/OpenDeployNG/log/src.dd_mxp_dev_mevnt_config.ts-to-db.uslcweb03.to.database.log.dd]
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| id=38 fDdArgs[6]=[depuuid=37776520-b6f3-11d9-8dd0-a571e82cecb8]
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| id=38 fDdArgs[7]=[leglabel=database]
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Database Vendor set to oracle
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column CORPEVENT_ID is VARCHAR2(255)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column TITLE is VARCHAR2(225)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column SYNOPSIS is VARCHAR2(2000)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column PICTUREURL is VARCHAR2(100)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column APPROVED is VARCHAR2(100)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column BEGINDATE is DATE
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column ENDDATE is DATE
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column CREATEDATE is DATE
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column EVENTTYPE_ID is NUMBER(19,0)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column DETAIL is VARCHAR2(2000)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column DATELABEL is VARCHAR2(4000)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column DURATIONLABEL is VARCHAR2(4000)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column LOCATION is VARCHAR2(4000)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| # of columns: 13
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| # of primary key columns specified: 1
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| WARNING:Assuming group name as the table name for [CORPEVENT].
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column CORPEVENT_ID is VARCHAR2(255)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL datatype for column CORPEVENT_AUDIENCE_ID is VARCHAR2(80)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| # of columns: 2
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| # of primary key columns specified: 1
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| WARNING:Assuming group name as the table name for [CORPEVENT_AUDIENCE].
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| # of groups defined in <dbschema> element: 2
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| [Wed Apr 27 02:06:10 MDT 2005] Begin executing ts-to-db
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Area VPath:/iwmnt/washington/main/engine/STAGING
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Setting up TDbSchemaAgent.
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Validating cached connection...
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Cached connection OK
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Connected to [uslcdb01.ut.regence.com:1521:d116]
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWDELTRACKER'
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SELECT * FROM USER_TABLES WHERE TABLE_NAME='CORPEVENT'
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Table [CORPEVENT] exists.
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SELECT * FROM USER_TABLES WHERE TABLE_NAME='CORPEVENT_AUDIENCE'
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Table [CORPEVENT_AUDIENCE] exists.
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Running deployment [ts-to-db]
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| extraction type=full
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| tuple mode=wide
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| area=/iwmnt/washington/main/engine/STAGING
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| filelist=[/iw-home/TeamSite/tmp/deploy_fileList_24430.log]
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| /iwmnt/washington/main/engine/STAGING/templatedata/events/member/data/testOne.xml
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Generate DirectoryContents start:Wed Apr 27 02:06:10 MDT 2005
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Generate DirectoryContents end :Wed Apr 27 02:06:10 MDT 2005
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Generate TDCRTupleProducer start:Wed Apr 27 02:06:10 MDT 2005
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Generate TDCRTupleProducer end :Wed Apr 27 02:06:11 MDT 2005
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Building replicant order column information.
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Building replicant order column information... Done.
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Field : Audience/0/Audience Value: 101
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| TUPLE={location=test, TeamSite/Templating/DCR/Type=events/member, createDate=2005-04-26, synopsis=<p>test</p>
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| , state=Original, beginDate=2005-05-07, Audience/0=, approved=1, eventType/0/eventType=122, dateLabel=2005-04-26, path=templatedata/events/member/data/testOne.xml, eventType/0=, Audience/0/Audience=101, imageURL=/images/events/HealthWellness.Nutrition.gif, endDate=2005-05-08, corpEventId=3230, detail=<p>test</p>
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| , eventTitle=Test , IWOV_PROC_FLAG=true, durationLabel=test, FileName=/templatedata/events/member/data/testOne.xml}
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| TDbSchemaGroupCfg:RowsExistForTuple
ELECT COUNT(*) FROM CORPEVENT WHERE CORPEVENT_ID IN ( ? )
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| TTableSchemaHelper object for [CORPEVENT] found in cache.
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| TTableSchemaHelper object for [CORPEVENT] found in cache.
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| INSERT:INSERT INTO CORPEVENT(CORPEVENT_ID,TITLE,SYNOPSIS,PICTUREURL,APPROVED,BEGINDATE,ENDDATE,CREATEDATE,EVENTTYPE_ID,DETAIL,DATELABEL,DURATIONLABEL,LOCATION) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Column: CORPEVENT_ID, field: corpEventId, Index: 1,Converting '3230' to DECIMAL
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Column: TITLE, field: eventTitle, Index: 2,Converting 'Test ' to VARCHAR
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Column: SYNOPSIS, field: synopsis, Index: 3,Converting '<p>test</p>
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| ' to VARCHAR
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Column: PICTUREURL, field: imageURL, Index: 4,Converting '/images/events/HealthWellness.Nutrition.gif' to VARCHAR
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Column: APPROVED, field: approved, Index: 5,Converting '1' to DECIMAL
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Column: BEGINDATE, field: beginDate, Index: 6,Converting '2005-05-07' to TIMESTAMP
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Column: ENDDATE, field: endDate, Index: 7,Converting '2005-05-08' to TIMESTAMP
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Column: CREATEDATE, field: createDate, Index: 8,Converting '2005-04-26' to TIMESTAMP
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Column: EVENTTYPE_ID, field: eventType, Index: 9,null
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| length of CLOB/LONG data = 12
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD|
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| *******************************************************
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQLException occured in TableSchema:Exists()
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Exception Message: Io exception: Broken pipe
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| Vendor Error Code: 17002
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| SQL state: null
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| *******************************************************
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD|
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| *******STACK TRACE*************
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| java.sql.SQLException: Io exception: Broken pipe
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:496)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:619)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:513)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TableSchema.Exists(TableSchema.java:103)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TableSchema.CreateViaSql(TableSchema.java:274)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.getLobLocator(TDbAgent.java:4411)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.GetClobLocator(TDbAgent.java:4388)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbAgent.convertAndSetParameter(TDbAgent.java:4208)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1264)
ENG: 2005-04-27 02:06:11 MDT GMT-06:00 DD| at com.interwoven.dd100.
