SLK error with SP2013 – assignment (ID {0})

I’m working on a SharePoint 2013 + SharePoint Learning Kit (SLK) implementation as part of an upgrade from SharePoint 2010.  

We applied the new v1.7 of SLK, as well as the SQL Server patch (update).

We were finding that users could click on a course, but would see the following error message :

The assignment (ID {0}) does not exist or you may not have permission to access it.

Furthermore, this error was ONLY happening ‘in the morning’ on our environment !!

😦

Explanation (after many days of investigation) :

Within the function “LearnerAssignmentListForLearners” (SQL), there is a WHERE clause :

WHERE lui.[Key] = @UserKey

AND GETUTCDATE() >= asi.StartDate

 

The data rows are added to ‘AssignmentItem’ (asi) as :

  • 16/10/2014 00:00:00     (today at midnight)

But – the UTC date was resolving as :

  • 15/10/2014 22:35:00 (yesterday)

And so – ZERO rows were returned – and the error above occurred.

After a few hours (~11am) the UTC date ticked along – and it all worked !

  • 16/10/2014 00:05:00 (today)

We have changed this FUNCTION to :

WHERE lui.[Key] = @UserKey

AND GETDATE() >= asi.StartDate

GETUTCDATE()

changed to

GETDATE()

** I wonder if this ONLY impacts users that are more than ~10hrs ahead of the UTC (GMT) time ?      Australia, New Zealand, Fiji, Vanuatu ?

🙂

NB.  This has been logged with SLK (CodePlex).

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s