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

[Anon Anon]

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

 

 

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.

 

 

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

 

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

 

 

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 ?

[Suman Pramanik]

Hi Anant,

 

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

[Anon Anon]

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

[Suman Pramanik]

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.

[Anon Anon]

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..

[Suman Pramanik]

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

[Anon Anon]

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

[Suman Pramanik]

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.

 

[Anon Anon]

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

[Suman Pramanik]

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.

[Anon Anon]

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.

 

 

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

 

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.

 

please help.

[Suman Pramanik]

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

[Neil Goodwin]

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