Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: SQL Lookup doesn't work anymore

SQL Lookup doesn't work anymore 5 months 2 weeks ago #18872

Hi
I use SQL lookup object in a Transformation. The Transformation was working in the past, but not used very often, so I don't know in which release the Change happened. I updated today to Version 6.3.4.4 an still have the Problem.
The SQL lookup should return the number of records. Running in a package it does not work. Running in preview mode ("process data") it works sometimes.
Test Scenario, see also the attached printscreens:
1. open Validation in the Transformation an press "process data" --> no data
2a. double-click on the SQL lookup object and only pressing ok --> result is there OR..
2b. sometimes I have to Change the selected data record an it works also OR...
2c. uncheck and press again the "process data" icon

The SQL lookup is in a mysql table, I tried 2 different mysql Versions (older and newer), both are concerned.
I also tried to replace the Parameter1 '66' directly in the SQL Statement (in single quotes) --> no data.

Lionel





Attachments:

Please Log in or Create an account to join the conversation.

SQL Lookup doesn't work anymore 5 months 2 weeks ago #18873

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7544
  • Karma: 33
  • Thank you received: 412
We will have a look at it for you
Mike

Please Log in or Create an account to join the conversation.

SQL Lookup doesn't work anymore 5 months 2 weeks ago #18884

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7544
  • Karma: 33
  • Thank you received: 412
Hi

Works fine here.

Can you post a screenshot similar to this one

Mike
Attachments:

Please Log in or Create an account to join the conversation.

SQL Lookup doesn't work anymore 5 months 1 week ago #18900

Attachments:

Please Log in or Create an account to join the conversation.

SQL Lookup doesn't work anymore 5 months 1 week ago #18901

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7544
  • Karma: 33
  • Thank you received: 412
Hello

What is pst_process field type?
Mike

Please Log in or Create an account to join the conversation.

SQL Lookup doesn't work anymore 5 months 1 week ago #18902

If you run the transformation you should be able to see a detailed error message in the log
Peter Jonson
Support Analist

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2

We have 284 guests and no members online