Technics:CoPlanner-Server - Revision history

Admin at 10:03, 4 August 2020

2020-08-04T10:03:01Z

Show changes

Admin at 08:34, 4 August 2020

2020-08-04T08:34:00Z

Show changes

Admin at 08:12, 4 August 2020

2020-08-04T08:12:16Z

Show changes

Admin at 08:02, 4 August 2020

2020-08-04T08:02:33Z

← Older revision		Revision as of 10:02, 4 August 2020
Line 64:		Line 64:
	<font color="#0000ff"> <</font><font color="#3a3aff">CacheSizeFactor</font><font color="#0000ff">></font><font color="black">0.5</font><font color="#0000ff"></</font><font color="#3a3aff">CacheSizeFactor</font><font color="#0000ff">></font>		<font color="#0000ff"> <</font><font color="#3a3aff">CacheSizeFactor</font><font color="#0000ff">></font><font color="black">0.5</font><font color="#0000ff"></</font><font color="#3a3aff">CacheSizeFactor</font><font color="#0000ff">></font>
	<font color="#0000ff"> <</font><font color="#3a3aff">StartTabAdress</font><font color="#0000ff">></font><font color="black"></font><font color="#0000ff"></</font><font color="#3a3aff">StartTabAdress</font><font color="#0000ff">></font>		<font color="#0000ff"> <</font><font color="#3a3aff">StartTabAdress</font><font color="#0000ff">></font><font color="black"></font><font color="#0000ff"></</font><font color="#3a3aff">StartTabAdress</font><font color="#0000ff">></font>
			<font color="#0000ff"> <</font><font color="#3a3aff">EnableSwagger</font><font color="#0000ff">></font><font color="black">False</font><font color="#0000ff"></</font><font color="#3a3aff">EnableSwagger</font><font color="#0000ff">></font>
			<font color="#0000ff"> <</font><font color="#3a3aff">EnableCommandEndpoints</font><font color="#0000ff">></font><font color="black">True</font><font color="#0000ff"></</font><font color="#3a3aff">EnableCommandEndpoints</font><font color="#0000ff">></font>
			<font color="#0000ff"> <</font><font color="#3a3aff">EnableExperimentalEndpoints</font><font color="#0000ff">></font><font color="black">True</font><font color="#0000ff"></</font><font color="#3a3aff">EnableExperimentalEndpoints</font><font color="#0000ff">></font>
			<font color="#0000ff"> <</font><font color="#3a3aff">EnableMssEndpoints</font><font color="#0000ff">></font><font color="black">False</font><font color="#0000ff"></</font><font color="#3a3aff">EnableMssEndpoints</font><font color="#0000ff">></font>
			<font color="#0000ff"> <</font><font color="#3a3aff">EnableAuthWithSessionId</font><font color="#0000ff">></font><font color="black">True</font><font color="#0000ff"></</font><font color="#3a3aff">EnableAuthWithSessionId</font><font color="#0000ff">></font>
	<font color="#0000ff"> </</font><font color="#3a3aff">CopSettings</font><font color="#0000ff">></font>		<font color="#0000ff"> </</font><font color="#3a3aff">CopSettings</font><font color="#0000ff">></font>
	<font color="#0000ff"> <</font><font color="#3a3aff">SSASSettings</font><font color="#0000ff">></font>		<font color="#0000ff"> <</font><font color="#3a3aff">SSASSettings</font><font color="#0000ff">></font>

Admin at 15:59, 19 February 2020

2020-02-19T15:59:58Z

← Older revision		Revision as of 17:59, 19 February 2020
Line 673:		Line 673:
	Example:		Example:
	netsh http delete sslcert ipport=0.0.0.0:4443		netsh http delete sslcert ipport=0.0.0.0:4443

	~~===Conversion of existing systems===~~

	SQL Server 2000 Database can be imported on SQL Server Systems up to version 2008 R2. For higher versions it is necessary to recover the database in a version lower or equal than SQL Server 2008 R2, backup the database in that version and recover it in the target version.

	DTS Packages (Data Transformation Services) and Analysis Server 2000 Databases (OLAP) cannot be imported. The packages need to be recreated with the SQL Server Integration Services (SSIS). No downward compatibility is given from Microsoft.

	~~Analysis services data bases can be ported. But errors can occur and/or ported data bases can be limited in function or not to be used at all. Here we recommend a reconstruction of the data base.~~

	__NOEDITSECTION__		__NOEDITSECTION__

Admin at 15:59, 19 February 2020

2020-02-19T15:59:42Z

@@ Line 612: / Line 612: @@
 The installation has finished by copying of Server-directory onto the computer. You only have to start file CopServer.exe. A console window appears. Here you can see which operations the CoPlanner Server is carrying out.
-==CoPlanner Server and 64 Bit Systems==
+==Additional Requirements for using REST functionalities==
 It is not necessary that the user who runs the CoPlanner Server/Service is an administrator but if he is a normal user this command has to run with administrator rights and the given WebAppUrl in the command line:

Admin at 07:28, 10 July 2019

2019-07-10T07:28:29Z

← Older revision		Revision as of 09:28, 10 July 2019
Line 624:		Line 624:
	:*XML Parser 6 x64		:*XML Parser 6 x64
	:*AdoMD.Net		:*AdoMD.Net
	:*SQL Server 2012 with SP2/2014/2016		:*SQL Server 2012 with SP2/2014/2016/2017
	:*Analysis Services 2012 with SP2/2014/2016		:*Analysis Services 2012 with SP2/2014/2016/2017

	===Additional Requirements for using REST functionalities===		===Additional Requirements for using REST functionalities===

Admin at 07:02, 10 July 2019

2019-07-10T07:02:14Z

← Older revision		Revision as of 09:02, 10 July 2019
Line 619:		Line 619:
	The CoPlanner Server and Client needs the 64 bit components of the standard 32 bit components.		The CoPlanner Server and Client needs the 64 bit components of the standard 32 bit components.

	:*Windows Server ~~2008~~/~~2008~~ R2~~/2012~~/2016 x64		:*Windows Server 2012/2012 R2/2016 x64
	:*Net Framework 4.6.2 x64		:*Net Framework 4.7.2 x64
	:*XML Parser 4 with SP2		:*XML Parser 4 with SP2
	:*XML Parser 6 x64		:*XML Parser 6 x64
	:*AdoMD.Net		:*AdoMD.Net
	:*SQL Server ~~2008 R2/~~2012 with SP2/2014/2016		:*SQL Server 2012 with SP2/2014/2016
	:*Analysis Services ~~2008 R2/~~2012 with SP2/2014/2016		:*Analysis Services 2012 with SP2/2014/2016

	===Additional Requirements for using REST functionalities===		===Additional Requirements for using REST functionalities===

Admin at 15:09, 27 June 2019

2019-06-27T15:09:20Z

Admin at 10:40, 12 April 2019

2019-04-12T10:40:16Z

@@ Line 282: / Line 282: @@
 |style="color:#3a3aff;"|DoVersionCheck
 |defines, if a version check between clients and server takes place or not
 |}

← Older revision		Revision as of 17:09, 27 June 2019
Line 63:		Line 63:
	<font color="#0000ff"> <</font><font color="#3a3aff">UseNewCaching</font><font color="#0000ff">></font><font color="black">false</font><font color="#0000ff"></</font><font color="#3a3aff">UseNewCaching</font><font color="#0000ff">></font>		<font color="#0000ff"> <</font><font color="#3a3aff">UseNewCaching</font><font color="#0000ff">></font><font color="black">false</font><font color="#0000ff"></</font><font color="#3a3aff">UseNewCaching</font><font color="#0000ff">></font>
	<font color="#0000ff"> <</font><font color="#3a3aff">CacheSizeFactor</font><font color="#0000ff">></font><font color="black">0.5</font><font color="#0000ff"></</font><font color="#3a3aff">CacheSizeFactor</font><font color="#0000ff">></font>		<font color="#0000ff"> <</font><font color="#3a3aff">CacheSizeFactor</font><font color="#0000ff">></font><font color="black">0.5</font><font color="#0000ff"></</font><font color="#3a3aff">CacheSizeFactor</font><font color="#0000ff">></font>
			<font color="#0000ff"> <</font><font color="#3a3aff">StartTabAdress</font><font color="#0000ff">></font><font color="black"></font><font color="#0000ff"></</font><font color="#3a3aff">StartTabAdress</font><font color="#0000ff">></font>
	<font color="#0000ff"> </</font><font color="#3a3aff">CopSettings</font><font color="#0000ff">></font>		<font color="#0000ff"> </</font><font color="#3a3aff">CopSettings</font><font color="#0000ff">></font>
	<font color="#0000ff"> <</font><font color="#3a3aff">SSASSettings</font><font color="#0000ff">></font>		<font color="#0000ff"> <</font><font color="#3a3aff">SSASSettings</font><font color="#0000ff">></font>
Line 284:		Line 285:
	\|-		\|-
	\|style="color:#3a3aff;"\|UseNewDBSync		\|style="color:#3a3aff;"\|UseNewDBSync
	\|Ab 9.5 HF 2.1: defines, whether new DB Sync is used or not. True means that the new DB Sync is active.		\|From 9.5 HF 2.1: defines, whether new DB Sync is used or not. True means that the new DB Sync is active.
	\|-		\|-
	\|style="color:#3a3aff;"\|DBSyncMaxThreads		\|style="color:#3a3aff;"\|DBSyncMaxThreads
	\|Ab 9.5 HF 2.1: Defines the number of threads that can be used to write to the database when new DB Sync is active. If no value is entered, two threads are used. If the system utilization is to high, reduce the number of threads.		\|From 9.5 HF 2.1: Defines the number of threads that can be used to write to the database when new DB Sync is active. If no value is entered, two threads are used. If the system utilization is to high, reduce the number of threads.
	\|-		\|-
	\|style="color:#3a3aff;"\|SSLCertificate		\|style="color:#3a3aff;"\|SSLCertificate
	\|Ab 9.5 HF 2.4: Is empty if the communication between server and clients is not encrypted. If you want to encrypt the communication you have to set this entry to the fingerprint of your certificate. The ClientConfig.xml of all clients in this case also have to be updated. Set the SSLCommonName to the CN of the certificate.		\|From 9.5 HF 2.4: Is empty if the communication between server and clients is not encrypted. If you want to encrypt the communication you have to set this entry to the fingerprint of your certificate. The ClientConfig.xml of all clients in this case also have to be updated. Set the SSLCommonName to the CN of the certificate.
	\|-		\|-
	\|style="color:#3a3aff;"\|DBCommandTimeout		\|style="color:#3a3aff;"\|DBCommandTimeout
	\|Ab 9.5 HF 2.6: Database command timeout for certain commands. This timeout is used e.g. for the data processing of imports.		\|From 9.5 HF 2.6: Database command timeout for certain commands. This timeout is used e.g. for the data processing of imports.
	\|-		\|-
	\|style="color:#3a3aff;"\|UseNewCaching		\|style="color:#3a3aff;"\|UseNewCaching
	\|Ab 9.5 HF 3.5: defines, whether the new caching is used or not.		\|From 9.5 HF 3.5: defines, whether the new caching is used or not.
	\|-		\|-
	\|style="color:#3a3aff;"\|CacheSizeFaktor		\|style="color:#3a3aff;"\|CacheSizeFaktor
	\|Ab 9.5 HF 3.5: Has only effects when UseNewCaching is true. The new caching prepares the data in a column-oriented cache for showing in masks. To avoid that the memory usage gets to high, you can define the CacheSizeFactor. The CacheSizeFactor limits the relation from the cache size to the table size. 0.5 means that the cache is allowed to have half of the data of the table in the cache.		\|From 9.5 HF 3.5: Has only effects when UseNewCaching is true. The new caching prepares the data in a column-oriented cache for showing in masks. To avoid that the memory usage gets to high, you can define the CacheSizeFactor. The CacheSizeFactor limits the relation from the cache size to the table size. 0.5 means that the cache is allowed to have half of the data of the table in the cache.
			\|-
			\|style="color:#3a3aff;"\|StartTabAdress
			\|From 9.5 HF 3.8: If empty, the Start.html will be loaded as before. Now have the possibilty to open the tiles or another webpage on the start tab. An example: @Session_WebAppUrl@/tiles/?menu=MyStartpage&SessionID=@Session_ID@
	\|}		\|}