Posts Tagged ‘SQL’

Could not initialize a collection when launching SmartConnect

ErrorWhen launching the SmartConnect client received the below message:Could not log into the SQL Servercould not initialize a collection: [eOne.SmartConnect.Engine.User.UserWebFormOptions#6c6113ce-075b-4d49-8ec1-9ea400bb6db8][SQL: SELECT userwebfor0_.UserId as UserId1_, userwebfor0_.UserWebFormOptionId as UserWebF1_1_, userwebfor0_.UserWebFormOptionId as UserWebF1_100_0_, userwebfor0_.FormName as FormName100_0_, userwebfor0_.UserId as UserId100_0_ FROM [UserWebFormOption] userwebfor0_ WHERE userwebfor0_.UserId=?]ResolutionOne or more tables in the SmartConnect database are not using the expected dbo schema.…

[Read More]
Tech Tuesday

Tech Tuesday: Adding Company ID to SmartList Builder Multicompany Summary Report

I recently ran into a scenario that I’ve seen a few times before that I thought I’d document in today’s blog article.We’ll document the problem we’re trying to solve, the troubleshooting steps, the underlying issue, and then the solution.The scenario is this:Customer has created a summary report in SmartList Builder that does <something> and they…

[Read More]

Firewall Settings for SmartConnect.com

For connectors that connect to a database on a local server, you will need to open a port to allow SmartConnect to access them. To protect your security, you can add firewall white list rules to only allow SmartConnect in. The IP addresses that require access vary depending on your app login url.app.smartconnect.com168.62.106.4765.52.220.12365.52.192.52168.62.247.11452.162.107.623.96.246.1823.96.253.1065.52.218.20265.52.220.6165.52.221.146appeuw.smartconnect.com52.166.119.9952.166.119.19652.233.176.11323.100.14.21123.100.11.15252.166.64.20152.166.64.192 appuks.smartconnect.com51.140.152.15451.140.8.9251.140.0.5051.140.2.7651.140.7.10651.140.140.15751.140.8.6151.140.13.40smartconnectwebau.azurewebsites.net13.75.138.22413.70.65.11413.70.71.8313.70.65.14513.70.67.8413.70.71.5413.73.195.135

[Read More]

The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement

The user is running a SmartConnect integration to Dynamics GP.On one machine, the integration fails with the error:Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting…

[Read More]

This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms

What is FIPS?Windows has a setting that prevents applications on the machine from using encryption that are not compliant with Federal Information Processing Standards(FIPS). This setting is typically only needed for servers that contain government data. Here is a good article about FIPS and why it would need to be enabled.The reason this is causing…

[Read More]

Error Code 12005 not found when using Create Employee in SmartConnect

I’m running a SmartConnect map  to create employees using the Create Employee destination.  Most of the records are successful but a few give the error: Error Number = 12005  Stored Procedure=   Error Description = Error Codes were not found in table DYNAMICS..taErrorCode. Please insure that the table taErrorCode is up to update. 12005Since it doesn’t…

[Read More]

MSSQL Real-Time Data Source Registration Error

When registering an MSSQL Real-Time data source receive the following error message.Latest version of MSSQL real time data source assembly does not exist in SERVER : DATABASETo enable real time data sources please run the script below as a MSSQL system administrator on the server and try again.How to resolve the error messageIn most cases…

[Read More]

Error: SQL Script parse error: invalid syntax, during SmartConnect install

When installing SmartConnect we are getting the error message, SQL script parse error: invalid syntax. The install then rolls back all actions. We have tried installing several versions of SmartConnect with the same results on each one.  ———————————————————————————————————————-In this case the user was entering a SmartConnect user password that contained a single quote (‘). When…

[Read More]

Moving SmartConnect to a new server

There are two methods available when moving the SmartConnect to a new server. The best option is to export all your maps, objects, and variables through the SmartConnect user interface and import them into a brand new SmartConnect install on the new server. The other option, is to back up your current SmartConnect database and…

[Read More]

RECENT POSTS


Use the REST Connector to parse nested Value Arrays
SmartConnect email task fails with error: An invalid character was found in the email header
Does SmartConnect import into Avalara Avatax software
Could not initialize a collection when launching SmartConnect
ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key when you open a SmartConnect map.

POPULAR POSTS


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training