Forum Stats

  • 3,817,360 Users
  • 2,259,322 Discussions
  • 7,893,760 Comments

Discussions

Error Message, Failed to load Dimensions You are trying to change data that has been changed by a us

MichaelCHy
MichaelCHy Member Posts: 119
edited Oct 25, 2018 8:12AM in Planning and Budgeting

Greetings, we are running in an issue with Planning 11.1.2.4 EPMA deployed application. During application deployments it intermittently aborts. No one else is logged in at this time besides the "admin" id. I looked at the abort deployment logs and, I get the following:

[Oct 22, 2018 7:37:14 AM]: Parsing Application Properties...Done

[Oct 22, 2018 7:37:14 AM]: Parsing Dimensions info...Done

[Oct 22, 2018 7:37:14 AM]: Registering the application to shared services...Done

[Oct 22, 2018 7:37:15 AM]: Checking for rates properties...Done

[Oct 22, 2018 7:37:15 AM]: Loading Smart Lists...Done

[Oct 22, 2018 7:37:15 AM]: Loading Alias Tables...Done

[Oct 22, 2018 7:37:15 AM]: Updating the default user preferences...Done

[Oct 22, 2018 7:37:15 AM]: Loading Dimensions...[Oct 22, 2018 7:37:15 AM]: Failed to load Dimensions You are trying to change data that has been changed by a user on another server. Wait a few seconds and try again. If you continue to see this error message, please contact your administrator.

[Oct 22, 2018 7:37:15 AM]: An Exception occurred during Application deployment.: Failed to load Dimensions

This process runs when the system has no one logged on. The process is executed via an ODI Script but, I do the deployment separately within the Application library and get the abort deployment as well. The first time for the day it will fail, Second or third time it will complete successfully. The users are saying the attribute tagged dimensions are not getting updated so, there shouldn't be a change in metadata.

I logged into Planning0 and Planning1 logs with no insight. Not sure what other log to look into to see the root of the issue.  Does the community have any thoughts? Thank you in advance.

Answers

  • Madhusudhan. M
    Madhusudhan. M Business Analyst Member Posts: 1,904 Silver Trophy
    edited Oct 23, 2018 12:50AM

    If same process happening with both servers, i mean request handling with 2 servers we will get this type of issues. Check out EPMA logs and Planning logs also to check errors

    Thanks,

    Mady

  • MichaelCHy
    MichaelCHy Member Posts: 119
    edited Oct 24, 2018 8:55AM

    Thank you Mady, I looked at the dimensionserver.log files and, they don't give me much to go on. there are some warnings that we know of but, the application has been deploying for a while with the warnings. I don't think those warnings would throw the deployment to abort. I manually deployed and it completed but, then, I ran the ODI process twice and it failed with the same error deploy aborted. I ran the ODI process a third time and it completed successfully. So, the failures root do the aborted deployment but, cannot see why it aborts or completes. I have pasted part of the dimensionserver log below:

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T03:02:14.418-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.DimensionServer.Scheduler] [tid: Scheduler] [ecid: disabled,0] Executing scheduled task 'Purge Non-Associated Baselines'.[2018-10-24T03:02:44.729-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.DimensionServer.Scheduler] [tid: Scheduler] [ecid: disabled,0] Task Purge Non-Associated Baselines execution complete.  Next execute time is 10/25/2018 3:00:00 AM.[2018-10-24T04:02:44.771-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.DimensionServer.Scheduler] [tid: Scheduler] [ecid: disabled,0] Executing scheduled task 'Temporary Application Cleanup'.[2018-10-24T04:02:44.877-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.DimensionServer.Scheduler] [tid: Scheduler] [ecid: disabled,0] Task Temporary Application Cleanup execution complete.  Next execute time is 10/25/2018 4:00:00 AM.[2018-10-24T04:32:44.907-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.DimensionServer.Scheduler] [tid: Scheduler] [ecid: disabled,0] Executing scheduled task 'Cleanup Temp File Folders'.[2018-10-24T04:32:44.937-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.DimensionServer.Scheduler] [tid: Scheduler] [ecid: disabled,0] Task Cleanup Temp File Folders execution complete.  Next execute time is 10/25/2018 4:30:00 AM.[2018-10-24T07:01:17.629-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '50008' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.657-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '50307' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.680-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '50285' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.707-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '411402' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.726-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '50304' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.744-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '50076' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.762-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '50331' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.786-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '06-09-2015' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.803-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '01-26-2016' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.821-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '01-13-2016' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.839-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '10-13-2016' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.856-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '05-30-2017' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.874-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '01-01-2017' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.920-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '7143117 - Ramos Mata,Gabriela Maria' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.940-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '0478896 - Garrett,Larry' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.958-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '7047355 - Smith,Raymond A' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.977-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '0890705 - Starks,T'Era C' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:17.996-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '1125862 - Atkins,Asheli Shemeka' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)[2018-10-24T07:01:18.015-05:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: 13] [ecid: disabled,0] SVR_ERR_MEMBER_IS_REFERENCED:Member '0567584 - Eguia,Rodolfo Pablo' is referenced by another Member.    at Hyperion.DimensionServer.Dimension.DeleteBranch(RelationshipMember topMember, Boolean relaxErrorChecks, Boolean deleteAllInstances)

       at Hyperion.DimensionServer.Automators.DeleteBranch.Execute()

       at Hyperion.DimensionServer.ImportEngine.DeleteUnreferencedMembers(ImportDimension importDim)

  • Madhusudhan. M
    Madhusudhan. M Business Analyst Member Posts: 1,904 Silver Trophy
    edited Oct 25, 2018 12:38AM

    Then some issue with connecting to Application from ODI or any time out settings etc.

    Is it resolved ? you marked it as answered already.

    Thanks,

    Mady