11 Replies Latest reply: Dec 4, 2012 11:42 PM by 975451 RSS

    Reim Batch issue

    975451
      [oracle@retailsols reim-batch]$ ./reimpurge reim PURGE ALL COMMIT
      2012-11-21 15:58:56,215 INFO [main] oracle.retail.reim.batch.BatchRunner - Runn ing with arguments: [BatchPurgeBatch, reim, PURGE, ALL, COMMIT]
      2012-11-21 15:58:56,391 INFO [main] org.springframework.context.support.ClassPa thXmlApplicationContext - Refreshing org.springframework.context.support.ClassPa thXmlApplicationContext@65faba46: display name [org.springframework.context.supp                                                                                                 ort.ClassPathXmlApplicationContext@65faba46]; startup date [Wed Nov 21 15:58:56                                                                                                  IST 2012]; root of context hierarchy
      2012-11-21 15:58:56,616 INFO [main] org.springframework.beans.factory.xml.XmlBe anDefinitionReader - Loading XML bean definitions from class path resource [com/                                                                                                 retek/reim/reim-datasource-config.xml]
      2012-11-21 15:58:57,815 INFO [main] org.springframework.beans.factory.xml.XmlBe anDefinitionReader - Loading XML bean definitions from class path resource [com/                                                                                                 retek/reim/reim-service-config.xml]
      2012-11-21 15:59:07,325 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-dao-config.xml]
      2012-11-21 15:59:07,384 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-batch-config.xml]
      2012-11-21 15:59:07,447 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-util-config.xml]
      2012-11-21 15:59:07,547 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@65faba46]: org.springframework.beans.factory.support.DefaultListableBeanFactory@f8622f3
      2012-11-21 15:59:08,390 INFO [main] org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Loading properties file from class path resource [com/retek/reim/reim.properties]
      2012-11-21 15:59:09,202 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'loginCredentialBean' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
      2012-11-21 15:59:09,207 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#4f4db0e3' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
      2012-11-21 15:59:11,559 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#4f4db0e3' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
      2012-11-21 15:59:11,561 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#75982fc1' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
      2012-11-21 15:59:11,562 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#75982fc1' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
      2012-11-21 15:59:11,589 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'dataSource' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
      2012-11-21 15:59:11,597 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'transactionManager' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
      2012-11-21 15:59:11,606 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean '(inner bean)' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
      2012-11-21 15:59:11,607 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean '(inner bean)' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
      2012-11-21 15:59:11,607 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.transaction.config.internalTransactionAdvisor' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
      2012-11-21 15:59:11,695 INFO [main] org.springframework.beans.factory.support.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@f8622f3: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,loginCredentialBean,dataSource,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.config.internalTransactionAdvisor,simpleJdbcTemplate,transactionManagerFactory,com.retek.reim.services.SupplierOptionsService#0,com.retek.reim.services.NonMerchandiseDocumentService#0,com.retek.reim.services.ItemSupplierService#0,com.retek.reim.services.matching.CreditNoteMatchStatusService#0,com.retek.reim.services.EdiRejectService#0,com.retek.reim.services.EdiDocumentService#0,com.retek.reim.services.DiscrepancyPurgeService#0,DisputedCreditMemoResolutionRollupBatch,BatchPurgeBatch,FixedDealUploadBatch,CreditNoteAutoMatchBatch,AutoMatchBatch,ReceiptWriteOffBatch,DiscrepancyPurgeBatch,FinancialPostingBatch,EdiUploadBatch,ComplexDealUploadBatch,EdiDownloadBatch,ReasonCodeActionRollupBatch,AccountWorkspacePurgeBatch,FinancialPostingWorkspacePurgeBatch,autoDiscrepancyResolutionDao,costDiscrepancyDao,complexDealDao,receiverUnitAdjustmentDao,taxCalculationDao,ediRejectDocumentDetailTaxDao,creditNoteMatchCompletionDao,costDiscrepancyHistoryDao,matchProcessDao,matchQtyVarianceHistoryDao,docDetailReasonCodesDao,stageFixedDealDao,itemSupplierDao,matchResultDao,documentTaxDao,receiptWriteOffHistoryDao,nonMerchTaxDao,documentDetailRcTaxDao,fixedDealTaxDao,parentNonMerchTaxesDao,invoiceDetailAllowanceTaxDao,resolutionActionDao,matchResultItemDao,creditNoteMatchHistoryDao,ediRejectDocumentTaxDao,financialsGLStageDao,matchResultItemHistoryDao,documentDao,ediRejectDocumentDetailDao,qtyDiscrepancyHistoryDao,matchResultHistoryDao,summaryMatchDao,accountDao,termsDao,dateTimeDao,taxDataDao,DBSequenceLoaderDao,glOptionsDao,financialPostingAccountDao,supplierBasedCreditNoteMatchCandidateDao,matchDocumentToleranceDao,shipSkuDao,supplierOptionsDao,receiptDao,invoiceDetailDao,nonMerchandiseEntryDao,ediRejectDocumentDetailAllowTaxDao,invoiceDetailTaxDao,matchCostVarianceHistoryDao,ediRejectDocumentDao,dealDynamicSegmentsDao,itemTaxAuditDao,creditNoteQtyDiscrepancyDao,financialsAPStageDao,receiptItemPostingDao,ediRejectDocumentNonMerchTaxDao,varianceDao,itemSupCountryDao,orderLocationDao,creditNoteCostDiscrepancyDao,dealDetailDao,dynamicMappingDao,matchQtyVarianceDao,partiallyMatchedReceiptDao,ediRejectDocumentNonMerchDao,documentHoldingDao,stageComplexDealDao,fixedDealDao,matchDocHistoryDao,parentNonMerchDao,matchPoolKeyConfigDao,orderDao,qtyDiscrepancyDao,taxDiscrepancyDao,documentDetailDao,matchAttemptDao,applicationUserDao,documentVatDao,ediRejectDocumentDetailAllowDao,orderItemTaxAuditDao,financialPostingDao,matchCostVarianceDao,invoiceDetailAllowanceDao,documentMatchedCreditNoteDiscrepancyWriteOffPostingService,documentMatchedReleasedCreditNotePostingService,documentPrepayInvoicePostingService,receiptWriteOffPostingService,financialPostingService,documentMatchedNonHeldCreditNotePostingService,documentApprovedCreditNotePostingService,documentCreditMemoPostingService,documentInvoicePostingService,documentMatchedUnpersistedCreditNoteVWTPostingService,documentNonMerchandisePostingService,financialPostingStagingService,documentDebitMemoPostingService,documentPrepayParentInvoicePostingService,webServiceConsumerService,taxService,ediDocumentService,receiptWriteOffHistoryService,receiptService,taxDiscrepancyService,dynamicMappingService,varianceService,receiverAdjustmentService,financialPostingAccountService,financialApplicationIntegrationService,fixedDealUploadService,dealDynamicSegmentsService,reasonCodeActionRollupService,dealService,ediRejectService,invoiceDetailService,systemOptionsService,invoiceMaintenanceService,documentDetailService,taxDiscrepancyResolutionService,termsService,vatDiscrepancyService,applicationUserService,parentInvoiceService,complexDealUploadService,documentHoldingService,varianceResolutionService,accountService,log4jLoggingService,documentService,periodService,itemSupplierService,dateTimeService,nonMerchandiseEntryService,supplierOptionsService,autoDiscrepancyResolutionService,supplierBasedAutoMatchTaskExecutionService,detailMatchService,creditNoteMatchAttemptSummaryLevelService,creditNoteMatchAttemptDetailLevelService,creditNoteAutoMatchInitService,autoMatchService,headerOnlyInvoiceTaxValidationService,matchService,summaryMatchService,matchStatusService,creditNoteVarianceService,creditNoteMatchAttemptOneToOneLevelService,creditNoteSummaryMatchService,creditNoteAutomatchService,creditNoteDetailMatchService,manualGroupUIService,quantityReviewListUIService,discrepancyResolutionUIService,priceReviewCostSelectionLoadUIService,priceReviewListUIService,logger,toStringStyleLogger,systemDate,springContext,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,daoFactory,reIMSystemOptionsService,invoiceAdvSearchService,serviceFactory,discrepancyPurgeService]; root of factory hierarchy
      2012-11-21 15:59:22,528 INFO [main] oracle.retail.reim.batch.BatchProcessor - Executing BatchPurgeBatch...
      2012-11-21 15:59:24,916 ERROR [main] com.retek.reim.manager.LoginServiceImpl -
      com.retek.reim.merch.utils.ReIMException: Could not complete login.
      at com.retek.reim.manager.LoginServiceImpl.login(LoginServiceImpl.java:160)
      at com.retek.reim.batch.BatchUtils.start(BatchUtils.java:274)
      at com.retek.reim.purge.BatchPurge.main(BatchPurge.java:43)
      at oracle.retail.reim.batch.jobs.BatchPurgeBatch.performBatch(BatchPurgeBatch.java:17)
      at oracle.retail.reim.batch.ABatchProcess.execute(ABatchProcess.java:34)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      at $Proxy21.execute(Unknown Source)
      at oracle.retail.reim.batch.BatchProcessor.executeBatch(BatchProcessor.java:41)
      at oracle.retail.reim.batch.BatchRunner.configureAndRunBatch(BatchRunner.java:65)
      at oracle.retail.reim.batch.BatchRunner.main(BatchRunner.java:26)
      Caused by: com.retek.reim.merch.utils.ReIMException: Invalid username or password.
      at com.retek.reim.manager.LoginServiceImpl.validateLocalUserUsingDatabase(LoginServiceImpl.java:178)
      at com.retek.reim.manager.LoginServiceImpl.login(LoginServiceImpl.java:155)
      ... 18 more
      2012-11-21 15:59:24,920 ERROR [main] com.retek.reim.purge.BatchPurge -
      oracle.retail.reim.batch.BatchExecutionException: com.retek.reim.merch.utils.ReIMException: Could not complete login.
      at com.retek.reim.batch.BatchUtils.start(BatchUtils.java:285)
      at com.retek.reim.purge.BatchPurge.main(BatchPurge.java:43)
      at oracle.retail.reim.batch.jobs.BatchPurgeBatch.performBatch(BatchPurgeBatch.java:17)
      at oracle.retail.reim.batch.ABatchProcess.execute(ABatchProcess.java:34)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      at $Proxy21.execute(Unknown Source)
      at oracle.retail.reim.batch.BatchProcessor.executeBatch(BatchProcessor.java:41)
      at oracle.retail.reim.batch.BatchRunner.configureAndRunBatch(BatchRunner.java:65)
      at oracle.retail.reim.batch.BatchRunner.main(BatchRunner.java:26)
      Caused by: com.retek.reim.merch.utils.ReIMException: Could not complete login.
      at com.retek.reim.manager.LoginServiceImpl.login(LoginServiceImpl.java:160)
      at com.retek.reim.batch.BatchUtils.start(BatchUtils.java:274)
      ... 17 more
      Caused by: com.retek.reim.merch.utils.ReIMException: Invalid username or password.
      at com.retek.reim.manager.LoginServiceImpl.validateLocalUserUsingDatabase(LoginServiceImpl.java:178)
      at com.retek.reim.manager.LoginServiceImpl.login(LoginServiceImpl.java:155)
      ... 18 more


      I am getting above problem when i am running with correct user alias
        • 1. Re: Reim Batch issue
          Amrutha-Oracle
          Hi,

          In your below syntax

          ./reimpurge reim PURGE ALL COMMIT

          is 'reim' used for log into Reim application? If not use the username and password through which you will log into reim or ADMIN user credentials.


          Use the below syntax and try once again :

          ./reimpurge username/password PURGE ALL COMMIT


          Regards,
          Amrutha.C
          • 2. Re: Reim Batch issue
            964507
            Actually the syntax will depend on ReIM version. Starting from 13.2 there will be an alias for username/password instead of username/password combination itself.
            • 3. Re: Reim Batch issue
              975451
              I have getting one more problem when i am running my reim batches the problem is could not establish the connection

              java.sql.Exception.


              we have changed our ip is there any problem while getting the jdbc connection can you please tell me

              Regards
              Rajkumar

              Edited by: 972448 on Nov 26, 2012 2:23 AM
              • 4. Re: Reim Batch issue
                praveenps
                Hi,

                Give the stacktrace.

                Regards,
                PPS
                • 5. Re: Reim Batch issue
                  975451
                  Even though i am running with Username/pwd i am unable to run the batch

                  Regards
                  Rajkumar
                  • 6. Re: Reim Batch issue
                    praveenps
                    Hi,

                    Please give full error listing/java stack trace which will help us to get an idea on this error.

                    Regards,
                    PPS
                    • 7. Re: Reim Batch issue
                      975451
                      [oracle@retailsols reim-batch]$ ./reimpurge ADMIN/retek PURGE ALL COMMIT
                      2012-11-27 11:20:00,237 INFO [main] oracle.retail.reim.batch.BatchRunner - Running with arguments: [BatchPurgeBatch, ADMIN/retek, PURGE, ALL, COMMIT]
                      2012-11-27 11:20:00,344 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@5f7a8a02: display name [org.springframework.context.support.ClassPathXmlApplicationContext@5f7a8a02]; startup date [Tue Nov 27 11:20:00 IST 2012]; root of context hierarchy
                      2012-11-27 11:20:00,502 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-datasource-config.xml]
                      2012-11-27 11:20:01,215 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-service-config.xml]
                      2012-11-27 11:20:07,875 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-dao-config.xml]
                      2012-11-27 11:20:07,984 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-batch-config.xml]
                      2012-11-27 11:20:08,072 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-util-config.xml]
                      2012-11-27 11:20:08,850 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@5f7a8a02]: org.springframework.beans.factory.support.DefaultListableBeanFactory@a50a649
                      2012-11-27 11:20:09,531 INFO [main] org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Loading properties file from class path resource [com/retek/reim/reim.properties]
                      2012-11-27 11:20:10,239 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'loginCredentialBean' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                      2012-11-27 11:20:10,243 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#6e84cc09' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                      2012-11-27 11:20:12,026 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#6e84cc09' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                      2012-11-27 11:20:12,028 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#506f9b8e' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                      2012-11-27 11:20:12,029 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#506f9b8e' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                      2012-11-27 11:20:12,049 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'dataSource' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                      2012-11-27 11:20:12,051 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'transactionManager' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                      2012-11-27 11:20:12,060 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean '(inner bean)' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                      2012-11-27 11:20:12,061 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean '(inner bean)' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                      2012-11-27 11:20:12,061 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.transaction.config.internalTransactionAdvisor' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                      2012-11-27 11:20:12,149 INFO [main] org.springframework.beans.factory.support.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@a50a649: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,loginCredentialBean,dataSource,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.config.internalTransactionAdvisor,simpleJdbcTemplate,transactionManagerFactory,com.retek.reim.services.SupplierOptionsService#0,com.retek.reim.services.NonMerchandiseDocumentService#0,com.retek.reim.services.ItemSupplierService#0,com.retek.reim.services.matching.CreditNoteMatchStatusService#0,com.retek.reim.services.EdiRejectService#0,com.retek.reim.services.EdiDocumentService#0,com.retek.reim.services.DiscrepancyPurgeService#0,DisputedCreditMemoResolutionRollupBatch,BatchPurgeBatch,FixedDealUploadBatch,CreditNoteAutoMatchBatch,AutoMatchBatch,ReceiptWriteOffBatch,DiscrepancyPurgeBatch,FinancialPostingBatch,EdiUploadBatch,ComplexDealUploadBatch,EdiDownloadBatch,ReasonCodeActionRollupBatch,AccountWorkspacePurgeBatch,FinancialPostingWorkspacePurgeBatch,autoDiscrepancyResolutionDao,costDiscrepancyDao,complexDealDao,receiverUnitAdjustmentDao,taxCalculationDao,ediRejectDocumentDetailTaxDao,creditNoteMatchCompletionDao,costDiscrepancyHistoryDao,matchProcessDao,matchQtyVarianceHistoryDao,docDetailReasonCodesDao,stageFixedDealDao,itemSupplierDao,matchResultDao,documentTaxDao,receiptWriteOffHistoryDao,nonMerchTaxDao,documentDetailRcTaxDao,fixedDealTaxDao,parentNonMerchTaxesDao,invoiceDetailAllowanceTaxDao,resolutionActionDao,matchResultItemDao,creditNoteMatchHistoryDao,ediRejectDocumentTaxDao,financialsGLStageDao,matchResultItemHistoryDao,documentDao,ediRejectDocumentDetailDao,qtyDiscrepancyHistoryDao,matchResultHistoryDao,summaryMatchDao,accountDao,termsDao,dateTimeDao,taxDataDao,DBSequenceLoaderDao,glOptionsDao,financialPostingAccountDao,supplierBasedCreditNoteMatchCandidateDao,matchDocumentToleranceDao,shipSkuDao,supplierOptionsDao,receiptDao,invoiceDetailDao,nonMerchandiseEntryDao,ediRejectDocumentDetailAllowTaxDao,invoiceDetailTaxDao,matchCostVarianceHistoryDao,ediRejectDocumentDao,dealDynamicSegmentsDao,itemTaxAuditDao,creditNoteQtyDiscrepancyDao,financialsAPStageDao,receiptItemPostingDao,ediRejectDocumentNonMerchTaxDao,varianceDao,itemSupCountryDao,orderLocationDao,creditNoteCostDiscrepancyDao,dealDetailDao,dynamicMappingDao,matchQtyVarianceDao,partiallyMatchedReceiptDao,ediRejectDocumentNonMerchDao,documentHoldingDao,stageComplexDealDao,fixedDealDao,matchDocHistoryDao,parentNonMerchDao,matchPoolKeyConfigDao,orderDao,qtyDiscrepancyDao,taxDiscrepancyDao,documentDetailDao,matchAttemptDao,applicationUserDao,documentVatDao,ediRejectDocumentDetailAllowDao,orderItemTaxAuditDao,financialPostingDao,matchCostVarianceDao,invoiceDetailAllowanceDao,documentMatchedCreditNoteDiscrepancyWriteOffPostingService,documentMatchedReleasedCreditNotePostingService,documentPrepayInvoicePostingService,receiptWriteOffPostingService,financialPostingService,documentMatchedNonHeldCreditNotePostingService,documentApprovedCreditNotePostingService,documentCreditMemoPostingService,documentInvoicePostingService,documentMatchedUnpersistedCreditNoteVWTPostingService,documentNonMerchandisePostingService,financialPostingStagingService,documentDebitMemoPostingService,documentPrepayParentInvoicePostingService,webServiceConsumerService,taxService,ediDocumentService,receiptWriteOffHistoryService,receiptService,taxDiscrepancyService,dynamicMappingService,varianceService,receiverAdjustmentService,financialPostingAccountService,financialApplicationIntegrationService,fixedDealUploadService,dealDynamicSegmentsService,reasonCodeActionRollupService,dealService,ediRejectService,invoiceDetailService,systemOptionsService,invoiceMaintenanceService,documentDetailService,taxDiscrepancyResolutionService,termsService,vatDiscrepancyService,applicationUserService,parentInvoiceService,complexDealUploadService,documentHoldingService,varianceResolutionService,accountService,log4jLoggingService,documentService,periodService,itemSupplierService,dateTimeService,nonMerchandiseEntryService,supplierOptionsService,autoDiscrepancyResolutionService,supplierBasedAutoMatchTaskExecutionService,detailMatchService,creditNoteMatchAttemptSummaryLevelService,creditNoteMatchAttemptDetailLevelService,creditNoteAutoMatchInitService,autoMatchService,headerOnlyInvoiceTaxValidationService,matchService,summaryMatchService,matchStatusService,creditNoteVarianceService,creditNoteMatchAttemptOneToOneLevelService,creditNoteSummaryMatchService,creditNoteAutomatchService,creditNoteDetailMatchService,manualGroupUIService,quantityReviewListUIService,discrepancyResolutionUIService,priceReviewCostSelectionLoadUIService,priceReviewListUIService,logger,toStringStyleLogger,systemDate,springContext,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,daoFactory,reIMSystemOptionsService,invoiceAdvSearchService,serviceFactory,discrepancyPurgeService]; root of factory hierarchy
                      2012-11-27 11:20:24,188 INFO [main] oracle.retail.reim.batch.BatchProcessor - Executing BatchPurgeBatch...
                      2012-11-27 11:20:29,123 ERROR [main] com.oracle.retail.integration.common.security.credential.CredentialStoreManager - The credential doesn't exist for the given key/userNameAlias(ADMIN/RETEK).
                      2012-11-27 11:20:29,125 ERROR [main] com.oracle.retail.integration.common.security.credential.CredentialStoreManager - Unable to obtain the userName for the given key/userNameAlias(ADMIN/RETEK).
                      java.lang.IllegalArgumentException: The credential doesn't exist for the given key/userNameAlias(ADMIN/RETEK).
                      at com.oracle.retail.integration.common.security.credential.CredentialStoreManager.getUserName(CredentialStoreManager.java:886)
                      at oracle.retail.reim.utils.CredentialStoreAccessor.getUserName(CredentialStoreAccessor.java:44)
                      at com.retek.reim.batch.BatchUtils.start(BatchUtils.java:269)
                      at com.retek.reim.purge.BatchPurge.main(BatchPurge.java:43)
                      at oracle.retail.reim.batch.jobs.BatchPurgeBatch.performBatch(BatchPurgeBatch.java:17)
                      at oracle.retail.reim.batch.ABatchProcess.execute(ABatchProcess.java:34)
                      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:597)
                      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
                      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
                      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                      at $Proxy21.execute(Unknown Source)
                      at oracle.retail.reim.batch.BatchProcessor.executeBatch(BatchProcessor.java:41)
                      at oracle.retail.reim.batch.BatchRunner.configureAndRunBatch(BatchRunner.java:65)
                      at oracle.retail.reim.batch.BatchRunner.main(BatchRunner.java:26)
                      2012-11-27 11:20:29,127 ERROR [main] com.retek.reim.purge.BatchPurge -
                      oracle.retail.reim.batch.BatchExecutionException: java.lang.RuntimeException: Unable to obtain the userName for the given key/userNameAlias(ADMIN/RETEK).
                      at com.retek.reim.batch.BatchUtils.start(BatchUtils.java:285)
                      at com.retek.reim.purge.BatchPurge.main(BatchPurge.java:43)
                      at oracle.retail.reim.batch.jobs.BatchPurgeBatch.performBatch(BatchPurgeBatch.java:17)
                      at oracle.retail.reim.batch.ABatchProcess.execute(ABatchProcess.java:34)
                      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:597)
                      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
                      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
                      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                      at $Proxy21.execute(Unknown Source)
                      at oracle.retail.reim.batch.BatchProcessor.executeBatch(BatchProcessor.java:41)
                      at oracle.retail.reim.batch.BatchRunner.configureAndRunBatch(BatchRunner.java:65)
                      at oracle.retail.reim.batch.BatchRunner.main(BatchRunner.java:26)
                      Caused by: java.lang.RuntimeException: Unable to obtain the userName for the given key/userNameAlias(ADMIN/RETEK).
                      at com.oracle.retail.integration.common.security.credential.CredentialStoreManager.getUserName(CredentialStoreManager.java:903)
                      at oracle.retail.reim.utils.CredentialStoreAccessor.getUserName(CredentialStoreAccessor.java:44)
                      at com.retek.reim.batch.BatchUtils.start(BatchUtils.java:269)
                      ... 17 more
                      Caused by: java.lang.IllegalArgumentException: The credential doesn't exist for the given key/userNameAlias(ADMIN/RETEK).
                      at com.oracle.retail.integration.common.security.credential.CredentialStoreManager.getUserName(CredentialStoreManager.java:886)
                      ... 19 more
                      Done
                      Execution time (seconds) = 0.011
                      2012-11-27 11:20:29,133 ERROR [main] com.retek.reim.purge.BatchPurge - Aborted in init.
                      2012-11-27 11:20:29,137 INFO [main] oracle.retail.reim.batch.BatchProcessor - Batch completed, status: FAILED_INIT (1).
                      2012-11-27 11:20:29,138 INFO [main] oracle.retail.reim.batch.BatchRunner - FAILED_INIT (1) returned from batch process.


                      I am getting the above problem even though i used alias-name or username/pwd can you please help me.

                      Regards
                      Rajkumar

                      Edited by: 972448 on Nov 26, 2012 9:42 PM
                      • 8. Re: Reim Batch issue
                        975451
                        [oracle@retailsols reim-batch]$ ./reimpurge ADMIN/retek PURGE ALL COMMIT
                        2012-11-27 11:20:00,237 INFO [main] oracle.retail.reim.batch.BatchRunner - Running with arguments: [BatchPurgeBatch, ADMIN/retek, PURGE, ALL, COMMIT]
                        2012-11-27 11:20:00,344 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@5f7a8a02: display name [org.springframework.context.support.ClassPathXmlApplicationContext@5f7a8a02]; startup date [Tue Nov 27 11:20:00 IST 2012]; root of context hierarchy
                        2012-11-27 11:20:00,502 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-datasource-config.xml]
                        2012-11-27 11:20:01,215 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-service-config.xml]
                        2012-11-27 11:20:07,875 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-dao-config.xml]
                        2012-11-27 11:20:07,984 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-batch-config.xml]
                        2012-11-27 11:20:08,072 INFO [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/retek/reim/reim-util-config.xml]
                        2012-11-27 11:20:08,850 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@5f7a8a02]: org.springframework.beans.factory.support.DefaultListableBeanFactory@a50a649
                        2012-11-27 11:20:09,531 INFO [main] org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Loading properties file from class path resource [com/retek/reim/reim.properties]
                        2012-11-27 11:20:10,239 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'loginCredentialBean' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                        2012-11-27 11:20:10,243 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#6e84cc09' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                        2012-11-27 11:20:12,026 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#6e84cc09' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                        2012-11-27 11:20:12,028 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#506f9b8e' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                        2012-11-27 11:20:12,029 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#506f9b8e' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                        2012-11-27 11:20:12,049 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'dataSource' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                        2012-11-27 11:20:12,051 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'transactionManager' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                        2012-11-27 11:20:12,060 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean '(inner bean)' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                        2012-11-27 11:20:12,061 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean '(inner bean)' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                        2012-11-27 11:20:12,061 INFO [main] org.springframework.context.support.ClassPathXmlApplicationContext - Bean 'org.springframework.transaction.config.internalTransactionAdvisor' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
                        2012-11-27 11:20:12,149 INFO [main] org.springframework.beans.factory.support.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@a50a649: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,loginCredentialBean,dataSource,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.config.internalTransactionAdvisor,simpleJdbcTemplate,transactionManagerFactory,com.retek.reim.services.SupplierOptionsService#0,com.retek.reim.services.NonMerchandiseDocumentService#0,com.retek.reim.services.ItemSupplierService#0,com.retek.reim.services.matching.CreditNoteMatchStatusService#0,com.retek.reim.services.EdiRejectService#0,com.retek.reim.services.EdiDocumentService#0,com.retek.reim.services.DiscrepancyPurgeService#0,DisputedCreditMemoResolutionRollupBatch,BatchPurgeBatch,FixedDealUploadBatch,CreditNoteAutoMatchBatch,AutoMatchBatch,ReceiptWriteOffBatch,DiscrepancyPurgeBatch,FinancialPostingBatch,EdiUploadBatch,ComplexDealUploadBatch,EdiDownloadBatch,ReasonCodeActionRollupBatch,AccountWorkspacePurgeBatch,FinancialPostingWorkspacePurgeBatch,autoDiscrepancyResolutionDao,costDiscrepancyDao,complexDealDao,receiverUnitAdjustmentDao,taxCalculationDao,ediRejectDocumentDetailTaxDao,creditNoteMatchCompletionDao,costDiscrepancyHistoryDao,matchProcessDao,matchQtyVarianceHistoryDao,docDetailReasonCodesDao,stageFixedDealDao,itemSupplierDao,matchResultDao,documentTaxDao,receiptWriteOffHistoryDao,nonMerchTaxDao,documentDetailRcTaxDao,fixedDealTaxDao,parentNonMerchTaxesDao,invoiceDetailAllowanceTaxDao,resolutionActionDao,matchResultItemDao,creditNoteMatchHistoryDao,ediRejectDocumentTaxDao,financialsGLStageDao,matchResultItemHistoryDao,documentDao,ediRejectDocumentDetailDao,qtyDiscrepancyHistoryDao,matchResultHistoryDao,summaryMatchDao,accountDao,termsDao,dateTimeDao,taxDataDao,DBSequenceLoaderDao,glOptionsDao,financialPostingAccountDao,supplierBasedCreditNoteMatchCandidateDao,matchDocumentToleranceDao,shipSkuDao,supplierOptionsDao,receiptDao,invoiceDetailDao,nonMerchandiseEntryDao,ediRejectDocumentDetailAllowTaxDao,invoiceDetailTaxDao,matchCostVarianceHistoryDao,ediRejectDocumentDao,dealDynamicSegmentsDao,itemTaxAuditDao,creditNoteQtyDiscrepancyDao,financialsAPStageDao,receiptItemPostingDao,ediRejectDocumentNonMerchTaxDao,varianceDao,itemSupCountryDao,orderLocationDao,creditNoteCostDiscrepancyDao,dealDetailDao,dynamicMappingDao,matchQtyVarianceDao,partiallyMatchedReceiptDao,ediRejectDocumentNonMerchDao,documentHoldingDao,stageComplexDealDao,fixedDealDao,matchDocHistoryDao,parentNonMerchDao,matchPoolKeyConfigDao,orderDao,qtyDiscrepancyDao,taxDiscrepancyDao,documentDetailDao,matchAttemptDao,applicationUserDao,documentVatDao,ediRejectDocumentDetailAllowDao,orderItemTaxAuditDao,financialPostingDao,matchCostVarianceDao,invoiceDetailAllowanceDao,documentMatchedCreditNoteDiscrepancyWriteOffPostingService,documentMatchedReleasedCreditNotePostingService,documentPrepayInvoicePostingService,receiptWriteOffPostingService,financialPostingService,documentMatchedNonHeldCreditNotePostingService,documentApprovedCreditNotePostingService,documentCreditMemoPostingService,documentInvoicePostingService,documentMatchedUnpersistedCreditNoteVWTPostingService,documentNonMerchandisePostingService,financialPostingStagingService,documentDebitMemoPostingService,documentPrepayParentInvoicePostingService,webServiceConsumerService,taxService,ediDocumentService,receiptWriteOffHistoryService,receiptService,taxDiscrepancyService,dynamicMappingService,varianceService,receiverAdjustmentService,financialPostingAccountService,financialApplicationIntegrationService,fixedDealUploadService,dealDynamicSegmentsService,reasonCodeActionRollupService,dealService,ediRejectService,invoiceDetailService,systemOptionsService,invoiceMaintenanceService,documentDetailService,taxDiscrepancyResolutionService,termsService,vatDiscrepancyService,applicationUserService,parentInvoiceService,complexDealUploadService,documentHoldingService,varianceResolutionService,accountService,log4jLoggingService,documentService,periodService,itemSupplierService,dateTimeService,nonMerchandiseEntryService,supplierOptionsService,autoDiscrepancyResolutionService,supplierBasedAutoMatchTaskExecutionService,detailMatchService,creditNoteMatchAttemptSummaryLevelService,creditNoteMatchAttemptDetailLevelService,creditNoteAutoMatchInitService,autoMatchService,headerOnlyInvoiceTaxValidationService,matchService,summaryMatchService,matchStatusService,creditNoteVarianceService,creditNoteMatchAttemptOneToOneLevelService,creditNoteSummaryMatchService,creditNoteAutomatchService,creditNoteDetailMatchService,manualGroupUIService,quantityReviewListUIService,discrepancyResolutionUIService,priceReviewCostSelectionLoadUIService,priceReviewListUIService,logger,toStringStyleLogger,systemDate,springContext,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,daoFactory,reIMSystemOptionsService,invoiceAdvSearchService,serviceFactory,discrepancyPurgeService]; root of factory hierarchy
                        2012-11-27 11:20:24,188 INFO [main] oracle.retail.reim.batch.BatchProcessor - Executing BatchPurgeBatch...
                        2012-11-27 11:20:29,123 ERROR [main] com.oracle.retail.integration.common.security.credential.CredentialStoreManager - The credential doesn't exist for the given key/userNameAlias(ADMIN/RETEK).
                        2012-11-27 11:20:29,125 ERROR [main] com.oracle.retail.integration.common.security.credential.CredentialStoreManager - Unable to obtain the userName for the given key/userNameAlias(ADMIN/RETEK).
                        java.lang.IllegalArgumentException: The credential doesn't exist for the given key/userNameAlias(ADMIN/RETEK).
                        at com.oracle.retail.integration.common.security.credential.CredentialStoreManager.getUserName(CredentialStoreManager.java:886)
                        at oracle.retail.reim.utils.CredentialStoreAccessor.getUserName(CredentialStoreAccessor.java:44)
                        at com.retek.reim.batch.BatchUtils.start(BatchUtils.java:269)
                        at com.retek.reim.purge.BatchPurge.main(BatchPurge.java:43)
                        at oracle.retail.reim.batch.jobs.BatchPurgeBatch.performBatch(BatchPurgeBatch.java:17)
                        at oracle.retail.reim.batch.ABatchProcess.execute(ABatchProcess.java:34)
                        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                        at java.lang.reflect.Method.invoke(Method.java:597)
                        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
                        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
                        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                        at $Proxy21.execute(Unknown Source)
                        at oracle.retail.reim.batch.BatchProcessor.executeBatch(BatchProcessor.java:41)
                        at oracle.retail.reim.batch.BatchRunner.configureAndRunBatch(BatchRunner.java:65)
                        at oracle.retail.reim.batch.BatchRunner.main(BatchRunner.java:26)
                        2012-11-27 11:20:29,127 ERROR [main] com.retek.reim.purge.BatchPurge -
                        oracle.retail.reim.batch.BatchExecutionException: java.lang.RuntimeException: Unable to obtain the userName for the given key/userNameAlias(ADMIN/RETEK).
                        at com.retek.reim.batch.BatchUtils.start(BatchUtils.java:285)
                        at com.retek.reim.purge.BatchPurge.main(BatchPurge.java:43)
                        at oracle.retail.reim.batch.jobs.BatchPurgeBatch.performBatch(BatchPurgeBatch.java:17)
                        at oracle.retail.reim.batch.ABatchProcess.execute(ABatchProcess.java:34)
                        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                        at java.lang.reflect.Method.invoke(Method.java:597)
                        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
                        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
                        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                        at $Proxy21.execute(Unknown Source)
                        at oracle.retail.reim.batch.BatchProcessor.executeBatch(BatchProcessor.java:41)
                        at oracle.retail.reim.batch.BatchRunner.configureAndRunBatch(BatchRunner.java:65)
                        at oracle.retail.reim.batch.BatchRunner.main(BatchRunner.java:26)
                        Caused by: java.lang.RuntimeException: Unable to obtain the userName for the given key/userNameAlias(ADMIN/RETEK).
                        at com.oracle.retail.integration.common.security.credential.CredentialStoreManager.getUserName(CredentialStoreManager.java:903)
                        at oracle.retail.reim.utils.CredentialStoreAccessor.getUserName(CredentialStoreAccessor.java:44)
                        at com.retek.reim.batch.BatchUtils.start(BatchUtils.java:269)
                        ... 17 more
                        Caused by: java.lang.IllegalArgumentException: The credential doesn't exist for the given key/userNameAlias(ADMIN/RETEK).
                        at com.oracle.retail.integration.common.security.credential.CredentialStoreManager.getUserName(CredentialStoreManager.java:886)
                        ... 19 more
                        Done
                        Execution time (seconds) = 0.011
                        2012-11-27 11:20:29,133 ERROR [main] com.retek.reim.purge.BatchPurge - Aborted in init.
                        2012-11-27 11:20:29,137 INFO [main] oracle.retail.reim.batch.BatchProcessor - Batch completed, status: FAILED_INIT (1).
                        2012-11-27 11:20:29,138 INFO [main] oracle.retail.reim.batch.BatchRunner - FAILED_INIT (1) returned from batch process.


                        In the above i used username/pwd which are used to login into the application,even though i am getting the problem

                        Regards
                        Rajkumar
                        • 9. Re: Reim Batch issue
                          977408
                          2012-11-27 11:20:29,125 ERROR [main] com.oracle.retail.integration.common.security.credential.CredentialStoreManager - Unable to obtain the userName for the given key/userNameAlias(ADMIN/RETEK).
                          java.lang.IllegalArgumentException: The credential doesn't exist for the given key/userNameAlias(ADMIN/RETEK).


                          so as per the above error, the credentials are missing in the IM_USER_AUTHORIZATION and IM_BUSINESS_ROLE_MEMBER tables, please check the tables carefully and also check the role no assigned for ADMIN user.it should be 10 or 11.

                          Edited by: 974405 on Dec 1, 2012 10:15 AM
                          • 10. Re: Reim Batch issue
                            Andrey_Z
                            Hi,

                            Did you have the correct parameters: csm.wallet.path, and csm.wallet.partition.name in your $WLS_DOMAIN/retail/reim13/batch/WEB-INF/classes/com/retek/reim/reim.properties
                            file? You can check it by dump_credential.sh tool.
                            • 11. Re: Reim Batch issue
                              975451
                              USER1     User1     Test     0870CA889A953E7BEFCE95879AC39EB5C7C443EB     en     US     
                              ADMIN     User      Admin     EAF44E207F3E52845C7587412447E0D119FD4A4A     en     US     
                              ALAIN.FRECON     Frecon     Alain     C166C1334D8A5CCDFAAC714F749711C345748A10 en     US     
                              REIM      REIM     REIM      267738B26B137B69A7583DC01AB5F54C316CD36D      en     SA     
                              RMS     rms     rms     A59E4C07D090B6AB1F79FE2CD52B848320AAEF36     en     US     

                              Above table is Im_user_authorization


                              ADMIN     9000
                              ALAIN.FRECON     9000
                              REIM     9000
                              RMS     9000
                              USER1     9000



                              Above table is IM_BUSINESS_ROLES


                              ADMIN     9000
                              ALAIN.FRECON     9000
                              REIM     9000
                              RMS     9000
                              USER1     9000


                              Above table is IM_BUSINESS_ROLE_MEMBER


                              We have the correct credentials even though we are unable to run batches

                              Regards
                              Rajkumar

                              Edited by: 972448 on Dec 4, 2012 9:39 PM