We have certain list reports which are being run in PDF. The error we encounter is that, sometimes the reports run without any error and sometimes it suddenly throws run time error: [NRC][ODBC Teradata Driver] Only one active statement allowed per connection.
I tried searching for this in cognos support site but cudnt get any results :( We are using Cognos 8.2 and the underlying database is Teradata. Please share some information regarding this error so that we can make sure it doesnt happen in the future. And please let me know what other information you might need to resolve this issue. Thanks in advance.
hmm does anyone know a solution for this?
The driver message indicates that the ODBC connection is still busy retrieving data from the previous fetch command. I'd say this is more a teradata issue than a Cognos one. Can you communicate this with your teradata DBA?