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 = “XML Schema”>
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=“XQL FAQ (XML Query Language - Frequently Asked Questions)”>
- <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 HRI 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.