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

TOPIC: SQL Lookup doesn't work anymore

SQL Lookup doesn't work anymore 1 week 1 day 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 1 week 17 hours ago #18873

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7423
  • Karma: 32
  • Thank you received: 392
We will have a look at it for you

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

Mike

SQL Lookup doesn't work anymore 1 week 9 hours ago #18884

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7423
  • Karma: 32
  • Thank you received: 392
Hi

Works fine here.

Can you post a screenshot similar to this one

Attachments:

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

Mike

SQL Lookup doesn't work anymore 4 days 19 hours ago #18900

Attachments:

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

SQL Lookup doesn't work anymore 4 days 7 hours ago #18901

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7423
  • Karma: 32
  • Thank you received: 392
Hello

What is pst_process field type?

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

Mike

SQL Lookup doesn't work anymore 4 days 7 hours ago #18902

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

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

Peter Jonson
Support Analist
  • Page:
  • 1
  • 2

We have 304 guests and no members online