Averify 1.7.6 to Agile DB Running on Oracle Database 9i Ends in Empty String Error (Doc ID 2078205.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.2.2.2 and later
Information in this document applies to any platform.

Symptoms

After running Averify 1.7.6 against Agile schema on Oracle Database 9i, the following error occurs.

Error
check-tns-failed:
[AverifyAll] File Deleted
[AverifyAll] File ..\scripts\run.sql created
[AverifyAll] java.lang.NumberFormatException: empty String
[AverifyAll] at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1011)
[AverifyAll] at java.lang.Float.valueOf(Float.java:417)
[AverifyAll] at com.agile.averify.AverifyAll.execute(AverifyAll.java:87)
[AverifyAll] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[AverifyAll] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
[AverifyAll] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[AverifyAll] at java.lang.reflect.Method.invoke(Method.java:601)
[AverifyAll] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
[AverifyAll] at org.apache.tools.ant.Task.perform(Task.java:348)
[AverifyAll] at org.apache.tools.ant.Target.execute(Target.java:357)
[AverifyAll] at org.apache.tools.ant.Target.performTasks(Target.java:385)
[AverifyAll] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
[AverifyAll] at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
[AverifyAll] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[AverifyAll] at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
[AverifyAll] at org.apache.tools.ant.Main.runBuild(Main.java:698)
[AverifyAll] at org.apache.tools.ant.Main.startAnt(Main.java:199)
[AverifyAll] at org.apache.tools.ant.Main.start(Main.java:161)
[AverifyAll] at org.apache.tools.ant.Main.main(Main.java:250)


Steps
The issue can be reproduced at will with the following steps:

  1. Run Averify 1.7.6 on Oracle Database 9i

 

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