Skip to Content
avatar image
Former Member

Cannot create dimension table.Exception error has occurred;: Location (MakeTable)

maketable.tx

Hi SAP BPC 7.5 Users,

When we run our dev-to-prod SSIS for the account dimension, we get the below error message. Attached is the log from DataManager. Below is SQL for log id. Can you help us?

Thanks. Barry

==============[System Exception Tracing]==============
[System Name] : ManageDimension
[Message Type] : ErrorMessage
[Job Name] : clsMakeDimension : MakeTable
[DateTime] : 12/20/2016 8:14:07 PM

maketable.txt (8.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 22, 2016 at 09:59 AM

    Hi Barry,

    can you please share also the log id?

    Thanks

    Roberto

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 22, 2016 at 03:41 PM

    Here it is, Roberto:

    SystemNameManageDimensionJobNameclsMakeDimension : MakeTableLogID1997012==============[System Exception Tracing]==============[SystemName] : ManageDimension[Message Type] : ErrorMessage[Job Name]: clsMakeDimension : MakeTable[DateTime]: 12/20/2016 8:14:07 PM[UserId]: EMSC\BPCADMIN[Exception]DetailMsg: {}==============[System Exception TracingEnd ]==============

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 22, 2016 at 03:43 PM

    Attached as a .jpeg

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07, 2017 at 02:16 PM

    Hello Barry,

    Did you know that SAP BPC 7.5 is at end of support?

    You should consider upgrade to BPC 10.x soon.

    As for the issue is this a new custom SSIS package? Has it worked correctly before?

    You should review this with a SAP consultant.

    Can you take a look at KBA :

    1748057 - error on add a new dimension member.

    Best Regards,

    Dorra.

    Add comment
    10|10000 characters needed characters exceeded