Skip to Content
0

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

Dec 21, 2016 at 08:21 PM

82

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Roberto Vidotti Dec 22, 2016 at 09:59 AM
0

Hi Barry,

can you please share also the log id?

Thanks

Roberto

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 22, 2016 at 03:41 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 22, 2016 at 03:43 PM
0

Attached as a .jpeg

Share
10 |10000 characters needed characters left characters exceeded
Dorra KHEZAMI Jan 07, 2017 at 02:16 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded