1. Home
  2. Support
Article - CS170799

Error "ORA-01427: single-row subquery returns more than one row" while running the "stage" command with Windchill Bulk Migrator 4.0

Modified: 23-Oct-2015   


Applies To

  • Windchill Bulk Migrator 4.0 F000

Description

  • Following error is returned when executing java -jar Wbmff.jar -operation stage :
com.ptc.windchill.migration.wbm.wbmff.util.WbmffException: Error executing sql statement. Exception type: java.sql.SQLException
Exception message: ORA-01427: single-row subquery returns more than one row
ORA-06512: vid "STAGING.FF_POPULATEFOLDER", row 28
ORA-06512: vid rad 1

Update count (before error):
Command with error:
{call ff_PopulateFolder}

    at com.ptc.windchill.migration.wbm.wbmff.util.SqlServerHelper.executeStoredProcedure(SqlServerHelper.java:320)
    at com.ptc.windchill.migration.wbm.wbmff.data.DataAccess.PopulateFolders(DataAccess.java:593)
    at com.ptc.windchill.migration.wbm.wbmff.data.LoadStagingProcessor$LoadStagingProcessorContext.executeLoadActions(LoadStagingProcessor.java:96)
    at com.ptc.windchill.migration.wbm.wbmff.data.LoadStagingProcessor$LoadStagingProcessorContext.rootExecute(LoadStagingProcessor.java:59)
    at com.ptc.windchill.migration.wbm.wbmff.Context.execute(Context.java:434)
    at com.ptc.windchill.migration.wbm.wbmff.OperationDispatcher.commonMain(OperationDispatcher.java:96)
    at com.ptc.windchill.migration.wbm.wbmff.WbmFromFiles.main(WbmFromFiles.java:8)
 
  • partition extraction is used with wbmff
This is a printer-friendly version of Article 170799 and may be out of date. For the latest version click CS170799