topic Re: DB Connect dbxquery works fine, but not dbxlookup in All Apps and Add-ons

DB Connect dbxquery works fine, but not dbxlookup

phunte — Mon, 09 Aug 2021 22:22:12 GMT

Hi,

Has anyone run into this? I am still on DB Connect 3.2 and have used dbxquery successfully for years. I am just trying to use dbxlookup but cannot get even a simple example to work?

| makeresults count=3 | streamstats count as id | dbxlookup connection="agena_ro" query="SELECT * FROM `agena_production`.`plans`" "id" AS "id" OUTPUT "description" AS "description"

I see this in the logs that looks suspicious?

2021-08-09 15:19:37.141 11088@prod3splunksearchl [main] INFO com.splunk.dbx.connector.logger.AuditLogger - operation= connection_name= stanza_name= state=success sql='SELECT "id", "description" FROM (SELECT * FROM `agena_production`.`plans`) dbxlookup WHERE "id" IN (?,?,?)'

Thanks.

phunte

Re: DB Connect dbxquery works fine, but not dbxlookup

codebuilder — Wed, 18 Aug 2021 19:07:50 GMT

dbxquery connects to a configured database, so you cant use makeresults for testing queries.

Re: DB Connect dbxquery works fine, but not dbxlookup

phunte — Wed, 18 Aug 2021 19:29:34 GMT

Thanks codebuilder but I don't understand? I am only using makeresults to test the dbxlookup?

Re: DB Connect dbxquery works fine, but not dbxlookup

louismai — Thu, 13 Jan 2022 21:42:30 GMT

dbxlookup doesn't seem to work when I tried to run. The query doesn't provide any outputs when I clicked Open in Search in Data Lab/ Edit Lookup page. Both my reference search and Look SQL are working, and provide correct results when running separately.