0 Replies Latest reply on Jul 23, 2010 12:45 PM by Venkat Chella

    Sourcing Migration 9r1- Data Export

    Venkat Chella Journeyman

      Hello Folks,

       

      I was searching for Sourcing data export issues at connect and found about Ariba Exchange. This is my first discussion at Ariba Exchange. I have gone thru a few post before I post this, it seems really a great fourm.

       

      We are in the process of migrating from 4r4 to 9r1, as part of that we have started the data export process out of 4r4 instance and some of events could not get exported due to following error messages.

       

      ==============================================================

      Issue 1. java.lang.NullPointerException - ExcelBid.exportBundleLineData
      ==============================================================

      at ariba.aes.aqsmigration.spreadsheet.ExcelBid.exportBundleLineData(ExcelBid.java:461)
      at ariba.aes.aqsmigration.spreadsheet.ExcelBid.exportBid(ExcelBid.java:424)
      at ariba.aes.aqsmigration.spreadsheet.ExcelBid.exportToExcel(ExcelBid.java:196)
      at ariba.aes.aqsmigration.MarketExporter.exportBids(MarketExporter.java:529)
      at ariba.aes.aqsmigration.MarketExporter.exportDocument(MarketExporter.java:364)
      at ariba.aes.aqsmigration.DocumentExporter.export(DocumentExporter.java:136)
      at ariba.aes.aqsmigration.SourcingProjectExporter.exportDocuments(SourcingProjectExporter.java:61)
      at ariba.aes.aqsmigration.ProjectExporter.export(ProjectExporter.java:137)
      at ariba.aes.aqsmigration.EventExport.exportPublishedMarkets(EventExport.java:296)
      at ariba.aes.aqsmigration.EventExport.export(EventExport.java:105)
      at ariba.aes.aqsmigration.ASTransactionDataExport.export(ASTransactionDataExport.java:52)
      at ariba.aes.aqsmigration.ExportUtil.export(ExportUtil.java:648)
      at ariba.aes.aqsmigration.ExportUtil.export(ExportUtil.java:621)
      at ariba.aes.aqsmigration.ExportUtil.exportALL(ExportUtil.java:573)
      at ariba.aes.aqsmigration.ExportUtil.export(ExportUtil.java:460)
      at ariba.aes.aqsmigration.ExportUtil$AsynchronizedFileGenerator.run(ExportUtil.java:855)

       

      ==============================================================
      Issue 2. -
      java.lang.NullPointerException - MarketHelper.getAttrDisplayText
      ==============================================================


      at ariba.aes.aqsmigration.MarketHelper.getAttrDisplayText(MarketHelper.java:2627)
      at ariba.aes.aqsmigration.MarketHelper.getAQSAlias(MarketHelper.java:2610)
      at ariba.aes.aqsmigration.MarketHelper.fixFormulaExpression(MarketHelper.java:2431)
      at ariba.aes.aqsmigration.MarketHelper.getCostFormulaString(MarketHelper.java:2371)
      at ariba.aes.aqsmigration.MarketHelper.addLineDetails(MarketHelper.java:2101)
      at ariba.aes.aqsmigration.MarketHelper.addItems(MarketHelper.java:1216)
      at ariba.aes.aqsmigration.MarketHelper.buildItemList(MarketHelper.java:1136)
      at ariba.aes.aqsmigration.MarketHelper.getItems(MarketHelper.java:551)
      at ariba.aes.aqsmigration.spreadsheet.ExcelBasic.getItemlist(ExcelBasic.java:324)
      at ariba.aes.aqsmigration.MarketExporter.exportDocument(MarketExporter.java:299)
      at ariba.aes.aqsmigration.DocumentExporter.export(DocumentExporter.java:136)
      at ariba.aes.aqsmigration.SourcingProjectExporter.exportDocuments(SourcingProjectExporter.java:61)
      at ariba.aes.aqsmigration.ProjectExporter.export(ProjectExporter.java:137)
      at ariba.aes.aqsmigration.EventExport.exportPublishedMarkets(EventExport.java:296)
      at ariba.aes.aqsmigration.EventExport.export(EventExport.java:105)
      at ariba.aes.aqsmigration.ASTransactionDataExport.export(ASTransactionDataExport.java:52)
      at ariba.aes.aqsmigration.ExportUtil.export(ExportUtil.java:648)
      at ariba.aes.aqsmigration.ExportUtil.export(ExportUtil.java:621)
      at ariba.aes.aqsmigration.ExportUtil.exportALL(ExportUtil.java:573)
      at ariba.aes.aqsmigration.ExportUtil.export(ExportUtil.java:460)
      at ariba.aes.aqsmigration.ExportUtil$AsynchronizedFileGenerator.run(ExportUtil.java:855).

       


      ==============================================================
      Issue 3. -
      java.lang.NullPointerException - No Stactrace

      ==============================================================


      ==========================================================================
      Issue 4. ariba.util.core.FatalAssertionException - ExcelSheet.sortListsBasedOnColumnNumber
      ==========================================================================

       

      ariba.util.core.FatalAssertionException: Unique Values for Column Number 11 in sheet XXBIDXXX for row 9

       

      at ariba.util.core.Assert.assertFatal(Assert.java:400)
      at ariba.util.core.Assert.that(Assert.java:42)
      at ariba.aes.aqsmigration.spreadsheet.ExcelSheet.sortListsBasedOnColumnNumber(ExcelSheet.java:310)
      at ariba.aes.aqsmigration.spreadsheet.ExcelBase.preWriteoutRows(ExcelBase.java:223)
      at ariba.aes.aqsmigration.spreadsheet.ExcelBase.writeoutRows(ExcelBase.java:233)
      at ariba.aes.aqsmigration.spreadsheet.ExcelBid.exportToExcel(ExcelBid.java:197)
      at ariba.aes.aqsmigration.MarketExporter.exportBids(MarketExporter.java:529)
      at ariba.aes.aqsmigration.MarketExporter.exportDocument(MarketExporter.java:364)
      at ariba.aes.aqsmigration.DocumentExporter.export(DocumentExporter.java:136)
      at ariba.aes.aqsmigration.SourcingProjectExporter.exportDocuments(SourcingProjectExporter.java:61)
      at ariba.aes.aqsmigration.ProjectExporter.export(ProjectExporter.java:137)
      at ariba.aes.aqsmigration.EventExport.exportPublishedMarkets(EventExport.java:296)
      at ariba.aes.aqsmigration.EventExport.export(EventExport.java:105)
      at ariba.aes.aqsmigration.ASTransactionDataExport.export(ASTransactionDataExport.java:52)
      at ariba.aes.aqsmigration.ExportUtil.export(ExportUtil.java:648)
      at ariba.aes.aqsmigration.ExportUtil.export(ExportUtil.java:621)
      at ariba.aes.aqsmigration.ExportUtil.exportALL(ExportUtil.java:573)
      at ariba.aes.aqsmigration.ExportUtil.export(ExportUtil.java:460)
      at ariba.aes.aqsmigration.ExportUtil$AsynchronizedFileGenerator.run(ExportUtil.java:855)