SP Load balancing and ODBC

[Paul Brears]

I've found the load balancer is un sticky enough that I do need to use
the ODBC plugin to avoid the user entering a redirect loop trying to
sign in between /SAML/POST and /secure.

It appears that IE kindly opens two connection to the SP website; one of
which lands on each server.

 

I've got ODBC basically working with an existing SQL db; however on two
occasions it's got stuck.

 

2012-09-20 16:09:43 DEBUG XMLTooling.StorageService [1]: SQL: SELECT
version,expires,CASE version WHEN 0 THEN null ELSE value END FROM texts
WHERE context='NameID' AND id='_7e0806061a5c449da3674a8b4cd25f30' AND
expires > {ts '2012-09-20 16:09:43'}

2012-09-20 16:09:43 DEBUG XMLTooling.StorageService [1]: SQLPrepare
succeeded. SQL: INSERT INTO texts VALUES (?,?,{ts '2012-09-20
16:19:16'},1,?)

2012-09-20 16:09:43 DEBUG XMLTooling.StorageService [1]: SQLBindParam
succeeded (context = NameID)

2012-09-20 16:09:43 DEBUG XMLTooling.StorageService [1]: SQLBindParam
succeeded (key = _7e0806061a5c449da3674a8b4cd25f30)

2012-09-20 16:09:43 DEBUG XMLTooling.StorageService [1]: SQLBindParam
succeeded (value = <wddxPacket version="1.0"
lowercase="no"><header/><data><struct><var
name="4037adca1a9852ebcfde22621ca2e95563a3ea8e55868d68f193bcdffcc12cd8">
<array
length="1"><string>_e89706f8f40a49210a175fbc28bc7512</string></array></v
ar></struct></data></wddxPacket>)

2012-09-20 16:09:43 ERROR XMLTooling.StorageService [1]: insert record
failed (t=texts, c=NameID, k=_7e0806061a5c449da3674a8b4cd25f30)

2012-09-20 16:09:43 ERROR XMLTooling.StorageService [1]: ODBC Error:
23000:1:2627:[Microsoft][SQL Server Native Client 10.0][SQL
Server]Violation of PRIMARY KEY constraint
'PK__texts__797849F78C9DE53D'. Cannot insert duplicate key in object
'dbo.texts'. The duplicate key value is (NameID,
_7e0806061a5c449da3674a8b4cd25f30).

2012-09-20 16:09:43 ERROR XMLTooling.StorageService [1]: ODBC Error:
01000:2:3621:[Microsoft][SQL Server Native Client 10.0][SQL Server]The
statement has been terminated.

 

It continually reties to insert (and fails) the data then shibd exits on
one or both servers.

 

Are there any known issues with the ODBC plugin and MS SQL using SQL
Server Native Client 10.0?

 

Regards,

Paul
____________________________________________________________________


RM Books - the first ever ebook system designed specifically for schools.

Coming in Autumn 2012 - pre-register for free now!

www.RMbookshelf.com

____________________________________________________________________

P.S. Think Green - don't print this email unless you really need to.
This message is confidential. You should not copy it or disclose its contents to anyone. You may use and apply the information only for the intended purpose. Internet communications are not secure and therefore RM Education does not accept legal responsibility for the contents of this message. Any views or opinions presented are only those of the author and not those of RM Education. If this email has come to you in error please delete it and any attachments. Please note that RM Education may intercept incoming and outgoing email communications.

RM Education plc is a company registered in England and Wales, Company Reg. No: 01148594; Registered Office: New Mill House, 183 Milton Park, Abingdon, OXON OX14 4SE; VAT No: 630 8236 56
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://shibboleth.net/pipermail/users/attachments/20120920/69c0c9a1/attachment.html