Expand my Community achievements bar.

Join us for the Adobe Campaign Community Q&A Coffee Break on 30th September at 8 am PT with Campaign experts Arthur Lacroix and Sandra Hausmann.

Cursor sql error on postgres FDA table

Avatar

Level 2

I'm connecting to a postgres database on AWS via FDA but getting errors on the primary key.

The table is called transactions and has an attribute called betId as a unique primary key field.

When I access the data in the table (via schema data view) I either get an error that primary key needs to be defined or when I define betId as primary key a sql error for cursor:
ERROR: column a0.betid does not exist.

'SELECT A0.betId FROM adobe.transactions A0 LIMIT 200' could not be executed.

 

Schema definition:
<key internal="true" name="pid" noDbIndex="true">
  <keyfield xpath="@id"/>
</key>
<attribute advanced="false" label="betId" name="id" length="16" sqlname="betId" type="string"/>

1 Reply

Avatar

Level 3

Hi @PLundmark 

Adobe Campaign is case sensitive, so it seems "A0.betId" is not same for Adobe as "a0.betId".

Maybe you can check your database configuration to solve it.