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

[former_member576285]

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

[former_member283908]

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.

[former_member576285]

Attached as a .jpeg

[former_member576285]

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 ]==============

[former_member186498]

Hi Barry,

can you please share also the log id?

Thanks

Roberto