Smartviews
SmartViews - Steps to Configure SQL Connection
1. Open SmartView’s: Launch the SmartView’s Analyze application. The main interface will be displayed. 2. Access the Connection Settings: Click on the File menu. Navigate to Views > Create New View. This will allow access to the data connection ...
SmartViews Scheduler - Release Notes
version V1000.1200 - CustomAppointmentForm - fix minor issue with parameters showing when there aren't any -ScheduleScreen - Gracefully give user message about concurrency error when appointments that were processed while the UI was open version ...
Smartviews Data Connection
How to Add a data connection? Step 1 : Login to SmartViews and select Designer tab and Click on "Add" a data connection Currently, Smartviews support the following data connection: Microsoft SQL server MS Access MS Excel Oracle ODBC Lillyworks ...
SmartViews Update Error - Cannot Parse Date
Older versions of SmartViews were unable to parse date formats other than US English. This can prevent users from updating from those versions, as it checks the end-of-maintenance date in the update process. To resolve this, open up Windows Region ...
SmartViews - Extend Query Timeout
In some cases, you may want to extend the connection timeout in SmartViews if the query takes longer than the default 30 seconds to execute. To do this: Edit / Create a New View, select your database connection, then click "Edit" When the Connection ...
SmartViews Sync Error - "Cannot find column __"
If this error is ever encountered, update SmartViews as this was corrected in v452.1800
SmartViews Report "Object Reference" error when refreshing report
If this error occurs, verify the version the user is on. If they are on a version prior to 452.1200, then they should upgrade to resolve this issue.
SmartViews version 452.1000 and above on Windows 7
Versions of SmartViews 452.1000 and above uses the .NET Framework 4.5.2 (as denoted by the first 3 digits of the version of SmartViews). If a user is on Windows 7 and encounters this launch error, be sure .NET Framework 4.5.2 is installed. This can ...
Object Reference not set to an instance of an object
This error does not have enough information to diagnose ANY problem. We need to following information to get started: Please collect and document the following: The Application Customer Name Version of the Application - this is found clicking through ...
Blank / no data showing when loading SmartViews Report
SmartViews Reports differ from SmartViews Views in that Reports do not display data unless a layout is created. If the above screen is encountered when launching a View, ensure that a layout is selected by clicking the "Layout" button next to the ...
SmartViews Error “The specified table does not exist [sv_Users]” - On Premise Installations
SmartViews has an "On Premise" type of installation that allows customers to use a local SQL Server instead of the Azure cloud database. Depending on the version they are on, they may experience this error after updating to later versions: “The ...
Smartviews Canned Available Views List
How to turn on Roaming Profile for SmartViews
How to turn on Roaming Profile for SmartViews (Note: user must be running version 4.3.1.0 or later) Purpose: SmartViews uses local cache files to store its info. It always saved to the root directory where SmartViews is installed. Each user will have ...
SmartViews LillyWorks connection - Can't load ProductionExecution "virtual" table schema
This error does not come from SmartViews, but rather from the web service request. The error in the HTTP message itself is the "real" error, which could be one of many (i.e. it does not have to be "Call frequency cannot be more often than every 5 ...
Incorrect format error on SmartViews launch
If this error is ever encountered during SmartViews launch, ensure that both x64 and x86 versions of Microsoft SQL Server CE are installed on the machine. This is machine architecture dependent: 32 bit Windows installation ...
SmartViews Send User Invite - Failure Sending Mail
If you are running a version of SmartViews older than v452.1600, clicking Send User Invite will fail to email the receiving user. You will have to update to resolve this issue, but for a temporary workaround, click Show User Invite to view the user's ...
How to Output SmartViews Installation Log
If there is an unexpected issue when running the SmartViews installer, run it via the command line using the command below to output a log file. This can be helpful either to you or to a Synergy employee to help diagnose the reason why the install ...
SmartViews Error - Missing FilterCriteria token, Add: FilterCriteria = @FilterCriteria
If you encounter the above error in SmartViews, you need to add the Filter Criteria to the WHERE clause of the query. Open up the Designer and navigate to SQL Designer -> SQL. If the query already contains a WHERE clause, append "AND FilterCriteria = ...
How to disable syncing for a user
A user may want to disable their ability to sync if they're working on changes that they don't want to go out to everyone just yet. To do this, open up regedit and go to the following path: ...
Open Purchase Order - Missing POs without any lines
If you find in the View included with SmartViews called "Open Purchase Order" that you are not seeing Purchase Orders with no line-level Desired Recv Dates, this can be resolved by replacing the highlighted instance of PURC_ORDER_LINE with ...
Clearing\Resetting The Local Cache in SmartViews
This article is out of date. Read this one instead: Synergy Resources (zoho.com) There are times in which the local database becomes out of sync with the cloud database causing the sync functionality to stop working. Clearing the cache will solve ...
SmartViews - Using Report Parameters
In addition to the Filter Criteria window found in Reports and Views, Reports also have parameters that can be set up in the Report Layout Editor. One advantage to using parameters over Filter Criteria is that the parameter values can be displayed in ...
SmartViews - Local DB / Cache Reset
What is it? SmartViews has a feature called "Reset Local DB," or "Cache Reset" as it was called before v462.1100. When you make changes in SmartViews, those changes don't immediately get pushed to the Cloud; instead, they are only made in a local ...
What Data Does SmartViews Store?
SmartViews is a tool that allows you to view data from your various databases in an aesthetically pleasing way, but SmartViews requires its own database in order to run. By default, we host a SmartViews DB for all of our customers, but your company ...
SmartViews Network Requirements
In addition to connecting to other databases to view their data, SmartViews also needs to be able to connect to a designated SmartViews database in order to run. This SmartViews database stores the data in SmartViews, such as user accounts, Views, ...
SmartViews Scheduler User Guide
PREREQUISITES Supported Visual version are 7.0 – 10.x Database Platform: SQL Server & Oracle Microsoft .Net Framework 4.8 ADMINISTRATION INSTALLING Use the following link to download the setup file. Once downloaded follow these steps to install. Run ...
SmartViews Error - "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
If this error is ever encountered, be sure the Microsoft Access Database Engine is installed: https://www.microsoft.com/en-us/download/details.aspx?id=13255 Be sure to install the correct architecture version based on your windows installation. If ...
SmartViews - Error “The specified table does not exist [sv_Users]” - Azure Cloud Database
Depending on the version of SmartViews a customer is on, they may experience this error after updating to later versions: “The specified table does not exist [sv_Users]” The following steps should be tried in order to solve the issue. Try logging in ...
Sql Server LocalDB Installation for New SmartViews
Installation Instructions As of version 462.1000, SmartViews uses LocalDB 2017 in place of the previous local cache. As such, LocalDB 2017 or later needs to be installed on the machine, and an important patch needs to be applied. LOCALDB 2019 ...
SmartViews - User Guide
Prerequisites: Windows Server 2012R2-2022 Windows 8-11 SQL Server 2012R2-SQL 2019 SQL Server 2017 minimum Cumulative Update (CU) is 31 (14.0.3456.2) Visual 7x- .NET 4.6.2 Visual 11 - .NET 4.8 64 bit architecture if outgoing ports are blocked at the ...
SmartViews - Release Notes
v480.1000 (2025.01.09) Change to framework 4.8 Remove 32 bit requirement Update DevExpress to v23.2Change to framework 4.8 v462.2001 (8/9/2024) Fixed memory limitations and leaks when loading large amounts of data in a View Turned off automatic ...
Register Application for OAuth
Registering Application for 0Auth Login to Portal.azure.com and navigate to Azure Active Directory Select App Registrations Click on New registration Give the App a name of your choosing Set the Supported acount type to Single Tenant redirect URI ...