Oracle error: ORA-01747 in Push notification

[JorgeTo1]

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 solution]

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-colu...

Regards,

Craig