Select Page
Connecting the Clouds: Website vs. ERP Hosting

Connecting the Clouds: Website vs. ERP Hosting

Manufacturers and distributors can benefit significantly from a Managed Services Provider (MSP) managing one website or kin websites as part of an integrated IT services, IT security, and enterprise cloud strategy. An external IT provider ensures that the world will view web-based company representation with optimal performance, scalability, and security, reduced downtime and enhanced user experience. Through robust IT security measures, a cloud provider like EstesGroup safeguards sensitive data, mitigating the risk of cyber threats. Additionally, integrating enterprise cloud solutions facilitates seamless data access, collaboration, and scalability, enabling manufacturers and distributors to focus on core business functions while staying agile and competitive in the digital landscape.

Website vs ERP Hosting

For businesses, websites serve as crucial repositories for sharing information, necessitating proper hosting and data management to connect with customers, ensure security, and facilitate growth. When exploring website hosting services and ERP hosting solutions, businesses encounter various cloud options, with managed hosting and shared hosting being the primary types. Understanding the distinctions in the website vs. ERP hosting conversation empowers businesses to make informed decisions aligning with their unique identities.

Is your website hosting forgotten data?

While your IT team is focusing on critical tasks, your website might go unnoticed, opening the path to vulnerability and chaos. In the realm of website hosting, discerning between managed hosting and shared hosting is essential. Managed hosting is ideal for businesses seeking comprehensive control and responsibility, with the service provider acting as a dedicated IT department overseeing all aspects of the website. Conversely, shared hosting accommodates businesses needing performance and security but may lack the size or budget for full-service management. Multiple businesses share resources like RAM and CPU under a shared server, potentially impacting performance during traffic surges. Managed hosting suits larger enterprises prioritizing ultimate performance and security, while shared hosting remains viable for budget-conscious smaller businesses.

Managed Hosting vs. Shared Hosting vs. Managed ERP Hosting

Businesses should consider several key differences between managed and shared hosting for websites and ERP hosting for enterprise resource planning applications. Here are a few things to keep in mind as you unravel your web of business data.

  • Resources: Managed hosting provides dedicated server resources, ensuring optimal performance, while shared hosting involves resource-sharing, potentially leading to performance issues during high traffic.
  • Customization: Managed hosting offers customized solutions, tailored to specific business needs, whereas shared hosting tends to be more one-size-fits-all.
  • Security: Managed hosting prioritizes security, protecting individual businesses, whereas shared hosting may compromise security if one business on the shared server experiences a breach.
  • Optimal Performance: Managed hosting eliminates performance issues associated with shared resources, providing consistent and optimized performance.
  • Updates: Managed hosting ensures prompt updates and security patches, while shared hosting may require businesses to schedule updates themselves.
  • Email: Both hosting types offer email services, with managed hosting providing premium plans for enhanced features.
  • Cost: Shared hosting is more affordable, making it suitable for smaller businesses with budget constraints, while managed hosting, though more expensive, offers superior performance and security.

How ERP Hosting Gets Tangled in Your Website Web

The discussion on website hosting parallels ERP hosting, where businesses can opt for a managed service provider to host their ERP software in a remote, cloud-based data center. This centralized approach provides cost-effective, secure, and scalable solutions, enabling businesses to focus on operations rather than maintaining on-premise infrastructure.

Businesses must comprehend the disparities between the many available cloud options to make informed choices for their website and ERP hosting needs. While managed hosting excels in performance, security, and support, startups or small businesses with budget constraints may consider shared hosting initially. Managed hosting proves invaluable for businesses seeking to eliminate on-premise responsibilities, allowing them to concentrate on optimization and growth.

Complex Cloud Hosting Environments

Experience seamless business operations with our fully managed ERP hosting, ensuring optimal performance, security, and scalability as we take charge of your ERP software in a secure, remote, and cloud-based environment. Ready to tackle website vs. ERP hosting? Elevate your online presence with our fully managed website hosting, where a dedicated IT team handles every aspect, providing tailored solutions for peak performance, robust security, and unmatched support. Trust EstesGroup to streamline your technology infrastructure, allowing you to focus on growth and innovation without the burden of managing complex hosting environments.

SYSPRO Error Message: Operator Already Logged In

SYSPRO Error Message: Operator Already Logged In

A warning message that most SYSPRO users will commonly see is the “Operator already logged in” prompt. Under normal circumstances, this message means exactly what it says! The operator is already signed in.

SYSPRO Error Message Operator Sign In

However, the error message can appear for other reasons that may be puzzling to the user. It is most typically associated with users not exiting SYSPRO through normal means (crashes, forced computer shutdown, etc). It is good for both the ERP administrator as well as the end-users to know what this error means and why it may appear despite the user not being signed in.

SYSPRO Error Message Operator Logged In

What does this “SYSPRO Error Message – Operator Already Logged In” message mean?

SYSPRO’s database has a table called AdmOperator. Inside this table there is a column used to indicate whether a SYSPRO operator is currently signed in. The column value is set to “Y” when a user signs in and is cleared when SYSPRO is closed out normally by the user. The “Y” value can linger in the database if the user fails to close out of SYSPRO “gracefully”.

In that case, the “Operator already logged in” message will appear. The user has the option to proceed which will clear any lingering operator entries. If the user is in fact already signed in, any previous session is terminated by the system.

What causes this “Operator already logged in” message?

Besides the intended circumstance of the operator already being signed in on another computer, the message also appears if a user fails to close out of SYSPRO “gracefully”. Examples of this could include:

  • The user shuts down their PC while SYSPRO was running. 
  • The user closes SYSPRO forcefully using the Windows Task Manager. This is common in the event of SYSPRO freezing or crashing. 
  • Network failures between SYSPRO and the app server causing communication errors. 
  • If the user closes their web browser when using SYSPRO Avanti without using the logout functionality in the application.

Some of these events may also result in “Unknown Processes” lingering in SYSPRO. These will have to be closed out using administrative tools in SYSPRO. To learn about these processes, see our article on Handling Unknown Processes in SYSPRO.

So, what should you do about this message?

Clicking “OK” to proceed is all you need to do! If the warning appears because the user is in fact already signed in, that previous session will simply be terminated. If it appeared for any of the other reasons outlined above, the database fields are cleaned up from any incorrect flags and reset to their intended status. It is good to inform users that this error means no harm and that they can safely proceed if they do not believe that their operator is signed in anywhere else.

Turning the Degenerative into Generative AI in ERP

Turning the Degenerative into Generative AI in ERP

Generative AI in Enterprise Resource Planning

Generative AI (GenAI) is currently revolutionizing work dynamics and interactions. Despite initial societal skepticism and perceived risks, the majority of individuals are embracing and enjoying its capabilities. GenAI holds the power to significantly enhance efficiency and streamline operations for enterprises. When seamlessly integrated into an Enterprise Resource Planning (ERP) system, GenAI can have a positive impact on overall enterprise operations and productivity.

Generative AI ERP workstation with female engineer coding

AI TriSM

For enterprises to fully leverage GenAI in their ERP systems and applications, establishing a universal level of trust and understanding is crucial. Implementing AI TriSM controls – focusing on trust, risk, security, and management – is essential to unlock the full potential of GenAI. Over the next few years, standard regulations will likely make GenAI more trustworthy and reliable. It is anticipated that organizations will incorporate TRiSM controls into their cloud and ERP system applications to minimize risk, maintain compliance, and fortify security. The capabilities and benefits of GenAI for ERP systems and applications encompass:

  • Creative Collaboration and Problem Solving
  • Elimination of Time-Consuming, Arduous Tasks
  • Improved Employee Performance
  • Increased Productivity
  • Automation of Data Processes
  • Elimination of Flawed, Irrelevant Data for Optimal Decision-Making
  • Risk Reduction
  • Heightened Security with TRiSM Controls
  • Digital Assistance and Software Innovation
  • Redefined and Enhanced Jobs with GenAI Tools

The Cloud AI Shift

Generative AI undeniably holds the potential to completely transform ERP systems, applications, and cloud management. The capabilities and benefits of this technology are clear. However, as enterprises embrace this technological shift, having a trusted guide is crucial. EstesGroup has always been your reliable source for ERP systems and cloud services.

As GenAI becomes more regulated and applicable to enterprise operations, rest assured that our company will assist you in incorporating this technology. We are committed to keeping you at the forefront of technology, innovation, and productivity. EstesGroup can also aid in employee re-skilling as roles are redefined, and we will navigate regulation and compliance to ensure optimal risk management and data security.

AI in Epicor Kinetic, Epicor Prophet 21, Sage, and SYSPRO ERP

In the realm of Enterprise Resource Planning (ERP), the integration of Artificial Intelligence (AI) holds particular importance for leading systems such as Epicor Kinetic, Epicor Prophet 21, SYSPRO ERP, and Sage ERP. These platforms stand to benefit immensely from AI advancements, enhancing their capabilities and providing tailored solutions for businesses. In Epicor Kinetic, AI can optimize supply chain management, forecast demand, and automate routine tasks, resulting in more agile and responsive operations. For Epicor Prophet 21, AI can streamline inventory management, analyze customer behaviors, and enhance order processing efficiency. In SYSPRO ERP, AI can bolster production planning, inventory optimization, and predictive maintenance, contributing to overall operational excellence. Sage ERP systems, when integrated with AI, can revolutionize financial management, automate data entry, and provide valuable insights for strategic decision-making. The synergy between AI and these ERP systems represents a pivotal leap towards efficiency, precision, and innovation in enterprise management.

The Sensitive Nature of GenAI Data in ERP

Cloud hosting in a trusted data center stands as the epitome of security for ERP systems harnessing the power of Artificial Intelligence (AI). Leveraging the advanced infrastructure and protocols of a trusted data center ensures unparalleled reliability and resilience. The redundant systems and robust architecture not only guarantee minimal downtime but also provide a secure environment crucial for the sensitive nature of ERP data. The cloud, with its scalable resources, accommodates the dynamic computing needs of AI applications, enabling seamless integration and optimal performance.

Additionally, top-tier data centers adhere to stringent security measures, incorporating advanced encryption, access controls, and continuous monitoring. This fortified combination of cloud hosting and data center standards ensures that ERP systems not only harness the transformative capabilities of AI but do so in an environment that prioritizes data integrity, confidentiality, and accessibility with the utmost diligence.

An Introduction to the SYSPRO Database

An Introduction to the SYSPRO Database

An Introduction to the SYSPRO SQL Database Structure

In the early versions of SYSPRO, the ERP’s data was entirely stored in C-ISAM files. These C-ISAM files were essentially text files containing system data. They could cause a lot of trouble if you had to investigate or troubleshoot data problems as they were lacking a stable framework to review and analyze them. Thankfully, a modern SQL database structure was introduced between SYSPRO 6.1 and 7. In today’s SYSPRO 8 version, essentially all components of the ERP have now been converted and are stored in traditional SQL database tables. Knowing what SYSPRO’s database looks like becomes a vital tool if you are tasked to troubleshoot data problems, analyze company data, or build SQL queries to pull data for custom reports.

SYSPRO SQL Database Structure

So what does a SYSPRO database structure look like? 

The “System-Wide” Database

Both SYSPRO 7 and SYSPRO 8 contain what SYSPRO calls the “system-wide” database. While the name of the database can be customized to the business’ liking, it is commonly named “sysprodb” by default. The database contains information about operators, administrative settings, system information, and licensing details. Any data pertaining to system-wide configurations that span all SYSPRO companies will be found in this database. Particularly important tables to take note of in this database are:

  • AdmOperator – Contains data of all operators on file in SYSPRO along with their role, group, and other access level details. 
  • AdmSysVersion – Header table containing the database version details of the SYSPRO environment.
  • SysproAdmin – Table containing a list of the companies in your SYSPRO environment. This table becomes relevant when creating test companies or setting up SYSPRO’s default test databases. 

The Company Databases

Each company created in SYSPRO will have its own database and default company tables. By default, SYSPRO names these companies ‘SysproCompany’ along with the company’s ID at the end. Ex, SysproCompanyT, SysproCompanyA, etc. These are the databases where your company’s transactional data is stored. 

At a first glance, these databases can be overwhelming. A standard SYSPRO database can have over 1000 tables in it. The good thing is that while this full list of tables compromises all of SYSPRO’s functionality, it is unlikely that your environment is both licensed and actively using SYSPRO’s full suite of products. This means that most of these tables will be empty and will not be worth much of your attention.

Instead, there are about 25 – 50 tables in any given environment that sees most of the action. To provide a cheat sheet, here are some of the commonly used tables in SYSPRO that are essential to the daily use of SYSPRO:

  • ApInvoice – Supplier invoices
  • ApSupplier – Supplier header details
  • ApSupplierAddr – Addresses for the suppliers
  • ArCustomer – Customer header details
  • ArInvoice – Customer invoices
  • ArTrnDetail – Details about each invoice. Used extensively for sales reporting
  • BomOperations – Operations against a BOM
  • BomStructure – Structure against a BOM
  • InvMaster – Master for all stock codes in SYSPRO
  • InvMovements – Inventory transaction details against each SKU
  • InvPrice – Sell prices against each SKU
  • InvWarehouse – Master table for inventory counts of each SKU
  • PorMasterHdr – Purchase order header
  • PorMasterDetail – Purchase order details
  • SorMaster – Sales order master
  • SorDetail – Sales order details
  • WipMaster – Master for jobs
  • WipJobAllLab – Labor details against jobs
  • WipJobAllMat – Material details against jobs
  • WipJobPost – History of material/labor issued to jobs

The “Deployment” Database

Unique to SYSPRO 8, this database handles information relating to the release version of your SYSPRO environment. The “SYSPRO 8 Installer” tool uses this database exclusively to verify which products are available to you and whether any recent updates have become available. In addition, it contains information about which machines have SYSPRO clients installed on them and which versions they have installed. 

Admins, do you grasp the SYSPRO database structure for efficient data troubleshooting and analysis?

This covers the databases you will see in a usual SYSPRO environment. Knowing what SYSPRO’s database structure looks like is essential for any SYSPRO admin to effectively be able to find, troubleshoot, and analyze vital company data. 

How to Handle Unknown Processes in SYSPRO

How to Handle Unknown Processes in SYSPRO

Handling Unknown Processes in SYSPRO as an ERP Administrator

In SYSPRO, an “Unknown Process” is the result of a SYSPRO client having lost its connection to the host server prematurely. When an unknown process is detected, it means that a process is still running on the host server despite the client connection having been disconnected. Unknown processes can occur in the event of network disruption or a SYSPRO client shutting down unexpectedly.

Unknown Processes in SYSPRO ERP Admin

While SYSPRO generally catches common disconnects and clears these processes gracefully, in some cases, a process may linger and be declared as a “runaway” process. From an administrative point of view, it is important to stay on top of unknown processes as they can hog up valuable resources for others and can cause general instability if they are not terminated on a regular basis. Additionally, unknown processes can even consume user licenses which can affect other operators’ access to SYSPRO if you have an environment with limited user licensing.

To monitor and terminate any current unknown processes, you can use SYSPRO’s “Users” (IMPUSN) program. You can access the program by going to Main Menu > Administration > Logout Users. This program displays a list of all currently signed-in operators using SYSPRO. On the left-hand side, there is a “Processes” pane that you can filter for “Unknown”. A list of unknown processes will be displayed in the pane once selected. If you have any unknown processes in your system, the “End All Unknown Processes…” button will be enabled. Clicking it will clear the hung processes on the application server, and the previously hogged up server resources will once again be available.

SYSPRO Unknown Processes

To monitor operators seeing frequent disconnects, you can use the built-in Client-Server Diagnostic program (IMPDG5). Note that this program can only be run from a client machine. You can also make use of the System Audit Query program (IMPJNS) where you are able to filter for various system-related events such as client-server disconnects. These tools are sure to provide you with detailed information about any potential operator seeing frequent disconnects or unexpected client shutdowns.

SYSPRO ERP System Audit Screen

Please be aware that terminating unknown processes is only a temporary solution to the potential problem that is causing them to begin with. Be sure to monitor the specific client machines or operators encountering frequent disconnects.

Here are some helpful tips to reduce the number of unknown processes seen in your SYSPRO environment:

  • Educate your users about the importance of exiting SYSPRO “gracefully”. Unless SYSPRO is unresponsive, do not shut down Windows or use the Task Manager to kill SYSPRO.
  • Set a “timeout” value against operators so that SYSPRO disconnects the user after a given time of inactivity. This can be done through the “Operators” program (IMPBOP).
  • Schedule a task that performs a logout of all users in SYSPRO at a time where the system is not in use (generally overnight).
  • Stay up to date with available SYSPRO hotfixes and the latest SYSPRO product releases to remain within SYSPRO’s product support. New hotfixes are usually only developed for the latest versions of SYSPRO.

Looking for help with your SYSPRO ERP environment?

As an ERP Administrator handling Unknown Processes in SYSPRO, you know it’s crucial to vigilantly manage and terminate these processes to prevent resource depletion and licensing issues. The “Users” and “Client-Server Diagnostic” programs offer valuable tools for monitoring and addressing disconnects and unexpected shutdowns. However, it’s essential to address the root causes by educating users on proper exit procedures, setting timeout values, scheduling logouts during system downtime, and staying updated with SYSPRO hotfixes and releases to maintain product support and stability. Proactive management ensures the efficient operation of your SYSPRO environment.

If you find managing SYSPRO ERP processes and maintaining system stability a challenging task, consider reaching out to our team at EstesGroup. With our expertise in SYSPRO ERP consulting and our comprehensive suite of managed cloud and IT services, we can provide the support you need to streamline your operations, optimize performance, and ensure the smooth functioning of your SYSPRO environment. Don’t hesitate to leverage our experience and solutions to enhance your ERP management and IT infrastructure. Trust us at EstesGroup to help you navigate the complexities of SYSPRO with confidence.

Unlocking the SYSPRO System Audit Query

Unlocking the SYSPRO System Audit Query

System Audit Query – A SYSPRO ERP Administrator’s Go-To Report for SYSPRO Security Events

Being an administrator of an ERP system is no easy task. Thankfully, SYSPRO ships with several convenient programs that allow an administrator to actively monitor important events that are taking place within the system. One especially useful tool that stands out is the System Audit Query program (IMPJNS).

SYSPRO System Audit Query

SYSPRO System Audit

What You’ll Find in the SYSPRO System Audit Query Program

SYSPRO creates security logs automatically as events take place throughout the ERP. These logs are created to assist system administrators to better manage and review security related incidents in SYSPRO. The System Audit Query program is the place where these logs can be retrieved and analyzed. The program allows you to filter a time period for various security and system health-related events such as:

  • Access having been denied to a company or a program
  • Any security changes made to Groups, Roles, or specific operators
  • Logins attempted and any related error messages
  • Multi-Factor authentication changes or errors
  • System setup changes and activity related to licensing

Along with information about these events, the report can tell you which operator triggered the event, any notes associated with the event, as well as the name of the computer where the activity took place.

SYSPRO Security System Audit Query

One particularly important event that the System Audit Query program can identify for you is client-server disconnects. These are common problems reported by SYSPRO users and they can be highly complicated to investigate. SYSPRO generally has limited information about these events so the System Audit Query log is one of the few places where you can obtain valuable information about when/where they occur.

Along with the use of System Audit Query, you can investigate specific events even further by using the Job Logging Query program (IMPLOG). This program allows you to review and monitor general operator activity throughout SYSPRO.

For instance, if the System Audit Query reports technical issues relating to a specific operator, you can use the Job Logging Query program to analyze whether a specific program or user behavior is the cause of the problem. Be warned that the Job Logging Query program can take a long time to process if you choose to generate the report without filters. In a busy SYSPRO environment with a high number of daily users, the activity logs for operators will be dense and can take time to compile.

SYSPRO Job Logging Query

SYSPRO ERP Job Logging Query

A Day in the Life of a SYSPRO Admin

From the perspective of a SYSPRO administrator, actively monitoring the System Audit Query program is essential for ensuring the integrity of both the overall security and general stability of your ERP environment. The role of an ERP system administrator is undoubtedly challenging, requiring constant vigilance to ensure the smooth operation of crucial business processes.

Fortunately, SYSPRO equips administrators with a range of invaluable tools to actively monitor and maintain the system’s integrity. Among these, the System Audit Query program (IMPJNS) shines as a beacon of efficiency and reliability. With SYSPRO and its robust capabilities, administrators can confidently navigate the complex landscape of ERP management, ensuring their organizations operate seamlessly and securely.

Unlock the Full Potential of SYSPRO ERP Security with EstesGroup! Discover How Our Expert Consulting and Cutting-Edge Cloud Technology Services Can Help Your Business!