Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to recreate PSTL d...
Microsoft Dynamics GP (Archived)

How to recreate PSTL database objects

(0) ShareShare
ReportReport
Posted on by Riaan Taljaard 536

Hi all

I have an issue with creating database objects for PSTL. I have GP set up in a test environment. I created a new company using GP utilities. When I open PSTL it continuously gets stuck on creating a stored procedure. first it was the smChangeAccountIndex2.

I have tried removing PSTL and adding the chunk file again.

I have tried dropping recreating objects through the SQL Maintenance window inside GP.

I have made sure the datasource is correct.

I have delete the TA00850 and TA00860 tables to try again.

Nothing has worked thus far.

I then manually added that proc from my local installation but now it gets stuck on the next missing proc.

Any ideas?

Riaan

*This post is locked for comments

  • Verified answer
    Riaan Taljaard Profile Picture
    Riaan Taljaard 536 on at
    RE: How to recreate PSTL database objects

    Hi all

    I forgot to post, I managed to come right. I re applied SP2 for GP2013 and the PSTL objects created correctly and I was able to us PSTL.

    Thanks

    Riaan

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: How to recreate PSTL database objects

    Riaan, is this related to the installation of GP that failed to have the SA accessing the database in the TEST environment?

    If so, I strongly believe you have a deeper issue with this installation and that the underlying company database needs to be re-created.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: How to recreate PSTL database objects

    Nothing !

  • Riaan Taljaard Profile Picture
    Riaan Taljaard 536 on at
    RE: How to recreate PSTL database objects

    Here is a screenshot...

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: How to recreate PSTL database objects

    Riaan

    Share a print screen for the error and any details when clicking on the rebuild stored procedure

  • Riaan Taljaard Profile Picture
    Riaan Taljaard 536 on at
    RE: How to recreate PSTL database objects

    Hi,

    Thanks for the reply. Yes I tried the normal uninstall like you suggested before I tried the chunk file route. No success.

    The rebuild procs also gave me the same error unfortunately.

    Riaan

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: How to recreate PSTL database objects

    For Dynamics GP 2013, there is no need for a chunk file, it can be simply added from the control panel (Add remove features)

    71627.1.png

    Can you reach the PSTL window, there is a rebuild stored procedure button at the bottom as shown below, have you tried that ?

    Your feedback is highly appreciated,

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