Skip to main content
Amit_Kumar
Amit_Kumar
Level 10
December 16, 2015
Solved

Adobe campaign postgreSQL error while using aggregate function

I am getting a postgreSQL error while updating the schema which contains aggregate function sum.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Linda_Stinson
Linda_StinsonAccepted solution
Adobe Employee
December 18, 2015

Hi Amit,

  You need to Group by the targeting dimension. The primary key of the targeting dimension is always included in the results and that is what this error message is referring to. Edit the additional data and click on the Advanced settings link to do get to this setting.

View in thread

3 replies

Linda_Stinson
Adobe Employee
Linda_StinsonAdobe EmployeeAccepted solution
Adobe Employee
December 18, 2015

Hi Amit,

  You need to Group by the targeting dimension. The primary key of the targeting dimension is always included in the results and that is what this error message is referring to. Edit the additional data and click on the Advanced settings link to do get to this setting.

Translate
Amit_Kumar
Amit_KumarAuthor
Level 10
December 20, 2015

Hi Linda,

I am using a preloading in web form.so in there i don't see any

checkbox to Group by the targeting dimension.

How can i use query in a webform to display the count of all participants or some of a recipient field?

Regards,

Amit

Translate
Linda_Stinson
Adobe Employee
Linda_StinsonAdobe Employee
Adobe Employee
December 21, 2015

The Data Management options are much more limited in a web application workflow than in a Campaign workflow. Can you provide screen shots of what you have implemented?

Translate
Terms & ConditionsAccessibility statement

Loading footer...