Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -2,6 +2,8 @@
2	2
3	3	* [[.NET 6 Hosting Bundle>>https://dotnet.microsoft.com/en-us/download/dotnet/6.0]]
4	4
	5	+(% class="wikigeneratedid" %)
	6	+===== =====
5	5
6	6	===== **Ensure the following .NET Runtimes are installed:** =====
7	7
...	...	@@ -10,7 +10,7 @@
10	10
11	11	===== **Testing and Debugging:** =====
12	12
13		-* Check the system event viewer for any errors. Framework related and logs appear here if not successfully written to the logs. This may point to folder permission issues.
	15	+* Check the system event viewer for any errors. Framework and log related errors usually appear here if not successfully written to the actual log files. The cause might be folder permissions.
14	14
15	15	===== =====
16	16
...	...	@@ -22,6 +22,7 @@
22	22	* Each API under the CRM project should have Its own app pool.
23	23	** Format: ~{~{host_name}}.~{~{api_name}}.~{~{version}}
24	24	** Example: za.co.site.uapi.identity.v1
	27	+* Each API under the CRM should be deployed as a virtual application linked to its relative app pool.
25	25	* App pool considerations:
26	26	** .NET CRL Version: No Managed Code
27	27	** Managed Pipeline: Integrated
...	...	@@ -29,13 +29,84 @@
29	29	* Under the root directory, there is a wwwroot folder, which should contain a blank folder for each of the API projects.
30	30	* Ensure you replace all the connection strings, file paths and branding of the currently client with the new one.
31	31	* Clear out all the logs for each of the API projects and ensure IIS user has required permission to write to this directory
32		-** Directory: za.co.site.uapi\EBSphere.Api.v1.Workflow\logs
	35	+** Directory: "//za.co.site.uapi\EBSphere.Api.v1.Workflow\logs//"
33	33
34	34	===== =====
35	35
36	36	===== **Database Considerations:** =====
37	37
	41	+* Some databases are setup to require a reference number when making structural changes to the database:
	42	+** Create a session reference: (% style="color:#2980b9" %)//exec//(%%)// sp_set_session_context 'ReferenceNo', '123456789'//
	43	+** The reference number is the ticket number of the project, as found on our Issue log system.
	44	+* Depending on the state of the database, there might be tables, procedures, views and even data that need to be added. Is a list of some of these objects, that need to be present in the database for the CRM to work correctly (//Please feel free to added on//):
38	38
	46	+|=Object Type|=Name|=Latest Version|=Dependencies
	47	+|Procedure|api.sp_AddSupplier_Se| |
	48	+|Procedure|api.sp_BankAccountTypes_SelectV2| |
	49	+|Procedure|api.sp_Communication_Add| |
	50	+|Procedure|api.sp_Communication_AddProperty| |
	51	+|Procedure|api.sp_Content_Add| |
	52	+|Procedure|api.sp_Content_AddProperty| |
	53	+|Procedure|api.sp_CreateSupplier| |
	54	+|Procedure|api.sp_CRM_RegisterUser| |
	55	+|Procedure|api.sp_CRM_ResetPassword| |
	56	+|Procedure|api.sp_DocumentCategories_SelectV2| |
	57	+|Procedure|api.sp_Documents_SelectV2| |
	58	+|Procedure|api.sp_GetBBBEE_Levels| |
	59	+|Procedure|api.sp_GetPersonDetailsV2| |
	60	+|Procedure|api.sp_GetSupplierTypes| |
	61	+|Procedure|api.sp_GetUniversalBankBranch| |
	62	+|Procedure|api.sp_MemberBankDetails_SelectV2| |
	63	+|Procedure|api.sp_MemberBeneficiaries_SelectV2| |
	64	+|Procedure|api.sp_MemberClaimStatus_SelectV2| |
	65	+|Procedure|api.sp_MemberCouncilRates_SelectV2| |
	66	+|Procedure|api.sp_MemberNotes_InsertV2| |
	67	+|Procedure|api.sp_MemberNotes_SelectV2| |
	68	+|Procedure|api.sp_MemberNoteVariableGroups_SelectV2| |
	69	+|Procedure|api.sp_MemberNoteVariables_SelectV2| |
	70	+|Procedure|api.sp_MemberPayments_SelectV2| |
	71	+|Procedure|api.sp_MemberPaypoints_SelectV2| |
	72	+|Procedure|api.sp_MemberSalaries_SelectV2| |
	73	+|Procedure|api.sp_MemberSinglePremiums_SelectV2| |
	74	+|Procedure|api.sp_MemberTaxApplications_SelectV2| |
	75	+|Procedure|api.sp_People_SelectV2| |
	76	+|Procedure|api.sp_Scheduler_AddNote| |
	77	+|Procedure|api.sp_Scheduler_AddProperty| |
	78	+|Procedure|api.sp_Scheduler_CompleteActivity| |
	79	+|Procedure|api.sp_Scheduler_CreateProcess| |
	80	+|Procedure|api.sp_Scheduler_CurrentActivities| |
	81	+|Procedure|api.sp_Scheduler_GetActivityActions| |
	82	+|Procedure|api.sp_Scheduler_GetNotes| |
	83	+|Procedure|api.sp_Scheduler_GetProcessProperties| |
	84	+|Procedure|api.sp_SearchPersonDetails| |
	85	+|Procedure|api.sp_SearchPersonMembershipV2| |
	86	+|Procedure|api.sp_Workflow_AddNote| |
	87	+|Procedure|api.sp_Workflow_AddProperty| |
	88	+|Procedure|api.sp_Workflow_CompleteActivity| |
	89	+|Procedure|api.sp_Workflow_CreateProcess| |
	90	+|Procedure|api.sp_Workflow_GetActivityActions| |
	91	+|Procedure|api.sp_Workflow_GetLinkedContent| |
	92	+|Procedure|api.sp_Workflow_GetNotes| |
	93	+|Procedure|api.sp_Workflow_GetProcessProperties| |
	94	+|Procedure|api.sp_Workflow_LinkContent| |
	95	+|Procedure|api.sp_Workflow_Reallocate| |
	96	+|Procedure|api.sp_Workflow_SearchActivities| |
	97	+|Procedure|api.sp_Workflow_SearchProcess| |
	98	+|Procedure|api.sp_Workflow_SearchStreamResources| |
	99	+|Procedure|api.sp_Workflow_SearchStreams| |
	100	+|Procedure|api.sp_Workflow_UpdateProperty| |
	101	+|Procedure|dbo.sp_InsertImageToDocDatabase| |
	102	+|Procedure|dbo.sp_MaritalStatus| |
	103	+|Procedure|dbo.sp_SchedulerAddNote| |
	104	+|Procedure|dbo.sp_Update_frmPeople| |
	105	+|Procedure|dbo.sp_UserLevels| |
	106	+|Procedure|dbo.sp_WorkflowAddNote| |
	107	+|Procedure|prg.sp_ProviderParameters_select| |
	108	+|Procedure|scr.sp_BankBranches_Member| |
	109	+|Procedure|scr.sp_MFGMemberCFLO| |
	110	+|Procedure|scr.sp_MFGMemberPaypoints| |
	111	+|Procedure|scr.sp_Paypoints| |
	112	+|Procedure|web.sp_UserWebLogin| |
39	39
40	40
41	41