Error Compiling Script 'before Query Integration Manager
Search Topic OptionsPost ReplyCreate New Topic Printable Version Translate Topic asherwood Members Profile Find Members Posts MicrosoftDynamicsForums.com Member Joined: February052008 Status: Offline Points: 30 Post Options Post Reply Quoteasherwood Report Post Thanks(0) QuoteReply Topic: Integration Manager Script ErrorPosted: November042008 at 10:04am I am attempting to run an import from IM, and I am getting this error: The source could not be initialized due to the following problem: Error Compiling Script 'Before Query Document1' Line -5: Expected '(' I have tried to research this issue and have foudn nothing. Also, I have run imports before and have never seen this come up. Anyone have any experience with this issue? Thank you. Sponsored Links daoudm Members Profile Find Members Posts Visit Members Homepage MicrosoftDynamicsForums.com Member Joined: February042008 Location: Amman Status: Offline Points: 442 Post Options Post Reply Quotedaoudm Report Post Thanks(0) QuoteReply Posted: November052008 at 9:43am Did you write any scripts that affects your integration? if so you may need to check your code, otherwise reinstalling IM might help. Regards, Mohammad R. Daoud [MVP] +962 - 79 - 999 65 85 mohdaoud@gmail.com http://mohdaoud.blogspot.com animesh1001 Members Profile Find Members Posts MicrosoftDynamicsForums.com Member Joined: May222008 Location: London Status: Offline Points: 9 Post Options Post Reply Quoteanimesh1001 Report Post Thanks(0) QuoteReply Posted: November172008 at 9:42am please do the following - 1. open the integration manager tools > integration > integration manager 2. open the problem integration 3. select the source csv file. 4. right click the sources and select 'Preview' 5. check if you can 'Preview' if you can preview then it is possible that the problem is in the file. if you get the error while pre-view then there is problem at that state. 6. open the properties of the source and select [rows]. 7. see if the cretria is correctly entered. 8. also look for the [columns] tab for any discripiencies. I
Not a valid date Posted by HomeJoin TodayMembership Levels & PricingNetworking BenefitsEducation BenefitsVisitor CenterMy ProfileChapters Find a ChapterMy Chapter CommunityMy Chapter RegistrationsConferences AmplifyGPUG SummitLearn & Engage Special Interest GroupsUpcoming WebinarsWebinar RecordingsGPUG AcademyOpen ForumVolunteerPartner Company DirectoryCommunities Open ForumChapter CommunitiesSIG CommunitiesMy CommunitiesAll http://www.microsoftdynamicsforums.com/forums/forum_posts.asp?TID=3110 CommunitiesNews & Resources NewsMagazineBlogsGP 2015 ResourcesGP SandboxCredentialed ProfessionalsAbout Us Advisory CommitteeAbout GPUGContact UsFrequently Asked QuestionsShop GPUG Store Open Forum Community Home Discussion 24K Library 582 Blogs 233 Members 14.2K sort by most recent sort by thread https://www.gpug.com/communities/community-home/digestviewer/viewthread?GroupId=247&MID=27280&tab=digestviewer&CommunityKey=4754a624-39c5-4458-8105-02b65a7e929e Topic: HomeJoin TodayMembershipLevels & PricingNetworking BenefitsEducation BenefitsVisitor CenterMy ProfileChaptersFind a ChapterMy Chapter CommunityMy Chapter RegistrationsConferencesAmplifyGPUG SummitLearn & EngageSpecial Interest GroupsUpcoming WebinarsWebinar RecordingsGPUG AcademyOpen ForumVolunteerPartner Company DirectoryCommunitiesOpen ForumChapter CommunitiesSIG CommunitiesMy CommunitiesAll CommunitiesNews & ResourcesNewsMagazineBlogsGP 2015 ResourcesGP SandboxCredentialed ProfessionalsAbout UsAdvisory CommitteeAbout GPUGContact UsFrequently Asked QuestionsShop GPUG Store Copyright © 2016 Dynamic Communities, Inc. All rights reserved. Show Hide Mark Your Calendar Scott Guthrie Keynote at GPUG Summit on Tuesday, Oct 11 at 2:00 p.m. Learn More Contact GPUG | FAQ | Privacy Policy | Code of Conduct Site designed by Brightfind Powered by Cobalt xRM and Higher Logic Powered by Higher Logic
My good friend, David Musgrave, somehow manages to get me involved in interesting topics circulating in his inbox. Just recently, he came across a fairly long thread among his peers, needing to work out some http://dynamicsgpblogster.blogspot.com/2010/11/integration-manager-integrating-journal.html Integration Manager issues for journal entries with Analytical Accounting information. David was kind enough to involve me, as I had posted an answer on the newsgroups a long time ago on this same issue. If you are one of the fervourous Integration Manager fans out there and have had to work on integrating journal entries with Analytical Accounting information, you may know this is only possible with error compiling the eConnect Adapter, not the Standard Adapter. The eConnect Adapter was introduced with Integration Manager version 10, and replaces the old SQL Optimized Adapter available in prior versions of Integration Manager. The eConnect Adapter in turn, leverages eConnect components to deliver a robust transactional environment for high volume integrations using ADO.NET to access Microsoft Dynamics GP company databases. eConnect Adapter - Journal Entry# field with Use Default error compiling script rule value However, the eConnect Adapter, though, while it provides a Use Default rule value for the Journal Entry# field, this setting causes the integration to fail, as eConnect (the component) requires a value to be supplied, this is, the actual journal number. Of course the question now is, how do you retrieve the next journal number from your company database to supply this value to the Journal Entry# field to allow the integration to be successful and thereby, preventing you from having to manually reserve ? The answer is, scripting, of the VBScript type. You can add VBScript code to the Before Document event script in Integration Manager to retrieve the next journal number from your company database, as follows: ' Created by: Mariano Gomez, MVP ' This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.5 Generic license. Option Explicit Const adCmdStoredProc = 4 Const adParamInput = 1 Const adParamOutput = 2 Const adParamInputOutput = 3 Const adInteger = 3 Const adVarchar = 200 Const adBoolean = 11 Const adChar = 129 Const adDate = 7 Const adNumeric = 131 Dim SqlStmt Dim objConnection, objCommand, NextJournal Set objConnection = CreateObject("ADODB.Connection") Set objCommand = CreateObject("ADODB.Command") objConnection.Open _ "Provider=SQLNCLI10;Server=MGB001\GP11;