You’re offline. This is a read only version of the page.
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
this issue is resolved with me I found script with sp12 for frx I run it and work fine
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (