Oracle error: ORA-01747 in Push notification

Question

Finding this Oracle error when launching Push delivery (both IOs or Android).

The error "AM ORA-210000 Oracle error: ORA-01747: invalid user.table.column, table.column, or column specification" log shows when "recipient(s) match segmentation criteria " happens.

Haven't found the root cause nor info available about this, could anyone please help solve this?

Will be much appreciated!

First pic is normal push execution and second the error.

Craig_Thonis · Accepted Answer

Hi Jorge.You or your DBA will need to review it, but it there can be multiple reasons for this error, including referencing a reserved word in Oracle, including extra commas, or referencing an unspecified column. Here are some online resources explaining the same:https://docs.oracle.com/en/error-help/db/ora-01747/?r=23ai https://www.techonthenet.com/oracle/errors/ora01747.php https://stackoverflow.com/questions/9459204/ora-01747-invalid-user-table-column-table-column-or-column-specification Regards,Craig

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded