BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Lookup_ext issue with SQL Server DATE datatype


 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
reddevilme
Senior Member
Senior Member



Joined: 26 Aug 2013

Posts: 37
Location: New Jersey



PostPosted: Mon Feb 08, 2016 11:38 am 
Post subject: Lookup_ext issue with SQL Server DATE datatype

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.

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

Use PRE_LOAD_CACHE option in lookup function when a compare column <XYZ> contains unsupported data type <DATE>.. (BODI-1112351)> (BODI-1111191)


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
Back to top
reddevilme
Senior Member
Senior Member



Joined: 26 Aug 2013

Posts: 37
Location: New Jersey



PostPosted: Tue Feb 09, 2016 3:39 pm 
Post subject: Re: Lookup_ext issue with SQL Server DATE datatype

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.

icon_confused.gif icon_confused.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0318 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0282)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo