hello
i have a problem with the date format
in QAS i have report with 2 columns only:
col1.date_test: cAST ('31-12-2999' AS DATE)
col2.year
the displayed result is :
CAST ('31-12-2999' AS DATE ) year
31-12-2999 2011
when i run exactly the same on PRD i receive the error:
message: ORA-01843: not a valid month at OCI call OCIStmtExecute.
obi version: 10.1.3.2.1 both QAS/PRD
db version: 10.2.0.5.0 both QAS/PRD
i checked the following and they are exatly the same in QAS and PRD: (checked via SQLPLUS)
NLS_Database_Parameters DD-MON-RR
v$nls_parameters DD-MON-RR
the repostiory is the same, as we just moved the one from QAS to PRD;
the cast_supported is checked (but i checked the NQSConfig.INI anyway, the settings are identical in both env)
im running out of ideas what else can i check to find out what is the difference in the setup that causes the above error;
i already followed the tips and checked what was possible but it looks fine;
http://gerardnico.com/wiki/dat/obiee/cast_as_date
id appreciate any tips;
thanks
rgds