SQL Server - Function sequence error on transaction::Commit()

6 messages Options
Embed this post
Permalink
Chris Erickson-2

SQL Server - Function sequence error on transaction::Commit()

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

Can anyone tell me what this error would mean?

 

System.Exception: Error merging data ---> OSGeo.FDO.Common.Exception: RDBMS: [Microsoft][ODBC Driver Manager] Function sequence error

   at OSGeo.FDO.Connections.ITransactionImp.Commit()

   at SDT.DataInterchange.Fdo.FdoDatabase.CommitTransaction()

 

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 



_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
Chris Erickson-2

RE: SQL Server - Function sequence error on transaction::Commit()

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

This could be related to z/m values.

 

Does the SQL Spatial provider support Z or M?

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Friday, August 21, 2009 10:07 AM
To: FDO Users Mail List
Subject: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

Can anyone tell me what this error would mean?

 

System.Exception: Error merging data ---> OSGeo.FDO.Common.Exception: RDBMS: [Microsoft][ODBC Driver Manager] Function sequence error

   at OSGeo.FDO.Connections.ITransactionImp.Commit()

   at SDT.DataInterchange.Fdo.FdoDatabase.CommitTransaction()

 

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 



_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
Chris Erickson-2

RE: SQL Server - Function sequence error on transaction::Commit()

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

Anyone?  Still wondering if Z/M values are supported by the provider…

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Friday, August 21, 2009 10:18 AM
To: FDO Users Mail List
Subject: RE: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

This could be related to z/m values.

 

Does the SQL Spatial provider support Z or M?

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Friday, August 21, 2009 10:07 AM
To: FDO Users Mail List
Subject: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

Can anyone tell me what this error would mean?

 

System.Exception: Error merging data ---> OSGeo.FDO.Common.Exception: RDBMS: [Microsoft][ODBC Driver Manager] Function sequence error

   at OSGeo.FDO.Connections.ITransactionImp.Commit()

   at SDT.DataInterchange.Fdo.FdoDatabase.CommitTransaction()

 

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 



_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
Dan Stoica

RE: SQL Server - Function sequence error on transaction::Commit()

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

Hi,

 

By looking at the capabilities I see that currently Z/M are not supported.  I believe that initially MS SqlServer did not support these types.

 

Dan.

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Tuesday, September 01, 2009 3:21 PM
To: FDO Users Mail List
Subject: RE: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

Anyone?  Still wondering if Z/M values are supported by the provider…

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Friday, August 21, 2009 10:18 AM
To: FDO Users Mail List
Subject: RE: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

This could be related to z/m values.

 

Does the SQL Spatial provider support Z or M?

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Friday, August 21, 2009 10:07 AM
To: FDO Users Mail List
Subject: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

Can anyone tell me what this error would mean?

 

System.Exception: Error merging data ---> OSGeo.FDO.Common.Exception: RDBMS: [Microsoft][ODBC Driver Manager] Function sequence error

   at OSGeo.FDO.Connections.ITransactionImp.Commit()

   at SDT.DataInterchange.Fdo.FdoDatabase.CommitTransaction()

 

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 



_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
Chris Erickson-2

RE: SQL Server - Function sequence error on transaction::Commit()

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

Does anyone have any idea how hard it would be to implement?  I haven’t looked, but could perhaps get the time approved to do it.

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Dan Stoica
Sent: Wednesday, September 02, 2009 8:55 AM
To: FDO Users Mail List
Subject: RE: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

Hi,

 

By looking at the capabilities I see that currently Z/M are not supported.  I believe that initially MS SqlServer did not support these types.

 

Dan.

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Tuesday, September 01, 2009 3:21 PM
To: FDO Users Mail List
Subject: RE: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

Anyone?  Still wondering if Z/M values are supported by the provider…

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Friday, August 21, 2009 10:18 AM
To: FDO Users Mail List
Subject: RE: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

This could be related to z/m values.

 

Does the SQL Spatial provider support Z or M?

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Friday, August 21, 2009 10:07 AM
To: FDO Users Mail List
Subject: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

Can anyone tell me what this error would mean?

 

System.Exception: Error merging data ---> OSGeo.FDO.Common.Exception: RDBMS: [Microsoft][ODBC Driver Manager] Function sequence error

   at OSGeo.FDO.Connections.ITransactionImp.Commit()

   at SDT.DataInterchange.Fdo.FdoDatabase.CommitTransaction()

 

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 



_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
Dan Stoica

RE: SQL Server - Function sequence error on transaction::Commit()

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

It might be very tricky because WKB doesn’t support Z/M (that is, the format doesn’t contain a ‘dimensionality’ field and XY is always assumed). This is the format the provider is using for input/output.

 

I guess when MS says that SqlServer supports Z/M data that means it supports WKT representation which we cannot use because of performance issues.

 

Related to your error: I don’t think it is related to Z/M data because in such case you should you see an FDO exception “unsupported geometry type”.

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Wednesday, September 02, 2009 11:01 AM
To: FDO Users Mail List
Subject: RE: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

Does anyone have any idea how hard it would be to implement?  I haven’t looked, but could perhaps get the time approved to do it.

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Dan Stoica
Sent: Wednesday, September 02, 2009 8:55 AM
To: FDO Users Mail List
Subject: RE: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

Hi,

 

By looking at the capabilities I see that currently Z/M are not supported.  I believe that initially MS SqlServer did not support these types.

 

Dan.

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Tuesday, September 01, 2009 3:21 PM
To: FDO Users Mail List
Subject: RE: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

Anyone?  Still wondering if Z/M values are supported by the provider…

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Friday, August 21, 2009 10:18 AM
To: FDO Users Mail List
Subject: RE: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

This could be related to z/m values.

 

Does the SQL Spatial provider support Z or M?

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Chris Erickson
Sent: Friday, August 21, 2009 10:07 AM
To: FDO Users Mail List
Subject: [fdo-users] SQL Server - Function sequence error on transaction::Commit()

 

Can anyone tell me what this error would mean?

 

System.Exception: Error merging data ---> OSGeo.FDO.Common.Exception: RDBMS: [Microsoft][ODBC Driver Manager] Function sequence error

   at OSGeo.FDO.Connections.ITransactionImp.Commit()

   at SDT.DataInterchange.Fdo.FdoDatabase.CommitTransaction()

 

 

cid:image003.png@01C8E59D.204D9280

chris erickson

developer

[hidden email]

970.493.9500 x 191

970.482.1485 (fax)

 

 



_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users