Hello,
I'm trying to make an avanced query with the SQL editor with external entities. But i'm getting this error.
I tried this too:
Do you know what happen?
Thank you
Hello Alvaro,
You shouldn't have to specify the catalog within your queries - you can do this from the "Table or View Default Name" property in the Entity inside the Extension.
How did you create your Entity inside the Extension? Did you create it manually, or did you use the wizard? Does your Table name look like "outsystems_test_bi"."dbo"."dds_seguimiento_presupuesto" or similar?
Hello Alfonso,
I created it using the wizard with Integration Studio
The DB conection is called outsystems_test_bi and the Test connection is OK
I was sure the Integration wizard would set the catalog name on the Table Name.
Have you tried setting your Table name to "outsystems_test_bi"."dbo"."dds_seguimiento_presupuesto" (assuming "outsystems_test_bi" is your catalog and "dbo" is your schema)?
Hi,
i don't know anything about integration studio, so I could be way off, but can you try to first rule out the possibility of an attribute mismatch ?
Using SELECT * is a bad practice anyway, as it is very fragile to datamodel changes (not only this clear error, but also mistakenly filling wrong attributes if their sequence changes), and also doesn't optimize for the information you really need, so replace that by a specific list of attributes you want to select, and a matching output structure with only the attributes you want.
Dorine
Integration builder is not same as integration studio
Thanx, fixed that lapse
Finally, we need this case in other client and It's working prefectly there.
Thank you for your answers
Regards