SAP Knowledge Base Article - Preview

2198129 - BI4.1: In a WebI report and error is generated: "ORA-01843: not a valid month" when filtering on a Date with Oracle ODBC connection

Symptom

  • When running a WebI report, with filter on date, ORA-01843: not a valid month error appears.
  • Issue is only reproducible with Oracle ODBC connection and works fine with Oracle Native Client connection.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.1.
  • Web Intelligence
  • Oracle 11G R2

 

Product

SAP BusinessObjects Business Intelligence platform 4.1

Keywords

ODBC, Client, Oracle, ORA, 01843, Month, UDT, IDT, connection, webi, mismatch, month, altersession, connectinit, parameter,date, issue, timestamp, MON, MMM, YY, Native, webintelligence , KBA , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.