[JIRA] (JJDBC-17) ERROR when JSON Parsing with MS SQL Server

[Martin Hitschel (Jira)]

Martin Hitschel ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=60ad392346b55100698aa768 ) *commented* on JJDBC-17 ( https://shibboleth.atlassian.net/browse/JJDBC-17?atlOrigin=eyJpIjoiMDRjYzcyM2UzMTJmNDFjYTgwYmNhMmFmOTYyNjEwZTUiLCJwIjoiaiJ9 )

Re: ERROR when JSON Parsing with MS SQL Server ( https://shibboleth.atlassian.net/browse/JJDBC-17?atlOrigin=eyJpIjoiMDRjYzcyM2UzMTJmNDFjYTgwYmNhMmFmOTYyNjEwZTUiLCJwIjoiaiJ9 )

Rod Widdowson ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=59fb32bbc24efb3c4ed3c977 ) Concerning the hangover, I did actually convert shibpid and StorageRecords from a mySQL export. I had some attempts until the SQL server would accept the import. Besides the table definition, however, the only thing I adapted was the date columns of the shibpid table.

Do you suspect other records would have an influence? As I wrote, I had removed all Consent records of that user and could reproduce the error: the IdP throes this Runtime exception but does store the record, since on second log-in everything works smooth.

( https://shibboleth.atlassian.net/browse/JJDBC-17#add-comment?atlOrigin=eyJpIjoiMDRjYzcyM2UzMTJmNDFjYTgwYmNhMmFmOTYyNjEwZTUiLCJwIjoiaiJ9 ) Add Comment ( https://shibboleth.atlassian.net/browse/JJDBC-17#add-comment?atlOrigin=eyJpIjoiMDRjYzcyM2UzMTJmNDFjYTgwYmNhMmFmOTYyNjEwZTUiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100206- sha1:66dd41f )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/commits/attachments/20220908/6a469374/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-comment-icon-85dff753-4beb-40c6-a359-17dac99ed738
Type: image/png
Size: 1084 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220908/6a469374/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-avatar-f4d9ca1d-7cb4-4b02-83c3-f3077bc0a543
Type: image/png
Size: 425 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220908/6a469374/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-footer-desktop-logo-6e067c3e-6bd2-4dd3-a9f3-765053d0c402
Type: image/png
Size: 10805 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220908/6a469374/attachment-0005.png>