Expand my Community achievements bar.

Join us for Adobe Campaign Community Q&A Coffee Break on Thursday, March 7th at 8am PT with Eric Perrin, Gael Mouello, Chakravarthy Kalva, Bruce Swann and Sandra Hausmann.
SOLVED

Unable to import list in Campaign. ORA-00911: invalid syntax

Avatar

Level 6

Hi, we are trying to import a csv file into Campaign and getting invalid syntax error. Please help

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi Sanjana,

From the error, it looks like you may be missing a closing single quote. I can see one before the CREATE but not at the end, though this may be just cut off from the screenshot.

Additionally, based on Oracle documentation, it seems like spaces may not be allowed unless enclosed in double quotes. From the logs, it does look like there may be leading spaces that need to be removed.

https://docs.oracle.com/en/error-help/db/ora-00911/

Regards,

Craig

View solution in original post

4 Replies

Avatar

Community Advisor

Hello @Sanjana12,
How do you get syntax error for workflow activity? You only get it when you have script in the intialization tab? can you share the error message?

 

Marcel

Avatar

Community Advisor

Ah okey. It says invalid character. Maybe encoding issue. try to encode the file in utf 8 before adding data?

 

Marcel

Avatar

Correct answer by
Employee Advisor

Hi Sanjana,

From the error, it looks like you may be missing a closing single quote. I can see one before the CREATE but not at the end, though this may be just cut off from the screenshot.

Additionally, based on Oracle documentation, it seems like spaces may not be allowed unless enclosed in double quotes. From the logs, it does look like there may be leading spaces that need to be removed.

https://docs.oracle.com/en/error-help/db/ora-00911/

Regards,

Craig