Article - CS17826
Error "ORA-01461: can bind a LONG value only for insert into a LONG column" is returned in Windchill PDMLink 9.1
Modified: 01-Apr-2016
Applies To
- Windchill PDMLink 9.1 F000 to M060
Description
- Following error is reported in BackgroundMethodServer log
[WfUserWorkQueue.PollingThread] wt.queue.ProcessingQueue.WfUserWorkQueue -
wt.pom.DatastoreException: A SQL error has occurred for the statement "UPDATE QueueEntry SET args=?,blob$args=?,classnamekeydomainRef=?,idA3domainRef=?,endExec=?,entryNumber=?,entryOwnerIsNull=?,classnamekeyB5=?,idA3B5=?,failureCount=?,inheritedDomain=?,datelock=?,classnamekeyA2lock=?,idA3A2lock=?,notelock=?,classnamekeyA5=?,idA3A5=?,securityLabels=?,startExec=?,statusInfoIsNull=?,codeC5=?,messageC5=?,rescheduleTimeC5=?,targetClass=?,targetMethod=?,markForDeleteA2=?,updateStampA2=?,modifyStampA2=?,updateCountA2=updateCountA2+1 WHERE ((idA2A2 = ?) AND (updateCountA2 = ?))". Database system message follows:
Nested exception is: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
at wt.pds.SQLDatabasePds.updateList(SQLDatabasePds.java:2581)
at wt.pds.SQLDatabasePds.update(SQLDatabasePds.java:355)
at wt.pom.PersistentObjectManager.update(PersistentObjectManager.java:3017)
at wt.pom.PersistentObjectManager.update(PersistentObjectManager.java:814)
at wt.fc.StandardPersistenceManager.update(StandardPersistenceManager.java:2814)
at wt.fc.StandardPersistenceManager.update(StandardPersistenceManager.java:2774)
at wt.queue.QueueEntry.update(QueueEntry.java:648)
at wt.queue.ProcessingQueue.updateProcessEntry(ProcessingQueue.java:1306)
at wt.queue.ProcessingQueue.execEntry(ProcessingQueue.java:588)
at wt.queue.ProcessingQueue.execEntries(ProcessingQueue.java:1228)
at wt.queue.PollingQueueThread.run(PollingQueueThread.java:185)
wt.pom.DatastoreException: A SQL error has occurred for the statement "UPDATE QueueEntry SET args=?,blob$args=?,classnamekeydomainRef=?,idA3domainRef=?,endExec=?,entryNumber=?,entryOwnerIsNull=?,classnamekeyB5=?,idA3B5=?,failureCount=?,inheritedDomain=?,datelock=?,classnamekeyA2lock=?,idA3A2lock=?,notelock=?,classnamekeyA5=?,idA3A5=?,securityLabels=?,startExec=?,statusInfoIsNull=?,codeC5=?,messageC5=?,rescheduleTimeC5=?,targetClass=?,targetMethod=?,markForDeleteA2=?,updateStampA2=?,modifyStampA2=?,updateCountA2=updateCountA2+1 WHERE ((idA2A2 = ?) AND (updateCountA2 = ?))". Database system message follows:
Nested exception is: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
at wt.pds.SQLDatabasePds.updateList(SQLDatabasePds.java:2581)
at wt.pds.SQLDatabasePds.update(SQLDatabasePds.java:355)
at wt.pom.PersistentObjectManager.update(PersistentObjectManager.java:3017)
at wt.pom.PersistentObjectManager.update(PersistentObjectManager.java:814)
at wt.fc.StandardPersistenceManager.update(StandardPersistenceManager.java:2814)
at wt.fc.StandardPersistenceManager.update(StandardPersistenceManager.java:2774)
at wt.queue.QueueEntry.update(QueueEntry.java:648)
at wt.queue.ProcessingQueue.updateProcessEntry(ProcessingQueue.java:1306)
at wt.queue.ProcessingQueue.execEntry(ProcessingQueue.java:588)
at wt.queue.ProcessingQueue.execEntries(ProcessingQueue.java:1228)
at wt.queue.PollingQueueThread.run(PollingQueueThread.java:185)
- This issue can occurs in other circumstances than background queues.
- wt.pom.sql logger can be set before reproducing the error to analyse the query involved.
This is a printer-friendly version of Article 17826 and may be out of date. For the latest version click CS17826