ORA-01722 Occurs When Running AUT 1.7.5.3 (Doc ID 1672530.1)

Last updated on MAY 18, 2014

Applies to:

Oracle Agile PLM Framework - Version 9.3.2.0 to 9.3.3.0 [Release 9.3.2 to 9.3.3]
Information in this document applies to any platform.

Symptoms

When running AUT 1.7.5.3 to upgrade database to 9.3.2 or above, AUT.log shows the following error.

ERROR
-----------------------
  [exec] select id from subscriptions where trigger_event_ids=976 and id in
  [exec] *
  [exec] ERROR at line 4:
  [exec] ORA-01722: invalid number


Reproducing Step
-----------------------
1. Import 9.2.2.4 DB
2. Upgrade to 9.3.2 using AUT1.7.5.3
3. Check the AUT.log

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms