BusinessObjects Board

Lookup_ext issue with SQL Server DATE datatype

dataservices performance
#1

Hello Everyone,

It seems like there is an issue with Lookup_ext when looking up on a SQL Server table and using a column with DATE datatype in the comparison. If we use NO_CACHE or DEMAND_LOAD_CACHE and validate the dataflow, we see the below error message.

[i][Function Call:lookup_ext]
NRDM Function <Cannot parse expression.

Use PRE_LOAD_CACHE option in lookup function when a compare column contains unsupported data type … (BODI-1112351)> (BODI-1111191)[/i]

Is this a bug? I know there was a similar issue with the Table comparison but I guess it was fixed.

Source: Oracle 11g
BODS Version: 14.1.1.392 (4.1 SP1 Patch 4)
Target: SQL Server 2012
Job Server: Windows 2008 R2

reddevilme (BOB member since 2013-08-27)

#2

There is a workaround for this issue if PRE_LOAD_CACHE can’t be used in the lookup.

We did not see this validation error when we used a datastore with an ODBC connection.

:? :?

reddevilme (BOB member since 2013-08-27)