SAP Knowledge Base Article - Preview

1679587 - DBS 070401 Function sequence error while using lookup function with preload cache option in Unix Data Services 4.0


  • A simple job that does a simple lookup fails
  • Error like: ODBC data source <...> error message for operation <SQLExecute>: <[DataDirect][ODBC lib] Function sequence error>.
    (14.0) 01-23-12 13:31:39 (E) (249906:8996) RUN-050304: |Session <...Job>|Data flow lookupProduct|Transform
  • The first call to a lookup_ext where the cache type is NO_CACHE works.
  • Subsequent calls fail with the “Function Sequence Error” from ODBC.




  • Unix/Linux
  • DB2 9.x


SAP Data Services 4.0


DBS-070401, RUN-050304, RUN-053008, The above error occurs in the context... , KBA , EIM-DS , Data Services , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.