Invisible rows after failed syncronization

Publisher: SQL Server 2000 SP4
Subscriber: SQL Server 2005 Mobile Edition

Sometimes, after a failed merge replication(due to communication error) some rows on the subscriber became invisible for the publisher.

I've reproduced a case:

[START Short Version]
All rows inserted between a comm failed sync and a fine sync became invisible.
This seems to be caused because the subscriber keeps generating rows with the same generation number and the publisher doesn't look for this generation anymore.
[END Short Version]

[START Detailed case]
STEP 0: INITIAL STATE
Publisher
Orders Table
EMPTY

Subscriber
NO DATABASE

STEP 1: After FIRST SYNC and INSERTING 2 Orders

Publisher

Orders Table

EMPTY

Subscriber

Orders Table
OrderId __sysIG __sysCG __sysMC
000001 4 4 81
000002 4 4 81

STEP 2: After SECOND SYNC

Publisher

Orders Table

OrderId

000001

000002

Subscriber

Orders Table

OrderId __sysIG __sysCG __sysMC

000001 4 4 80

000002 4 4 80

STEP 3: INSERT ANOTHER ORDER

Subscriber

Orders Table

OrderId __sysIG __sysCG __sysMC

000001 4 4 80

000002 4 4 80

000003 6 6 81

STEP 4: After THIRD SYNC (with comm error)
Error: [NativeError:28037][HRESULT:-2147012889]->[A request to send data to the computer running IIS has failed. For more information, see HRESULT.]
When: Error happens provoked after sending from Subscriber to Publisher but before ending syn process.
Publisher
Orders Table

OrderId

000001

000002

000003
Subscriber
Orders Table

OrderId __sysIG __sysCG __sysMC

000001 4 4 80

000002 4 4 80
000003 6 6 81
Note: Publisher has the row but subscriber keeps the state in 81.

STEP 5: INSERT ANOTHER ORDER (BEFORE A GOOD SYNC)
Subscriber
Orders Table

OrderId __sysIG __sysCG __sysMC

000001 4 4 80

000002 4 4 80
000003 6 6 81

000004 6 6 81
Note: Orders 000003 and 000004 have the same system info

STEP 6: After FOURTH SYNC
Publisher
Orders Table

OrderId
000001

000002

000003
Subscriber
Orders Table

OrderId __sysIG __sysCG __sysMC

000001 4 4 80

000002 4 4 80
000003 6 6 81

000004 6 6 81

Note: Even with a fine merge process Publisher didn't get the 000004 row and the Subscriber didn't update the __sysMC

STEP 7: INSERT ANOTHER ORDER

Subscriber

Orders Table
OrderId __sysIG __sysCG __sysMC
000001 4 4 80
000002 4 4 80

000003 6 6 81

000004 6 6 81

000005 8 8 81

STEP 8: After FIFTH SYNC

Publisher
Orders Table
OrderId
000001
000002
000003
000005
Subscriber
Orders Table
OrderId __sysIG __sysCG __sysMC
000001 4 4 80
000002 4 4 80
000003 6 6 81

000004 6 6 81

000002 8 8 80

Note: Data from generation 8 merge correctly, but data from generation 6 keeps invisible to publisher.
STEP 9: DUMMY UPDATE ON GEN 6 ROWS
Action: I made a non relevant update to force the Subscriber update the generation.
Subscriber
Orders Table

OrderId __sysIG __sysCG __sysMC

000001 4 4 80

000002 4 4 80
000003 6 10 81
000004 6 10 81
000005 8 8 80

Note: sysCG get its value updated correctly.

STEP 10: After SIXTH SYNC

Publisher
Orders Table
OrderId
000001
000002
000003
000004

000005
Subscriber
Orders Table
OrderId __sysIG __sysCG __sysMC
000001 4 4 80
000002 4 4 80

000003 6 6 80

000004 6 6 80

000002 8 8 80

Note: Data merges correctly.
[END Detailed case]

I could code a system that checks all the publication tables and updates all the last generation rows in case of communication error but i would really like to avoid doing it.

I don't know if I'm missing something or if this is a bug or a known issue.

This is a big problem for me because communication errors on cellular phone based connection are quite common and users keep working even if there's an error.

Any comment will be appreciated.Finally, I've modified my replication process solve this manually.

On a normal case (no previous error):
1. I get the current generation (__sysMergeSubscriptions.LastUploadedGen+1)
2. Launch a normal sync.
3. If it fails I save the failed generation for using it on next sync.

On the previous error case:
1. Do a normal sync (to get a valid __sysMergeSubscriptions.LastUploadedGen)
2. Do a dummy update on all rows (from all published tables (from __sysMergeArticles)) that __sysIG or __sysCG equals the wrong generation number.
3. Do a normal sync to send all the invisible rows to the publisher.

I don't like my own solution, but that's the only way I have to keep the system working as I haven't find any reference to this problem anywhere.|||

Hey MeZKaL,

I just have few questions to narrow downt he problem point in the whole path of sync components.

In the same above scenario, can you please also let me know the contents of __sysMergeSubscription and
__sysMergeSubscriptionProperties table for that subscription in each of the above STEPs (esp. Steps 4 to 6)?

Basically, I just want to know which of the following is true (after a failed sync)

1) Client did not enumerate the changes and hence did not send the changes

2) Client has enumerated the changes, sent the changes but metadata does not say its new change

3) Client has enumerated, sent the changes, metadata also says its a new change, but publisher ignores it for some internal
reasons like publisher metadata says its a false change ...etc

Thanks,

Laxmi

|||I repeated the case saving a copy of the mobile db for each step.

There are no changes on __sysMergeSubscriptionProperties so I will put it just one time.

__sysMergeSubscriptionProperties
SubscriptionId: 87a0e646-d908-b0b9-e2b1-d6eb58165c8f
Distributor
DistributorAddress
DistributorNetwork: 0
DistributorSecurityMode: 1
DistributorLogin
DistributorPassword
ExchangeType: 3
InternetLogin: domain\user
InternetURL: URL
InternetPassword: *******
LoginTimeout: 15
ProfileName: DEFAULT
Publisher: SERVER\INSTANCE
PublisherAddress
PublisherNetwork: 0
PublisherDatabase: DBName
PublisherSecurityMode: 1
PublisherLogin: domain\user
PublisherPassword: *******
Publication: PubName
QueryTimeout: 300
Validate: 0
HostName
Subscriber: domain\user
InternetProxyServer
InternetProxyLogin
InternetProxyPassword
ConnectionRetryTimeout: 120
CompressionLevel: 1
ConnectionManager: 0
SnapshotTransferType: 99

Many of the field value from __sysMergeSubscriptions didn't change during the process.

__sysMergeSubscriptions
Publisher: server\instance
PublisherDatabase: DBName
Publication: PubName
PublicationId: 03e497f6-83b6-4de3-87e3-e97835880c94
SubscriptionId: 87a0e646-d908-b0b9-e2b1-d6eb58165c8f
SyncPartnerId: 751a4dfe-2eba-7a4a-b11a-35beec9a8bf3
SyncAnchorId: 00000000-0000-0000-0000-000000000000
SchemaVersion: 481
SchemaVersionId: 00000000-0000-0000-0000-000000000000
ReplNick (casted to int): -312916250
Retention: 0
MachineId: 374677b5-b002-d9f5-d4e4-4628538f2ccd
PathName: Path\DB.sdf
ReinitRequested: 0
ReplProp: NULL
HostName:
ValidationHostName: 0
ReplicaState: 00000000-0000-0000-0000-000000000000
LastCleanupDate: 15/11/2006 16:30
ReconcilerVersion: 8
Subscriber: domain\user

[START Detailed case]

STEP 1: After FIRST SYNC
Publisher
Orders Table
EMPTY

Subscriber
Orders Table
EMPTY

__sysMergeSubscriptions
SyncAnchor LastUploadedGen LastSuccessfulSync SentGen80
4977 0 15/11/2006 16:30 70
SentGen80Id: 61327c39-f34b-15d1-3924-8e2577f94d6f

STEP 2: After INSERTING 2 Orders
Subscriber
Orders Table
OrderId __sysIG __sysCG __sysMC
57000 4 4 81
57001 4 4 81

__sysMergeSubscriptions
SyncAnchor LastUploadedGen LastSuccessfulSync SentGen80
4977 0 15/11/2006 16:30 70
SentGen80Id: 61327c39-f34b-15d1-3924-8e2577f94d6f

STEP 3: After SECOND SYNC (with comm error)
Error: [NativeError:28037][HRESULT:-2147012889]->[A request to send data to the computer running IIS has failed. For more information, see HRESULT.]
When: Error happens provoked after sending from Subscriber to Publisher but before ending syn process.
Publisher
Orders Table
OrderId
57000
57001

Subscriber
Orders Table
OrderId __sysIG __sysCG __sysMC
57000 4 4 81
57001 4 4 81

__sysMergeSubscriptions
SyncAnchor LastUploadedGen LastSuccessfulSync SentGen80
4977 0 15/11/2006 16:30 70
SentGen80Id: 61327c39-f34b-15d1-3924-8e2577f94d6f

STEP 4: INSERT ANOTHER ORDER
Subscriber
Orders Table
OrderId __sysIG __sysCG __sysMC
57000 4 4 81
57001 4 4 81
57002 4 4 81

__sysMergeSubscriptions
SyncAnchor LastUploadedGen LastSuccessfulSync SentGen80
4977 0 15/11/2006 16:30 70
SentGen80Id: 61327c39-f34b-15d1-3924-8e2577f94d6f

STEP 5: After THIRD SYNC
Publisher
Orders Table
OrderId
57000
57001

Subscriber
Orders Table
OrderId __sysIG __sysCG __sysMC
57000 4 4 81
57001 4 4 81
57002 4 4 81

__sysMergeSubscriptions
SyncAnchor LastUploadedGen LastSuccessfulSync SentGen80
5095 5 15/11/2006 17:22 71
SentGen80Id: e5ff3df6-195c-3145-273e-86784ace7e16

STEP 6: DUMMY UPDATE
Subscriber
Orders Table
OrderId __sysIG __sysCG __sysMC
57000 4 6 81
57001 4 6 81
57002 4 6 81

__sysMergeSubscriptions
SyncAnchor LastUploadedGen LastSuccessfulSync SentGen80
5095 5 15/11/2006 17:22 71
SentGen80Id: e5ff3df6-195c-3145-273e-86784ace7e16

STEP 7: After FOURTH SYNC
Publisher
Orders Table
OrderId
57000
57001
57002

Subscriber
Orders Table
OrderId __sysIG __sysCG __sysMC
57000 4 6 80
57001 4 6 80
57002 4 6 80

__sysMergeSubscriptions
SyncAnchor LastUploadedGen LastSuccessfulSync SentGen80
5213 7 15/11/2006 17:35 72
SentGen80Id
SentGen80Id: 4171a971-b963-a541-300a-0b1602902e39

[__sysMergeSubscriptions DETAIL]
SyncAnchor LastUploadedGen LastSuccessfulSync SentGen80
step1 4977 0 15/11/2006 16:30 70
step2 4977 0 15/11/2006 16:30 70
step3 4977 0 15/11/2006 16:30 70
step4 4977 0 15/11/2006 16:30 70
step5 5095 5 15/11/2006 17:22 71
step6 5095 5 15/11/2006 17:22 71
step7 5213 7 15/11/2006 17:35 72

SentGen80Id
61327c39-f34b-15d1-3924-8e2577f94d6f
61327c39-f34b-15d1-3924-8e2577f94d6f
61327c39-f34b-15d1-3924-8e2577f94d6f
61327c39-f34b-15d1-3924-8e2577f94d6f
e5ff3df6-195c-3145-273e-86784ace7e16
e5ff3df6-195c-3145-273e-86784ace7e16
4171a971-b963-a541-300a-0b1602902e39|||Can you open a case with CSS please for this? That way we can get a better handle on this in a timely manner.|||My workaround runs pretty well and I don't have time now for spending hours and hours crossing mails and test results with a support service.

If anyone can help with the previous data, it'll be welcomed but I won't spent more time testing and logging for this issue. I've lots of work and not many time.

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...

InvalidReportServerDatabaseException RS 2000

After upgrading to SP2, I get the following errors while tying to access the report server:

aspnet_wp!library!160!11/16/2006-15:04:07:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.43'. The expected version is 'C.0.6.54'. To continue, update the version of the report server database and verify access rights., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.43'. The expected version is 'C.0.6.54'. To continue, update the version of the report server database and verify access rights.

The message would indicate that i need to run some scripts that possibly did not get run during the SP2 upgrade? I am running RS with a remote database.

Not sure why your database wasn't upgraded. That is supposed to happen automagically.

You should be able to generate a script with the RSConfigTool.exe that you can then run on the database manually.

Run RSConfigTool.exe

Choose Database Setup

Choose Script ...

Choose the appropriate values

Invalid XML Elements found inside cync block

I'm receiving the following error when attempting to execute an
updategram using SQL 2005 and SQLXML 4.0
FrostingModel.Tests.Artist.InvalidConcurrencyUpdate :
Microsoft.Data.SqlXml.SqlXmlException : HRESULT="0x80004005"
Description="Invalid XML elements found inside sync block"
Here is my updategram.
<u>
<updg:sync mapping-schema=".\Schemata\Artist.xsd" nullvalue="NULL"
xmlns:updg="urn:schemas-microsoft-com:xml-updategram">
<updg:before>
<ns1:Artist updg:id="0" ArtistID="1716"
UpdateStamp="AAAAAAAADUw=" xmlns:ns1="urn:Frosting" />
</updg:before>
<updg:after>
<ns1:Artist updg:id="0" ArtistID="1716" Name="Blah Blah Update"
xmlns:ns1="urn:Frosting" />
</updg:after>
</updg:sync>
</u>
And here is the accompanying schema:
<xsd:complexType name="Artist">
<xsd:attribute name="ArtistID" type="xsd:int" use="required"
sql:identity="ignore" sql:datatype="int" />
<xsd:attribute name="Name" type="xsd:string" use="optional"
sql:datatype="nvarchar" />
<xsd:attribute name="UpdateStamp" use="optional" dt:type="bin.hex"
sql:datatype="timestamp" sql2:concurrency="UseValue" />
</xsd:complexType>
It should be noted that if I use concurrency on the Name attribute, it
works as expected. However I would prefer to use a timestamp - it's
the timestamp that seems to be the big proverbial pain in the arse.
I can't seem to find any solutions online regarding this problem... any
takers?
- ryan.Okay...
I changed my UpdateStamp value to be something like 0x000000000000101A
and the updategram worked as expected. However this doesn't make any
sense, because SQL 2005's FOR XML EXPLICIT returns the timestamp value
in a 12 character format such as "AAAAAAAADUw=", not in the above
format.
Am I missing something, or is this a bug in SQLXML 4.0 / SQL 2005? How
is it that SQL 2005 can emit a timestamp value in that "AAA..." format,
but it can't accept it? Do I have to do some type of conversion on my
client side after I receive the timestamp value from sql server?
Any help would be appreciated,
- cranley
cranley wrote:
> I'm receiving the following error when attempting to execute an
> updategram using SQL 2005 and SQLXML 4.0
> FrostingModel.Tests.Artist.InvalidConcurrencyUpdate :
> Microsoft.Data.SqlXml.SqlXmlException : HRESULT="0x80004005"
> Description="Invalid XML elements found inside sync block"
> Here is my updategram.
> <u>
> <updg:sync mapping-schema=".\Schemata\Artist.xsd" nullvalue="NULL"
> xmlns:updg="urn:schemas-microsoft-com:xml-updategram">
> <updg:before>
> <ns1:Artist updg:id="0" ArtistID="1716"
> UpdateStamp="AAAAAAAADUw=" xmlns:ns1="urn:Frosting" />
> </updg:before>
> <updg:after>
> <ns1:Artist updg:id="0" ArtistID="1716" Name="Blah Blah Update"
> xmlns:ns1="urn:Frosting" />
> </updg:after>
> </updg:sync>
> </u>
> And here is the accompanying schema:
> <xsd:complexType name="Artist">
> <xsd:attribute name="ArtistID" type="xsd:int" use="required"
> sql:identity="ignore" sql:datatype="int" />
> <xsd:attribute name="Name" type="xsd:string" use="optional"
> sql:datatype="nvarchar" />
> <xsd:attribute name="UpdateStamp" use="optional" dt:type="bin.hex"
> sql:datatype="timestamp" sql2:concurrency="UseValue" />
> </xsd:complexType>
> It should be noted that if I use concurrency on the Name attribute, it
> works as expected. However I would prefer to use a timestamp - it's
> the timestamp that seems to be the big proverbial pain in the arse.
> I can't seem to find any solutions online regarding this problem... any
> takers?
> - ryan.

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 Udate SQL statement DOES NOT cause error... Does anyone know why?

Here's my update statement:

UPDATE Item1
SET reviewloop = 1, currentreviewstate=5
WHERE itemid in
(SELECT itemid FROM Item2)

The thing is: the table Item2 DOES NOT HAVE a field called itemid.
So, I should receive an error, right? Not so.Instead, every single
record in Item1 was updated.

Does anyone know why SQL Serverr does not trown an error?

Thanks guys,

-Silvio SouzaBecause the sub query can reference fields from the update. itemid in this
case will be retrieved from Item1.|||The rule for subqueries is that a column name that can't be resolved to
column within the subquery is assumed to reference a column in the outer
query. If in doubt, use the two-part column name including the table
name/alias.

--
David Portas
SQL Server MVP
--|||"no spam" <chuck@.sheckmedia.com> wrote in message news:<vCWhc.71068$Lh2.5553@.bignews1.bellsouth.net>...
> Because the sub query can reference fields from the update. itemid in this
> case will be retrieved from Item1.

I don't think so. SQL certainly doesn't say to itself "Since I can't
find that value in Item2 I'll assume that they must mean the value in
Item1" - that would be catastrophic.

I've just tried this myself, and whilst it didn't give any error, it
didn't update any rows in Item1 either. This makes sense, because
the subquery is simply evaluating to FALSE, so 0 rows are updated in
the main query.|||> I don't think so. SQL certainly doesn't say to itself "Since I can't
> find that value in Item2 I'll assume that they must mean the value in
> Item1" - that would be catastrophic.

The problem isn't to do with *values* it's to do with resolution of *column
names*. Substitute the word "column" for "value" and your statement
describes exactly what SQL does.

Assuming the column Itemid doesn't exist in Item2, the UPDATE statement you
posted is equivalent to:

UPDATE Item1
SET reviewloop = 1, currentreviewstate=5
WHERE Item1.itemid IN
(SELECT Item1.itemid FROM Item2)

As long as there is at least one row in Item2, every row in Item1 should get
updated.

--
David Portas
SQL Server MVP
--|||Any field reference in a sub query will always look for the field internally
first and if not found it will look in the outer query. The reason for this
behaviour is that the sub query can use values from the outer query as
selection criteria, in case statements etc.

This is not a bug, it is by design. By always using table qualifiers in all
sql it will never cause a problem even if the developer mistypes a field
name.
Sloppy SQL (without proper table qualifiers etc) may behave funny as in the
example provided by the OP.

Also, if you look at the execution plan for this and similar queries it will
be more clear why. The optimizer usually turn sub queries like this into
joins.

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

Invalid syntax near nvarchar

Im trying to update and modify data in a grid view in my sql data base. I keep getting this error..What is the solution to this. Sorry, I have no programing experience. All help will be greatly appreciated. thank you
jdslim

Incorrect syntax near 'nvarchar'.

Description:Anunhandled exception occurred during the execution of the current webrequest. Please review the stack trace for more information about theerror and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Incorrect syntax near 'nvarchar'.

Source Error:

An unhandled exception was generated during the execution of thecurrent web request. Information regarding the origin and location ofthe exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Incorrect syntax near 'nvarchar'.]
 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +95
 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +82
 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346
 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3244
 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +186
 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1121
 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +334
 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +407
 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +149
 System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +493
 System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +915
 System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +179
 System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +1140
 System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +835
 System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +162
 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56
 System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +118
 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56
 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +107
 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +175
 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +244
 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3840

It would help if you posted your code.

|||

Here is the new stack trace and the code that goes with it. I started a new page that just contains the gridview and the sql data source.

Stack Trace:

[SqlException (0x80131904): Incorrect syntax near 'nvarchar'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +177 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +68 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2300 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +147 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1021 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +314 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +413 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +115 System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +392 System.Web.UI.WebControls.SqlDataSourceView.ExecuteDelete(IDictionary keys, IDictionary oldValues) +638 System.Web.UI.DataSourceView.Delete(IDictionary keys, IDictionary oldValues, DataSourceViewOperationCallback callback) +71 System.Web.UI.WebControls.GridView.HandleDelete(GridViewRow row, Int32 rowIndex) +933 System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +1152 System.Web.UI.WebControls.GridView.RaisePostBackEvent(String eventArgument) +191 System.Web.UI.WebControls.GridView.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +172 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4919

<%

@.PageLanguage="VB" %>

<!

DOCTYPEhtmlPUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<

scriptrunat="server">

</

script>

<

htmlxmlns="http://www.w3.org/1999/xhtml">

<

headrunat="server"><title>Untitled Page</title>

</

head>

<

body><formid="form1"runat="server"><div> <asp:SqlDataSourceID="SqlDataSource1"runat="server"ConflictDetection="CompareAllValues"ConnectionString="<%$ ConnectionStrings:ConnectionString %>"DeleteCommand="DELETE FROM [Trials] WHERE [Trial#] = @.original_column1 AND [Wet Date] = @.original_Wet_Date AND [Check Date] = @.original_Check_Date AND [Comments] = @.original_Comments"InsertCommand="INSERT INTO [Trials] ([Trial#], [Wet Date], [Check Date], [Comments]) VALUES (@.column1, @.Wet_Date, @.Check_Date, @.Comments)"OldValuesParameterFormatString="original_{0}"SelectCommand="SELECT * FROM [Trials]"UpdateCommand="UPDATE [Trials] SET [Wet Date] = @.Wet_Date, [Check Date] = @.Check_Date, [Comments] = @.Comments WHERE [Trial#] = @.original_column1 AND [Wet Date] = @.original_Wet_Date AND [Check Date] = @.original_Check_Date AND [Comments] = @.original_Comments"><DeleteParameters><asp:ParameterName="original_column1"Type="String"/><asp:ParameterName="original_Wet_Date"Type="DateTime"/><asp:ParameterName="original_Check_Date"Type="DateTime"/><asp:ParameterName="original_Comments"Type="String"/></DeleteParameters><UpdateParameters><asp:ParameterName="Wet_Date"Type="DateTime"/><asp:ParameterName="Check_Date"Type="DateTime"/><asp:ParameterName="Comments"Type="String"/><asp:ParameterName="original_column1"Type="String"/><asp:ParameterName="original_Wet_Date"Type="DateTime"/><asp:ParameterName="original_Check_Date"Type="DateTime"/><asp:ParameterName="original_Comments"Type="String"/></UpdateParameters><InsertParameters><asp:ParameterName="column1"Type="String"/><asp:ParameterName="Wet_Date"Type="DateTime"/><asp:ParameterName="Check_Date"Type="DateTime"/><asp:ParameterName="Comments"Type="String"/></InsertParameters></asp:SqlDataSource></div><asp:GridViewID="GridView1"runat="server"AllowSorting="True"AutoGenerateColumns="False"DataKeyNames="Trial#"DataSourceID="SqlDataSource1"Style="z-index: 100; left: 538px; position: absolute; top: 391px"><Columns><asp:CommandFieldShowDeleteButton="True"ShowEditButton="True"/><asp:BoundFieldDataField="Trial#"HeaderText="Trial#"ReadOnly="True"SortExpression="Trial#"/><asp:BoundFieldDataField="Wet Date"HeaderText="Wet Date"SortExpression="Wet Date"/><asp:BoundFieldDataField="Check Date"HeaderText="Check Date"SortExpression="Check Date"/><asp:BoundFieldDataField="Comments"HeaderText="Comments"SortExpression="Comments"/></Columns></asp:GridView></form>

</

body>

</

html>|||

Hi

I just want to check if you ever solved the problem? I'm sitting with the same thing, but nothing will work...

I've tried the suggestions made, but it still doesn't work.

|||

Hi

I just want to check if you ever solved the problem? I'm sitting with the same thing, but nothing will work...

I've tried the suggestions made, but it still doesn't work.

|||you are better off starting a new thread and post your codes there