Skip to Content
0
D Q
Jan 12, 2012 at 09:56 PM

GetLov failed A connection required to refresh this document is unavailable

85 Views

Hi,

We are currently experiencing issues while trying to refresh report data from Designer, the following error message is obtained:

"GetLov failed: A connection required to refresh this document is unavailable (DA0004)".

Our BOE version is XI 3.1 and its CMC DB is MySQL running on a Linux server. The datasource DB where the designer is trying to refresh the data from is an MaxDB db running in the same BOE server.

After reviewing the logs we were able to identify the following error message from the :boe_fcprocd_30907_2012_01_12_17_58_29_789_trace.log" log file:

SQLNet::CreateConnectionObject :CS, DBDriver failed to load : /usr/sap/BD1/bobje/enterprise120/linux_x86/dataAccess/RDBMS/connectionServer/libdbd_ddodbc.so (libodbc.so: cannot open shared object file: No such file or directory).

Even when is not exactly our scenario, we've followed directions from note "1549355 - Configure GreenPlum (PostgreSQL) ODBC on Linux " but with no luck. Bellow the steps from that were performed:

Resolution

1-Modify the ~/.bash_profile, and add the following entries:

export BOBJEDIR=/opt/boxi31/bobje/

export ODBC_HOME=$BOBJEDIR/enterprise120/linux_x86/odbc

export ODBCINI=$BOBJEDIR/odbc.ini

export LD_LIBRARY_PATH=/usr/local/lib:/usr/lib:$BOBJEDIR/enterprise120/linux_x86/odbc/lib:$BOBJEDIR/enterprise120/linux_x86/dataAccess/RDBMS/connectionServer

2 -Modify the $BOBJEDIR/setup/env.sh and appended the following to LIBRARYPATH:

:$enterprise120/$SOFTWAREPATH/odbc/lib:$MWHOME/lib-linux_optimized:$enterprise120/$SOFTWAREPATH/dataAccess/RDBMS/connectionServer

Also, a new entry on the odbc.ini file was added described in guide "ODBC Manual: SAP DB":

[<data_source_name>] ServerDB=<database_name> ServerNode=<name_of_database_server> SQLMode=<INTERNAL|DB2|ANSI|ORACLE> IsolationLevel=<Uncommitted|Committed|Repeatable|Serializable> TraceFileName=<trace_file_path_and_name>

All the above mentioned didn't solved the issue.

It worth to mention that the connection type the Universe is using has been created as "Generic ODBC DataSource". After reviewing the Connection Server (in CMC) metrics, it was noticed that the Generic ODBC datasource has a "failed status".

Could that be the cause of this issue? If so...How should I activate Generic ODBC datasource in order to have it in a Loaded state?

If the above mentioned is not the cause of our error, what else should I check?

My last question....Is MaxDB/SapDB supported as DataSource?

Your help is highly appreciated.

Thanks and best regards