Error when creating pivot or table view in Visual analyzer 12.2.1.2 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Error when creating pivot or table view in Visual analyzer 12.2.1.2

Received Response
1
Views
2
Comments
sandy45252
sandy45252 Rank 3 - Community Apprentice

Hi ,

We have installated clusted obiee environment with visual analyzer in it.

When we try to create a project with pivot or table view by selecting any field from subject area .Getting an error "A general error occurred, please contact system administrator".

With blank view and when i check the biserver log found below error

[2017-02-27T08:26:16.597+00:00] [bi_server1] [ERROR] [] [oracle.bi.tech.services.clienterror.resources.ErrorResource] [tid: [ACTIVE].ExecuteThread: '24' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 30f5f20a-a1f6-4c37-bf64-78cf5b85ce68-000337ff,0] [APP: bitech-analysis-application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000Ldycf7w7EC2_Rpt1id1OYgF800000I] [SI-Key: biservice] ERROR: Handling BIPS view html request failed.: saw is not defined[[

mozilla/5.0 (windows nt 6.1; wow64) applewebkit/537.36 (khtml, like gecko) chrome/56.0.2924.87 safari/537.36

ECID: undefined

1. Added Data Source "Sample"

2. Created Pivot from [Region Metro]. Source: Double-Click Data Element

3. <Current State>

ReportXML: <saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201201160"><saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;Sample&quot;"><saw:columns><saw:column columnID="IBXMetro" xsi:type="saw:regularColumn"><saw:columnFormula><sawx:expr xsi:type="sawx:sqlExpression">"Sample"."IBX"."IBX Metro"</sawx:expr></saw:columnFormula></saw:column></saw:columns><saw:criteriaConfig>{"_version":"1.0.0","settings":{}}</saw:criteriaConfig></saw:criteria><saw:datasources><saw:datasource subjectArea="&quot;Sample&quot;"/></saw:datasources><saw:layouts><saw:layout name="layout2" layoutType="oracle.bi.tech.layout.split"><saw:layoutCell left="0" top="0" zIndex="1"><saw:cellContent viewName="view!1" type="view"/><saw:displayFormat><saw:formatSpec width="1093px" height="621px"/></saw:displayFormat></saw:layoutCell></saw:layout></saw:layouts><saw:views currentView="0"><saw:view xsi:type="saw:canvas" name="canvas!1"><saw:layoutRef name="layout2"/></saw:view><saw:view xsi:type="saw:pluginView" pluginType="oracle.bi.tech.pivot" name="view!1" physicalDataModelVersion="2.2"><saw:dataModels><saw:dataModel name="dm1"><saw:logicalDataModel>{"_version":"1.0.0","settings":{"logicalDataModel":{"logicalEdges":{"row":{"logicalEdgeLayers":[{"columnID":"IBXMetro","type":"column","isUsed":true}]},"col":{"logicalEdgeLayers":[{"type":"measure","visibility":"visible","userAdded":false,"isUsed":true}]}},"_settingsVersion":"1.0.0"},"ldm_generation":1}}</saw:logicalDataModel><saw:edges><saw:edge axis="row" showColumnHeader="rollover"><saw:edgeLayers><saw:edgeLayer columnID="IBXMetro" type="column"/></saw:edgeLayers></saw:edge><saw:edge axis="column" showColumnHeader="rollover" dependent="true"><saw:edgeLayers/></saw:edge><saw:edge axis="page"/><saw:edge axis="section"/></saw:edges></saw:dataModel></saw:dataModels><saw:viewConfig>{"_version":"1.0.1","settings":{}}</saw:viewConfig></saw:view></saw:views><saw:reportConfig>{"_version":"1.0.0","settings":{"oracle.bi.tech.colorSchemeService":{"_version":"1.0.0","settings":{"version":"1.0.1","generation":0,"colorDomains":{}}}}}</saw:reportConfig></saw:report>

ERROR: Handling BIPS view html request failed.: saw is not defined

ReferenceError: saw is not defined

    at Q.fetchHtml (http://obiee12c/va/api/v1/plugins/resource/viz/1.0.0.bd737fb/viz.js:258:72)

    at F._submitBipsVizHtmlFetchRequest (http://obiee12c/va/api/v1/plugins/resource/viz/1.0.0.bd737fb/viz.js:250:197)

    at n.exec (http://obiee12c/va/api/v1/plugins/resource/application/1.0.0.05edebf/application.js:47:375)

    at http://obiee12c/va/api/v1/plugins/resource/viz/1.0.0.bd737fb/viz.js:247:303

    at Object.execCb (http://obiee12c/va/api/v1/plugins/resource/oracle-jet/2.0.1.5f0f82d/require.js:29:365)

    at Z.check (http://obiee12c/va/api/v1/plugins/resource/oracle-jet/2.0.1.5f0f82d/require.js:18:423)

    at Z.<anonymous> (http://obiee12c/va/api/v1/plugins/resource/oracle-jet/2.0.1.5f0f82d/require.js:23:9)

    at http://obiee12c/va/api/v1/plugins/resource/oracle-jet/2.0.1.5f0f82d/require.js:8:102

    at http://obiee12c/va/api/v1/plugins/resource/oracle-jet/2.0.1.5f0f82d/require.js:23:442

    at v (http://obiee12c/va/api/v1/plugins/resource/oracle-jet/2.0.1.5f0f82d/require.js:7:173)

    at Z.emit (http://obiee12c/va/api/v1/plugins/resource/oracle-jet/2.0.1.5f0f82d/require.js:23:413)

]]

And this issue is not appearing in other views of VA.

If you have any solution please respond.

Thanks,

Sandy

Answers

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    Check the Doc ID 2082593.1 it's talking about a similar problem.

    It may help you

  • sandy45252
    sandy45252 Rank 3 - Community Apprentice

    Hi Ftisiot,

    Thanks for your quick response.

    I have tried the solution provided in the Doc ID 2082593.1 . But no use still facing the issue and this issue is not related to "failed.: Script error for: ImportMeFirst".

    Here we are facing completely different error .

    Thanks,

    Sandy