Problems with Assignment

Topics: Developer Forum, Project Management Forum, User Forum
Jan 31, 2007 at 12:34 PM

I am having problems with the Assignment List Web Part

I have successfully installed SLK on a test virtual server with MOSS 2007 and SQL Server 2005. No problems configuring it to a site collection and have enabled SLK with no problems. The Assignment web part appears in the tool pane but when I add it to a page I get the following error:

An error occurred. More information may be available in the server event log.

I have checked the event log and can't make much sense out of it, although there is some reference to a registry key. Site permissions seem to be OK. Any ideas as to what I might be doing wrong?
Jan 31, 2007 at 2:41 PM

Can you post the contents of the event log?

Feb 1, 2007 at 11:39 AM
I deleted SLK and its databases and reinstalled it - same error. Here is the last few lines of the most recent log file.....

02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 3259, use count 2, key ct-1033-0x00a7470eadf4194e2e9ed1031b61da088402
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 2597, use count 2, key ct-1033-0x010100a2e3c117a0c5482faee3d57c48cb042f
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 2321, use count 2, key ct-1033-0x010108
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 5753, use count 2, key ct-1033-0x010100c568db52d9d0a14d9b2fdcc96666e9f2007948130ec3db064584e219954237af3900242457efb8b24247815d688c526cd44d
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 5020, use count 3, key ct-1033-0x010801
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 2393, use count 2, key ct-1033-0x01010a
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 5964, use count 2, key ct-1033-0x0107
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 3623, use count 2, key ct-1033-0x0102
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 1667, use count 2, key ct-1033-0x01004d5a79bafa4a4576b79c56ff3d0d662d
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 5878, use count 1, key 14-0-3-1033-112
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 1697, use count 2, key ct-1033-0x01002cf74a4dae39480396eea7a4ba2be5fb
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 2392, use count 3, key ct-1033-0x010109
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 5238, use count 2, key ct-1033-0x01010058ddeb47312e4967bfc1576b96e8c3d4
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 3757, use count 2, key ct-1033-0x00a7470eadf4194e2e9ed1031b61da088403
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 2056, use count 2, key ct-1033-0x010104
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 1224, use count 2, key ct-1033-0x012001
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Preserving template record with size 2694, use count 3, key ct-1033-0x010802
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Final table size: 184711 in 59 entries
02/01/2007 11:25:54.57 OWSTIMER.EXE (0x0618) 0x0A90 Windows SharePoint Services General 0 Medium Exiting MRU trim routine.
02/01/2007 11:26:01.28 wsstracing.exe (0x0624) 0x039C ULS Logging Unified Logging Service uls1 Monitorable Tracing Service lost trace events. Current value 6.
02/01/2007 11:26:25.76 OWSTIMER.EXE (0x0618) 0x00FC SharePoint Portal Server SSO 8inc Medium In SSOService::Synch(), sso database conn string:
Feb 1, 2007 at 5:28 PM
This looks like the WSS log. What error is in the server event log? You can get to that via Start > All Programs > Administrative Tools > Event Viewer. Look for a recent error in the Application log.
Feb 7, 2007 at 10:26 PM
I have sorted the problem - it was the permssions on the database - its all running finenow, and the solitaire example works a peach. Many thanks for your help, as the server event log file gave me all the pointers I needed!
Jul 18, 2008 at 2:38 PM
Hi,

I have just upgraded to SLK 1.3.1 Alpha to test the SLK Course Manager.

I only noticed this problem after the upgrade. I followed the upgrade instructions in GettingStarted.pdf and it upgraded successfully.
I'm getting the same error as above. The Application log has the following information in it:

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: None
Event ID: 0
Date:  18/07/2008
Time:  14:22:52
User:  N/A
Computer: SAMISRV1
Description:
SharePoint Learning Kit Error

System.Web.HttpException: Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the <configuration>\<system.web>\<httpModules> section in the application configuration.
   at System.Web.UI.Page.get_Session()
   at Microsoft.SharePointLearningKit.ApplicationPages.AlwpQuerySummary.get_SlkStore()
   at Microsoft.SharePointLearningKit.ApplicationPages.AlwpQuerySummary.Page_Load(Object sender, EventArgs e)

Any advice would be much appreciated.



Jul 20, 2008 at 9:23 PM
SLK 1.3.1 Alpha and thr version that shipped with MLG all require session state to be enabled.

This should be documented in the installation guide,  but basically involves setting values in your web.config

<pages enableSessionState="false"...

to

<pages enableSessionState="true"...


It also relys on you have session state defined,  look for

      <add name="Session" type="System.Web.SessionState.SessionStateModule" />

It may be commented out in your web.config with <!-- at the start and --> at the end.   Also be careful as you may also have two entries for this.

Andrew
Jul 21, 2008 at 11:09 AM
Thanks Andew,

That helped. It's working now!

Henry
Oct 9, 2008 at 8:32 AM
(DirectoryContext context)
   at Microsoft.SharePointLearningKit.DomainGroupUtilities.EnumerateDomainGroup(String groupName, TimeSpan timeout)
   at Microsoft.SharePointLearningKit.SlkStore.EnumerateDomainGroupMembers(SPWeb spWeb, SPUser domainGroup, Boolean isInstructor, Boolean isLearner, List`1 groupFailuresList, StringBuilder groupFailureDetailsBuilder, Dictionary`2 instructorsByUserKey, Dictionary`2 learnersByUserKey, Dictionary`2 users, List`1 learnerKeys, List`1 learnerGroups, DateTime startTime)
   at Microsoft.SharePointLearningKit.SlkStore.<>c__DisplayClass6.<GetMemberships>b__5()
   at Microsoft.SharePoint.SPSecurity.CodeToRunElevatedWrapper(Object state)
   at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()
   at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
   at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
   at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
   at Microsoft.SharePointLearningKit.SlkStore.GetMemberships(SPWeb spWeb, IEnumerable`1 additionalInstructors, IEnumerable`1 additionalLearners, ReadOnlyCollection`1& groupFailures, String& groupFailureDetails)
   at Microsoft.SharePointLearningKit.ApplicationPages.AssignmentPropertiesPage.get_SlkMembers()
   at Microsoft.SharePointLearningKit.ApplicationPages.AssignmentPropertiesPage.SetAssignmentProperties()
   at Microsoft.SharePointLearningKit.ApplicationPages.AssignmentPropertiesPage.OnPreRender(EventArgs e)
Oct 20, 2008 at 1:47 AM

    I have the same problem chrisrowles has with the assignment page, but lack the skill to read the clues in the event viewer to change the

the permissions in the data base. Is there a quick drill down to follow?

Thanks,

Murray

 

Oct 20, 2008 at 1:52 AM
    I also tried to upload solitare, when it came to selecting elearning in the drop-down box, it wasn't there. I haven't uninstalled SLK, but that may be the next step.


Again, Thanks,

Murray
Oct 20, 2008 at 4:04 PM
I had the same problem as chrisrowles and solved it by looking into the server Event Viewer, Application Log. To detail the solution for further reference:

Event Type:    Error
Event Source:    Windows SharePoint Services 3
Event Category:    None
Event ID:    0
Date:        20.10.2008
Time:        16:39:41
User:        N/A
Computer:    MOSSME
Description:
SharePoint Learning Kit Error

System.Data.SqlClient.SqlException: Cannot open database "SLK_DB1" requested by the login. The login failed.
Login failed for user 'MOSS\MossAppPool'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.LearningComponents.Storage.LearningStore.GetSchemaInformationFromCache(String connectionString, ImpersonationBehavior impersonationBehavior, TextWriter debugLog)
   at Microsoft.LearningComponents.Storage.LearningStore.GetSchema()
   at Microsoft.LearningComponents.Storage.LearningStore.CreateJob()
   at Microsoft.SharePointLearningKit.SlkStore.GetStore(SPWeb spWeb)
   at Microsoft.SharePointLearningKit.WebParts.AssignmentListWebPart.get_SlkStore()
   at Microsoft.SharePointLearningKit.WebParts.AssignmentListWebPart.SetQuerySetOverride()
   at Microsoft.SharePointLearningKit.WebParts.AssignmentListWebPart.SetAlwpProperties(Int32& cols)
   at Microsoft.SharePointLearningKit.WebParts.AssignmentListWebPart.RenderAssignmentList(HtmlTextWriter htmlTextWriter)
   at Microsoft.SharePointLearningKit.WebParts.AssignmentListWebPart.RenderContents(HtmlTextWriter writer)


The error says that the user configured for the Application Pool identity account doesn't have the required permissions to log in to the database.
I then opened the SQL Management Studio, navigated to Security, Logins and opened Properties for the account (MOSS\MossAppPool).
Opened User Mapping and found my SLK database (SLK_DB1) and checked "LearningStore".

That's it!

After a refresh of the site, the My Assignments webpart show up correctly.

-Thomas
Nov 15, 2008 at 12:48 AM
I've experienced the same problem on WSS3 with SQL Express 5. I'm not an expert on DB management but I've installed SQL Studio and we've like to know what should be done to change the database access in order to solve the issue.
Dec 11, 2008 at 3:06 AM
for the error:

System.Web.HttpException: Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the <configuration>\<system.web>\<httpModules> section in the application configuration.
   at System.Web.UI.Page.get_Session()
   at Microsoft.SharePointLearningKit.ApplicationPages.AlwpQuerySummary.get_SlkStore()
   at Microsoft.SharePointLearningKit.ApplicationPages.AlwpQuerySummary.Page_Load(Object sender, EventArgs e)

You could follow these steps to solve it:
1. find the folder /wwwroot/wss/80
2. in that folder ,find 'web.config' , and open it
3.find
<pages enableSessionState="false"... 
 change to 
<pages enableSessionState="true"... 

look for 
<<--!add name="Session" type="System.Web.SessionState.SessionStateModule" />-->
change to 
<add name="Session" type="System.Web.SessionState.SessionStateModule" />
4.save
 
that will be OK!

Wurongrong from China.

Coordinator
Feb 20, 2009 at 3:13 AM
Edited Feb 20, 2009 at 3:15 AM
I have now removed the requirement for session state unless you are actually using the observer role, in which case it will give a useful error message. You can download a build with this functionality from http://www.codeplex.com/SLK/Release/ProjectReleases.aspx?ReleaseId=23487.

Richard
SLK Co-ordinator
http://blog.salamandersoft.co.uk
Mar 4, 2009 at 7:53 AM
Edited Mar 4, 2009 at 8:01 AM
The Assignment web part appears in the tool pane but when I add it to a page I get the following error:

An error occurred. More information may be available in the server event log.

chrisrowles resolved it with some database changes .Can you please help me to resolve the same?


What datasbse changes you  made to resolve the issue?


Thanks in advance.
Coordinator
Mar 5, 2009 at 11:42 PM
What error is logged in the event log?
Mar 6, 2009 at 4:20 AM
My problem is resolved .I made changes in web.config file and changed enableSessionState 
 to true.Now its working fine.