connection error

building reports desktopintelligence
1

HI,

When I try to create a report on DB2 I am getting the following error statement from bussiness Objects 5.1.4

Connection or SQL Sentence error DA0005
[StarSQL][StarSQL ODBC Driver]invalid cursor state 0

is it a problem with the ODBC Driver. I am using 4.10. But it’s working fine with 4.01 version.

If anyone know about this let me know that how to overcome with this type of problem.

Thanks

peacock (BOB member since 2002-11-07)

2

I would assume the answer is Yes it is a problem with the ODBC drivers, I can’t provide a lot of details but I do vaguely remember an ODBC issue when installing a newer version of BO(5.1.2), on some older PC’s in our training room. I remember obtaining 2 different odbc dll’s (init and 32 I think) from our pc techs, installing these files resolved our problems. Moral to my story - I believe there can be BO/ODBC compatibility issues. - good luck

jswoboda :us: (BOB member since 2002-06-20)

3

I am getting this error when ever I use prompts Or conditions. That too in starsql driver version 4.10

peacock (BOB member since 2002-11-07)

4

This is what Tech support says

Follow these steps to reproduce the issue:

  1. In the regional settings, set the decimal separator to a comma (",") and the group separator to a period (".").
  2. In the query panel, select a measure object containing decimals and apply the following condition on the object:
    “Greater than or equal to” <value from list of values (data displayed with comma as decimal separator)>
  3. Go to View SQL. The inserted value is displayed as “123,45”.
  4. Run the query and you receive error “Error DA0003” or “Error DA0005”.

CAUSE****
BusinessObjects only appears to accept a period (".") as a decimal separator for measures within the generated SQL.

This issue has been logged as a bug (# 1050451).

****RESOLUTION
There are two workarounds:

  1. Enter the value for the prompt manually; do not select a value from the LOV via “Show List of Values”.
    or
  2. Change the decimal separator in the Regional Settings from a comma (",") to a period (".").

Good Luck

gowthaman (BOB member since 2002-08-15)

5

Hi there!

I’m having kind of similar problem. One of our users got “Invalid cursor state” -error message, while running reports with prompts. And yes, he must use prompts because of scheduling.

If I open free-SQL window in query panel, I see an empty line between “FROM table1, table2” and “WHERE” -clause in this report. When I manually delete this empty line the query usually works. Then I can re-run the query also WITH the empty line. But always when I reconnect to BO it doesn’t work with empty-line. I’m still not sure if this line causes the error… Does anyone know what’s going on or how to modify BO so that there is no emptyline? In other reports there is no empty line…

Another question: Is it possible to configure BO so that only some users are allowed to e-mail schuduled reports and others can only schedule to inbox etc.??

Thanks a lot for help beforehand! :smiley:

MastahYoda (BOB member since 2008-05-29)