One of our java programs sometimes gets a ""Loss of significance"" error when attempting to store records to IDMS. Sometimes the record stores fine and other times it gets the error. The developer says that she has had it work and then not work. When I tried it it failed the first couple of times (see error message below), then it started working for no apparent reason and it worked fine the rest of the day. I can't figure out if this is a connection issue with IDMS or something else. The program opens and closes the database connection each time a record is stored. When the record stores successfully the IDMS log shows the transaction, when it fails IDMS shows nothing. ""Loss of significance"" appears to be related to certain arithmetic operations, but the developer says that she does not do any of those in her program. Any ideas on how to debug this would be appreciated.
From the web server log:
CREATE_ID VALUE : 018645
IDMS INSERT, SSN: 123456789
java.sql.SQLException: DB001001 T391 C-4M322: Loss of significance
error DB001001 T391 C-4M322: Loss of significance
IDMS INSERT SUCCESS VALUE: 0