This discussion is archived
11 Replies Latest reply: Dec 4, 2012 9:42 PM by 975451 RSS

Reim Batch issue

975451 Newbie
Currently Being Moderated
[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) Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    Hi,

    Give the stacktrace.

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

    Regards
    Rajkumar
  • 6. Re: Reim Batch issue
    praveenps Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    [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 Newbie
    Currently Being Moderated
    [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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points