web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Creation of Structure ...
Microsoft Dynamics GP (Archived)

Creation of Structure Dimension Wizard for AA in FRx

(0) ShareShare
ReportReport
Posted on by Community Member

Hello, 

I have a big problem when i try to create a structure dimension with the wizard. All of the steps were completed but the last step is the problem, because this step never finish.

I identified the stored procedures what have the problem and don't finish their work. The stored procedures that are used:

Firstly. csp_PopulateAccountCodeTable, which is completed when i avoid the other. But this stored only works with accounts and dimensions.

Secondly. csp_PopulateBudgetAccountCodes, which never finish, this stored works with tree budgets associated to dimesnions and accounts.

Greatings, i hope that someone can help me.

HAROLD. 

*This post is locked for comments

I have the same question (0)
  • callen Profile Picture
    callen 4,595 on at
    Re: Creation of Structure Dimension Wizard for AA in FRx

    Have you verified there are no invalid characters? Have you tried using SQL Profiler to see if there are any problems during the creation of the structure?

     

     

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Creation of Structure Dimension Wizard for AA in FRx

    Hi,

     Thanks for the answer; i verified those things firstly and everything is normal; all of codes that i use are numbers of 6 digits, nothing rare.

     But, now i realized something extrange happened;  After 3 or 4 days of waiting that the process finish, i received the following message:  "An Error Occurred While Saving a New Dimension Structure."

    I noticed i have low space in my hard disk after this error, however when i started the process i had like 12 Gb. of space.

    Greatings, i hope new answers, thanks.

  • Community Member Profile Picture
    Community Member on at
    RE: Creation of Structure Dimension Wizard for AA in FRx

    i have the same problem and i found in event viewer that "Message: ERROR [23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_frl_entity_seg_num'. Cannot insert duplicate key in object 'dbo.frl_seg_desc'.

    ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]"

    this Happend also when try to refresh COA to let the new AA item to Appear In FRX

    till now i can't solve this problem  please help

  • Community Member Profile Picture
    Community Member on at
    RE: Creation of Structure Dimension Wizard for AA in FRx

    this issue  is resolved with me I found script with sp12 for frx I run it and work fine

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans