Print Page - Errors while running report

Title: Errors while running report
Post by: niahanth on 21 Jan 2016 02:32:59 PM

Hi

I am getting the following errors while running a report.

1) Data source adapter error: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long

2)SQL cannot be generated, because the filter condition [Presentation Layer].[EmpName_DP].[EMPR_NM] = ?PEmpName? could not be applied to the following fact stream which does not contain a fact projection: (EMPLOYER_NAME1).

Can anyone tell me whats the reason for the following errors.

Thanks

Title: Re: Errors while running report
Post by: BigChris on 22 Jan 2016 02:00:18 AM

Looks like an Oracle error:

http://www.dba-oracle.com/sf_ora_00972_identifier_is_too_long.htm (http://www.dba-oracle.com/sf_ora_00972_identifier_is_too_long.htm)
http://www.techonthenet.com/oracle/errors/ora00972.php (http://www.techonthenet.com/oracle/errors/ora00972.php)
http://stackoverflow.com/questions/3085562/ora-00972-identifier-is-too-long-alias-column-name (http://stackoverflow.com/questions/3085562/ora-00972-identifier-is-too-long-alias-column-name)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: niahanth on 21 Jan 2016 02:32:59 PM