Cybersecurity
DevOps Cloud
IT Operations Cloud
<status event-id="0" level="error" type="driver-general">
<description>Unable to process query. Unable to select row(s) from table/view 'IDM.CLIENTS'. Unsupported SQL type 'java.sql.Types.OTHER'.</description>
<jdbc:document xml:space="preserve"><nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.5.2.20070719 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="IDM.CLIENTS" event-id="0" scope="subtree">
<search-class class-name="IDM.CLIENTS"/>
<search-attr attr-name="CLIENT_ID">
<value timestamp="1186120987#6" type="string">E123456</value>
</search-attr>
<read-attr/>
</query>
</input>
</status>
<sql-type-map>
<type>
<from>OTHER</from>
<to>VARCHAR2</to>
</type>
</sql-type-map>
<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#20070805073814#1#1" level="error" type="driver-general">
<description>Unable to modify object. Unable to update row(s) in table/view 'IDM.WORK_ORDER'. Unsupported SQL type 'java.sql.Types.OTHER'.</description>
<object-dn>O=LAB\OU=APPS\OU=APP\OU=Work Orders\CN=SW_THINCLIENT01-91002</object-dn>
<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#20070805073814#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="1186299494#1">
<association state="associated">PK_WORK_ORDER_NUM=91002,table=WORK_ORDER,schema=IDM</association>
<modify-attr attr-name="INCIDENT_DESCRIPTION">
<add-value>
<value timestamp="1186299494#1" type="string">Ticket Content</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="ACMESMSLES10FS1#20070803062951#1#1" level="error" type="password-set-operation">
<description>Unable to add object. Unable to obtain value(s) from stored procedure '_SMSYSADMIN_.SMSYSGETNEXTECNUMDB'. Unable to write to prepared statement.</description>
<object-dn>O=LAB\OU=EMPLOYEES\OU=NEW\CN=ITEST030</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.2.20070719 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<add class-name="IDM.CLIENTS" event-id="ACMESMSLES10FS1#20070803062951#1#1" jdbc:op-id="0" jdbc:op-type="password-set-operation" jdbc:transaction-id="0" qualified-src-dn="O=LAB\OU=EMPLOYEES\OU=NEW\CN=ITEST030" src-dn="\ACME-LAB\LAB\EMPLOYEES\NEW\ITEST030" src-entry-id="43070" xmlns:jdbc="urn:dirxml:jdbc">
<add-attr attr-name="NOTE">
<value timestamp="1186120974#70" type="string">Work Order Description
This is more description
</value>
</add-attr>
<add-attr attr-name="EMPLOYEESTATUS1">
<value>Active</value>
</add-attr>
<add-attr attr-name="FIRST_NAME">
<value timestamp="1186120974#75" type="string">IDM</value>
</add-attr>
<add-attr attr-name="LAST_NAME">
<value timestamp="1186120974#76" type="string">TEST030</value>
</add-attr>
<password>
<!--content suppressed-->
</password>
</add>
<jdbc:statement event-id="0" jdbc:op-id="0" jdbc:transaction-id="0" jdbc:transaction-type="manual" xmlns:exalt="http://exslt.org/common" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:sql>UPDATE direct.view_usr SET username = 'TEST030{$pk_idu}', loginame = 'TEST030{$pk_idu}' WHERE pk_idu = {$pk_idu}</jdbc:sql>
</jdbc:statement>
<jdbc:statement event-id="1" jdbc:op-id="0" xmlns:exslt="http://exslt.org/common" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:sql>CREATE USER "TEST030{$pk_idu}" IDENTIFIED BY "{$$password}"</jdbc:sql>
</jdbc:statement>
<jdbc:statement event-id="2" jdbc:op-id="0" xmlns:exslt="http://exslt.org/common" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:sql>GRANT CREATE SESSION TO "TEST030{$pk_idu}"</jdbc:sql>
</jdbc:statement>
</input>
</nds></jdbc:document>
<operation-data>
<password-subscribe-status>
<association/>
</password-subscribe-status>
</operation-data>
</status>
</output>
</nds>
<jdbc:statement event-id="0" jdbc:op-id="0" jdbc:transaction-id="0" jdbc:transaction-type="manual" xmlns:exslt="http://exslt.org/common" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:sql>UPDATE direct.view_usr SET username = 'TEST030{$pk_idu}', loginame = 'TEST030{$pk_idu}' WHERE pk_idu = {$pk_idu}</jdbc:sql>
</jdbc:statement>
<jdbc:statement event-id="1" jdbc:op-id="0" xmlns:exslt="http://exslt.org/common" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:sql>CREATE USER "TEST030{$pk_idu}" IDENTIFIED BY "{$$password}"</jdbc:sql>
</jdbc:statement>
<jdbc:statement event-id="2" jdbc:op-id="0" xmlns:exslt="http://exslt.org/common" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:sql>GRANT CREATE SESSION TO "TEST030{$pk_idu}"</jdbc:sql>
</jdbc:statement>
<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 level="warning">The number of parameters declared for stored procedure '_SMSYSADMIN_.SMSYSGETNEXTRECNUMDB' does not match the number of passed parameters. There is/are 2 declared parameter(s) and 1 passed parameter(s).</status>
<status level="warning">Parameter type mismatch detected in stored procedure '_SMSYSADMIN_.SMSYSGETNEXTRECNUMDB'. Parameter 'VALNAME' at index 1 is of type 'IN' and field 'IDM.CLIENTS.PK_SEQUENCE' passed to it is of type 'INOUT'.</status>
<status level="warning">Parameter SQL type mismatch detected in stored procedure '_SMSYSADMIN_.SMSYSGETNEXTRECNUMDB'. Parameter 'VALNAME' at index 1 is of type 'java.sql.Types.OTHER' and field 'IDM.CLIENTS.PK_SEQUENCE' passed to it is of type 'java.sql.Types.DECIMAL'.</status>
<status event-id="0" level="success"></status>
</output>
</nds>
<nds>
<input xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:statement event-id="0">
<jdbc:call-procedure jdbc:name="IDM.IDM_SMSYSGETNEXTRECNUMDB">
<jdbc:param>
<jdbc:value>0</jdbc:value>
</jdbc:param>
</jdbc:call-procedure>
</jdbc:statement>
</input>
</nds>
DirXML: [10/16/07 12:50:00.59]: TRACE: {call IDM.IDM_SMSYSGETNEXTRECNUMDB(?)}
DirXML: [10/16/07 12:50:00.59]: TRACE: IN @ index 1, param 'NEXT_WONUM', field '$1', value = 0
DirXML: [10/16/07 12:50:00.59]: TRACE: OUT @ index 1, param 'NEXT_WONUM', field '$1'
DirXML: [10/16/07 12:50:00.65]: TRACE: OUT @ index 1, param 'NEXT_WONUM', field '$1', value = 363052
DirXML: [10/16/07 12:50:00.65]: TRACE: Remote Loader: SubscriptionShim.execute() returned:
DirXML: [10/16/07 12:50:00.65]: TRACE: <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>
<jdbc:out-parameters event-id="0" jdbc:number-of-params="1">
<jdbc:param jdbc:name="NEXT_WONUM" jdbc:param-type="INOUT" jdbc:position="1" jdbc:sql-type="java.sql.Types.DECIMAL">
<jdbc:value>363052</jdbc:value>
</jdbc:param>
</jdbc:out-parameters>
<status event-id="0" level="success"/>
</output>
</nds>
DirXML: [10/16/07 12:50:00.59]: TRACE: {call IDM.IDM_SMSYSGETNEXTRECNUMDB(?)}
DirXML: [10/16/07 12:50:00.59]: TRACE: IN @ index 1, param 'NEXT_WONUM', field '$1', value = 0
DirXML: [10/16/07 12:50:00.59]: TRACE: OUT @ index 1, param 'NEXT_WONUM', field '$1'
DirXML: [10/16/07 12:50:00.65]: TRACE: OUT @ index 1, param 'NEXT_WONUM', field '$1', value = 363052
<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>
<jdbc:out-parameters event-id="0" jdbc:number-of-params="1">
<jdbc:param jdbc:name="NEXT_WONUM" jdbc:param-type="INOUT" jdbc:position="1" jdbc:sql-type="java.sql.Types.DECIMAL">
<jdbc:value>363052</jdbc:value>
</jdbc:param>
</jdbc:out-parameters>
<status event-id="0" level="success"/>
</output>
</nds>