10 Known Issues - Resolutions

This topic describes the known issues encountered while using the application and its resolutions.

obscfcm-instruments-receivables-services

Troubleshooting deployment failure in obscfcm-instruments-receivables-services.war. This failure is occuring due to duplicate values getting created in the OB PAYMENT TW for the 510.114.9.5.0.2.051011424.28.0.sql.

Deployment Error –

Error is because data issue in table :-mum-1922.snbomprshared1.gbucdsint02bom.oraclevcn.com:1521/OBSCF (Oracle 19.1)
07:56:49:503 | obscfcm-instruments-receivables-services | | | | | | WARN | [,] | o.f.c.i.d.b.Database.warn | Flyway upgrade recommended: Oracle 19.1 is newer than this version of Flyway and support has not been tested. The latest supported version of Oracle is 19.0.
07:56:49:619 | obscfcm-instruments-receivables-services | | | | | | WARN | [,] | o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext.refresh | Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'purchaseOrderProcessingBatchConfig': Unsatisfied dependency expressed through field 'jobRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'executeDomain' defined in class path resource [oracle/fsgbu/plato/flyway/FlywayConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.flywaydb.core.Flyway]: Factory method 'domainFlywayInit' threw exception; nested exception is org.flywaydb.core.api.exception.FlywayValidateException: Validate failed: Migrations have failed validation

Detected failed migration to version 510.114.9.5.0.2.051011424.28.0 (OB PAYMENT TW).
Please remove any half-completed changes then run repair to fix the schema history.
Need more flexibility with validation rules? Learn more:  https://rd.gt/3AbJUZE
07:56:49:648 | obscfcm-instruments-receivables-services | | | | | | INFO | [,] | o.s.b.a.l.ConditionEvaluationReportLoggingListener.logMessage |Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
07:56:49:671 | obscfcm-instruments-receivables-services | | | | | | ERROR | [,] | o.s.b.SpringApplication.reportFailure | Application run failed
org.flywaydb.core.api.exception.FlywayValidateException: Validate failed: Migrations have failed validation

Detected failed migration to version 510.114.9.5.0.2.051011424.28.0 (OB PAYMENT TW).
Please remove any half-completed changes then run repair to fix the schema history.
Need more flexibility with validation rules? Learn more:  https://rd.gt/3AbJUZE
at org.flywaydb.core.Flyway$1.execute(Flyway.java:130)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:124)
at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:205
Resolution –
  1. Delete the entry with status 0 in the Flyway history table under OBSCFCM_INSTRUMENTS schema.
  2. Run the following scripts on the OBSCFCM_INSTRUMENTS schema.
    DELETE FROM OB_PAYMENT_TW WHERE ID NOT IN ( SELECT MAX(ID) FROM OB_PAYMENT_TW GROUP BY PAYMENT_NUMBER,PAYMENT_MODE,SEQ_NO);
    DELETE FROM OB_PAYMENT WHERE ID NOT IN ( SELECT MAX(ID) FROM OB_PAYMENT GROUP BY PAYMENT_NUMBER,PAYMENT_MODE,SEQ_NO);
    Delete from obscfcm_instruments.OB_PAYMENT_TW where id in ( SELECT y.id FROM obscfcm_instruments.OB_PAYMENT_TW y INNER JOIN (SELECT PAYMENT_NUMBER,PAYMENT_MODE,SEQ_NO, COUNT(*) AS CountOf FROM obscfcm_instruments.OB_PAYMENT_TW GROUP BY PAYMENT_NUMBER,PAYMENT_MODE,SEQ_NO HAVING COUNT(*)>1) dt ON y.PAYMENT_NUMBER=dt.PAYMENT_NUMBER AND y.PAYMENT_MODE=dt.PAYMENT_MODE AND y.SEQ_NO=dt.SEQ_NO );
    commit;
    
  3. Start the obscfcm-instruments-receivables-services application in the Weblogic.