Modify Model - Error

[Former Member]

Hi folks,

I'm trying to process the dimension eventually I got an error with processing... then process the model then got an issue with OLAP..

For some reason system cannot create a CUBE... Any help will be greatly appreciated..

Thanks

Syed

==============[System Error Tracing]==============

[System  Name] : AdminServerHandler

[Message Type] : ErrorMessage

[Job Name]     : AdminApplicationHandler : ExecuteModIfyApplication

[DateTime]     : 09/07/2014 10:14:53

[UserId]       : xxxxxxxxxxxx

[Exception]

    DetailMsg  : {System.Exception: CreateOLAPCubeForApplication:CreateCube:Exception error has occurred; check the Log ID = 75724 for more details at OSoft.Services.Application.AdminMainServer.AdminApplicationHandler.ExecuteModIfyApplication(String strAppSet, String strApplicationName, String strApplicationDescription, String strSourceApplicationType, String strNewApplicationType, String strRateApplicationName, String strOwnerShipApplicationName, String strCurrencyConversionsCalculation, String strCalculation, String strIntercompanyBookings, String strUSEliminations, String strOpeningBalance, String strValidations, String strIntercompanyEliminations, DataTable dtDimensionList, Boolean bReassignSQLIndex, Boolean bProcessApplication, Boolean bDeleteFact, String strChangeAppType, String strUserID, String strReportBackID)}

==============[System Error Tracing  End ]==============

[former_member186498 · Accepted solution]

Hi Syed,

can you please share the message in Log ID = 75724?

In the meanwhile try processing dimensions one by one and verify which dimension has an issue and if the message change.

Try also processing the cube from SSMS.

It's a new installation or upgrade?

Regards

     Roberto

[Former Member · Accepted solution]

Hi Roberto

The issue started with dim processing failed with the following error message, and we thought the processing APP will fix this issue, even the processing Model gave some sort of issues:

Below is the complete message for Log-Id = 75724, also it is a new upgrade to 10.0 from 7.5, there is a issue with one of the dimension which of type "ACCOUNT".

Dimension processing Issue:

Model Processing Issue:

==============[System Error Tracing]==============

[System  Name] : AdminServerHandler

[Message Type] : ErrorMessage

[Job Name]     : AdminApplicationHandler : ExecuteModIfyApplication

[DateTime]     : 09/07/2014 10:14:53

[UserId]       : xxxxxxxxxxxx

[Exception]

    DetailMsg  : {System.Exception: CreateOLAPCubeForApplication:CreateCube:Exception error has occurred; check the Log ID = 75724 for more details at OSoft.Services.Application.AdminMainServer.AdminApplicationHandler.ExecuteModIfyApplication(String strAppSet, String strApplicationName, String strApplicationDescription, String strSourceApplicationType, String strNewApplicationType, String strRateApplicationName, String strOwnerShipApplicationName, String strCurrencyConversionsCalculation, String strCalculation, String strIntercompanyBookings, String strUSEliminations, String strOpeningBalance, String strValidations, String strIntercompanyEliminations, DataTable dtDimensionList, Boolean bReassignSQLIndex, Boolean bProcessApplication, Boolean bDeleteFact, String strChangeAppType, String strUserID, String strReportBackID)}

==============[System Error Tracing  End ]==============We are

[Former Member · Accepted solution]

Hi Roberto,

Here is some more information:

I would like to know where we can see  the more information related to highlighted lines below:

Thanks in advance

==============[System Error Tracing]==============

[System  Name] : DimensionManage

[Message Type] : ErrorMessage

[Job Name]     : DimensionManage : MakeDimension

[DateTime]     : 09/07/2014 10:13:34

[UserId]       : xxxxxxxxxxxx

[SqlException]

    Type      : System.Data.SqlClient.SqlException

    Errors    : System.Data.SqlClient.SqlErrorCollection

    Class     : 16

    LineNumber: 2

    Message   : {String or binary data would be truncated. The statement has been terminated.}

    Number    : 8152

    Procedure :

    Server    : SERVER NAME\ INSTANCE,3314

    State     : 10

    Source    : .Net SqlClient Data Provider

    TargetSite: System.Object InvokeMethod(Method, System.Object[], Boolean[], System.Reflection.BindingFlags)

    HelpLink  :

==============[System Error Tracing  End ]==============

[former_member186498 · Accepted solution]

Hi Syed,

sorry but this isn't the Log ID = 75724 message, you have to copy it from tbllogs.

Regards

     Roberto

[former_member186498 · Accepted solution]

Are you trying to add a new dimension?

Please explain better the sequence of your steps. You upgrade from 7.5 and after? Did you do a modify application just after the upgrade?

Whiuch step of the modify create the error?