Unique Server Extension

I am at a loss right now. I can’t get the unique server to work properly, or to define a document that conforms to the TSD…which one is still beyond me.

I am running Tamino 4.1.4 with the 208 Hotfix and the unique Server extensions. I made a simple TSD:

<?xml version = "1.0" encoding = "UTF-8"?>

<xs:schema xmlns:tsd = “http://namespaces.softwareag.com/tamino/TaminoSchemaDefinition” xmlns:xs = “http://www.w3.org/2001/XMLSchema”>
xs:annotation
xs:appinfo
<tsd:schemaInfo name = “Company”>
<tsd:collection name = “Company”></tsd:collection>
<tsd:doctype name = “company”>
tsd:logical
tsd:contentclosed</tsd:content>
</tsd:logical>
</tsd:doctype>
</tsd:schemaInfo>
</xs:appinfo>
</xs:annotation>
xs:annotation
xs:appinfo
<tse:schemaExtension xmlns:tse = “http://namespaces.softwareag.com/tamino/TaminoSchemaExtension”>
<tse:doctype name = “company”>
<tse:unique name = “DepNo-key”>
<tse:field xpath = “DepNo”></tse:field>
</tse:unique>
</tse:doctype>
</tse:schemaExtension>
</xs:appinfo>
</xs:annotation>
<xs:element name = “company”>
xs:annotation
xs:appinfo
tsd:elementInfo
tsd:logical
tsd:trigger
<tsd:onInsert type = “action”>UniqueConstraintSXS.onInsert</tsd:onInsert>
<tsd:onUpdate type = “action”>UniqueConstraintSXS.onUpdate</tsd:onUpdate>
</tsd:trigger>
</tsd:logical>
tsd:physical
tsd:native
tsd:index
tsd:standard</tsd:standard>
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:elementInfo>
</xs:appinfo>
</xs:annotation>
xs:complexType
xs:sequence
<xs:element name = “department”>
xs:complexType
xs:sequence
<xs:element name = “DepNo” type = “xs:integer”>
xs:annotation
xs:appinfo
tsd:elementInfo
tsd:physical
tsd:native
tsd:index
tsd:standard</tsd:standard>
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:elementInfo>
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name = “DepName” type = “xs:string”></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

When I try to insert a document (and I did not insert anything yet at this point), I get the following error message:

<?xml version="1.0" encoding="windows-1252" ?>
  • <ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“http://metalab.unc.edu/xql/”>
  • <ino:message ino:returnvalue=“0”>
    ino:messagelinedocument processing started</ino:messageline>
    </ino:message>
  • <ino:message ino:returnvalue=“7126”>
    <ino:messagetext ino:code=“INOSXE7126”>Server extension failed</ino:messagetext>
    ino:messagelineINOSXE7055: The server extension threw exception "9202 Unique Constraint Violated: Document type company with ino:id=“1” cannot be inserted because of the following constraint violations: "</ino:messageline>
    </ino:message>
    </ino:response>

My document looks like:

<?xml version="1.0" encoding="UTF-8"?> 15 HR

I tried to submit the document before without the unique server constraint and it works fine. I defined the triggers at different places before and it never worked.

Please, somebody point out to me what I’m doing wrong. Thank you.