Clarity

Expand all | Collapse all

Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

  • 1.  Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Posted 11-17-2015 08:10 AM


    Hi All,

     

    I am having following rights but the domains are not visible when i create an Ad-Hoc View.

     

    Advanced Reporting - Ad Hoc Create

    Advanced Reporting - Dashboard Create

    Advanced Reporting - Report Create

    Advanced Reporting - Navigate

    Advanced Reporting - Domain Create

     

    c2.JPG

     

    Navigation done : Advance Reporting > Ad Hoc Views > Create (Screenshot attached )

     

     

    After that i tried giving all the rights i.e. 'Advanced Reporting - Administer' & 'Advanced Reporting - Data Source Create' too and then navigated to same, now i can see the domains.

     

    c3.JPG

     

    Now in above i have selected the data sources as 'Resource Management'

     

    c4.JPG

    And in the next step selected Resource Name as selected fields.

     

    c5.JPG

     

    Now when i drag 'Resource Name' field to the Columns text box above i get this error everytime.

     

    the tomcat logs shows this error.

     

    2015-11-17 11:38:35,299 ERROR CustomTenantBuiltInParameterProvider,http-apr-8080-exec-8:338 -

    getProfileAttributes(User=superuser,tenant=null):Profile Level User(jasperadmin) specified could not be found in the tenant.

    2015-11-17 11:38:35,575 ERROR CustomTenantBuiltInParameterProvider,http-apr-8080-exec-8:338 -

    getProfileAttributes(User=superuser,tenant=null):Profile Level User(jasperadmin) specified could not be found in the tenant.

    2015-11-17 11:38:57,267 ERROR JaaSProxyJDBCPoolDataSourceFactory,http-apr-8080-exec-8:1204 -

    ::-Org.apache.jasper.JasperException: JaaSProxyJDBCPoolDataSourceFactory.createService(){Tenant=null,User=superuser}-

    Dynamic Proxy Data Source Pool can only be used at a Tenant Level context.

     

     

    Could anyone help please ?



  • 2.  Re: Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Broadcom Employee
    Posted 11-17-2015 08:22 AM

    Hi Anant,

     

    Are you doing this from CA PPM --> Advance reporting or Jasper console?



  • 3.  Re: Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Posted 11-17-2015 08:26 AM

    Advance Reporting, Please check for the steps which i have taken.



  • 4.  Re: Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Broadcom Employee
    Posted 11-17-2015 08:34 AM

    I assumed the same but wanted to check, the error says jasperadmin is not found which means the content is not uploaded correctly. can you delete the organization and reimport again.



  • 5.  Re: Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Posted 11-17-2015 08:51 AM

    Its still the same

    following the log from putty during the import

     


    Importing....
    Importing....
    Importing....
    Importing....
    Importing....
    Importing....
    SYS   17-11 14:44:40,680 - Successfully Created designer role :: ROLE_ADHOC_DESI                 GNER
    SYS   2015-11-17 14:44:40,680 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: ROLE_ADHOC_DESIGNER
    SYS   17-11 14:44:40,797 - Successfully Created designer role :: ROLE_REPORT_DES                 IGNER
    SYS   2015-11-17 14:44:40,797 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: ROLE_REPORT_DESIGNER
    SYS   17-11 14:44:40,906 - Successfully Created designer role :: ROLE_DATASOURCE                 _DESIGNER
    SYS   2015-11-17 14:44:40,906 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: ROLE_DATASOURCE_DESIGNER
    SYS   17-11 14:44:41,011 - Successfully Created designer role :: ROLE_DOMAIN_DES                 IGNER
    SYS   2015-11-17 14:44:41,011 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: ROLE_DOMAIN_DESIGNER
    SYS   17-11 14:44:41,120 - Successfully Created designer role :: ROLE_DASHBOARD_                 DESIGNER
    SYS   2015-11-17 14:44:41,120 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: ROLE_DASHBOARD_DESIGNER
    SYS   17-11 14:44:41,226 - Successfully Created designer role :: CSK_ROLE_FINANC                 IAL_MANAGEMENT
    SYS   2015-11-17 14:44:41,226 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: CSK_ROLE_FINANCIAL_MANAGEMENT
    SYS   17-11 14:44:41,350 - Successfully Created designer role :: CSK_ROLE_INVEST                 MENT_MANAGEMENT
    SYS   2015-11-17 14:44:41,350 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: CSK_ROLE_INVESTMENT_MANAGEMENT
    SYS   17-11 14:44:41,450 - Successfully Created designer role :: CSK_ROLE_PROGRA                 M_MANAGEMENT
    SYS   2015-11-17 14:44:41,450 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: CSK_ROLE_PROGRAM_MANAGEMENT
    SYS   17-11 14:44:41,559 - Successfully Created designer role :: CSK_ROLE_PROJEC                 T_MANAGEMENT
    SYS   2015-11-17 14:44:41,559 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: CSK_ROLE_PROJECT_MANAGEMENT
    SYS   17-11 14:44:41,663 - Successfully Created designer role :: CSK_ROLE_RESOUR                 CE_MANAGEMENT
    SYS   2015-11-17 14:44:41,663 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: CSK_ROLE_RESOURCE_MANAGEMENT
    SYS   17-11 14:44:41,775 - Successfully Created designer role :: CSK_ROLE_TIME_M                 ANAGEMENT
    SYS   2015-11-17 14:44:41,775 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: CSK_ROLE_TIME_MANAGEMENT
    SYS   17-11 14:44:41,879 - Successfully Created designer role :: CSK_ROLE_ADMINI                 STRATION
    SYS   2015-11-17 14:44:41,879 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: CSK_ROLE_ADMINISTRATION
    SYS   17-11 14:44:41,993 - Successfully Created designer role :: CSK_ROLE_APPLIC                 ATION_MANAGEMENT
    SYS   2015-11-17 14:44:41,993 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: CSK_ROLE_APPLICATION_MANAGEMENT
    SYS   17-11 14:44:42,111 - Successfully Created designer role :: CSK_ROLE_CUSTOM                 _MASTER_OBJECTS
    SYS   2015-11-17 14:44:42,111 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: CSK_ROLE_CUSTOM_MASTER_OBJECTS
    SYS   17-11 14:44:42,219 - Successfully Created designer role :: CSK_ROLE_IDEA_M                 ANAGEMENT
    SYS   2015-11-17 14:44:42,219 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: CSK_ROLE_IDEA_MANAGEMENT
    SYS   17-11 14:44:42,323 - Successfully Created designer role :: CSK_ROLE_ALL_RE                 PORTS_DOMAINS
    SYS   2015-11-17 14:44:42,323 [main] jasper.CSKDesignerRole Successfully Created                  designer role :: CSK_ROLE_ALL_REPORTS_DOMAINS
    Content imported
    Updating user profile attributes..
    Data Warehouse Bean DS URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXXXXXXXX)(PORT=1521))(CONNECT_DATA=(SID=XXXXX)(SERVER=dedicated)))
    PPM Bean DS URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXXXXXX)(PORT=1521))(CONNECT_DATA=(SID=******)(SERVER=dedicated)))
    Updating addition profile attributes..
    Updating the profile attribute ppmValidationQuery_enc
    Updating the profile attribute dwhValidationQuery_enc
    Updating Domains to have correct schema name...
    Processing domain...Application Management
    Processing domain...Custom Master Objects
    Processing domain...Financial Management
    Processing domain...Idea Management
    Processing domain...Investment Management
    Processing domain...Project Management
    Processing domain...Resource Management
    Processing domain...Time Management
    Importing themes..
    Preparing content to be deployed on  teliasonera using file /var/clarity/home/reporting/content/csk/jaspersoft/package/jaspersoft_themes.zip
    Importing prepared content.../tmp/jaasreports_2987740732387728282/export_5453310410276805696.zip
    Importing....
    Content imported
    User ppmjasperadmin not available in report server. Resource ppmjasperadmin not found. code:resource.not.found  parameter:["ppmjasperadmin"]
    Creation/updation process is started for PPM user ppmjasperadmin as ppmjasperadmin user in jasper server
    User ppmjasperadmin not available in report server. Resource ppmjasperadmin not found. code:resource.not.found  parameter:["ppmjasperadmin"]
    Creating the user ppmjasperadmin in report server
    Creating shared folder..
    Setting shared folder permissions..
    Setting theme permissions..
    Setting global permissions..
    Importing content completed..



  • 6.  Re: Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Broadcom Employee
    Posted 11-17-2015 09:24 AM

    So if i understand correctly you deleted the organization and reimported the same and generated the keystore and you still have the error. Then please raise a support case and we will work with you



  • 7.  Re: Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Posted 11-18-2015 08:25 AM

    we checked the tomcat logs for jaspersoft server and getting below this error, it's looking like schema issue Jaspersoftserver is not supporting the DWH for clarity 14.3

     

    see the logs -

     

    we ran the query for 'DWH_RES_SECURITY_V' view  and found that 'USER_ID' column doesn't exists in the view.

     

    select * from ( select "DWH_RES_RESOURCE"."RESOURCE_NAME" as "DWH_RES_RESOURCE_RESOURCE_NAME"
    from "PPM_DWH"."DWH_RES_RESOURCE" "DWH_RES_RESOURCE"
    inner join "PPM_DWH"."DWH_RES_SECURITY_V" "DWH_RES_SECURITY_V" on ("DWH_RES_RESOURCE"."RESOURCE_KEY" = "DWH_RES_SECURITY_V"."RESOURCE_KEY")
    where ("DWH_RES_SECURITY_V"."USER_UID" = 'scc0785')
    group by "DWH_RES_RESOURCE"."RESOURCE_NAME"
    order by "DWH_RES_RESOURCE_RESOURCE_NAME"
    ) where ROWNUM <= 1000

    at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:432)
    at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:219)
    ... 135 more
    Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: null.
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267)
    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)
    at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:156)
    ... 1 more
    Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "DWH_RES_SECURITY_V"."USER_UID": ogiltig identifierare



  • 8.  Re: Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Broadcom Employee
    Posted 11-18-2015 08:34 AM

    It looks like you have some issue with DWH schema, i just queried and I can see USER_ID. So you can drop your DWH schema and reimport from the ISO file where template is provided.

     



  • 9.  Re: Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Posted 11-18-2015 08:41 AM

    Thanks

     

    Can you please let me know the high level steps for this, i have the steps with me just wanted to no i am doing right



  • 10.  Re: Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Broadcom Employee
    Posted 11-18-2015 09:13 AM

    Here are the steps

     

    1. Drop the DWH schema

    2. Import the DWH schema from ISO

    3. Ensure DB link is set up

    4. Run the datawarehouse jobs.



  • 11.  Re: Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Posted 11-19-2015 03:59 AM

    thanks, now we are able to create ad-hoc views

     

    But the domain is still not visible to the users which have the following rights

     

    Advanced Reporting - Ad Hoc Create

    Advanced Reporting - Dashboard Create

    Advanced Reporting - Report Create

    Advanced Reporting - Navigate

     

    We checked the user and roles permission over domain in repository and following is the observation -

     

    Role 'ROLE_ADHOC_DESIGNER' is having 'Read Only*' rights over the domain.

     

    untitled.bmp

     

    User is having the role i.e. 'ROLE_ADHOC_DESIGNER'

    c3.JPG

     

    But still the user is not having 'Read Only*'   rights.

     

    Also why there is two roles in above screenshot i.e. ''ROLE_ADHOC_DESIGNER' this also same for report designer and all others.

    this is same with all other aslos like dashboard, domain , datasource and not same for CSK* ones and ADMINS.

    c2.JPG

     

    please help.



  • 12.  Re: Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Broadcom Employee
    Posted 11-19-2015 04:10 AM

    Hi Anant,

     

    I believe I request for a case before where it needs deeper analysis, but it looks like you are hitting a bug where until you give Advanced Reporting - Administrator, you dont see the domain/reports. So try the workaround

     

    1. Log directly into Jaspersoft UI with the superuser account

    2. In the Toolbar -> select "View" -> "Repository"

    3. Then expand root -> <your organization name> -> CA PPM -> Then Right-Click on the "Reports" Folder and select "Permissions"

    4. Scroll down and find the role of "ROLE_USER"

    5. The role has "No Access" to this folder -> Give that role "Read Only"

    6. When logging into CA Clarity PPM and choosing "Advance Reporting" - users with only the access right of "Advanced Reporting - Navigate" can see and run reports

     

    Hope this helps

     

    Regards

    Suman Pramanik



  • 13.  Re: Domain not visible while creating Ad-Hoc view in Advance Reporting (Clarity 14.3)

    Posted 01-28-2016 07:41 PM

    I just tested this and if a user cannot see the domains via "Create Adhoc View", you need to give "Role_User" read only rights to the domain (which makes sense).

     

    Your workaround above looks to be from defect CLRT-79026 JasperSoft Content Doesn't import Repository with correct permissions, Advance Reporting - Navigate right does not allow to see/run reports

     

    I opened a support case to mention my findings above.  I am guessing it is the same defect, and you may want to append this information to it.  I will let support decide that.

     

    Thanks,

    Neil