1. Home
  2. Support
Article - CS185332

"ORA-30926: unable to get a stable set of rows in the source tables" while executing wbmff -operation preload in Windchill Bulk Migrator 4.0 M010

Modified: 03-May-2016   


Applies To

  • Windchill Bulk Migrator 4.0 M010 to M010_CPS03

Description

  • Upon execution of java -jar Wbmff.jar -operation preload, the following error is reported:
    *** Terminating exception (ProcessCADFiles):
        com.ptc.windchill.migration.wbm.wbmff.util.WbmffException: Error executing sql command. Exception: ORA-30926: unable to get a stable set of rows in the source tables
        
        Command with error:
        -- Set FT member sourceId (variant 2)
                merge into ff_NdFtMember fm
                        using (select netg.Id, netg.originId, ni.sourceId, upper(ni.Name
        ) Name
                                   from
                                      ff_NdExtract netg
                                      join ff_NdExtract ne
                                      on netg.FileId = ne.FileId and netg.originId = ne.originId
                                      join ff_NdItem ni on ni.sourceId = ne.Id and ne.originId = ni.originId) u
                        on (fm.topGenericSourceId = u.Id and fm.originId = u.originId and u.Name = upper(fm.Name))
                        when matched then
                                update set fm.sourceId = u.sourceId
                        where fm.sourceId is null. ORA-30926: unable to get a stable set of rows in the source tables
        
                at com.ptc.windchill.migration.wbm.wbmff.util.SqlServerHelper.executeNonQueries(Unknown Source)
                at com.ptc.windchill.migration.wbm.wbmff.data.DataAccess.setModelNameFromND(Unknown Source)
                at com.ptc.windchill.migration.wbm.wbmff.data.CombineNDProcessor$CombineNDProcessorContext.rootExecute(Unknown Source)
                at com.ptc.windchill.migration.wbm.wbmff.Context.execute(Unknown Source)        
                at com.ptc.windchill.migration.wbm.wbmff.OperationDispatcher.commonMain(Unknown Source)
                at com.ptc.windchill.migration.wbm.wbmff.WbmFromFiles.main(Unknown Source)
        Caused by: java.sql.SQLException: ORA-30926: unable to get a stable set of rows in the source tables                                                                                                        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
                at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
                at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
                at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
                at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
                at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
                at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
                at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
                at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)        
                at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
                ... 6 more
        Exiting WbmFromFiles, exit code: 1
This is a printer-friendly version of Article 185332 and may be out of date. For the latest version click CS185332