Application Delivery Management
Application Modernization & Connectivity
CyberRes
IT Operations Management
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070626_0243" instance="APP-JDBC" version="3.5.1">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status event-id="ACMESMSLES10FS1#20070805072520#1#1" level="error" type="app-general">
<description>Unable to modify object. Unable to update row(s) in table/view 'IDM.WORK_ORDER'. Unable to write to prepared statement.</description>
<object-dn>O=LAB\OU=APPS\OU=APP\OU=Work Orders\CN=SW_THINCLIENT01-91002</object-dn>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="17004">
<jdbc:message>Invalid column type</jdbc:message>
</jdbc:exception>
<jdbc:document xml:space="preserve"><nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.5.0.20070315 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<modify class-name="IDM.WORK_ORDER" event-id="ACMESMSLES10FS1#20070805072520#1#1" qualified-src-dn="O=LAB\OU=APPS\OU=APP\OU=Work Orders\CN=SW_THINCLIENT01-91002" src-dn="\ACME-LAB\LAB\APPS\APP\Work Orders\SW_THINCLIENT01-91002" src-entry-id="46560" timestamp="1186298720#2">
<association state="associated">PK_WORK_ORDER_NUM=91002,table=WORK_ORDER,schema=IDM</association>
<modify-attr attr-name="INCDENT_DESCRIPTION">
<remove-all-values/>
<add-value>
<value/>
</add-value>
</modify-attr>
</modify>
</input>
</nds></jdbc:document>
</status>
</output>
</nds>
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070626_0243" instance="APP-JDBC" version="3.5.1">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status event-id="0" level="warning">Table 'WORK_ORDER_DETAIL' is undefined or not a parent table.</status>
<status event-id="0" level="success"></status>
</output>
</nds>
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070626_0243" instance="APP-JDBC" version="3.5.1">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status event-id="" level="error" type="app-general">
<description>An error occurred executing statement "INSERT INTO IDM.CLIENTS (NOTE,PK_SEQUENCE,INACTIVE,EMPLOYEESTATUS1,CLIENTFUNCTGROUPS,LASTMODIFIED,FIRST_NAME,LAST_NAME) VALUES ('TEST NOTE',91052,0,'Active','F00BAA','20070812024109832','IDM','TESTb 030')".</description>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="1861" jdbc:sql-state="22008">
<jdbc:message>ORA-01861: literal does not match format string
</jdbc:message>
</jdbc:exception>
<jdbc:document xml:space="preserve"><nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.5.0.20070315 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<jdbc:statement xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:sql>INSERT INTO IDM.CLIENTS (NOTE,PK_SEQUENCE,INACTIVE,EMPLOYEESTATUS1,CLIENTFUNCTGROUPS,LASTMODIFIED,FIRST_NAME,LAST_NAME) VALUES ('TEST NOTE',91052,0,'Active','F00BAA','20070812024109832','IDM','TESTb 030')</jdbc:sql>
</jdbc:statement>
<add class-name="IDM.CLIENTS" event-id="ACMESMSLES10FS1#20070812074106#1#1" qualified-src-dn="O=LAB\OU=EMPLOYEES\OU=ACTIVE\CN=ITEST030" src-dn="\ACME-LAB\LAB\EMPLOYEES\ACTIVE\ITEST030" src-entry-id="46577">
<password>
<!--content suppressed-->
</password>
</add>
</input>
</nds></jdbc:document>
</status>
</output>
</nds>
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070626_0243" instance="APP-JDBC" version="3.5.1">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status event-id="" level="error" type="app-general">
<description>An error occurred executing statement "INSERT INTO IDM.CLIENTS (NOTE,PK_SEQUENCE,INACTIVE,EMPLOYEESTATUS1,CLIENT_ID,EMPLOYEETYPE1,RANK1,CLIENTFUNCTGROUPS,LASTMODIFIED,FIRST_NAME,LAST_NAME) VALUES ('TEST NOTE',91056,0,'Active','V053493','Contractor','Associate','F00BAA','12-Aug-07','IDM','TEST 030')".</description>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="1" jdbc:sql-state="23000">
<jdbc:message>ORA-00001: unique constraint (_SMDBA_.PK_CUSTOMER_) violated
</jdbc:message>
</jdbc:exception>
<jdbc:document xml:space="preserve"><nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.5.0.20070315 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<jdbc:statement xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:sql>INSERT INTO IDM.CLIENTS (NOTE,PK_SEQUENCE,INACTIVE,EMPLOYEESTATUS1,CLIENT_ID,EMPLOYEETYPE1,RANK1,CLIENTFUNCTGROUPS,LASTMODIFIED,FIRST_NAME,LAST_NAME) VALUES ('TEST NOTE',91056,0,'Active','V053493','Contractor','Associate','F00BAA','12-Aug-07','IDM','TEST 030')</jdbc:sql>
</jdbc:statement>
<add class-name="IDM.CLIENTS" event-id="ACMESMSLES10FS1#20070812104448#1#1" qualified-src-dn="O=LAB\OU=EMPLOYEES\OU=ACTIVE\CN=ITEST030" src-dn="\ACME-LAB\LAB\EMPLOYEES\ACTIVE\ITEST030" src-entry-id="46577">
<password>
<!--content suppressed-->
</password>
</add>
</input>
</nds></jdbc:document>
</status>
</output>
</nds>
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070626_0243" instance="APP-JDBC" version="3.5.1">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status event-id="" level="error" type="app-general">
<description>An error occurred executing statement "INSERT INTO IDM.WORK_ORDER_DETAILS (PK_SEQUENCE, WO_NUM, DESCRIPTION, NOTE, LASTMODIFIED, SEQ_GROUP, INACTIVE, DURATION, ACTION_ID, LASTUSER) VALUES ('419577', '91034', 'The IDM process encountered an error', 'The IDM process encountered the following error: successful.', '20070811093017345', '1061', '0', '1', 'IDMNOTE', 'IDMSCRPT')".</description>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="1776" jdbc:sql-state="42000">
<jdbc:message>ORA-01776: cannot modify more than one base table through a join view
</jdbc:message>
</jdbc:exception>
<jdbc:document xml:space="preserve"><nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.5.0.20070315 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<jdbc:statement jdbc:transaction-id="1" jdbc:transaction-type="manual" jdbc:type="update" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:sql>INSERT INTO IDM.WORK_ORDER_DETAILS (PK_SEQUENCE, WO_NUM, DESCRIPTION, NOTE, LASTMODIFIED, SEQ_GROUP, INACTIVE, DURATION, ACTION_ID, LASTUSER) VALUES ('419577', '91034', 'The IDM process encountered an error', 'The IDM process encountered the following error: successful.', '20070811093017345', '1061', '0', '1', 'IDMNOTE', 'IDMSCRPT')</jdbc:sql>
<jdbc:sql>UPDATE IDM.WORK_ORDER SET SEQ_GROUP = '1023' WHERE PK_WORK_ORDER_NUM = '91034'</jdbc:sql>
<jdbc:sql/>
</jdbc:statement>
<modify class-name="IDM.WORK_ORDER" event-id="ACMESMSLES10FS1#20070811143011#1#1" qualified-src-dn="O=LAB\OU=APPS\OU=APP\OU=Work Orders\CN=SW_THINCLIENT05-91034" src-dn="\ACME-LAB\LAB\APPS\APP\Work Orders\SW_THINCLIENT05-91034" src-entry-id="46629" timestamp="1186842611#2">
<association state="associated">PK_WORK_ORDER_NUM=91034,table=WORK_ORDER,schema=IDM</association>
</modify>
</input>
</nds></jdbc:document>
</status>
</output>
</nds>
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070626_0243" instance="APP-JDBC" version="3.5.1">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status event-id="" level="error" type="app-general">
<description>An error occurred executing statement "INSERT INTO IDM.WORK_ORDER_DETAILS (PK_SEQUENCE, WO_NUM, DESCRIPTION, NOTE, LASTMODIFIED, SEQ_GROUP, INACTIVE, DURATION, SEQ_ACTION, LASTUSER) VALUES ('419616', '91064', 'Work Order Complete', 'The IDM process successfully completed the Work Order.', '20070813055213722', '1061', '0', '1', '15, 'IDMSCRPT')".</description>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="917" jdbc:sql-state="42000">
<jdbc:message>ORA-00917: missing comma
</jdbc:message>
</jdbc:exception>
<jdbc:document xml:space="preserve"><nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.5.0.20070315 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<jdbc:statement jdbc:transaction-id="2" jdbc:transaction-type="manual" jdbc:type="update" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:sql>INSERT INTO IDM.WORK_ORDER_DETAILS (PK_SEQUENCE, WO_NUM, DESCRIPTION, NOTE, LASTMODIFIED, SEQ_GROUP, INACTIVE, DURATION, SEQ_ACTION, LASTUSER) VALUES ('419616', '91064', 'Work Order Complete', 'The IDM process successfully completed the Work Order.', '20070813055213722', '1061', '0', '1', '15, 'IDMSCRPT')</jdbc:sql>
<jdbc:sql>UPDATE IDM.WORK_ORDER SET INCIDENT_RESOLUTION = '' WHERE PK_WORK_ORDER_NUM = '91064'</jdbc:sql>
<jdbc:sql>UPDATE IDM.WORK_ORDER SET SEQ_CLOSED_BY = '1749' WHERE PK_WORK_ORDER_NUM = '91064'</jdbc:sql>
<jdbc:sql>UPDATE IDM.WORK_ORDER SET SEQ_UDSTATUS ='2' WHERE PK_WORK_ORDER_NUM = '91064'</jdbc:sql>
</jdbc:statement>
<modify class-name="IDM.WORK_ORDER" event-id="ACMESMSLES10FS1#20070813105207#1#1" qualified-src-dn="O=LAB\OU=APPS\OU=APP\OU=Work Orders\CN=SW_THINCLIENT01-91064" src-dn="\ACME-LAB\LAB\APPS\APP\Work Orders\SW_THINCLIENT01-91064" src-entry-id="46634" timestamp="1187002327#1">
<association state="associated">PK_WORK_ORDER_NUM=91064,table=WORK_ORDER,schema=IDM</association>
</modify>
</input>
</nds></jdbc:document>
</status>
</output>
</nds>
<jdbc:sql>INSERT INTO IDM.WORK_ORDER_DETAILS (PK_SEQUENCE, WO_NUM, DESCRIPTION, NOTE, LASTMODIFIED, SEQ_GROUP, INACTIVE, DURATION, SEQ_ACTION, LASTUSER) VALUES ('419616', '91064', 'Work Order Complete', 'The IDM process successfully completed the Work Order.', '20070813055213722', '1061', '0', '1', '15, 'IDMSCRPT')</jdbc:sql>
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070626_0243" instance="APP-JDBC" version="3.5.1">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status event-id="" level="error" type="app-general">
<description>An error occurred executing statement "INSERT INTO IDM.WORK_ORDER_DETAILS (PK_SEQUENCE, WO_NUM, DESCRIPTION, NOTE, LASTMODIFIED, SEQ_GROUP, INACTIVE, DURATION, SEQ_ACTION, LASTUSER) VALUES ('419631', '91067', 'Forwarded WO to Group NOC', 'The IDM process encountered the following error: test closing', '13-Aug-07 09:03:13', '1061', '0', '1', '16', 'IDMSCRPT')".</description>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="1830" jdbc:sql-state="22008">
<jdbc:message>ORA-01830: date format picture ends before converting entire input string
</jdbc:message>
</jdbc:exception>
<jdbc:document xml:space="preserve"><nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.5.0.20070315 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<jdbc:statement jdbc:transaction-id="3" jdbc:transaction-type="manual" jdbc:type="update" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:sql>INSERT INTO IDM.WORK_ORDER_DETAILS (PK_SEQUENCE, WO_NUM, DESCRIPTION, NOTE, LASTMODIFIED, SEQ_GROUP, INACTIVE, DURATION, SEQ_ACTION, LASTUSER) VALUES ('419631', '91067', 'Forwarded WO to Group NOC', 'The IDM process encountered the following error: test closing', '13-Aug-07 09:03:13', '1061', '0', '1', '16', 'IDMSCRPT')</jdbc:sql>
<jdbc:sql>UPDATE IDM.WORK_ORDER SET SEQ_GROUP = '1023' WHERE PK_WORK_ORDER_NUM = '91067'</jdbc:sql>
<jdbc:sql/>
</jdbc:statement>
<modify class-name="IDM.WORK_ORDER" event-id="ACMESMSLES10FS1#20070813140313#1#1" qualified-src-dn="O=LAB\OU=APPS\OU=APP\OU=Work Orders\CN=SW_THINCLIENT01-91067" src-dn="\ACME-LAB\LAB\APPS\APP\Work Orders\SW_THINCLIENT01-91067" src-entry-id="46637" timestamp="1187013793#2">
<association state="associated">PK_WORK_ORDER_NUM=91067,table=WORK_ORDER,schema=IDM</association>
</modify>
</input>
</nds></jdbc:document>
</status>
</output>
</nds>
INSERT INTO SCHEMA.TABLE (PK_SEQUENCE, MODIFIEDDATE) VALUES ('123456', to_date('timestring', 'format string').
to_date('12/22/2007 11:11:23', 'MM/DD/YYYY HH24:MI:SS')
<token-text xml:space="preserve">to_date('</token-text>
<token-time format="MM/dd/yyyy hh:mm:ss" tz="EST"/>
<token-text xml:space="preserve">', 'MM/DD/YYYY HH24:MI:SS')</token-text>
<do-append-xml-text expression="/nds/input/jdbc:statement/jdbc:sql[1]">
<arg-string>
<token-text xml:space="preserve">INSERT INTO IDM.WORK_ORDER_DETAILS </token-text>
<token-text xml:space="preserve">(PK_SEQUENCE, WO_NUM, DESCRIPTION, NOTE, LASTMODIFIED, SEQ_GROUP, INACTIVE, DURATION, SEQ_ACTION, LASTUSER, FROM_GROUP) VALUES ('</token-text>
<token-local-variable name="next-sequence"/>
<token-text xml:space="preserve">', '</token-text>
<token-attr name="DirXML-nwoWorkOrderNumber"/>
<token-text xml:space="preserve">', 'Closed WO # </token-text>
<token-attr name="DirXML-nwoWorkOrderNumber"/>
<token-text xml:space="preserve">', 'The IDM process successfully completed the Work Order.', to_date('</token-text>
<token-time format="MM/dd/yyyy hh:mm:ss" tz="EST"/>
<token-text xml:space="preserve">', 'MM/DD/YYYY HH24:MI:SS'), '</token-text>
<token-text xml:space="preserve">', '0', '1', '15', 'IDMUSER','NOVELL-IDM')</token-text>
</arg-string>