Showing posts with label message. Show all posts
Showing posts with label message. Show all posts

Wednesday, March 28, 2012

invalied length parameter passed the substring function

Does anyone know what the above error message means?What length did you pass to substring?|||What do you mean, what length...|||From the SQL Server Books Online (a.k.a. BOL):

SUBSTRING
Returns part of a character, binary, text, or image expression. For more information about the valid Microsoft SQL Server data types that can be used with this function, see Data Types.

Syntax
SUBSTRING ( expression , start , length )

Arguments
....|||DECLARE @.x int, @.y int, @.z varchar(8000)

-- This works
SELECT @.x = 47, @.y = 22, @.z = 'Even if God Almighty, points his finger at us, It just Doesnt matter'
SELECT SUBSTRING(@.z,@.x,@.y)

-- This works in SQL Server...DB2's head would explode though since it's out of range
SELECT @.x = 47, @.y = 8000
SELECT SUBSTRING(@.z,@.x,@.y)

-- Same as the above...really doesn't make a whole lot of sense though
SELECT @.x = 47, @.y = 0
SELECT SUBSTRING(@.z,@.x,@.y)

-- So the Only thing that doesn't work is a negative...but the way sql works...probably could have allowed it
-- Would have been neat to go to the left in the string for negative nymbers
SELECT @.x = 47, @.y = -1
SELECT SUBSTRING(@.z,@.x,@.y)

EDIT: Oh, most likely you have code that's deriving the length..post the code and we can figure it out...

invalid value for 'table' on 'relationship'

I'm using sqlxml3.0 to load a schema file. I cannot, for the life of me,
figure out why I keep getting this error message "-2147467259 Schema:
invalid value for 'table' on 'relationship'".
If anyone can offer the path to a solution it would be most appreciated.
Thanks
Schema:
Here is the schema:
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xs:annotation>
<xs:appinfo>
<sql:relationship name="relactionstep1" child="step1" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relactionpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reladjustproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relc_statementcrittech" child="crittech"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relc_statementreasondate" child="reasondate"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relc_statementreleaseagent" child="releaseagent"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relcalibrationproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relcautiontrim_para" child="trim_para"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relcheckstepstep1" child="step1" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relcheckstepindication" child="indication"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relcheckstepaction" child="action"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relcleanproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relcomp-itemtitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relcomp-itempara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relcpcdatapara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reldefpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reldeflistterm_def" child="term_def"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reldescwpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reldescwpeqpinfo" child="eqpinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reldescwplocdesc" child="locdesc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reldescwpeqpdata" child="eqpdata"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reldestrpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reldestructmatpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reldistc_statement" child="c_statement"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="releicnomensysnomen" child="sysnomen"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="releirpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="releqpdatatitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="releqpdatapara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="releqpdesctitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="releqpdescpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="releqpinfoeqpdesc" child="eqpdesc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relexportpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relfiguretitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relfiguregraphic" child="graphic"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relframed_frntloepwp" child="loepwp"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relframed_frntfrntcover" child="frntcover"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relframed_frntcontents" child="contents"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relframed_frnthowtouse" child="howtouse"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relframed_manualframed_frnt" child="framed_frnt"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relframed_manualgim" child="gim" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relframed_manualtim" child="tim" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relframed_manualmim" child="mim" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relframed_manualsim" child="sim" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relframed_manualda2028" child="da2028"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relfrntcovertmtitle" child="tmtitle"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relfrntcovergraphic" child="graphic"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relfrntcovernotices" child="notices"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relfrntcoverservnomen" child="servnomen"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relgen_maintwpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relgen_maintwpwpinfo" child="wpinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relgen_maintwpproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relgen_maintwpmaintsk" child="maintsk"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relgeninfotitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relgeninfopara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relgeninfospecpara" child="specpara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relgimtitlepg" child="titlepg" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relgimginfowp" child="ginfowp" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relgimdescwp" child="descwp" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relginfowpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relginfowpscope" child="scope" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relginfowpmfrr" child="mfrr" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relginfowpeir" child="eir" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relginfowpcpcdata" child="cpcdata"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relginfowpodsdata" child="odsdata"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relginfowpdestructmat" child="destructmat"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relginfowppssref" child="pssref" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relginfowpwrntyref" child="wrntyref"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relginfowpnomenreflist" child="nomenreflist"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relhowtouseproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relidentnopartno" child="partno" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relidentnocageno" child="cageno" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relindicationstep1" child="step1"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relindicationsubtitle" child="subtitle"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relindicationpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relinspinstitmsubtitle" child="subtitle"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relinspinstitmpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relinspinstitmspecpara" child="specpara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relinstallproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relinternetemail" child="email" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relintrotitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relintropara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relintroparatitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relintroparapara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="rellocdesccomp-item" child="comp-item"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relloepwpnote" child="note" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relloepwprev_date" child="rev_date"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relloepwppara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relloepwprev_chg" child="rev_chg"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="rellubeproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintskservice" child="service"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskinspinstitm" child="inspinstitm"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskclean" child="clean" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintskcaution" child="caution"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskwarning" child="warning"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskremove" child="remove" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintskrepair-rplc" child="repair-rplc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintsklube" child="lube" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintsknote" child="note" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintskprepforuse" child="prepforuse"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskadjust" child="adjust" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintskinstall" child="install"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskcalibration" child="calibration"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskservice" child="service"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintskremove" child="remove" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintskrepair-rplc" child="repair-rplc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintwpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintwpwpinfo" child="wpinfo" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintwpgeninfo" child="geninfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintwpwarning" child="warning"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmaintwpnote" child="note" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmaintwpmaintsk" child="maintsk"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmfrrpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmimtitlepg" child="titlepg" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmimpmcsintrowp" child="pmcsintrowp"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmimpmcswp" child="pmcswp" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmimgen_maintwp" child="gen_maintwp"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relmimmaintwp" child="maintwp" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relmrplpartpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relnomenreflistpara" child="para"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relnotetrim_para" child="trim_para"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relnoticesdist" child="dist" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relnoticesexport" child="export" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relnoticesdestr" child="destr" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relodsdatapara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relopcheck-tsproctitle" child="title"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relopcheck-tsproctestproc" child="testproc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relopcheck-tswpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relopcheck-tswpwpinfo" child="wpinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relopcheck-tswpintro" child="intro"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relopcheck-tswpproc" child="proc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relopcheck-tswpopcheck-tsproc"
child="opcheck-tsproc" parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relparaemphasis" child="emphasis"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relparainternet" child="internet"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relparafigure" child="figure" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relparaxref" child="xref" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relpararandlist" child="randlist"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relparaseqlist" child="seqlist" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relparanull" child="null" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relparadeflist" child="deflist" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relpersnreqpersnreq-setup-item"
child="persnreq-setup-item" parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpersnreq-setup-itemname" child="name"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpmcsintrowpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpmcsintrowpintropara" child="intropara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpmcswpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpmcswpwpinfo" child="wpinfo" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relpmcswpmrplpart" child="mrplpart"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relprepforuseproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relproctitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relprocnote" child="note" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relprocpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relproccaution" child="caution" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relprocstep1" child="step1" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relproductionframed_manual" child="framed_manual"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relprtitlesysnomen" child="sysnomen"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpssrefpara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relpublisttitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relpublistpubident" child="pubident"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relpublistname" child="name" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrandlistitem" child="item" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrefref-setup-item" child="ref-setup-item"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relref-setup-itemextref" child="extref"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relrefwpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relrefwpscope" child="scope" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrefwppublist" child="publist" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relremovefigure" child="figure" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relremoveproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrepair-rplcproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrev_chgwpno" child="wpno" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrev_chgrev_no" child="rev_no" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrev_datetitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relrev_daterev_no" child="rev_no"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relrev_datedate" child="date" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relscopepara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relseqlistitem" child="item" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relservicesubtitle" child="subtitle"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relservicespecpara" child="specpara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relservicepara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relserviceproc" child="proc" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relsimtitlepg" child="titlepg" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relsimrefwp" child="refwp" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relspecparawarning" child="warning"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relspecparacaution" child="caution"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relspecparanote" child="note" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relspecparapara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep1para" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep1specpara" child="specpara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relstep1step2" child="step2" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep2para" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep2step3" child="step3" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep2specpara" child="specpara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relstep3para" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep3step4" child="step4" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relstep3specpara" child="specpara"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relstep4para" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relsysnomenname" child="name" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relsysnomeneic" child="eic" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relterm_defterm" child="term" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relterm_defdef" child="def" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reltesteqptesteqp-setup-item"
child="testeqp-setup-item" parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltesteqp-setup-itemname" child="name"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltesteqp-setup-itemidentno" child="identno"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltestproccheckstep" child="checkstep"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltimtitlepg" child="titlepg" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reltimtsintrowp" child="tsintrowp"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltimtsindxwp" child="tsindxwp" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reltimopcheck-tswp" child="opcheck-tswp"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltitlepgname" child="name" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reltminfonotmno" child="tmno" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reltmtitletminfono" child="tminfono"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltmtitleprtitle" child="prtitle"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltoolstools-setup-item" child="tools-setup-item"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltools-setup-itemname" child="name"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltools-setup-itemidentno" child="identno"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relts-categorytitle" child="title"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relts-categorytsindx-entry" child="tsindx-entry"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsindxts-category" child="ts-category"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsindx-entrymalfunc" child="malfunc"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsindx-entryxref" child="xref"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsindxwpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsindxwpgeninfo" child="geninfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsindxwptsindx" child="tsindx"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsintrowpwpidinfo" child="wpidinfo"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="reltsintrowptitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="reltsintrowppara" child="para" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relwarningtrim_para" child="trim_para"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relwpidinfomaintlvl" child="maintlvl"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relwpidinfoeicnomen" child="eicnomen"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relwpidinfotitle" child="title" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relwpinfotools" child="tools" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relwpinfotesteqp" child="testeqp"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relwpinfopersnreq" child="persnreq"
parent-key="key_id" child-key="parent_id"/>
<sql:relationship name="relwpinfonull" child="null" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relwpinforef" child="ref" parent-key="key_id"
child-key="parent_id"/>
<sql:relationship name="relwrntyrefpara" child="para" parent-key="key_id"
child-key="parent_id"/>
</xs:appinfo>
</xs:annotation>
<xs:element name="action" sql:relation="action">
<xs:complexType>
<xs:choice>
<xs:element ref="step1" maxOccurs="unbounded" sql:relation="step1"
sql:relationship="relactionstep1"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="relactionpara"/>
</xs:choice>
</xs:complexType>
</xs:element>
<xs:element name="adjust" sql:relation="adjust">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" sql:relation="proc"
sql:relationship="reladjustproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="c_statement" sql:relation="c_statement">
<xs:complexType>
<xs:sequence>
<xs:element ref="crittech" sql:relation="crittech"
sql:relationship="relc_statementcrittech"/>
<xs:element ref="reasondate" sql:relation="reasondate"
sql:relationship="relc_statementreasondate"/>
<xs:element ref="releaseagent" sql:relation="releaseagent"
sql:relationship="relc_statementreleaseagent"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="cageno" sql:relation="cageno">
<xs:complexType/>
</xs:element>
<xs:element name="calibration" sql:relation="calibration">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" maxOccurs="unbounded" sql:relation="proc"
sql:relationship="relcalibrationproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="caution" sql:relation="caution">
<xs:complexType>
<xs:sequence>
<xs:element ref="trim_para" maxOccurs="unbounded" sql:relation="trim_para"
sql:relationship="relcautiontrim_para"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="checkstep" sql:relation="checkstep">
<xs:complexType>
<xs:sequence>
<xs:element ref="step1" maxOccurs="unbounded" sql:relation="step1"
sql:relationship="relcheckstepstep1"/>
<xs:element ref="indication" sql:relation="indication"
sql:relationship="relcheckstepindication"/>
<xs:element ref="action" sql:relation="action"
sql:relationship="relcheckstepaction"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="clean" sql:relation="clean">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" maxOccurs="unbounded" sql:relation="proc"
sql:relationship="relcleanproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="comp-item" sql:relation="comp-item">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relcomp-itemtitle"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="relcomp-itempara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="contents" sql:relation="contents">
<xs:complexType/>
</xs:element>
<xs:element name="cpcdata" sql:relation="cpcdata">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" maxOccurs="unbounded" sql:relation="para"
sql:relationship="relcpcdatapara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="crittech" sql:relation="crittech">
<xs:complexType/>
</xs:element>
<xs:element name="da2028" sql:relation="da2028">
<xs:complexType/>
</xs:element>
<xs:element name="date" sql:relation="date" type="xs:string"/>
<xs:element name="def" sql:relation="def">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para" sql:relationship="reldefpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="deflist" sql:relation="deflist">
<xs:complexType>
<xs:sequence>
<xs:element ref="term_def" maxOccurs="unbounded" sql:relation="term_def"
sql:relationship="reldeflistterm_def"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="descwp" sql:relation="descwp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="reldescwpwpidinfo"/>
<xs:element ref="eqpinfo" sql:relation="eqpinfo"
sql:relationship="reldescwpeqpinfo"/>
<xs:element ref="locdesc" sql:relation="locdesc"
sql:relationship="reldescwplocdesc"/>
<xs:element ref="eqpdata" sql:relation="eqpdata"
sql:relationship="reldescwpeqpdata"/>
</xs:sequence>
<xs:attribute name="wpno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="destr" sql:relation="destr">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para" sql:relationship="reldestrpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="destructmat" sql:relation="destructmat">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" maxOccurs="unbounded" sql:relation="para"
sql:relationship="reldestructmatpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="dist" sql:relation="dist">
<xs:complexType>
<xs:sequence>
<xs:element ref="c_statement" sql:relation="c_statement"
sql:relationship="reldistc_statement"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="eic" sql:relation="eic" type="xs:string"/>
<xs:element name="eicnomen" sql:relation="eicnomen">
<xs:complexType>
<xs:sequence>
<xs:element ref="sysnomen" sql:relation="sysnomen"
sql:relationship="releicnomensysnomen"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="eir" sql:relation="eir">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para" sql:relationship="releirpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="email" sql:relation="email">
<xs:complexType>
<xs:attribute name="address" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="emphasis" sql:relation="emphasis">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="emph" type="xs:string" use="required"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="eqpdata" sql:relation="eqpdata">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="releqpdatatitle"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="releqpdatapara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="eqpdesc" sql:relation="eqpdesc">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="releqpdesctitle"/>
<xs:element ref="para" maxOccurs="unbounded" sql:relation="para"
sql:relationship="releqpdescpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="eqpinfo" sql:relation="eqpinfo">
<xs:complexType>
<xs:sequence>
<xs:element ref="eqpdesc" maxOccurs="unbounded" sql:relation="eqpdesc"
sql:relationship="releqpinfoeqpdesc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="export" sql:relation="export">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para"
sql:relationship="relexportpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="extref" sql:relation="extref">
<xs:complexType>
<xs:attribute name="docno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="figure" sql:relation="figure">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relfiguretitle"/>
<xs:element ref="graphic" sql:relation="graphic"
sql:relationship="relfiguregraphic"/>
</xs:sequence>
<xs:attribute name="label" use="required" type="xs:string"/>
<xs:attribute name="id"/>
<xs:attribute name="config" type="xs:string"/>
</xs:complexType>
</xs:element>
<xs:element name="framed_frnt" sql:relation="framed_frnt">
<xs:complexType>
<xs:sequence>
<xs:element ref="loepwp" sql:relation="loepwp"
sql:relationship="relframed_frntloepwp"/>
<xs:element ref="frntcover" sql:relation="frntcover"
sql:relationship="relframed_frntfrntcover"/>
<xs:element ref="contents" sql:relation="contents"
sql:relationship="relframed_frntcontents"/>
<xs:element ref="howtouse" sql:relation="howtouse"
sql:relationship="relframed_frnthowtouse"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="framed_manual" sql:relation="framed_manual">
<xs:complexType>
<xs:sequence>
<xs:element ref="framed_frnt" sql:relation="framed_frnt"
sql:relationship="relframed_manualframed_frnt"/>
<xs:element ref="gim" sql:relation="gim"
sql:relationship="relframed_manualgim"/>
<xs:element ref="tim" sql:relation="tim"
sql:relationship="relframed_manualtim"/>
<xs:element ref="mim" sql:relation="mim"
sql:relationship="relframed_manualmim"/>
<xs:element ref="sim" sql:relation="sim"
sql:relationship="relframed_manualsim"/>
<xs:element ref="da2028" sql:relation="da2028"
sql:relationship="relframed_manualda2028"/>
</xs:sequence>
<xs:attribute name="revno" type="xs:string" use="required"/>
<xs:attribute name="maintitl" type="xs:string" use="required"/>
<xs:attribute name="maintlvls" type="xs:string" use="required"/>
<xs:attribute name="currentasof" type="xs:string" use="required"/>
<xs:attribute name="date" type="xs:string" use="required"/>
<xs:attribute name="pubno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="frntcover" sql:relation="frntcover">
<xs:complexType>
<xs:sequence>
<xs:element ref="tmtitle" sql:relation="tmtitle"
sql:relationship="relfrntcovertmtitle"/>
<xs:element ref="graphic" sql:relation="graphic"
sql:relationship="relfrntcovergraphic"/>
<xs:element ref="notices" sql:relation="notices"
sql:relationship="relfrntcovernotices"/>
<xs:element ref="servnomen" sql:relation="servnomen"
sql:relationship="relfrntcoverservnomen"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="gen_maintwp" sql:relation="gen_maintwp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relgen_maintwpwpidinfo"/>
<xs:element ref="wpinfo" sql:relation="wpinfo"
sql:relationship="relgen_maintwpwpinfo"/>
<xs:element ref="proc" minOccurs="0" sql:relation="proc"
sql:relationship="relgen_maintwpproc"/>
<xs:element ref="maintsk" minOccurs="0" sql:relation="maintsk"
sql:relationship="relgen_maintwpmaintsk"/>
</xs:sequence>
<xs:attribute name="wpno" use="required">
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="geninfo" sql:relation="geninfo">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relgeninfotitle"/>
<xs:element ref="para" minOccurs="0" maxOccurs="unbounded"
sql:relation="para" sql:relationship="relgeninfopara"/>
<xs:element ref="specpara" minOccurs="0" sql:relation="specpara"
sql:relationship="relgeninfospecpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="gim" sql:relation="gim">
<xs:complexType>
<xs:sequence>
<xs:element ref="titlepg" sql:relation="titlepg"
sql:relationship="relgimtitlepg"/>
<xs:element ref="ginfowp" sql:relation="ginfowp"
sql:relationship="relgimginfowp"/>
<xs:element ref="descwp" sql:relation="descwp"
sql:relationship="relgimdescwp"/>
</xs:sequence>
<xs:attribute name="tmno" type="xs:string" use="required"/>
<xs:attribute name="imlevel" type="xs:string" use="required"/>
<xs:attribute name="revno" type="xs:string" use="required"/>
<xs:attribute name="chngno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="ginfowp" sql:relation="ginfowp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relginfowpwpidinfo"/>
<xs:element ref="scope" sql:relation="scope"
sql:relationship="relginfowpscope"/>
<xs:element ref="mfrr" sql:relation="mfrr"
sql:relationship="relginfowpmfrr"/>
<xs:element ref="eir" sql:relation="eir" sql:relationship="relginfowpeir"/>
<xs:element ref="cpcdata" sql:relation="cpcdata"
sql:relationship="relginfowpcpcdata"/>
<xs:element ref="odsdata" sql:relation="odsdata"
sql:relationship="relginfowpodsdata"/>
<xs:element ref="destructmat" sql:relation="destructmat"
sql:relationship="relginfowpdestructmat"/>
<xs:element ref="pssref" sql:relation="pssref"
sql:relationship="relginfowppssref"/>
<xs:element ref="wrntyref" sql:relation="wrntyref"
sql:relationship="relginfowpwrntyref"/>
<xs:element ref="nomenreflist" sql:relation="nomenreflist"
sql:relationship="relginfowpnomenreflist"/>
</xs:sequence>
<xs:attribute name="wpno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="graphic" sql:relation="graphic">
<xs:complexType>
<xs:attribute name="boardno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="howtouse" sql:relation="howtouse">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" sql:relation="proc"
sql:relationship="relhowtouseproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="identno" sql:relation="identno">
<xs:complexType>
<xs:sequence>
<xs:element ref="partno" sql:relation="partno"
sql:relationship="relidentnopartno"/>
<xs:element ref="cageno" sql:relation="cageno"
sql:relationship="relidentnocageno"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="indication" sql:relation="indication">
<xs:complexType>
<xs:sequence>
<xs:element ref="step1" minOccurs="0" maxOccurs="unbounded"
sql:relation="step1" sql:relationship="relindicationstep1"/>
<xs:element ref="subtitle" minOccurs="0" sql:relation="subtitle"
sql:relationship="relindicationsubtitle"/>
<xs:element ref="para" minOccurs="0" sql:relation="para"
sql:relationship="relindicationpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="inspinstitm" sql:relation="inspinstitm">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element ref="subtitle" sql:relation="subtitle"
sql:relationship="relinspinstitmsubtitle"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="relinspinstitmpara"/>
<xs:element ref="specpara" sql:relation="specpara"
sql:relationship="relinspinstitmspecpara"/>
</xs:choice>
</xs:complexType>
</xs:element>
<xs:element name="install" sql:relation="install">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" sql:relation="proc"
sql:relationship="relinstallproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="internet" sql:relation="internet">
<xs:complexType>
<xs:sequence>
<xs:element ref="email" sql:relation="email"
sql:relationship="relinternetemail"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="intro" sql:relation="intro">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element ref="title" sql:relation="title"
sql:relationship="relintrotitle"/>
<xs:element ref="para" sql:relation="para" sql:relationship="relintropara"/>
</xs:choice>
</xs:complexType>
</xs:element>
<xs:element name="intropara" sql:relation="intropara">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relintroparatitle"/>
<xs:element ref="para" maxOccurs="unbounded" sql:relation="para"
sql:relationship="relintroparapara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="item" sql:relation="item" type="xs:string"/>
<xs:element name="locdesc" sql:relation="locdesc">
<xs:complexType>
<xs:sequence>
<xs:element ref="comp-item" sql:relation="comp-item"
sql:relationship="rellocdesccomp-item"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="loepwp" sql:relation="loepwp">
<xs:complexType>
<xs:sequence>
<xs:element ref="note" sql:relation="note"
sql:relationship="relloepwpnote"/>
<xs:element ref="rev_date" sql:relation="rev_date"
sql:relationship="relloepwprev_date"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="relloepwppara"/>
<xs:element ref="rev_chg" sql:relation="rev_chg"
sql:relationship="relloepwprev_chg"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="lube" sql:relation="lube">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" sql:relation="proc" sql:relationship="rellubeproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="maintlvl" sql:relation="maintlvl">
<xs:complexType>
<xs:attribute name="level" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="maintsk" sql:relation="maintsk">
<xs:complexType>
<xs:sequence>
<xs:element ref="service" minOccurs="0" sql:relation="service"
sql:relationship="relmaintskservice"/>
<xs:element ref="inspinstitm" minOccurs="0" sql:relation="inspinstitm"
sql:relationship="relmaintskinspinstitm"/>
<xs:element ref="clean" minOccurs="0" sql:relation="clean"
sql:relationship="relmaintskclean"/>
<xs:element ref="caution" minOccurs="0" sql:relation="caution"
sql:relationship="relmaintskcaution"/>
<xs:element ref="warning" minOccurs="0" sql:relation="warning"
sql:relationship="relmaintskwarning"/>
<xs:element ref="remove" minOccurs="0" sql:relation="remove"
sql:relationship="relmaintskremove"/>
<xs:element ref="repair-rplc" minOccurs="0" sql:relation="repair-rplc"
sql:relationship="relmaintskrepair-rplc"/>
<xs:element ref="lube" minOccurs="0" sql:relation="lube"
sql:relationship="relmaintsklube"/>
<xs:element ref="note" minOccurs="0" sql:relation="note"
sql:relationship="relmaintsknote"/>
<xs:element ref="prepforuse" minOccurs="0" sql:relation="prepforuse"
sql:relationship="relmaintskprepforuse"/>
<xs:element ref="adjust" minOccurs="0" sql:relation="adjust"
sql:relationship="relmaintskadjust"/>
<xs:element ref="install" minOccurs="0" sql:relation="install"
sql:relationship="relmaintskinstall"/>
<xs:element ref="calibration" minOccurs="0" sql:relation="calibration"
sql:relationship="relmaintskcalibration"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="maintwp" sql:relation="maintwp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relmaintwpwpidinfo"/>
<xs:element ref="wpinfo" sql:relation="wpinfo"
sql:relationship="relmaintwpwpinfo"/>
<xs:element ref="geninfo" minOccurs="0" sql:relation="geninfo"
sql:relationship="relmaintwpgeninfo"/>
<xs:element ref="warning" minOccurs="0" sql:relation="warning"
sql:relationship="relmaintwpwarning"/>
<xs:element ref="note" minOccurs="0" sql:relation="note"
sql:relationship="relmaintwpnote"/>
<xs:element ref="maintsk" maxOccurs="unbounded" sql:relation="maintsk"
sql:relationship="relmaintwpmaintsk"/>
</xs:sequence>
<xs:attribute name="wpno" use="required">
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="malfunc" sql:relation="malfunc">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="label" use="required">
</xs:attribute>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="mfrr" sql:relation="mfrr">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para" sql:relationship="relmfrrpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="mim" sql:relation="mim">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element ref="titlepg" sql:relation="titlepg"
sql:relationship="relmimtitlepg"/>
<xs:element ref="pmcsintrowp" sql:relation="pmcsintrowp"
sql:relationship="relmimpmcsintrowp"/>
<xs:element ref="pmcswp" sql:relation="pmcswp"
sql:relationship="relmimpmcswp"/>
<xs:element ref="gen_maintwp" sql:relation="gen_maintwp"
sql:relationship="relmimgen_maintwp"/>
<xs:element ref="maintwp" sql:relation="maintwp"
sql:relationship="relmimmaintwp"/>
</xs:choice>
<xs:attribute name="tmno" type="xs:string" use="required"/>
<xs:attribute name="imlevel" type="xs:string" use="required"/>
<xs:attribute name="revno" type="xs:string" use="required"/>
<xs:attribute name="chngno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="mrplpart" sql:relation="mrplpart">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para"
sql:relationship="relmrplpartpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="name" sql:relation="name" type="xs:string"/>
<xs:element name="nomenreflist" sql:relation="nomenreflist">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para"
sql:relationship="relnomenreflistpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="note" sql:relation="note">
<xs:complexType>
<xs:sequence>
<xs:element ref="trim_para" maxOccurs="unbounded" sql:relation="trim_para"
sql:relationship="relnotetrim_para"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="notices" sql:relation="notices">
<xs:complexType>
<xs:sequence>
<xs:element ref="dist" sql:relation="dist"
sql:relationship="relnoticesdist"/>
<xs:element ref="export" sql:relation="export"
sql:relationship="relnoticesexport"/>
<xs:element ref="destr" sql:relation="destr"
sql:relationship="relnoticesdestr"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="null" sql:relation="null">
<xs:complexType/>
</xs:element>
<xs:element name="odsdata" sql:relation="odsdata">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para"
sql:relationship="relodsdatapara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="opcheck-tsproc" sql:relation="opcheck-tsproc">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" minOccurs="0" sql:relation="title"
sql:relationship="relopcheck-tsproctitle"/>
<xs:element ref="testproc" sql:relation="testproc"
sql:relationship="relopcheck-tsproctestproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="opcheck-tswp" sql:relation="opcheck-tswp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relopcheck-tswpwpidinfo"/>
<xs:element ref="wpinfo" sql:relation="wpinfo"
sql:relationship="relopcheck-tswpwpinfo"/>
<xs:element ref="intro" minOccurs="0" sql:relation="intro"
sql:relationship="relopcheck-tswpintro"/>
<xs:element ref="proc" minOccurs="0" maxOccurs="unbounded"
sql:relation="proc" sql:relationship="relopcheck-tswpproc"/>
<xs:element ref="opcheck-tsproc" sql:relation="opcheck-tsproc"
sql:relationship="relopcheck-tswpopcheck-tsproc"/>
</xs:sequence>
<xs:attribute name="wpno" use="required">
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="para" sql:relation="para">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element ref="emphasis" sql:relation="emphasis"
sql:relationship="relparaemphasis"/>
<xs:element ref="internet" sql:relation="internet"
sql:relationship="relparainternet"/>
<xs:element ref="figure" sql:relation="figure"
sql:relationship="relparafigure"/>
<xs:element ref="xref" sql:relation="xref" sql:relationship="relparaxref"/>
<xs:element ref="randlist" sql:relation="randlist"
sql:relationship="relpararandlist"/>
<xs:element ref="seqlist" sql:relation="seqlist"
sql:relationship="relparaseqlist"/>
<xs:element ref="null" sql:relation="null" sql:relationship="relparanull"/>
<xs:element ref="deflist" sql:relation="deflist"
sql:relationship="relparadeflist"/>
</xs:choice>
</xs:complexType>
</xs:element>
<xs:element name="partno" sql:relation="partno">
<xs:complexType/>
</xs:element>
<xs:element name="persnreq" sql:relation="persnreq">
<xs:complexType>
<xs:sequence>
<xs:element ref="persnreq-setup-item" sql:relation="persnreq-setup-item"
sql:relationship="relpersnreqpersnreq-setup-item"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="persnreq-setup-item" sql:relation="persnreq-setup-item">
<xs:complexType>
<xs:sequence>
<xs:element ref="name" sql:relation="name"
sql:relationship="relpersnreq-setup-itemname"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="pmcsintrowp" sql:relation="pmcsintrowp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relpmcsintrowpwpidinfo"/>
<xs:element ref="intropara" maxOccurs="unbounded" sql:relation="intropara"
sql:relationship="relpmcsintrowpintropara"/>
</xs:sequence>
<xs:attribute name="wpno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="pmcswp" sql:relation="pmcswp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relpmcswpwpidinfo"/>
<xs:element ref="wpinfo" sql:relation="wpinfo"
sql:relationship="relpmcswpwpinfo"/>
<xs:element ref="mrplpart" sql:relation="mrplpart"
sql:relationship="relpmcswpmrplpart"/>
</xs:sequence>
<xs:attribute name="wpno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="prepforuse" sql:relation="prepforuse">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" maxOccurs="unbounded" sql:relation="proc"
sql:relationship="relprepforuseproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="proc" sql:relation="proc">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" minOccurs="0" sql:relation="title"
sql:relationship="relproctitle"/>
<xs:element ref="note" minOccurs="0" maxOccurs="unbounded"
sql:relation="note" sql:relationship="relprocnote"/>
<xs:element ref="para" minOccurs="0" maxOccurs="unbounded"
sql:relation="para" sql:relationship="relprocpara"/>
<xs:element ref="caution" minOccurs="0" sql:relation="caution"
sql:relationship="relproccaution"/>
<xs:element ref="step1" minOccurs="0" maxOccurs="unbounded"
sql:relation="step1" sql:relationship="relprocstep1"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="production" sql:relation="production">
<xs:complexType>
<xs:sequence>
<xs:element ref="framed_manual" sql:relation="framed_manual"
sql:relationship="relproductionframed_manual"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="prtitle" sql:relation="prtitle">
<xs:complexType>
<xs:sequence>
<xs:element ref="sysnomen" sql:relation="sysnomen"
sql:relationship="relprtitlesysnomen"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="pssref" sql:relation="pssref">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para"
sql:relationship="relpssrefpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="pubident" sql:relation="pubident">
<xs:complexType/>
</xs:element>
<xs:element name="publist" sql:relation="publist">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relpublisttitle"/>
<xs:element ref="pubident" sql:relation="pubident"
sql:relationship="relpublistpubident"/>
<xs:element ref="name" sql:relation="name"
sql:relationship="relpublistname"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="randlist" sql:relation="randlist">
<xs:complexType>
<xs:sequence>
<xs:element ref="item" maxOccurs="unbounded" sql:relation="item"
sql:relationship="relrandlistitem"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="reasondate" sql:relation="reasondate" type="xs:string"/>
<xs:element name="ref" sql:relation="ref">
<xs:complexType>
<xs:sequence>
<xs:element ref="ref-setup-item" maxOccurs="unbounded"
sql:relation="ref-setup-item" sql:relationship="relrefref-setup-item"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ref-setup-item" sql:relation="ref-setup-item">
<xs:complexType>
<xs:sequence>
<xs:element ref="extref" sql:relation="extref"
sql:relationship="relref-setup-itemextref"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="refwp" sql:relation="refwp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="relrefwpwpidinfo"/>
<xs:element ref="scope" sql:relation="scope"
sql:relationship="relrefwpscope"/>
<xs:element ref="publist" sql:relation="publist"
sql:relationship="relrefwppublist"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="releaseagent" sql:relation="releaseagent"
type="xs:string"/>
<xs:element name="remove" sql:relation="remove">
<xs:complexType>
<xs:sequence>
<xs:element ref="figure" minOccurs="0" sql:relation="figure"
sql:relationship="relremovefigure"/>
<xs:element ref="proc" maxOccurs="unbounded" sql:relation="proc"
sql:relationship="relremoveproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="repair-rplc" sql:relation="repair-rplc">
<xs:complexType>
<xs:sequence>
<xs:element ref="proc" sql:relation="proc"
sql:relationship="relrepair-rplcproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="rev_chg" sql:relation="rev_chg">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpno" sql:relation="wpno"
sql:relationship="relrev_chgwpno"/>
<xs:element ref="rev_no" sql:relation="rev_no"
sql:relationship="relrev_chgrev_no"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="rev_date" sql:relation="rev_date">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relrev_datetitle"/>
<xs:element ref="rev_no" sql:relation="rev_no"
sql:relationship="relrev_daterev_no"/>
<xs:element ref="date" sql:relation="date"
sql:relationship="relrev_datedate"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="rev_no" sql:relation="rev_no">
<xs:complexType>
<xs:attribute name="no" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="scope" sql:relation="scope">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" maxOccurs="unbounded" sql:relation="para"
sql:relationship="relscopepara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="seqlist" sql:relation="seqlist">
<xs:complexType>
<xs:sequence>
<xs:element ref="item" maxOccurs="unbounded" sql:relation="item"
sql:relationship="relseqlistitem"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="service" sql:relation="service">
<xs:complexType>
<xs:sequence>
<xs:element ref="subtitle" minOccurs="0" sql:relation="subtitle"
sql:relationship="relservicesubtitle"/>
<xs:element ref="specpara" minOccurs="0" sql:relation="specpara"
sql:relationship="relservicespecpara"/>
<xs:element ref="para" minOccurs="0" sql:relation="para"
sql:relationship="relservicepara"/>
<xs:element ref="proc" minOccurs="0" maxOccurs="unbounded"
sql:relation="proc" sql:relationship="relserviceproc"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="servnomen" sql:relation="servnomen" type="xs:string"/>
<xs:element name="sim" sql:relation="sim">
<xs:complexType>
<xs:sequence>
<xs:element ref="titlepg" sql:relation="titlepg"
sql:relationship="relsimtitlepg"/>
<xs:element ref="refwp" sql:relation="refwp"
sql:relationship="relsimrefwp"/>
</xs:sequence>
<xs:attribute name="tmno" type="xs:string" use="required"/>
<xs:attribute name="imno" type="xs:string" use="required"/>
<xs:attribute name="imlevel" type="xs:string" use="required"/>
<xs:attribute name="revno" type="xs:string" use="required"/>
<xs:attribute name="chngno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="specpara" sql:relation="specpara">
<xs:complexType>
<xs:sequence>
<xs:element ref="warning" minOccurs="0" maxOccurs="unbounded"
sql:relation="warning" sql:relationship="relspecparawarning"/>
<xs:element ref="caution" minOccurs="0" maxOccurs="unbounded"
sql:relation="caution" sql:relationship="relspecparacaution"/>
<xs:element ref="note" minOccurs="0" maxOccurs="unbounded"
sql:relation="note" sql:relationship="relspecparanote"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="relspecparapara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="step1" sql:relation="step1">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" minOccurs="0" sql:relation="para"
sql:relationship="relstep1para"/>
<xs:element ref="specpara" minOccurs="0" sql:relation="specpara"
sql:relationship="relstep1specpara"/>
<xs:element ref="step2" minOccurs="0" maxOccurs="unbounded"
sql:relation="step2" sql:relationship="relstep1step2"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="step2" sql:relation="step2">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" minOccurs="0" sql:relation="para"
sql:relationship="relstep2para"/>
<xs:element ref="step3" minOccurs="0" maxOccurs="unbounded"
sql:relation="step3" sql:relationship="relstep2step3"/>
<xs:element ref="specpara" minOccurs="0" sql:relation="specpara"
sql:relationship="relstep2specpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="step3" sql:relation="step3">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" minOccurs="0" sql:relation="para"
sql:relationship="relstep3para"/>
<xs:element ref="step4" minOccurs="0" maxOccurs="unbounded"
sql:relation="step4" sql:relationship="relstep3step4"/>
<xs:element ref="specpara" minOccurs="0" sql:relation="specpara"
sql:relationship="relstep3specpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="step4" sql:relation="step4">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para" sql:relationship="relstep4para"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="subtitle" sql:relation="subtitle" type="xs:string"/>
<xs:element name="sysnomen" sql:relation="sysnomen">
<xs:complexType>
<xs:sequence>
<xs:element ref="name" sql:relation="name"
sql:relationship="relsysnomenname"/>
<xs:element ref="eic" sql:relation="eic" sql:relationship="relsysnomeneic"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="term" sql:relation="term" type="xs:string"/>
<xs:element name="term_def" sql:relation="term_def">
<xs:complexType>
<xs:sequence>
<xs:element ref="term" sql:relation="term"
sql:relationship="relterm_defterm"/>
<xs:element ref="def" sql:relation="def" sql:relationship="relterm_defdef"/>
</xs:sequence>
<xs:attribute name="id" use="required">
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="testeqp" sql:relation="testeqp">
<xs:complexType>
<xs:sequence>
<xs:element ref="testeqp-setup-item" maxOccurs="unbounded"
sql:relation="testeqp-setup-item"
sql:relationship="reltesteqptesteqp-setup-item"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="testeqp-setup-item" sql:relation="testeqp-setup-item">
<xs:complexType>
<xs:sequence>
<xs:element ref="name" sql:relation="name"
sql:relationship="reltesteqp-setup-itemname"/>
<xs:element ref="identno" sql:relation="identno"
sql:relationship="reltesteqp-setup-itemidentno"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="testproc" sql:relation="testproc">
<xs:complexType>
<xs:sequence>
<xs:element ref="checkstep" sql:relation="checkstep"
sql:relationship="reltestproccheckstep"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tim" sql:relation="tim">
<xs:complexType>
<xs:sequence>
<xs:element ref="titlepg" sql:relation="titlepg"
sql:relationship="reltimtitlepg"/>
<xs:element ref="tsintrowp" sql:relation="tsintrowp"
sql:relationship="reltimtsintrowp"/>
<xs:element ref="tsindxwp" sql:relation="tsindxwp"
sql:relationship="reltimtsindxwp"/>
<xs:element ref="opcheck-tswp" maxOccurs="unbounded"
sql:relation="opcheck-tswp" sql:relationship="reltimopcheck-tswp"/>
</xs:sequence>
<xs:attribute name="tmno" type="xs:string" use="required"/>
<xs:attribute name="imlevel" type="xs:string" use="required"/>
<xs:attribute name="revno" type="xs:string" use="required"/>
<xs:attribute name="chngno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="title" sql:relation="title" type="xs:string"/>
<xs:element name="titlepg" sql:relation="titlepg">
<xs:complexType>
<xs:sequence>
<xs:element ref="name" sql:relation="name"
sql:relationship="reltitlepgname"/>
</xs:sequence>
<xs:attribute name="maintlvl" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="tminfono" sql:relation="tminfono">
<xs:complexType>
<xs:sequence>
<xs:element ref="tmno" sql:relation="tmno"
sql:relationship="reltminfonotmno"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tmno" sql:relation="tmno" type="xs:string"/>
<xs:element name="tmtitle" sql:relation="tmtitle">
<xs:complexType>
<xs:sequence>
<xs:element ref="tminfono" sql:relation="tminfono"
sql:relationship="reltmtitletminfono"/>
<xs:element ref="prtitle" sql:relation="prtitle"
sql:relationship="reltmtitleprtitle"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tools" sql:relation="tools">
<xs:complexType>
<xs:sequence>
<xs:element ref="tools-setup-item" maxOccurs="unbounded"
sql:relation="tools-setup-item"
sql:relationship="reltoolstools-setup-item"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tools-setup-item" sql:relation="tools-setup-item">
<xs:complexType>
<xs:sequence>
<xs:element ref="name" sql:relation="name"
sql:relationship="reltools-setup-itemname"/>
<xs:element ref="identno" sql:relation="identno"
sql:relationship="reltools-setup-itemidentno"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="trim_para" sql:relation="trim_para" type="xs:string"/>
<xs:element name="ts-category" sql:relation="ts-category">
<xs:complexType>
<xs:sequence>
<xs:element ref="title" sql:relation="title"
sql:relationship="relts-categorytitle"/>
<xs:element ref="tsindx-entry" maxOccurs="unbounded"
sql:relation="tsindx-entry" sql:relationship="relts-categorytsindx-entry"/>
</xs:sequence>
<xs:attribute name="catg-name" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="tsindx" sql:relation="tsindx">
<xs:complexType>
<xs:sequence>
<xs:element ref="ts-category" sql:relation="ts-category"
sql:relationship="reltsindxts-category"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tsindx-entry" sql:relation="tsindx-entry">
<xs:complexType>
<xs:sequence>
<xs:element ref="malfunc" sql:relation="malfunc"
sql:relationship="reltsindx-entrymalfunc"/>
<xs:element ref="xref" sql:relation="xref"
sql:relationship="reltsindx-entryxref"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tsindxwp" sql:relation="tsindxwp">
<xs:complexType>
<xs:sequence>
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="reltsindxwpwpidinfo"/>
<xs:element ref="geninfo" sql:relation="geninfo"
sql:relationship="reltsindxwpgeninfo"/>
<xs:element ref="tsindx" sql:relation="tsindx"
sql:relationship="reltsindxwptsindx"/>
</xs:sequence>
<xs:attribute name="wpno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="tsintrowp" sql:relation="tsintrowp">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element ref="wpidinfo" sql:relation="wpidinfo"
sql:relationship="reltsintrowpwpidinfo"/>
<xs:element ref="title" sql:relation="title"
sql:relationship="reltsintrowptitle"/>
<xs:element ref="para" sql:relation="para"
sql:relationship="reltsintrowppara"/>
</xs:choice>
<xs:attribute name="wpno" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="warning" sql:relation="warning">
<xs:complexType>
<xs:sequence>
<xs:element ref="trim_para" maxOccurs="unbounded" sql:relation="trim_para"
sql:relationship="relwarningtrim_para"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="wpidinfo" sql:relation="wpidinfo">
<xs:complexType>
<xs:sequence>
<xs:element ref="maintlvl" sql:relation="maintlvl"
sql:relationship="relwpidinfomaintlvl"/>
<xs:element ref="eicnomen" sql:relation="eicnomen"
sql:relationship="relwpidinfoeicnomen"/>
<xs:element ref="title" sql:relation="title"
sql:relationship="relwpidinfotitle"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="wpinfo" sql:relation="wpinfo">
<xs:complexType>
<xs:sequence>
<xs:element ref="tools" minOccurs="0" sql:relation="tools"
sql:relationship="relwpinfotools"/>
<xs:element ref="testeqp" minOccurs="0" sql:relation="testeqp"
sql:relationship="relwpinfotesteqp"/>
<xs:element ref="persnreq" minOccurs="0" sql:relation="persnreq"
sql:relationship="relwpinfopersnreq"/>
<xs:element ref="null" minOccurs="0" sql:relation="null"
sql:relationship="relwpinfonull"/>
<xs:element ref="ref" minOccurs="0" sql:relation="ref"
sql:relationship="relwpinforef"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="wpno" sql:relation="wpno">
<xs:complexType>
<xs:attribute name="wpref" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="wrntyref" sql:relation="wrntyref">
<xs:complexType>
<xs:sequence>
<xs:element ref="para" sql:relation="para"
sql:relationship="relwrntyrefpara"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="xref" sql:relation="xref">
<xs:complexType>
<xs:attribute name="wpid" use="required">
</xs:attribute>
<xs:attribute name="pretext" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
</xs:schema>
|||"Jay" <the10thREMOVECAPSletteref@.hotmail.com> wrote in message
news:O%23vCcnjTEHA.3988@.tk2msftngp13.phx.gbl...
> I'm using sqlxml3.0 to load a schema file. I cannot, for the life of me,
> figure out why I keep getting this error message "-2147467259 Schema:
> invalid value for 'table' on 'relationship'".
> If anyone can offer the path to a solution it would be most appreciated.
I would start by explicitly declaring the parent in each relationship.
Bryant
sql

Invalid Use of Null

I am getting the "Invalid use of Null" message when I execute the following code under the following conditions.

fields in SQL Server table
db_date varchar(30) --> "December 29"
db_subject varchar(200) --> "Test Subject"
db_thought text --> "This is a test to see if this works"

I execute the following code from VB6

strText = "select * from db_table where db_date = 'December 29'"
ors.open strText, dbConnect
if not ors.eof then
if not isnull(ors("db_thought")) then
txtBox1 = ors("db_thought")
end if
end if

Here is my problem. Since there is a value in db_thought the code if not isnull(ors("db_thought")) evaluates to true -- this is what I expect. However when I try to assign the ors("db_thought") to the txBox1 field I get an Invalid use of Null. What am I missing?

ThanksWhat happens if you change the if statement to:

if isnull(...) then
txtField1 = ""
else
txtField1 = ...
end if

Also, put in a msgbox before the assignment to display the value or look at it in debug mode under locals.|||Originally posted by rnealejr
What happens if you change the if statement to:

if isnull(...) then
txtField1 = ""
else
txtField1 = ...
end if

Also, put in a msgbox before the assignment to display the value or look at it in debug mode under locals.

I tired your suggestion, and I get the same results. It appears that the test to see if there is information in the field is testing to be true, but the attempt to read from the field is saying that the information is null. I have rechecked the database to see if there is valid data in the field and I see data there.

Invalid URI: The format of the URI could not be determined

I'm using the sample on custom authentication from msdn but whenever I try to login I get this message.What URI are they complaining about? Has it anything to do with the custom cookie handling? I cant for the world understand whats wrong.

I had to replace the url to the service in the proxy.

But now I have problems with the cookie. Authorization ticket not received by LogonUser

|||

Am I the only one with this problem?

Could the problem be that I'm using two instances of reporting services? I thought that it was a good idea to create two instances of reporting services to be able to preserve our project portal (team foundation, sharepoint) with windows authentication and use the other one for development with forms authenitcation.

Anyone? Any input would be useful.

|||

Maybe this link will be of some help to you:

http://msdn2.microsoft.com/en-us/library/ms155878.aspx

Shyam

|||Thanks Shyam for your reply but sadly it didnt make any difference.

Invalid Target name - how can it be determined?

Hi, I am sending a message to an invalid target name. The message eventually gets back to the initiator as an error type message. How can I determine the exact cause of the error - and determine that the target service name is invalid? I am using the ServiceBrokerInterface and the Message does not tell much - it seems. Also, in the sys.conversation_endpoints table, the record associated to the message only says 'Error', but no other indicator.

I found it - it is embedded as a stream in the Body property.|||

Right, the cast the response Error message_body to XML and the text will contain the problem service name.

HTH,
~ Remus

Monday, March 26, 2012

Invalid schema or catalog specified for provider 'SQLOLEDB'

Hi,
I'm getting the following message when querying a database of a second
sql server.
"Invalid schema or catalog specified for provider 'SQLOLEDB'.
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.]."
This does not occur when querying other databases from the second
server. Is the problem a naming problem? If so, how can i correct it.
The name of the database as i can see in the enterprise manager has a
different name than the database's filename.
Thnx
Kommt darauf an welche Art von datenbank Du abfragst (hast Du leider nciht in
Deinem Posting genannt). Entsprechend der Datenbank stimmt der Katalog nicht
(z.B. bei einer AS/400, oder evtl. der Schema Owner z.B. Oracle nicht. N?here
Informationen sollten Dir und uns helfen das Problem zu finden.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Jason" wrote:

> Hi,
> I'm getting the following message when querying a database of a second
> sql server.
> "Invalid schema or catalog specified for provider 'SQLOLEDB'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.]."
> This does not occur when querying other databases from the second
> server. Is the problem a naming problem? If so, how can i correct it.
> The name of the database as i can see in the enterprise manager has a
> different name than the database's filename.
> Thnx
>
|||Sorry, posted in the wrong language to the wrong thread :-). Ok , again...
If the second server (linked server i guess, or do you use a openquery or
opensource statement =) is a sql server you should check the owner of the
database objects you are quering for, perhaps they are created under a
special user account. ?
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Jason" wrote:

> Hi,
> I'm getting the following message when querying a database of a second
> sql server.
> "Invalid schema or catalog specified for provider 'SQLOLEDB'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.]."
> This does not occur when querying other databases from the second
> server. Is the problem a naming problem? If so, how can i correct it.
> The name of the database as i can see in the enterprise manager has a
> different name than the database's filename.
> Thnx
>
|||Hi
If your server is SP4 and the server you are conenction to is SP3 and
earlier, the catalogue stored procedures are out of date.
Run Instcat.sql, using the copy on the SP4 server against the SP3 server.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jason" wrote:

> Hi,
> I'm getting the following message when querying a database of a second
> sql server.
> "Invalid schema or catalog specified for provider 'SQLOLEDB'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.]."
> This does not occur when querying other databases from the second
> server. Is the problem a naming problem? If so, how can i correct it.
> The name of the database as i can see in the enterprise manager has a
> different name than the database's filename.
> Thnx
>
|||Hi Mike,
Both machines are sp4. Like i said earlier. It doesn't occur when
querying other databases on the second server. The only difference i can
see is that the database has a different filename than the databasename.
Mike Epprecht (SQL MVP) wrote:
> Hi
> If your server is SP4 and the server you are conenction to is SP3 and
> earlier, the catalogue stored procedures are out of date.
> Run Instcat.sql, using the copy on the SP4 server against the SP3 server.
sql

Invalid schema or catalog specified for provider 'SQLOLEDB'

Hi,
I'm getting the following message when querying a database of a second
sql server.
"Invalid schema or catalog specified for provider 'SQLOLEDB'.
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.]."
This does not occur when querying other databases from the second
server. Is the problem a naming problem? If so, how can i correct it.
The name of the database as i can see in the enterprise manager has a
different name than the database's filename.
ThnxKommt darauf an welche Art von datenbank Du abfragst (hast Du leider nciht i
n
Deinem Posting genannt). Entsprechend der Datenbank stimmt der Katalog nicht
(z.B. bei einer AS/400, oder evtl. der Schema Owner z.B. Oracle nicht. N?he
re
Informationen sollten Dir und uns helfen das Problem zu finden.
--
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Jason" wrote:

> Hi,
> I'm getting the following message when querying a database of a second
> sql server.
> "Invalid schema or catalog specified for provider 'SQLOLEDB'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.]."
> This does not occur when querying other databases from the second
> server. Is the problem a naming problem? If so, how can i correct it.
> The name of the database as i can see in the enterprise manager has a
> different name than the database's filename.
> Thnx
>|||Sorry, posted in the wrong language to the wrong thread :-). Ok , again...
If the second server (linked server i guess, or do you use a openquery or
opensource statement =) is a sql server you should check the owner of the
database objects you are quering for, perhaps they are created under a
special user account. ?
--
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Jason" wrote:

> Hi,
> I'm getting the following message when querying a database of a second
> sql server.
> "Invalid schema or catalog specified for provider 'SQLOLEDB'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.]."
> This does not occur when querying other databases from the second
> server. Is the problem a naming problem? If so, how can i correct it.
> The name of the database as i can see in the enterprise manager has a
> different name than the database's filename.
> Thnx
>|||Hi
If your server is SP4 and the server you are conenction to is SP3 and
earlier, the catalogue stored procedures are out of date.
Run Instcat.sql, using the copy on the SP4 server against the SP3 server.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jason" wrote:

> Hi,
> I'm getting the following message when querying a database of a second
> sql server.
> "Invalid schema or catalog specified for provider 'SQLOLEDB'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.]."
> This does not occur when querying other databases from the second
> server. Is the problem a naming problem? If so, how can i correct it.
> The name of the database as i can see in the enterprise manager has a
> different name than the database's filename.
> Thnx
>|||Hi Mike,
Both machines are sp4. Like i said earlier. It doesn't occur when
querying other databases on the second server. The only difference i can
see is that the database has a different filename than the databasename.
Mike Epprecht (SQL MVP) wrote:
> Hi
> If your server is SP4 and the server you are conenction to is SP3 and
> earlier, the catalogue stored procedures are out of date.
> Run Instcat.sql, using the copy on the SP4 server against the SP3 server.|||Dear All,
I am looking for data one server to another server which
invoicenumber not same in the table.
Thanks
Prabhakar|||Dear all,
I am getting this error while looking query the data from one server which
is not match from another server.
pleae let us know the reply
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.].
Thanks
Prabhakar|||Dear all,
I am getting this error while looking query the data from one server which
is not match from another server.
pleae let us know the reply
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.].
Thanks
Prabhakar

Invalid schema or catalog specified for provider 'SQLOLEDB'

Hi,
I'm getting the following message when querying a database of a second
sql server.
"Invalid schema or catalog specified for provider 'SQLOLEDB'.
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.]."
This does not occur when querying other databases from the second
server. Is the problem a naming problem? If so, how can i correct it.
The name of the database as i can see in the enterprise manager has a
different name than the database's filename.
ThnxKommt darauf an welche Art von datenbank Du abfragst (hast Du leider nciht in
Deinem Posting genannt). Entsprechend der Datenbank stimmt der Katalog nicht
(z.B. bei einer AS/400, oder evtl. der Schema Owner z.B. Oracle nicht. Nähere
Informationen sollten Dir und uns helfen das Problem zu finden.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Jason" wrote:
> Hi,
> I'm getting the following message when querying a database of a second
> sql server.
> "Invalid schema or catalog specified for provider 'SQLOLEDB'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.]."
> This does not occur when querying other databases from the second
> server. Is the problem a naming problem? If so, how can i correct it.
> The name of the database as i can see in the enterprise manager has a
> different name than the database's filename.
> Thnx
>|||Sorry, posted in the wrong language to the wrong thread :-). Ok , again...
If the second server (linked server i guess, or do you use a openquery or
opensource statement =) is a sql server you should check the owner of the
database objects you are quering for, perhaps they are created under a
special user account. ?
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Jason" wrote:
> Hi,
> I'm getting the following message when querying a database of a second
> sql server.
> "Invalid schema or catalog specified for provider 'SQLOLEDB'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.]."
> This does not occur when querying other databases from the second
> server. Is the problem a naming problem? If so, how can i correct it.
> The name of the database as i can see in the enterprise manager has a
> different name than the database's filename.
> Thnx
>|||Hi
If your server is SP4 and the server you are conenction to is SP3 and
earlier, the catalogue stored procedures are out of date.
Run Instcat.sql, using the copy on the SP4 server against the SP3 server.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jason" wrote:
> Hi,
> I'm getting the following message when querying a database of a second
> sql server.
> "Invalid schema or catalog specified for provider 'SQLOLEDB'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.]."
> This does not occur when querying other databases from the second
> server. Is the problem a naming problem? If so, how can i correct it.
> The name of the database as i can see in the enterprise manager has a
> different name than the database's filename.
> Thnx
>|||Hi Mike,
Both machines are sp4. Like i said earlier. It doesn't occur when
querying other databases on the second server. The only difference i can
see is that the database has a different filename than the databasename.
Mike Epprecht (SQL MVP) wrote:
> Hi
> If your server is SP4 and the server you are conenction to is SP3 and
> earlier, the catalogue stored procedures are out of date.
> Run Instcat.sql, using the copy on the SP4 server against the SP3 server.|||Dear All,
I am looking for data one server to another server which
invoicenumber not same in the table.
Thanks
Prabhakar|||Dear all,
I am getting this error while looking query the data from one server which
is not match from another server.
pleae let us know the reply
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.].
Thanks
Prabhakar|||Dear all,
I am getting this error while looking query the data from one server which
is not match from another server.
pleae let us know the reply
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.].
Thanks
Prabhakar

invalid report server database

I'm trying to install the developer edition of SQL Reporting Services in a
developer edition of SQL 2000. I keep getting the error message
"rsInvalidReportServerDatabase" and the expected version is 'C.0.6.54'. I do
a complete uninstall, manually remove the database and log files, and attempt
another install, but keep getting an error that I need to run rsactivate.
When I do I get the error that the Report Web service has not generated a
public key. I unchecked the require SSL during install. When I run the report
manager I get the invalid report server database. Any help will be
appreciated.The problem is that I changed the name of the machine and needed to update
Security with the SQL logon of the new <local machine>\ASPNET account and
set the database access for Master, ReportServer, ReportServerTempDB to
RSExecRole. If anyone gets this same error, you may want to check your
ASPNET logon in SQL server.
Dan
"DLS" <DLS@.discussions.microsoft.com> wrote in message
news:EB4F685C-7B22-4499-AC95-26E53A123A42@.microsoft.com...
> I'm trying to install the developer edition of SQL Reporting Services in a
> developer edition of SQL 2000. I keep getting the error message
> "rsInvalidReportServerDatabase" and the expected version is 'C.0.6.54'. I
> do
> a complete uninstall, manually remove the database and log files, and
> attempt
> another install, but keep getting an error that I need to run rsactivate.
> When I do I get the error that the Report Web service has not generated a
> public key. I unchecked the require SSL during install. When I run the
> report
> manager I get the invalid report server database. Any help will be
> appreciated.

Invalid Path message

In the following code, I received an error on

execInfo = rsReportExec.LoadReport(strReportPath, strHistoryID). The errro was "System.Web.Services.Protocols.SoapException: The path of the item "http://localhost/ReportServer/Pages/ReportViewer.aspx?/CAITReports/rptIssuesByRole&rs:Command=Render&intProjectID=119&nvchrWhoRan=DYW" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. > Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: The path of the item "http://localhost/ReportServer/Pages/ReportViewer.aspx?/CAITReports/rptIssuesByRole&rs:Command=Render&intProjectID=119&nvchrWhoRan=DYW" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply.

I copied and pasted the path on the URL and it worked. What did I miss in the code? Why strHistoryID is required as it is nothing? Please refer to http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx

Private Sub sExecuteReportingServicesReport()

Dim rsReportExec As ReportExecutionService = New ReportExecutionService

rsReportExec.Credentials = System.Net.CredentialCache.DefaultCredentials

'rsReportExec.Url = "http://localhost/reportserver/ReportExecution2005.asmx"

Dim byteResult() As Byte = Nothing

Dim strReportPath As String = "http://localhost/ReportServer/Pages/ReportViewer.aspx?/CAITReports/rptIssuesByRole&rs:Command=Render&intProjectID=" & Me.cboProject.SelectedValue & "&nvchrWhoRan=" & Session("strEmployeeName")

'Dim strReportPath As String = "/Pages/ReportViewer.aspx?/CAIT/rptIssuesByRole&rs:Command=Render&intProjectID=" & Me.cboProject.SelectedValue & "&nvchrWhoRan=" & Session("strEmployeeName")

Dim strFormat As String = "MSWord"

Dim strHistoryID As String = Nothing

Dim strEncoding As String = ""

Dim strMineType As String = ""

Dim strExtension As String = ""

Dim wrnWarnings() As Warning = Nothing

Dim strStreamIDs() As String = Nothing

Dim execInfo As New ExecutionInfo

Dim execHeader As New ExecutionHeader

rsReportExec.ExecutionHeaderValue = execHeader

execInfo = rsReportExec.LoadReport(strReportPath, strHistoryID)

Dim strSessionID As String = rsReportExec.ExecutionHeaderValue.ExecutionID

byteResult = rsReportExec.Render(strFormat, Nothing, strExtension, strEncoding, strMineType, wrnWarnings, strStreamIDs)

Response.ClearContent()

Response.AppendHeader("content-length", byteResult.Length.ToString)

Response.ContentType = "application/MSWord"

Response.BinaryWrite(byteResult)

Response.Flush()

Response.Close()

End Sub

Thanks.

DanYeung

The report path should be like /ReportFolder/ReportName

What you have given is URL. Check it for yourself in the msdn link you have given. There is nothing to do with hitory id.

Shyam