Invoking a batch file from Report

Hi !

I have to invoke a batch file (.bat) when an ad-hoc report is executed. I've currently written a .Net code for invoking (using System.Diagnostics.Process) the batch file. The rdl file calls the method.

When I run the report from Report Designer the batch file is getting executed. But if I deploy it in the Reporting Server and run the report through Web Interface the batch file is not getting executed.

Looks like some security issue. Can someone provide a solution for this?

Thanks.

Where did you place the batch file ? All commands executed either in Script or custom code or executed on the server not on the client.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Just a suggestion on how to execute the .bat file. Could′t you use a SQL Agent job instead and call sp_start_job from a dataset in the report?|||

Hi Jens,

Thanks for the reply.

I placed the batch file in the server. I also moved the code (to invoke a batch file using System.Diagnostics.Process class) to a VB.Net dll and tried invoking the function from the rdl. The function is not getting invoked. I also added SecurityPermissionAttribute to the class. Is there any other Security permission that needs to be added for the code to be accessed.

Please find below the sample:

Public Shared Function fnRunSPX(ByVal x As String, ByVal y As String, ByVal z As String, ByVal w As String)

Dim Pro As New System.Diagnostics.Process

Dim Elog As New System.Diagnostics.EventLog

If Not Elog.SourceExists("BillingDateBatch") Then

Elog.CreateEventSource("BillingDateBatch", "Application")

End If

Dim EventLog1 As New System.Diagnostics.EventLog

EventLog1.Source = "BillingDateBatch"

EventLog1.Log = "Application"

EventLog1.WriteEntry("Success", System.Diagnostics.EventLogEntryType.SuccessAudit)

Pro.StartInfo.FileName = "C:\\batch.bat"

Pro.StartInfo.Arguments = x + " " + y + " " + z + " " + w

Pro.Start()

Pro.WaitForExit()

End Function

Even the evenlogging (present in teh above code) does not happen. Please let me know if you have any questions.

Thanks,

Aravind

Investigating what makes my log file grow and grow and grow

I need to learn the steps to investigate which
transactions are not getting replicated, thus causing my
log file to grow. I periodically check the dbs I
administer and wait until after hours to force
replacation done using sp_ReplDone, followed by a backup
and shrink, for those dbs with excessively large log
files. I only have this problem on the server that acts
as distributor and subscriber.
I even set up jobs that do the following, in order (by
start time):
1)exec sp_ReplDone @.xactid = NULL, @.xact_segno = NULL,
@.numtrans = 0, @.time = 0, @.reset = 1
2)Backup transaction log (part of maintenance plan)
3)Backup db (part of maintenance plan)
4)DBCC Shrinkfile
I have these jobs spread out every 1/2 hour to give them
plenty of time to complete before the next one begins.
Yet the log file doesn't shrink.
When I run DBCC OPENTRAN on the db, I get the following:
Transaction information for database 'Database1'.
Replicated Transaction Information:
Oldest distributed LSN : (0:0:0)
Oldest non-distributed LSN : (570647:21697:1)
DBCC execution completed.
So, my two requests are:
1) why doesn't my shrink procedure work? (If I do these
steps by hand I can shrink the log file down to 1MB)
2) how do I determine what's causing the hangup that
starts the log file to grow.
Roger.
When you get a value for DBCC Opentran Oldest non-distributed LSN it means
there are transaction in your tlog that the log reader has not read yet, or
has not marked as replicated.
There is a problem with your log reader. I can't tell you what it is,
perhaps there is an error message on it. Perhaps your system is under load
and not enough resources are avaliable for the log reader - this is only
solved by a reboot.
I would never run sp_repldone the way you are. Basically what you are in
effect doing is saying I need all commands replicated for a time period, and
then when I run sp_repldone if there are any commands in the log, throw them
away.
It could also be that you are not dumping your log frequently enough. You
should be dumping it very frequently, perhaps every 20 minutes, or even
every 1-3 minutes if your database is large.
Pruning your tlog this way will improve overall system performance, and mean
your log reader has less log to read, hence its read performance will be
better. You might want to decrease its PollingInterval to 1s.
Also run a dbcc loginfo. Ideally you should have a small number of rows
which correspond to your virtual log files, ie 16 or so. Best of all 4. If
you have a large number you should try to size your tlog to something large
to prevent frequent autogrows.
Another factor which could cause your log to grow is orphaned transactions.
DBCC opentran should show this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Roger Denison" <anonymous@.discussions.microsoft.com> wrote in message
news:19be01c4bdd2$48a792e0$a401280a@.phx.gbl...
> I need to learn the steps to investigate which
> transactions are not getting replicated, thus causing my
> log file to grow. I periodically check the dbs I
> administer and wait until after hours to force
> replacation done using sp_ReplDone, followed by a backup
> and shrink, for those dbs with excessively large log
> files. I only have this problem on the server that acts
> as distributor and subscriber.
> I even set up jobs that do the following, in order (by
> start time):
> 1)exec sp_ReplDone @.xactid = NULL, @.xact_segno = NULL,
> @.numtrans = 0, @.time = 0, @.reset = 1
> 2)Backup transaction log (part of maintenance plan)
> 3)Backup db (part of maintenance plan)
> 4)DBCC Shrinkfile
> I have these jobs spread out every 1/2 hour to give them
> plenty of time to complete before the next one begins.
> Yet the log file doesn't shrink.
> When I run DBCC OPENTRAN on the db, I get the following:
> Transaction information for database 'Database1'.
> Replicated Transaction Information:
> Oldest distributed LSN : (0:0:0)
> Oldest non-distributed LSN : (570647:21697:1)
> DBCC execution completed.
> So, my two requests are:
> 1) why doesn't my shrink procedure work? (If I do these
> steps by hand I can shrink the log file down to 1MB)
> 2) how do I determine what's causing the hangup that
> starts the log file to grow.
> Roger.

Investigate Unknown database file type?

hello guys,
i'm new on this forum, i got a file with .inn extension but have a problem while i want to access it. i've tried so many ways to access such that file.
The extension maybe masked by the developer for security reason, i try to change the extension to .dbf and .mdb to access it from odbc but still cannot access it.

please help me to investigate that file.
the file is included on the attachment

thanx in advance for all of your answer.

regards,
canfieldmysql innodb table?|||Perhaps Essbase Temporary Analytic Services index file?
Or Cobol/2 overlay?
(Found those two using Google service. Never heard about Essbase before ...)|||You may not be able to rescue this data.
The file seems to contain no data definitions (schema), therefore unless you have the originating program AND this program has some default/embedded definitions, then you maybe could access the data in this file.

Otherwise, it is useless to try and figure out data structures in a file which you do not have the design format.

:rolleyes:

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 object name 'db_student.myuser.tbl_studentname'.

HI, i am a newbie of SQL server.
What I got is an error shown as the title in which an ASP file made the SQL
call.
The script is just as follow:
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_cia_STRING
'Recordset1.Source = "SELECT * FROM fund WHERE studentno='k01' and remark
='confirm' ORDER BY date DESC"
Recordset1.Source = "db_aia..po_student_socre 'K01',' ',1"
Recordset1.CursorType = 1
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
I am sure that the procedure po_student_score exist and have set the execute
permission for the user with username myuser.
How can I solve the problem?
Thank you very much.
Hi,
First see the spelling of the procedure, the SCORE is spelled as SOCRE..
Recordset1.Source = "db_aia..po_student_socre 'K01',' ',1"
Thanks
Hari
MCDBA
<blue> wrote in message news:%231E%23aCUmEHA.1672@.TK2MSFTNGP14.phx.gbl...
> HI, i am a newbie of SQL server.
> What I got is an error shown as the title in which an ASP file made the
> SQL
> call.
> The script is just as follow:
> set Recordset1 = Server.CreateObject("ADODB.Recordset")
> Recordset1.ActiveConnection = MM_cia_STRING
> 'Recordset1.Source = "SELECT * FROM fund WHERE studentno='k01' and
> remark
> ='confirm' ORDER BY date DESC"
> Recordset1.Source = "db_aia..po_student_socre 'K01',' ',1"
> Recordset1.CursorType = 1
> Recordset1.CursorLocation = 2
> Recordset1.LockType = 3
> Recordset1.Open()
> I am sure that the procedure po_student_score exist and have set the
> execute
> permission for the user with username myuser.
> How can I solve the problem?
> Thank you very much.
>

Invalid Object Issue...

I ran the Upsizing wizard to convert an Access file to a SQL file.
Everything worked fine before. I changed my connection string and now I
get:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) [Microsoft][ODBC SQL
Server Driver][SQL Server]Invalid object name 'tbl_MRSongs'.
/impulse/impulse_MR.asp, line 77
For the record, the connection works fine in Live Data in DW.
Here's the offending code:
<%
var rs_MRSong = Server.CreateObject("ADODB.Recordset");
rs_MRSong.ActiveConnection = MM_con_MR_STRING;
rs_MRSong.Source = "SELECT * FROM tbl_MRSongs WHERE ID_Song = "+
rs_MRSong__MMColParam.replace(/'/g, "''") + "";
rs_MRSong.CursorType = 0;
rs_MRSong.CursorLocation = 2;
rs_MRSong.LockType = 1;
rs_MRSong.Open(); <-- This is line 77
var rs_MRSong_numRows = 0;
%>
Here's the connection string:
var MM_con_MR_STRING = "Provider=MSDASQL;Driver={SQL
Server};Server=(local);Database =
DataBASE;UID=USER;PWD=PASSWORD;Trusted_Connection= yes"
What changes did u make to the connection string? Also, you might want to
first test this new connection string and if it works by using a UDL file.
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Invalid Object Issue...

I ran the Upsizing wizard to convert an Access file to a SQL file.
Everything worked fine before. I changed my connection string and now I
get:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) [Microsoft][
ODBC SQL
Server Driver][SQL Server]Invalid object name 'tbl_MRSongs'.
/impulse/impulse_MR.asp, line 77
For the record, the connection works fine in Live Data in DW.
Here's the offending code:
<%
var rs_MRSong = Server.CreateObject("ADODB.Recordset");
rs_MRSong.ActiveConnection = MM_con_MR_STRING;
rs_MRSong.Source = "SELECT * FROM tbl_MRSongs WHERE ID_Song = "+
rs_MRSong__MMColParam.replace(/'/g, "''") + "";
rs_MRSong.CursorType = 0;
rs_MRSong.CursorLocation = 2;
rs_MRSong.LockType = 1;
rs_MRSong.Open(); <-- This is line 77
var rs_MRSong_numRows = 0;
%>
Here's the connection string:
var MM_con_MR_STRING = "Provider=MSDASQL;Driver={SQL
Server};Server=(local);Database =
DataBASE;UID=USER;PWD=PASSWORD;Trusted_C
onnection=yes"What changes did u make to the connection string? Also, you might want to
first test this new connection string and if it works by using a UDL file.
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Invalid file name trying to create catelog

I am trying to "Define full text indexing" on a table but
when it attempts to create the catelog, I get the
following error:
Execution of the full text operation failed. The
directory name is invalid.
Any ideas? I check to ensure the directory is correct....
Mike B
What is the path? Normally if the path is too long you get a very specific
error message stating that. Also are you trying to create your catalog on a
fixed disk?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Mike B" <mbujak@.psi-hci.com> wrote in message
news:0a7701c46e71$f0b72230$a301280a@.phx.gbl...
> I am trying to "Define full text indexing" on a table but
> when it attempts to create the catelog, I get the
> following error:
> Execution of the full text operation failed. The
> directory name is invalid.
> Any ideas? I check to ensure the directory is correct....
> Mike B
|||
>--Original Message--
>What is the path? Normally if the path is too long you
get a very specific
>error message stating that. Also are you trying to
create your catalog on a[vbcol=seagreen]
>fixed disk?
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"Mike B" <mbujak@.psi-hci.com> wrote in message
>news:0a7701c46e71$f0b72230$a301280a@.phx.gbl...
but[vbcol=seagreen]
correct....
>
>.
>
I was using the default path :
C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA
I also created a testing folder on C where the catelog
directory name would have been
C:\Tesging
Fixed disk, yes, right on the server c:
Mike B
|||Mike,
What is the <value> for the following registry key on the server where this
problem exists?
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<named_instance>\MSSQLServer
FullTextDefaultPath= <value>
Do you get the same error if you specify a specific path for your new FT
Catalog name <Cat_Address>?
There should be no invisible or un-printable characters in the above <value>
for FullTextDefaultPath. Could you use Regedit and delete the current string
and re-enter it? In the past I've had customer's who had un-printable
(un-viewable) characters in this Registry key value cause similar
problems...
Regards,
John
<anonymous@.discussions.microsoft.com> wrote in message
news:0b1d01c46e7a$38535f70$a301280a@.phx.gbl...
> get a very specific
> create your catalog on a
> but
> correct....
> I was using the default path :
> C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA
> I also created a testing folder on C where the catelog
> directory name would have been
> C:\Tesging
> Fixed disk, yes, right on the server c:
> Mike B
>

Invalid File DSN

Please help me.
Recently I have been getting the following error more and more often:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
General error: Invalid file dsn 'C:\Program Files\Common Files\ODBC\Data
Sources\"name of dsn"
This doesn't occur all the time jsut every now and then, but like I said
this has been happening more often now. If i run an IISRESET on the web
server making the call to the SQL server the error goes away and everything
works fine. I have done some research and everything I have found so far
says not to use File DSNs. However, the web server has over 60 sites on it
and every single one uses a file DSN or two. I am not the developer so I
can not force them to change their coding only make suggestions, but they
don't really like the suggestion to remove FIle DSNs and make calls
directly. If anyone has any other suggestions PLEASE!! let me know.
--sean.
Unfortunately, that's the price you pay with DSNs -- they often end up
being more trouble than they're worth. If you can prevail on your
developers to use direct connection strings instead, you'll all be
much happier in the long run. Valid ODBC connection strings can be
found at www.able-consulting.com/ADO_Conn.htm and
www.connectionstrings.com.
--Mary
On Tue, 8 Feb 2005 15:30:10 -0500, "Sean Kirby"
<sean.kirby@.blazenet.com> wrote:

>Please help me.
>Recently I have been getting the following error more and more often:
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>General error: Invalid file dsn 'C:\Program Files\Common Files\ODBC\Data
>Sources\"name of dsn"
>This doesn't occur all the time jsut every now and then, but like I said
>this has been happening more often now. If i run an IISRESET on the web
>server making the call to the SQL server the error goes away and everything
>works fine. I have done some research and everything I have found so far
>says not to use File DSNs. However, the web server has over 60 sites on it
>and every single one uses a file DSN or two. I am not the developer so I
>can not force them to change their coding only make suggestions, but they
>don't really like the suggestion to remove FIle DSNs and make calls
>directly. If anyone has any other suggestions PLEASE!! let me know.
>--sean.
>

Invalid File DSN

Please help me.
Recently I have been getting the following error more and more often:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
General error: Invalid file dsn 'C:\Program Files\Common Files\ODBC\Data
Sources\"name of dsn"
This doesn't occur all the time jsut every now and then, but like I said
this has been happening more often now. If i run an IISRESET on the web
server making the call to the SQL server the error goes away and everything
works fine. I have done some research and everything I have found so far
says not to use File DSNs. However, the web server has over 60 sites on it
and every single one uses a file DSN or two. I am not the developer so I
can not force them to change their coding only make suggestions, but they
don't really like the suggestion to remove FIle DSNs and make calls
directly. If anyone has any other suggestions PLEASE!! let me know.
--sean.Unfortunately, that's the price you pay with DSNs -- they often end up
being more trouble than they're worth. If you can prevail on your
developers to use direct connection strings instead, you'll all be
much happier in the long run. Valid ODBC connection strings can be
found at www.able-consulting.com/ADO_Conn.htm and
www.connectionstrings.com.
--Mary
On Tue, 8 Feb 2005 15:30:10 -0500, "Sean Kirby"
<sean.kirby@.blazenet.com> wrote:

>Please help me.
>Recently I have been getting the following error more and more often:
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>General error: Invalid file dsn 'C:\Program Files\Common Files\ODBC\Data
>Sources\"name of dsn"
>This doesn't occur all the time jsut every now and then, but like I said
>this has been happening more often now. If i run an IISRESET on the web
>server making the call to the SQL server the error goes away and everything
>works fine. I have done some research and everything I have found so far
>says not to use File DSNs. However, the web server has over 60 sites on it
>and every single one uses a file DSN or two. I am not the developer so I
>can not force them to change their coding only make suggestions, but they
>don't really like the suggestion to remove FIle DSNs and make calls
>directly. If anyone has any other suggestions PLEASE!! let me know.
>--sean.
>

Invalid Character in Flat File or Turncate problem

My source is a csv flat file. Currently I use that same flat file on SQL 2000 and SQL 2005.

On SQL 2000 it runs fine and it inserts that character as part of the string (varchar), however, it gives me truncate error on sql 2005. I already use the "Suggest Types...." and my Output columns have the correct lenght (specially that lehght of that column is only 30 char which is less than the default anyways). If I remove that character it runs fine for that column.....

This is the values that I get in my flat file for the trouble coulmn is "ATTN: JON OLSEN a€“ CTRL8 "

And the error that I get when running the SSIS is

[Flat File Source OrderDetail [1]] Error: Data conversion failed. The data conversion for column "Column 15" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

[Flat File Source OrderDetail [1]] Error: The "output column "ShipToAddr1" (63)" failed because truncation occurred, and the truncation row disposition on "output column "ShipToAddr1" (63)" specifies failure on truncation.
A truncation error occurred on the specified object of the specified component.

[Flat File Source OrderDetail [1]] Error: An error occurred while processing file "C:\Inetpub\ftproot\orderdetail.csv" on data row 6.

Any help greatly approciated.....

Thank you,

Maria

What code page are you using? 1252?|||

Yes, It is 1252.

|||There are more than 30 characters in your example.|||

Hi Phil,

yes, you are right I just counted and it is 32 characters.....What do you suggest - Should I have the flat file to be corrected OR should I handle it on my side in SSIS? If to handle on my side in SSIS - than what's the best way to address it? The table column is 30 char.

I did not realize as it never has been problem in sql 2000

Thank you,

Maria

|||Since you are going into a varchar, try trimming the column.

Stick a derived column between the source and destination and use the RTRIM() character function to eliminate the trailing whitespace. Then it'll fit.

So, in your expression, you'll do: RTRIM([columnname])

Try that. The characters are valid in the 1252 code page, so that shouldn't be an issue.|||

Phil,

The derived column did not solve the issue - it fails before it reaches the derived column. I went to the Flat File Source Editor -> Error Output and change to "Ignore Failure" for Truncate for that Column and that did it. But I am not comfortable with doing it....not sure if that is a right way to do it.

Can you think of anything that I am overlooking before reaching the derived column?

Thank you,

Maria

|||

It may be better to use 'Redirect rows' to a external file for further inspection. May be if you see all the faulty rows you would get better clues. If you still want those rows to make the final destination use a multicast after the error output; then use one output to the error file destination and the other to merge them back to the main flow (via Union all). This won't solve your problem but at least will give you the ability of looking into the faulty rows.

Just a suggestion...

|||How exactly do you have your SSIS package setup? What source, destination, and transformation components do you have and in what order?

You might have to put the derived column *right* after the source and then you may have to remap some columns in downstream components so that they pick up the correct column lengths.|||

Thank you Rafael. I will try that.

Maria

|||

Phil,

within my Data Flow i have it set up as follow

Flat File Source -> Derived Column ->OLE DB Destination.

The data flow part should pretty much take the flat file and insert it into my Tmp table.....and then within Contol Flow i do the update, insert, etc from that tmp table. But the problem that I get is within my Data Flow, Flat File Source to be specific. I only have one Derived Column to format data for couple of other columns including the RTRIM(column_name) that you suggested earlier.

Thank you,

Maria

|||Yep, try Rafael's suggestion and then report back with the error number that's provided for those rows.

Thanks,
Phil|||

Phil and Rafael,

I ran a test with just first 6 rows to see what exactly is happening......And in my ErrorOutput file I was able to see the ErrorCode which was always -1071607675 (Truncate error) in my case and then ErrorColumn which was the ID. What seems to be is that when I did the "Suggest Type....." it picked the Flat File Source External Column width from flat file which has columns width bigger by 1 or 2 char from Flat file source Output column....So that is why this is failing and gives me the truncate error message. The Flat file source Output Column has the correct width. The bigger width in External Column is random and it is dependent on whats in the flat file so I cannot assume that my Product Description column will be always 81 varchar, for some products might be bigger depending on what the invalid character will be......I guess it is caused by the ascii char that cannot be properly handled by text editor.....

We will have to address the problem at the point where the flat file is being generated and my SSIS should work just fine.

Thank you both for your help.

Maria

|||

mariap wrote:

Phil and Rafael,

I ran a test with just first 6 rows to see what exactly is happening......And in my ErrorOutput file I was able to see the ErrorCode which was always -1071607675 (Truncate error) in my case and then ErrorColumn which was the ID. What seems to be is that when I did the "Suggest Type....." it picked the Flat File Source External Column width from flat file which has columns width bigger by 1 or 2 char from Flat file source Output column....So that is why this is failing and gives me the truncate error message. The Flat file source Output Column has the correct width. The bigger width in External Column is random and it is dependent on whats in the flat file so I cannot assume that my Product Description column will be always 81 varchar, for some products might be bigger depending on what the invalid character will be......I guess it is caused by the ascii char that cannot be properly handled by text editor.....

We will have to address the problem at the point where the flat file is being generated and my SSIS should work just fine.

Thank you both for your help.

Maria

Just remember that suggest types is only valid for getting you to a starting point. You should still implement your own quality control for every column to be sure they are correct. Don't rely on the suggest types feature to be accurate as you are finding out.

Phil|||

Thank you Phil. you are absolutly right!

Maria