Posts Tagged ‘SQL’

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]

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


Web request did not return any data. Verify the mapID is correct and try again.
Configure a Business Central Change Data Source
Failed to create record.: Entity does not support insert
Too Many Fields Defined After Microsoft Update
The operating system is not presently configured to run this application

POPULAR POSTS


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
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
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms

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