Puumsoft COACH

Announcement

Favorite Download Links

General

+ Hardware/Software requirement
+ Server OS Support: Windows Server 2008 R2, Windows Server 2012 R2 and Windows Server 2016
+ Database Support: SQL Sever 2008 R2, SQL Server 2012 and SQL Server 2016
+ Browser Support: Internet Explorer 11+, Chrome 45+ and Firefox 45+
+ Pre-Implementation readiness checklist
+ Implementation Methodology
+ Limitation of liability
We will not be liable for any direct, indirect, incidental, consequential or exemplary loss or damages which may be incurred by you as a result of using our products, services, or as a result of any changes, data loss or corruption, cancellation, attackers, loss of access, or downtime to the full extent that applicable limitation of liability laws apply. The customer will be responsible for all validation and verification of payroll data prior to the actual payroll releases.
+ Privacy Policy

Performance Management (PM) FAQ

+ Using "Measure Roll Up Type" the right way
+ Measure ball color display best practice
+ Measure target settings best practice
+ Appraisal system recommended score guidance

Learning Management (LM) FAQ

+ SCORM 2004 Primer by McGill

IT FAQ

;+ COACH Support & Upgrade Policy
+ How to change encoding from ANSI to UTF8
+ How to optimize COACH application
+ Server Specification Requirement
Users < 1000 Web and DB Server (2 Servers) CPU Core: 4 Memory: 64GB Disk: 1TB
Users 1000-5000 Web and DB Server (2 Servers) CPU Core: 8 Memory: 128GB Disk: 1TB
Users 5001-10,000 Web and DB Server (2 Servers) CPU Core: 12 Memory: 256GB Disk: 2TB
Users 10,000-20,000 Web and DB Server (2 Servers) CPU Core: 14 Memory: 512GB Disk: 3TB
Users 20,000-50,000 Web Farm and DB Server (3 Servers+) CPU Core: 14 Memory: 768GB+ Disk: 5TB+
+ Internet Information Server (IIS)
COACH supports Internet Information Services (IIS) versions 7 and 8.0 and 8.5 including with Microsoft .NET Framework version 4.5.2 or higher 64-bit edition. We recommend that you install and run IIS before you install COACH.
+ Internet Information Server (IIS)
COACH supports Internet Information Services (IIS) versions 7 and 8.0 and 8.5 including with Microsoft .NET Framework version 4.5.2 or higher 64-bit edition. We recommend that you install and run IIS before you install COACH.
+ SQL Server Authentication Mode Setup
If you install Microsoft SQL Server, you must specify the Mixed Mode Authentication. You must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Microsoft SQL Server account that will be used in the ConnectionString under COACH application web.config.

How To

+ Installation manual
+ Backup & restore database in SQL Server 2005/2008
+ Strategy Map component installation
+ Run COACH without Identity in web.config
+ Run COACH with Web.Config encryption
+ How to enable XP_CMDSHELL when importing data
+ How to import KPI checkpoint values from Excel
+ How To: Encrypt web.config to protect confidential information
To encrypt/decrypt the credentials for the identity, use the Aspnet_setreg utility. This utility is available, with instructions, from Microsoft at https://msdn.microsoft.com/en-us/library/bb986855.aspx

Troubleshoot

+ What to do after database restoration
+ How To: Error while loading code module: 'Puumsoft.Coach.Resource'
+ How To: Speed test your wide area network (WAN)
+ How To: Test your LDAP
+ Troubleshoot: You may receive the "System.OutOfMemoryException" error message when opening large report
+ Troubleshoot: Use DefaultAppPool for COACH in IIS 7.0
+ Troubleshoot: You receive a "The request was rejected by the HTTP Security filter" error message when you try to open COACH that is published in ISA Server and in Microsoft Forefront Threat Management Gateway, Medium Business Edition
+ Troubleshoot: Why your Outlook prompt for download image when you open e-mail message from COACH
+ Troubleshoot: Import data with thai characters into COACH must use Unicode format
+ Troubleshoot: Setup COACH Application Identity
In order for the application to function properly, COACH application user identity under web.config must be set within the local Administrators Group only. The identity user will be used to perform several elevated privilege functions such as writing to EventLog for all informational, warning or error messages and privilege for importing attachment files to the application data folder.
+ Troubleshoot: IIS Memory Tuning for Application Pool
By default the IIS application pool is set to recycle at an arbitrary time offset from the time the server is started. This generally does not have a detrimental affect on COACH, but it is a good practice to set the recycle time to a low usage time for COACH. Recycling clears global variables and will force users to reconnect to COACH. Open up the Application Pools section. Uncheck Fixed Intervals > Regular time intervals (default is every 24 hours, based on when the IIS based application was originally installed). Check specific time(s) and set a time such as 1:00 AM when COACH users are not normally using the system.
+ Troubleshoot: Viewing page with HTTPS (SSL) - The page was not displayed because the request entity is too large
Why this is happing on SSL? : Because during client renegotiation process,the request entity body must be preloaded using SSL preload. SSL preload will use the value of the UploadReadAheadSize metabase property, which is used for ISAPI extensions. Use the following statement. (Please note that the default value for the UploadReadAheadSize is 49152. The maximum size for this property is 2147483647.) - appcmd.exe set config -section:system.webserver/serverruntime/uploadreadaheadsize: 2147483647 /commit:apphost
+ Troubleshoot: Tuning SQL Server Performance with TempDB
SQL Server defaults to a conservative setting of 8 megabytes (MB) for Initial Size and 64 MB for Autogrowth. A best practice is to start with an initial file size of 4,092 MB, with an autogrowth setting of 512 MB, as the initial file size is still small by most standards. Many DBAs dedicate a standard-size file system (typically 100–200 GB) to TempDB and allocate 90 percent of it to the data files. This sizing can reduce contention and also prevents any uncontrolled TempDB growth from impacting user databases.
+ Troubleshoot: How to sp_send_dbmail as CSV in ANSI format
By default SQL Server use sp_send_dbmail as Unicode attachment format which cannot be directly opened in Excel. Click here to find out how to open the attached file directly in Excel and in ANSI format.
+ Troubleshoot: Monitor deadlock on SQL Server
Monitor deadlock with the following statement:
DBCC TRACEON (1204, 1222, -1)
GO
View the SQL Server error log by using SQL Server Management Studio or any text editor. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.
+ Troubleshoot: bcp.exe for SQL Server 2016
Ensure you have the bcp.exe under C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn. Use the bcp.exe /v to check that the version is 13.0. If not, you need to install SQL Server 2016 Client/ODBC Tools under https://www.microsoft.com/en-us/download/details.aspx?id=52676. Ensure the PATH variable is set to higher priority for the bcp.exe path located.

File Transfer

+ Download file
+ Upload file via SkyDrive
+ Upload file direct to Puumsoft
- Download 7z command line
- Zip file size <= 1.9GB - d:\7z.exe a FileZip.zip FileName.bak
- Unzip zip file - d:\7z.exe e FileZip.zip
- Zip file size > 1.9GB - d:\7z.exe a FileZip.zip FileName.bak -v1900m
- Upload split zip files to the server (.001, .002, ...)
- Unzip split zip files - d:\7z.exe e FileZip.zip.001
- Use Chrome or Firefox to upload to see the Upload % Progress

- Zip file 1.9GB will take approximately 3 hours to upload

Internal

SUPPORT

Support