Error while activating Analytical View..................

[Former Member]

Hi friends,

Error is coming while creating analytical view .

essage :

  Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:exception  1: no.8104014  (mdx/metadata/deployment/join/JoinManager.cpp:710)n    Logical join points to different physical tables in cube.nexception throw location:n 1: 0x00007ff05922efd3 in mdx::metadata::JoinManager::convertLogicalToPhysicalJoin(mdx::metadata::DMOLogicalJoin&, ltt::auto_ptr<mdx::metadata::DMOWrappedJoin>&, ptime::Connection*)+0xe30 at JoinManager.cpp:710 (libhdbmdx.so)n 2: 0x00007ff0592314a0 in mdx::metadata::JoinManager::generateJoinModelAnalyticView(ptime::Connection*)+0xe70 at auto_ptr.hpp:286 (libhdbmdx.so)n 3: 0x00007ff05922335e in mdx::metadata::DMOMeasureGroup::generate(mdx::metadata::DMOVariableCollection&, ptime::Connection*)+0x3a at DMOMeasureGroup.cpp:288 (libhdbmdx.so)n 4: 0x00007ff0592267b5 in mdx::metadata::DMOCube::generateOutput(mdx::metadata::XMLWriter*, ptime::Connection*, mdx::metadata::ModelCache const&)+0x4a1 at DMOCube.cpp:83 (libhdbmdx.so)n 5: 0x00007ff0592a5118 in mdx::metadata::ProcessCube::generateOutput(ltt::basic_string<char, ltt::char_traits<char> >&, ltt::basic_string<char, ltt::char_traits<char> >&, ltt::basic_string<char, ltt::char_traits<char> >&, ltt::basic_string<char, ltt::char_traits<char> >&, ptime::Connection*, mdx::metadata::ModelCache const&)+0x194 at ProcessCube.cpp:995 (libhdbmdx.so)n 6: 0x00007ff05928ea64 in mdx::metadata::DeployAnalyticView::endOfDimensions(mdx::metadata::ModelCache const&)+0x2c0 at DeployAnalyticView.cpp:214 (libhdbmdx.so)n 7: 0x00007ff0591edade 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> >&)+0x76a at deployModel.cpp:320 (libhdbmdx.so)n 8: 0x00007ff059139ddf in deploy_mdx_model+0xbb at handle_mdx.cpp:51 (libhdbmdx.so)n 9: 0x00007ff07e7dd578 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)+0x11f4 at biRuntime.cpp:285 (libhdbrepo.so)n10: 0x00007ff07e7e6874 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)n11: 0x00007ff07e6a008e in repo::Activator::activateObjectsInternalFast2(repo::AbstractSession*, ltt_adp::vector<repo::ObjectID, ltt::integral_constant<bool, true> > const&, repo::InactiveVersion const&, repo::ActivationMode, int&, ltt_adp::vector<Authorization::ObjectId, ltt::integral_constant<bool, true> >&, repo::ObjectDependenciesFacade&, ltt_adp::vector<repo::CheckResult, ltt::integral_constant<bool, true> >&)+0x110a at activator.cpp:687 (libhdbrepo.so)n12: 0x00007ff07e6a4898 in repo::Activator::activateObjects(repo::AbstractSession*, ltt_adp::vector<repo::ObjectID, ltt::integral_constant<bool, true> > const&, repo::InactiveVersion const&, repo::ActivationMode, bool, int&, repo::ObjectDependenciesFacade&, ltt_adp::vector<repo::CheckResult, ltt::integral_constant<bool, true> >&)+0x654 at activator.cpp:264 (libhdbrepo.so)n13: 0x00007ff07ec09991 in repo::Repository::activateObjectsInternal(repo::InactiveSession*, ltt_adp::vector<repo::ObjectID, ltt::integral_constant<bool, true> > const&, repo::ActivationMode, bool, int&, ltt_adp::vector<repo::CheckResult, ltt::integral_constant<bool, true> >&)+0x1d0 at repository.cpp:361 (libhdbrepo.so)n14: 0x00007ff07ec0d2e7 in repo::Repository::activateObjects(repo::InactiveSession*, ltt_adp::vector<repo::ObjectID, ltt::integral_constant<bool, true> > const&, repo::ActivationMode, int&, ltt_adp::vector<repo::CheckResult, ltt::integral_constant<bool, true> >&, bool)+0x583 at repository.cpp:275 (libhdbrepo.so)n15: 0x00007ff07ea1c992 in repo::ProtoHandler::dispatchCheckObjects(TRexUtils::JsonObject&, TRexUtils::JsonObject&, TRexUtils::JsonAllocator&, ltt_adp::basic_ostringstream<char, ltt::char_traits<char> >&)+0x410 at proto.cpp:3209 (libhdbrepo.so)n16: 0x00007ff07ea214fc 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&)+0x9c8 at proto.cpp:1069 (libhdbrepo.so)n17: 0x00007ff07ea250a4 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&)+0x2e0 at proto.cpp:818 (libhdbrepo.so)n18: 0x00007ff07ea2ad75 in repo::Transporter::handleV2()+0x6c1 at transport.cpp:244 (libhdbrepo.so)n19: 0x00007ff07ea2b358 in repo::Transporter::process()+0x194 at transport.cpp:37 (libhdbrepo.so)n20: 0x00007ff07ea2b491 in processRestMessage+0xb0 at transport.cpp:387 (libhdbrepo.so)n21: 0x00007ff05f2df8d1 in ptime::BuiltinProcedure_REPOSITORY_REST::execute(ptime::Env&) const+0x130 at dyn.h:71 (libhdbrskernel.so)n22: 0x00007ff05ec91144 in ptime::Proc_call::execute(ptime::Env&) const+0x290 at qe_proc_call.cc:160 (libhdbrskernel.so)n23: 0x00007ff05ec92525 in ptime::Proc_call::operator()(ptime::Env&) const+0x1e1 at qe_proc_call.cc:131 (libhdbrskernel.so)n24: 0x00007ff05f28efa1 in ptime::Query::_execute(ptime::Transaction&, ptime::Query::Plan*, ptime::Query::param_t*, ptime::Query::result_t*)+0x1c0 at query.cc:3695 (libhdbrskernel.so)n25: 0x00007ff05f2910ce in ptime::Query::execute(ptime::Transaction&, char const*, ptime::Query::param_t*, ptime::Query::Plan*, ptime::Query::result_t*, ptime::Statement*)+0x56a at query.cc:575 (libhdbrskernel.so)nn

[former_member208246]

Hi Mahesh

Even i face with the same issue when i activated Analytic view.

Have you got the solution for the issue which you have mentioned above?

Thanks and regards

Sanjay