'sqlOpenResult' status='-28' with UDA-SQL-0114

[raj_aries81]

Hi All,

I have a view built using columns from different tables. I could see the data when I execute select * from dbname.viewname on database. However, when I import the same view into FM, am getting sqlOpenResult status='-28' with UDA-SQL-0114 with 'Invalid date supplied for tablename.columnname' error.
I am not using this column in my report, but I assume that this column to be part of the view definition.

I don't understand why there is no error when select query is executed on database while Cognos FM  throws the error.

I am using FM 10.2.1, DB as Teradata.

Regards
Raj

[raj_aries81]

Hi All,

We found the root cause for this issue. Cognos is using ODBC driver to connect to the database and default year format for an ODBC conncetion is not 'yyyy' hence when the SUBSTR(CURRENT_DATE,1,4) is executed from an ODBC connection its giving an invalid date.

we used set session dateform=ansidate in the SQL code and its working fine in database using ODBC. However, I would like to understand if there is any option of enforcing this when a report is run from cognos.

Regards
Raj