ERROR in CamelInformixAdapter - Joining 2 tables using more than one column

[former_member597689]

Hi everyone.

Our consultant has created an Informix Provisioning Remote Source and worked fine quering individual virtual tables.

We have a porblem when quering 2 tables joined by more than one column:

The query:

select count(*)

from "HOSPITALARIO"."VIR_SCS_HLV_hgproqui" HG

inner join "HOSPITALARIO"."VIR_SCS_HLV_hgactqui" AQ

on AQ."actquiepi" = HG."proquiepi" -- match1

and AQ."actquinum" = HG."proquinum"; -- match 2

Results:

Could not execute 'select count(*) from "HOSPITALARIO"."VIR_SCS_HLV_hgproqui" HG inner join ...' in 391 ms 942 µs . SAP DBTech JDBC: [403]: internal error: Remote execution error Failed to rewrite SQL statement [SELECT COUNT(*) FROM ("informix.hgproqui" "HG" INNER JOIN "informix.hgactqui" "AQ" ON ("HG"."proquiepi" = "AQ"."actquiepi" AND "HG"."proquinum" = "AQ"."actquinum") ) ]. for query "SELECT COUNT(*) FROM ("informix.hgproqui" "HG" INNER JOIN "informix.hgactqui" "AQ" ON ("HG"."proquiepi" = "AQ"."actquiepi" AND "HG"."proquinum" = "AQ"."actquinum") ) "

"If" i only use one of the two matching fields the query works fine.

Can you please give me some advice?

Thanks a lot.

Larry.

[former_member8403]

Hi!

• Can you let us know your HANA version please?
• Is that a SDI probably you're using right?

As this error comes from backend, you might raise this towards our HANA SDI support team per expert area: "HAN-DP-SDI"...

Some more info about troubleshooting SDI you can find in:

1. https://launchpad.support.sap.com/#/notes/2596892
2. https://launchpad.support.sap.com/#/notes/2496051

Cheers, Mark

[former_member597689]

Hi Mark,

In fact, our counsultant updated the Agent version and it solved the problem with the Informix provisioning

Thanks for your answer and sorry about the delay.

Larry.