Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Additional GP login wi...
Microsoft Dynamics GP (Archived)

Additional GP login window titled "Login"

(0) ShareShare
ReportReport
Posted on by Rennecia Barran

Hi,

Further to adding new feature 'tax effective date rates' in a GP 2013 environment we now have a login window coming up before the regular GP login window. Before this a message comes up saying "An open operation on table "SY_Pathnames' failed because you are not logged in to a valid data source"

I have checked the ODBC and changed the default database from master to DYNAMICS.

I have checked the security on the GP Folder

I have recompiled and update statistics in SQL>Maintenance on the pathnames and tax module setup tables but still nothing resolves my issue.

Now strange is, it worked in one GP 2013 environment but not this one.

Any feedback is appreciated.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Additional GP login window titled "Login"

    Thanks David!

    It was in a Start script. We were able to remove the appropriate lines from our macro and some other obsolete code as well.

    Your help and explanation were greatly appreciated. It was a good learning experience for all involved.

    Cheers,

    Darren Moffat

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,926 Most Valuable Professional on at
    RE: Additional GP login window titled "Login"

    Hi Darren

    Ignore the ClickCancel lines, they can be removed from the macro.

    You are selecting the CMG_Installation_Procedure to run during the chunking process. This will work during the build process.

    You don't mention whether it is the Start/Pre or End/Post script, but it does not make much difference. Neither will work as you cannot do your installation before logging in.

    In the ctree/btrieve/P.SQL days, you could have done your installation here, but not with SQL Server. With SQL Server you need to be logged in as a user with permissions to create tables before trying to install.

    You need to remove the section starting with

     MoveTo field '(L) Has Start Script'  # 'FALSE'

    or

      MoveTo field '(L) Has End Script'  # 'FALSE'

    down to and including

     MoveTo field 'Ok Button'

     ClickHit field 'Ok Button'

    NewActiveWin dictionary 'default'  form 'Auto Chunk' window 'Auto Chunk'

    David

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Additional GP login window titled "Login"

    Hi David,

    Thank you for the help with this! We did get it figured out.

    The line with "item 276" in it was the culprit. We have two application being built on this server and depending on version and application we modify our chunk macro. We missed updating this line. We were surprised to see this wasn't caught as a build error. I suspect dexutils tries to select it, selects nothing because the value doesn't exist in this application, and moves on. i would expect a macro error, but...

    I still don't understand what this step is doing though. Would you mind giving a brief explanation?

    Cheers,

    Darren

    NewActiveWin dictionary 'default'  form Chunker window 'Global Script Lookup'

    WindowMove dictionary 'default'  form Chunker window 'Global Script Lookup' pointh 191 pointv 40

     ClickCancel field 'Resource Listbox' item 0

     ClickCancel field 'Resource Listbox' item 0

     ClickHit field 'Resource Listbox' item 276  # 'CMG_Installation_Procedure'

     MoveTo field 'Ok Button'

     ClickHit field 'Ok Button'

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,926 Most Valuable Professional on at
    RE: Additional GP login window titled "Login"

    Glad I was able to help.

    Make sure you mark the question as answered.

    David

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Additional GP login window titled "Login"

    Hi David,

    We've found the issue in the macro, as you said it's using a post chunking script, in our case it was incorrect in our macro. Thanks for the assistance on this. We'll adjust our trigger scripts as well.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,926 Most Valuable Professional on at
    RE: Additional GP login window titled "Login"

    Hi Andrew

    In your macro, on the Auto chunk window are you setting a pre or post chunking script.

    Are you running as administrator when you unchunk? Is UAC active on the machine?

    Can you detail exactly what the error message is as I don't think you are getting the same error for the same reasons that was originally on this forum post.

    David

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Additional GP login window titled "Login"

    Hi David,

    Sorry, i'm not sure what you mean by post chunking scripts. We use a macro in dexterity utilities to compile the chunk file, then use the dag.exe to build the corresponding application dll for use with our gp addins.  The strange thing here is if we build the chunk file from a different server (sames steps) it actually deploys properly. So my best guess is something in the environment but we have not been able to pinpoint what it would be.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,926 Most Valuable Professional on at
    RE: Additional GP login window titled "Login"

    Hi Andrew

    Use anonymous() with your focus triggers not reference(). reference() is deprecated.

    Again the Switch Company form can close without logging in and your trigger still fires.

    You could also make sure that both 'User ID' of globals and 'Company ID' of globals are not empty to be sure you have logged in.

    But your current trigger will fire if I am logged in and open the Switch Company form and click cancel.

    That's why you should use the procedure I mentioned.

    Do you have any pre or post chunking scripts? They cannot access any tables as you have not yet logged in.

    David

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Additional GP login window titled "Login"

    HI David,

    The error only occurs immediately after deploying the chunk file, and it's followed by an error that is based on a project accounting trigger. We will adjust the code for the Add_Successful_Login_record to see if it makes a difference.

    Below is the initial trigger that checks the SY_PATHNAMES

    Trigger_RegisterFocus(reference(form 'Switch Company'), TRIGGER_FOCUS_POST,TRIGGER_AFTER_ORIGINAL,script CMG_Installation)

    The really odd thing is it only occurs after the deployment of the .cnk file. After that everything is fine.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,926 Most Valuable Professional on at
    RE: Additional GP login window titled "Login"

    Hi Andrew

    Clicking OK is not a guarantee of a successful sign in to a company.

    Use a trigger on procedure Add_Successful_Login_Record instead

    When do you get the error? Do you have a login window appearing before the standard GP login window?

    Have you used anonymous() to wrap any table references when registering triggers, usually in your startup script?

    David

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans