Clarity

Hi All,

We have upgraded to Clarity version 14.2 and CABI 3.3 SP5 from CA Clarity 12.1.3 and CABI 3.X. We have noticed none of our out of the box reports (available in CSP folder) are working.

As soon as we are changing data base configuration to our QA instance DB configuration, we are getting below error. This seems like some of the commands/variables/columns used in report are not available in DB OR we are no longer connecting to correct database.

This is default DB setting

and we changed it to

we have also validated the

1- ODBC 32 bit availability and DSN entry

2- Completed both the  OOTB Jobs "Create Business Object Users", "Update Business Object Reports Database Tables"

3- System option has setting for data warehouse options

4- We have also re-imported biar file 

5- we have also installed csk

We are still able to run previous out of the box reports which are outside of CSP folder. Also we have noticed that when we are opening the report in Crystal report 2008 and running the query manually based on attached word document suggested in  post.

How to get CSP reports SQL query using Crystal Report.docx 

then some of them are working fine like (Missing Timesheet) . 

However when running the report via crystal report design and connected to QA instance database manually not the way suggested in above mentioned post then it is throwing the error " The field name is unknown" and showing these formula's one after other

Is there something missing which needs to install as part of OOTB feature?

Thanks,

Shalinee

Hello Shalinee,

Can you check if you are missing out on any resource related access rights?

Suhail.

Suhail,

Access rights looks good. One more thing I have noticed that when I am running the report via CMC and using the below setting then it is not working. 

CMC is not allowing to run any report and below is the error message when trying to run the "Missing Timesheet" Report with the default setting.

However when I change optioned to use "Default table space as shown in next screen shot it is working fine. Also when I am running the report from Clarity using below setting, it is reverting back the setting to "Specify a custom table prefix" and there is no way to edit the box below and report failed.

Thanks,

Shalinee

Hello Shalinee,

Why don't you login using the original DB option? Why do you login using the custom DB option?

Suhail.

That is not editable to add the database name; It has to connect to Clarity 14.2 Database to get the CSK tables information. Default database is also not working. It gives the same error. It is working fine when we associated with custom database and "Default Table Prefix" via CMC only . As soon as with same setting you will try via Clarity Application, it will switch back the setting to "specify custom table prefix" and report will fail with above mentioned error.

Thanks.

Anyone has any suggestion to fix this issue.

Thanks in advance.

Shalinee.

Hello Shalinee,

Does this help? https://www.codeproject.com/Questions/216667/Crystal-Report-This-field-name-is-not-known-error 

Suhail.