This article serves as a "one-stop shop" of recommended reading for system administrators who need to understand the basics of keeping FeneVision running. Links are provided to the main articles relevant to System Administrators. Please contact us at support@fenetech.com with further questions.
FeneVision Infrastructure Overview
FeneVision is a Microsoft-centric ERP platform consisting of .NET-based client and service applications, backed by Microsoft SQL Server, with additional web components. It uses SQL databases, SQL Server Reporting Services, and Internet Information Services.
Client PCs (or terminal servers) run the applications and require a connection to a SQL database server. Most companies have an on-premise server for this purpose. Cyncly cloud hosting is also offered.
- FeneVision Overview Flowchart - this will give you an overview of the path an order takes through FeneVision.
- Reports are hosted in SQL Server Reporting Services and generally fall into two file types: RDL and ZPL.
- For information related to ZPL reports (typically labels), see ZPL Label Development and Testing and ZPL Label Tags
- RDL reports are hosted in SSRS on your report server (often the same as the database server). The reports are usually built in Visual Studio and then deployed to SSRS. If you build and deploy custom reports, please follow the guidelines in Managing Customized Reports
- eServer is a module that manages the handoff of documents from FeneVision to your SMTP host for sending to your customers via email. See eServer Troubleshooting
- FeneVision interfaces with many different accounting software packages. See: Accounting Interface Overview
- Managing User Permissions in FeneVision
Server Administration
Customers are responsible for the maintenance and administration of their servers (unless using Cyncly cloud hosting).
- Hardware & Software Requirements
- Managing Storage Space on the FeneVision Database Server
- Performance Troubleshooting
- Performance Troubleshooting - Advanced
- WEB
Database Administration
Customers are responsible for administration of their SQL databases (unless using Cyncly cloud hosting). FeneVision Support agents are not certified database administrators, and can only provide general advice based on our ticket archives and personal experience.
- It is important to configure and maintain SQL Database Mail so you will receive notifications when something is wrong with the databases or the maintenance jobs. See SQL Database Mail
- Monitor the storage space on your database server. Running out of space on the drives can cause FeneVision to become completely unusable (see Managing Storage Space on the FeneVision Database Server).
- We recommend keeping up-to-date on the latest SQL Server service pack for your version of SQL Server: https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates
- Databases:
- FVMaster - the main database for FeneVision CORE.
- FVWarehouse - holds archived production data for schedules closed 6+ months ago. See Archive Alerts
- FVTransLog - holds transaction data for orders and some other areas of the system. See Transaction Log Guide
- FVRemoteWC - holds WEB data for FeneVision WEB. Syncs with the FVMaster database on a scheduled basis.
- FVOptiGlass - holds OPTI data for glass cutting machines and releases/patterns.
- SQL Agent & FeneVision Agent Jobs
- How to Send FeneTech a Database Backup for Troubleshooting
- Queries to Search the FeneVision Databases