Error: Install /SAP_SMART_BUSINESS_FOR_FND or SMART Business for ERP on HANA

[Former Member]

hi

I have a problem with the install of Smart Business for HANA in the HANA Studio.

I have a HANA DB (Revision 82). ERP Business Suite EHP 7 installed.

Now I want to install for FIORI Analytical, SMART business.

But I always get an error. In the log that different tables Column is not found:

. : Activation is performed with activation mode import.

sap.hba.fnd.SocialPostSearchTerms : Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Create Scenario failed:

ColumnTable SAP_FND:SMI_SRCHQRY not found (cannot get catalog object)(CalculationNode (SMI_SRCHQRY))

The following errors occured: Inconsistent calculation model (34011)

Details (Errors):

- CalculationNode (SMI_SRCHQRY): ColumnTable SAP_FND:SMI_SRCHQRY not found (cannot get catalog object).

- CalculationNode (SMI_SRCHTERM): ColumnTable SAP_FND:SMI_SRCHTERM not found (cannot get catalog object).

<?xml version="1.0" encoding="UTF-8" standalone="no"?><cubeSchema defaultLanguage="EN" defaultSchema="_SYS_BIC" operation="createCalculationScenario" version="3"><calculationScenario name="sap.hba.fnd/SocialPostSearchTerms" schema="_SYS_BIC"><scenarioHints enforceSqlExecution="true"/><dataSources><tableDataSource name="SMI_SRCHQRY" schema="SAP_FND" table="SMI_SRCHQRY"><attributes><allAttribute /></attributes></tableDataSource><tableDataSource name="SMI_SRCHTERM" schema="SAP_FND" table="SMI_SRCHTERM"><attributes><allAttribute /></attributes></tableDataSource></dataSources><calculationViews><aggregation name="Aggregation_1" ><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="CLIENT" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SOCIALMEDIACHANNEL" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SOCIALPOSTSEARCHTERM" /></viewAttributes><keyfigures></keyfigures><inputs><input name="SMI_SRCHQRY"><mapping source="CLIENT" target="CLIENT"/><mapping source="SOCIALMEDIACHANNEL" target="SOCIALMEDIACHANNEL"/><mapping source="SOCIALPOSTSEARCHTERM" target="SOCIALPOSTSEARCHTERM"/></input></inputs></aggregation><join name="Join_1" type="inner" cardinality="n:1"><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="CLIENT" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SOCIALPOSTSEARCHTERM" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SOCIALPOSTSEARCHTERMTEXT" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SEARCHTERMISACTIVE" /></viewAttributes><inputs><input name="Aggregation_1"><mapping source="CLIENT" target="CLIENT"/><mapping source="SOCIALPOSTSEARCHTERM" target="SOCIALPOSTSEARCHTERM"/></input><input name="SMI_SRCHTERM"><mapping source="SOCIALPOSTSEARCHTERMTEXT" target="SOCIALPOSTSEARCHTERMTEXT"/><mapping source="SEARCHTERMISACTIVE" target="SEARCHTERMISACTIVE"/><mapping source="CLIENT" target="CLIENT"/><mapping source="SOCIALPOSTSEARCHTERM" target="SOCIALPOSTSEARCHTERM"/></input></inputs><joinAttributes><joinAttribute excludeFlag="false" name="CLIENT" /><joinAttribute excludeFlag="false" name="SOCIALPOSTSEARCHTERM" /></joinAttributes></join><projection name="Projection_1" ><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SAPClient"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SocialPostSearchTerm"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SocialPostSearchTermText"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SEARCHTERMISACTIVE"/></viewAttributes><inputs><input name="Join_1"  ><mapping source="CLIENT" target="SAPClient"/><mapping source="SOCIALPOSTSEARCHTERM" target="SocialPostSearchTerm"/><mapping source="SOCIALPOSTSEARCHTERMTEXT" target="SocialPostSearchTermText"/><mapping source="SEARCHTERMISACTIVE" target="SEARCHTERMISACTIVE"/></input></inputs><filter>&quot;SEARCHTERMISACTIVE&quot;!=&apos;X&apos;</filter></projection><projection name="finalProjection" defaultViewFlag="true"><inputs><input name="Projection_1"><mapping source="SAPClient" target="SAPClient"/><mapping source="SocialPostSearchTerm" target="SocialPostSearchTerm"/><mapping source="SocialPostSearchTermText" target="SocialPostSearchTermText"/></input></inputs><viewAttributes><viewAttribute name="SAPClient"/><viewAttribute name="SocialPostSearchTerm"/><viewAttribute name="SocialPostSearchTermText"/></viewAttributes></projection></calculationViews><variables><variable name="$$language$$" typeMask="512" isGlobal="true" usage="optional"/><variable name="$$client$$" typeMask="512" isGlobal="true" usage="optional"/></variables></calculationScenario></cubeSchema>

sap.hba.fnd.SocialPostSearchTerms : Model deployment started: sap.hba.fnd/SocialPostSearchTerms timestamp: 2014-12-13,10:28:35.880

sap.hba.fnd.SocialPostSearchTerms : Removing BIMC records for sap.hba.fnd/SocialPostSearchTerms timestamp: 2014-12-13,10:28:35.883

sap.hba.fnd.SocialPostSearchTerms : Removing hierarchy views for sap.hba.fnd/SocialPostSearchTerms timestamp: 2014-12-13,10:28:35.939

sap.hba.fnd.SocialPostSearchTerms : Start deployment of graphical calculation view, timestamp: 2014-12-13,10:28:36.130

sap.hba.fnd.SocialPostSearchTerms : Calculation Scenario XML: <?xml version="1.0" encoding="UTF-8" standalone="no"?><cubeSchema defaultLanguage="EN" defaultSchema="_SYS_BIC" operation="createCalculationScenario" version="3"><calculationScenario name="sap.hba.fnd/SocialPostSearchTerms" schema="_SYS_BIC"><scenarioHints enforceSqlExecution="true"/><dataSources><tableDataSource name="SMI_SRCHQRY" schema="SAP_FND" table="SMI_SRCHQRY"><attributes><allAttribute /></attributes></tableDataSource><tableDataSource name="SMI_SRCHTERM" schema="SAP_FND" table="SMI_SRCHTERM"><attributes><allAttribute /></attributes></tableDataSource></dataSources><calculationViews><aggregation name="Aggregation_1" ><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="CLIENT" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SOCIALMEDIACHANNEL" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SOCIALPOSTSEARCHTERM" /></viewAttributes><keyfigures></keyfigures><inputs><input name="SMI_SRCHQRY"><mapping source="CLIENT" target="CLIENT"/><mapping source="SOCIALMEDIACHANNEL" target="SOCIALMEDIACHANNEL"/><mapping source="SOCIALPOSTSEARCHTERM" target="SOCIALPOSTSEARCHTERM"/></input></inputs></aggregation><join name="Join_1" type="inner" cardinality="n:1"><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="CLIENT" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SOCIALPOSTSEARCHTERM" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SOCIALPOSTSEARCHTERMTEXT" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SEARCHTERMISACTIVE" /></viewAttributes><inputs><input name="Aggregation_1"><mapping source="CLIENT" target="CLIENT"/><mapping source="SOCIALPOSTSEARCHTERM" target="SOCIALPOSTSEARCHTERM"/></input><input name="SMI_SRCHTERM"><mapping source="SOCIALPOSTSEARCHTERMTEXT" target="SOCIALPOSTSEARCHTERMTEXT"/><mapping source="SEARCHTERMISACTIVE" target="SEARCHTERMISACTIVE"/><mapping source="CLIENT" target="CLIENT"/><mapping source="SOCIALPOSTSEARCHTERM" target="SOCIALPOSTSEARCHTERM"/></input></inputs><joinAttributes><joinAttribute excludeFlag="false" name="CLIENT" /><joinAttribute excludeFlag="false" name="SOCIALPOSTSEARCHTERM" /></joinAttributes></join><projection name="Projection_1" ><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SAPClient"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SocialPostSearchTerm"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SocialPostSearchTermText"/><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="SEARCHTERMISACTIVE"/></viewAttributes><inputs><input name="Join_1"  ><mapping source="CLIENT" target="SAPClient"/><mapping source="SOCIALPOSTSEARCHTERM" target="SocialPostSearchTerm"/><mapping source="SOCIALPOSTSEARCHTERMTEXT" target="SocialPostSearchTermText"/><mapping source="SEARCHTERMISACTIVE" target="SEARCHTERMISACTIVE"/></input></inputs><filter>&quot;SEARCHTERMISACTIVE&quot;!=&apos;X&apos;</filter></projection><projection name="finalProjection" defaultViewFlag="true"><inputs><input name="Projection_1"><mapping source="SAPClient" target="SAPClient"/><mapping source="SocialPostSearchTerm" target="SocialPostSearchTerm"/><mapping source="SocialPostSearchTermText" target="SocialPostSearchTermText"/></input></inputs><viewAttributes><viewAttribute name="SAPClient"/><viewAttribute name="SocialPostSearchTerm"/><viewAttribute name="SocialPostSearchTermText"/></viewAttributes></projection></calculationViews><variables><variable name="$$language$$" typeMask="512" isGlobal="true" usage="optional"/><variable name="$$client$$" typeMask="512" isGlobal="true" usage="optional"/></variables></calculationScenario></cubeSchema>

sap.hba.fnd.SocialPostSearchTerms : End deployment of graphical calculation view, timestamp: 2014-12-13,10:28:36.141

sap.hba.fnd.SocialPostSearchTerms : Model deployment ended: sap.hba.fnd/SocialPostSearchTerms timestamp: 2014-12-13,10:28:36.141

sap.hba.fnd.SrchTrmSntmntInSoclMdaChnl : Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Create Scenario failed:

ColumnTable SAP_FND:SMI_VOICE_CUST not found (cannot get catalog object)(CalculationNode (SMI_VOICE_CUST))

The following errors occured: Inconsistent calculation model (34011)

Details (Errors):

- CalculationNode (SMI_VOICE_CUST): ColumnTable SAP_FND:SMI_VOICE_CUST not found (cannot get catalog object).

- CalculationNode (SocialPostSearchTerms): ColumnView _SYS_BIC:sap.hba.fnd/SocialPostSearchTerms not found (cannot get catalog object).

- CalculationNode (SOCIALDATA): ColumnTable SAP_FND:SOCIALDATA not found (cannot get catalog object).

etc .......

I know I'm doing something wrong 😃 Do I need to set up an SLT or something?

Thank you.

greeting
niick

[Former Member]

Resolve the issue with help of SAP consultant.

first you need to make sure you have installed "51048865_SAP_SMART_BUSINESS_FOR_FND.ZIP" addon first to create "FND" under hba.

Issue is due to SCHEMA name mapping.

Go to hana studio -> Login with system user ->

and later go below path and first you need to add SAP_FND -> your schema name in

Window -> show view -> other -> search quick view ->

add SAP_FND -> your schema name

it will be red in your case and then just start from top and redeploy one by one.

and later import the HANA addon again it should complete successfully.

Regards,

Bond

[Former Member]

Hello James,

Thank you for this add.

Go to hana studio -> Login with system user ->

How add SAP_FND to my schema name

i go Window -> show view -> other -> search quick view ->

how add SAP_FND, i cannot find SAP_FND or My schema ??

i go ahead with your solution to install smart business FND first , but i cannot install smart business FND with HLM, i got a similar error 😞

but i can see fnd tree:

Question:

should i install FND add-on on ABAP stack before?

Thank you for your help

[Former Member]

any solution as of now????

[Former Member]

Hello,

no, we still waiting for SAP SUPPORT  

[Former Member]

Hello Nick,

do you solve fix the issue, we are facing the same problem.

Thank you in advance for your help