Issue while redeploying a calculation view

[former_member212706]

Dear Experts,

     We had created a calculation view a while back. Now the HANA is on revision 52. But it has gone through 2 upgrades since the calculation view was created. Now when i try to preview the data in calculation view i get a message stating

"Error:The model is not activated properly.BIMC table contains no metadataof the table. Try re-deploying it"

When we try to redeploy the calculation view we are getting an error stating

Message :

Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Deploy Calculation View: failed, schema does not exist: SAP_ERP

Please help us in resolving the issue also let us know what was the reason behind the issue.

Thanks in advance!!!

Regards,

Rajesh.

[former_member184768 · Accepted solution]

Hi Rajesh,

I am sure you would have done the primary investigation on this issue. But still, can you please try the following to check if the Calc view does exist and related to SAP_ERP and also check if the schema exists.

I am sure you would have checked all the objects included in the Calc view and all the dependent objects like Analytic views, Attribute views, base tables etc.

SELECT * FROM "_SYS_BI"."BIMC_ALL_CUBES"

WHERE "CUBE_NAME" like '%<your calc view technical name>%'

select * from schemas where SCHEMA_NAME like %'SAP_ERP%';

Regards,

Ravi

[former_member212706 · Accepted solution]

Dear Ravi,

First of all, Thanks a lot for your timely help.

The schema actually doesnt exist. But when i look at the schema mapping, one of the physical schema has authoring schema as "sap_erp"

select * from schemas where SCHEMA_NAME like 'SAP_ERP';

returns me 0 rows.

And

SELECT * FROM "_SYS_BI"."BIMC_ALL_CUBES"

WHERE "CUBE_NAME" like 'CLV_TEST'

also returns 0 rows

I tried to check if i could redeploy the associated attr and anlytic views. To my surprise i wasnt able to redeploy an attribute view named "AT_TIME" which is of type "TIME". It uses '_SYS_BI.M_TIME_DIMENSION' as its data foundation . When i tried to redeploy it i get an error stating

Message :

Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:exception 1: no.1000014 (mdx/metadata/deployment/ProcessModel.cpp:592)n Table VBAP does not exist in schema SAP_ERPnexception throw location:n 1: 0x00007f78f80cb4e1 in mdx::metadata::ProcessModel::createPDFTableProxies(mdx::metadata::ProcessModel::XMLTree*)+0x17b0 at ProcessModel.cpp:592 (libhdbmdx.so)n 2: 0x00007f78f80cbbc8 in mdx::metadata::ProcessModel::createPrivateDataFoundation(mdx::metadata::ProcessModel::XMLTree*)+0xa4 at ProcessModel.cpp:530 (libhdbmdx.so)n 3: 0x00007f78f80d79b8 in mdx::metadata::ProcessCube::createModel(mdx::metadata::ProcessModel::XMLTree*)+0x194 at ProcessCube.cpp:86 (libhdbmdx.so)n 4: 0x00007f78f80d7c55 in mdx::metadata::ProcessCube::process()+0x11 at ProcessCube.cpp:54 (libhdbmdx.so)n 5: 0x00007f78f80c3fe8 in mdx::metadata::ProcessModel::endDocument()+0x114 at ProcessModel.cpp:173 (libhdbmdx.so)n 6: 0x00007f78f80b6ca5 in mdx::metadata::DeployAnalyticView::endDocument()+0xd1 at DeployAnalyticView.cpp:120 (libhdbmdx.so)n 7: 0x00007f7914ecea9e in expat_impl::parseStr(ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> > const&)+0x22a at saxexpat.cpp:225 (libhdbbasement.so)n 8: 0x00007f78f8011619 in mdx::metadata::DeployModel::processXML(ltt::basic_string<char, ltt::char_traits<char> >&)+0xb5 at deployModel.cpp:2440 (libhdbmdx.so)n 9: 0x00007f78f80205e2 in mdx::metadata::DeployModel::deploy(ltt::basic_string<char, ltt::char_traits<char> >&, ltt::vector<mdx::CreatedItemStructure>&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> >&)+0x470 at deployModel.cpp:143 (libhdbmdx.so)n10: 0x00007f78f7f9c552 in deploy_mdx_model+0xc0 at handle_mdx.cpp:60 (libhdbmdx.so)n11: 0x00007f791980b95e in repo::biRuntime::generate(repo::ActiveSession*, int, ltt_adp::vector<repo::ObjectID, ltt::integral_constant<bool, true> > const&, bool, ltt_adp::vector<Authorization::ObjectId, ltt::integral_constant<bool, true> >&, bool)+0x1baa at biRuntime.cpp:359 (libhdbrepo.so)n12: 0x00007f7919813374 in repo::colviews::generate(repo::ActiveSession*, int, ltt_adp::vector<repo::ObjectID, ltt::integral_constant<bool, true> > const&, bool, ltt_adp::vector<Authorization::ObjectId, ltt::integral_constant<bool, true> >&, bool)+0xd0 at colviews.cpp:21 (libhdbrepo.so)n13: 0x00007f79196ec06f in repo::Activator::revalidateObjectsInternal(repo::ActiveSession*, repo::ObjectDependenciesFacade const&, int&, ltt_adp::vector<Authorization::ObjectId, ltt::integral_constant<bool, true> >&)+0x33b at activator.cpp:907 (libhdbrepo.so)n14: 0x00007f79196edc3e in repo::Activator::revalidateObjects(repo::ActiveSession*, ltt_adp::vector<repo::ObjectID, ltt::integral_constant<bool, true> > const&, int&)+0x64a at activator.cpp:827 (libhdbrepo.so)n15: 0x00007f7919ba6f3b in repo::Repository::revalidateObjects(repo::ActiveSession*, ltt_adp::vector<repo::ObjectID, ltt::integral_constant<bool, true> > const&, bool, int&)+0x4c7 at repository.cpp:426 (libhdbrepo.so)n16: 0x00007f79199f03de in repo::ProtoHandler::dispatchRevalidateObjects(ltt_adp::map<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, TRexUtils::TypedJson, ltt::less<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> > >, ltt::integral_constant<bool, true> >&, ltt_adp::map<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, TRexUtils::TypedJson, ltt::less<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> > >, ltt::integral_constant<bool, true> >&, TRexUtils::JsonAllocator&, ltt_adp::basic_ostringstream<char, ltt::char_traits<char> >&)+0x1ba at proto.cpp:3322 (libhdbrepo.so)n17: 0x00007f7919a060c1 in repo::ProtoHandler::_dispatch(ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> > const&, ltt_adp::basic_ostringstream<char, ltt::char_traits<char> >&, bool&)+0xd90 at proto.cpp:1142 (libhdbrepo.so)n18: 0x00007f7919a098bf in repo::ProtoHandler::dispatch(ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> > const&, ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >&, bool&)+0x2bb at proto.cpp:854 (libhdbrepo.so)n19: 0x00007f7919a0d92d in repo::Transporter::handleV2()+0x399 at transport.cpp:244 (libhdbrepo.so)n20: 0x00007f7919a0ebf8 in repo::Transporter::process()+0x194 at transport.cpp:37 (libhdbrepo.so)n21: 0x00007f7919a0ed31 in processRestMessage+0xb0 at transport.cpp:387 (libhdbrepo.so)n22: 0x00007f78fd3c3ff1 in ptime::BuiltinProcedure_REPOSITORY_REST::execute(ptime::Env&) const+0x170 at dyn.h:71 (libhdbrskernel.so)n23: 0x00007f78fce4f1fb in ptime::Proc_call::execute(ptime::Env&) const+0x97 at qe_proc_call.cc:70 (libhdbrskernel.so)n24: 0x00007f78fce4f064 in ptime::Proc_call::operator()(ptime::Env&) const+0x110 at qe_proc_call.cc:40 (libhdbrskernel.so)nn"

Though i couldnt get much reg the error the statement "Table VBAP does not exist in schema SAP_ERP" provoked me to look for such table. And i find that it is available in a physical schema whose authoring schema is "SAP_ERP" which i saw in the schema mapping.

Couldnt proceed further. Please help here.

Thanks,

Rajesh.

[former_member184768 · Accepted solution]

Hi Rajesh,

Can you please check the following thread which discusses the schema mapping in details. Your issue could be related to the import - export and a correct schema should be mapped to resolve the issue.

http://scn.sap.com/thread/3281388

You may want to remove the mapping if you think that it is not required.

Regards,

Ravi

[former_member212706 · Accepted solution]

Dear Ravi,

I am still facing this issue.Is this issue realted to the HANA upgrade?

Thanks,

Rajesh.

[former_member184768 · Accepted solution]

Hi Rajesh,

I tried to check if i could redeploy the associated attr and anlytic views. To my surprise i wasnt able to redeploy an attribute view named "AT_TIME" which is of type "TIME". It uses '_SYS_BI.M_TIME_DIMENSION' as its data foundation . When i tried to redeploy it i get an error stating

The Time Dimension is not dependent on the VBAP, but it seems AT_TIME is being used in some Analytic view which might be referring to VBAP table. Please check the dependencies and try to activate the dependent objects.

You can refer to Extended Where used functionality to find all the dependent objects for AT_VIEW.

Regards,

Ravi