Office Solution Accelerator for Recruiting (anyone ?)
It's been a while since Microsoft first introduce the Microsoft Office solution accelerator for recruiting to customers. Probably you also had seen the cool flash-demo of how this Recruiting Accelerator in action. Smartly integrates Microsoft Office, Sharepoint, SQL Server, Exchange & Windows Server into single solution to address recruitment scenario in HR department. The Office System had set the higher bar in office productivity tools competition.
However, if you are in the middle of MOSA for recruiting implementation right now, you probably facing several challenges in getting the engine works. Well, some of the challenges i've found during the joint activity with my partner are :
- Failed import sample database
- Failed Save Interview Feedback Form
- Cannot access Free Busy public folder (therefore it brings you to the next challenge)
- Unable use the cool 'generate schedule' features
- Send Interview Meeting Request Failed
The good news is you get the access for most of the source code and the documentation is very comprehensive. You may have it from www.gotdotnet.com community, you'll need to request approval to join the workspace though.
There always another side of the story. So, the bad news : there is one core component that you may not have access of the source code : HRSSWebServices.dll It's a core component in getting the interviewer's schedule, sending meeting request, updating meeting request, etc. So, if you slip the recommended configuration (or unwritten one), you may find it hard to trace the root of the problem. The other bad news is the documentation is not complete enough, so you may need to use your 'competencies' to trace the problem and find the right button to start the engine works properly. And not to mention, you will only found 5 thread from the gotdotnet workspace - so it's kind a hard to get a 'support' from the community. I did contacting one member who post the same problem I faced, hoping he got the workaround by now. Apparently, he surrounder the project the moment he encountered the problem. It's very unfortunate to miss this great solution, hopefully this articles might help for others.
Before I summarized the workaround for each problem you might encountered, following is my recommendation to help you 'trace' the problem :
- You can use SQL Profiler to trace SQL Statement that had been execute for each action that raise an error
- Use Network monitoring tools, such as HttpAnalyzer or Colasoft Capsa, this really helpful to monitor what URL's or Packet being transferred from your InfoPath Forms-Web Services-Exchange Server.
- For Web Services component, you can use Visual Studio to debug and trace the program (unless the HRSSWebServices.dll I mentioned above)
- For InfoPath form, you can save the form locally, switch to design mode. And from the tools menu, go to the script - Microsoft Script Editor. You can learn how the form works, which web method are initiate and which part of the code that not executed successfuly.
- .... and a search engine :)
Following is the summarized check list that I've found during the implementation in the last couple of weeks :
- Failed import sample database:
From the documentation, you are suggested to download O*Net 5.0 from US labour website, you won't find it. But it's ok, download the latest O*Net 8.0 instead. For your note here, don't forget to update your reference_data.txt from onetsoc_data.txt. You will found the "Unknown Job ID" error if you forgot to update the reference_data.txt
- Failed Save Interview Feedback Form
This workaround are found from gotdotnet.com (thanx to sjtuross) messageboard. The solution as follow :
1. Grant "Network Service" as the db owner...Success;
2. Then use SQL Profiler to trace the "Save or Send Interview Notices" process;
3. The stored procedure "check_OkToUpdateInstance" is used but does not have the EXEC permission, which is not mentioned in the legacy deployment doc!!!
4. Four new stored procedures "check_InterviewStatus" "check_OkToUpdateInstance" "internal_AddInterview" "internal_AddInterviewInstance" are added in the new solution accelerator. I therefore suggestion granting the account "Nerwork Service" EXEC permission for them.
- Cannot access Free Busy public folder (therefore it brings you to the next challenge)
- Unable use the cool 'generate schedule' features
Most probably you had slip the configuration in Web.config in Interview_Exchange folder or machine.config in WINDOWS/Microsoft.NET/.... . So refer to the documentation if you found this.
- Send Interview Meeting Request Failed
This is the most troublemaker for me. If you go through the messageboard in gotdotnet.com, you'll found that most of the member were stuck in this point. Found the webservices that called from the InfoPath Form, I try to execute the web method directly. As expected, the web method return error saying "Invalid access to memory location (Error Code: 0x800703e6)". Using the error description, I found a workaround that actually suggested for error in Windows Media Services implementation. WTH, i try it and it did resolve this problem. You need to register the msxml3.dll in your server :
1. Go to your Windows' System32 directory (i.e, %WINDIR%\system32).
2. Run regsvr32 msxml3.dll
