Question
Accenture
IN
Last activity: 11 Oct 2019 9:28 EDT
Getting privilege error while uploading CSV in a segment
Hi,
I am trying to upload a CSV with few customers in a segment rule in Pega Marketing. It successfully validates the file but when i click on finish, it shows an error:
Problem in executing BatchA-B-Data-CUSTOMER: code: 1031 SQLState: 42000 Message: ORA-01031: insufficient privileges
DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
Can anyone help with this issue? Is there any privilege missing for this customer class?
Thanks and Regards,
Chiranjeet Mishra
Accepted Solution
Pegasystems Inc.
IN
Pegasystems Inc.
US
can you share more details of your environment, with versions etc? thanks
Accenture
IN
Hi,
We are currently using Pega 7.3.1 and Pega Marketing 7.31. We are trying to create a List type segment with just one column for customer id and 3-4 customer ids.
Thanks
Accepted Solution
Pegasystems Inc.
IN
Hi,
If you are using Add or Add or update purpose, then the customer table will be inserted/updated with the values in the import csv file. Please check at the database end if mktuser (or similar) has the required permission to update the customer table.
If you are just trying to populate the list segment - Please use "Populate segment only" purpose ensuring that the customer id's in the import file are present in the customer table already.
Accenture
IN
Hi,
Thanks for your help! It was really helpful and I was able to successfully upload the CSV to the segment.
Thanks,
Chiranjeet
Hi,
If you are using Add or Add or update purpose, then the customer table will be inserted/updated with the values in the import csv file. Please check at the database end if mktuser (or similar) has the required permission to update the customer table.
If you are just trying to populate the list segment - Please use "Populate segment only" purpose ensuring that the customer id's in the import file are present in the customer table already.