Advertisement
mugs

ORA-27465: invalid value

May 4th, 2016
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 6.19 KB | None | 0 0
  1. SEVERE 5/4/16 3:17 PM: liquibase: liquibase/kfs/master.xml: liquibase/kfs/schema.xml::NWUKFS-2781-3::za-kfs: Change SET liquibase/kfs/schema.xml::NWUKFS-2781-3::za-kfs failed.  Error: Error executing SQL BEGIN
  2.     DBMS_SCHEDULER.CREATE_JOB (
  3.             job_name => '"KULDEV".CM_AST_PAYMENT_DATE_JOB',
  4.             Job_Type => 'STORED_PROCEDURE',
  5.             job_action => 'KULDEV.cm_ast_payment_date_populate',
  6.             Number_Of_Arguments => 0,
  7.             Start_Date => TO_TIMESTAMP_TZ('2016-03-14 10:00:00.468668000 AFRICA/HARARE','YYYY-MM-DD HH24:MI:SS.FF TZR'),
  8.             repeat_interval => 'FREQ=DAILY;BYHOUR=23;BYMINUTE=55;BYSECOND=0',
  9.             end_date => NULL,
  10.             enabled => FALSE,
  11.             auto_drop => FALSE,
  12.             comments => '');
  13.  
  14.     DBMS_SCHEDULER.SET_ATTRIBUTE(
  15.              name => '"KULDEV".CM_AST_PAYMENT_DATE_JOB',
  16.              attribute => 'logging_level', VALUE => DBMS_SCHEDULER.LOGGING_OFF);
  17.  
  18.  
  19.     DBMS_SCHEDULER.enable(
  20.              name => '"KULDEV".CM_AST_PAYMENT_DATE_JOB');
  21. END;: ORA-27465: invalid VALUE FREQ=DAILY;BYHOUR=23;BYMINUTE=55;BYSECOND=0 FOR attribute REPEAT_INTERVAL
  22. ORA-06512: AT "SYS.DBMS_ISCHED", line 124
  23. ORA-06512: AT "SYS.DBMS_SCHEDULER", line 271
  24. ORA-06512: AT line 2
  25.  
  26. liquibase.EXCEPTION.DatabaseException: Error executing SQL BEGIN
  27.     DBMS_SCHEDULER.CREATE_JOB (
  28.             job_name => '"KULDEV".CM_AST_PAYMENT_DATE_JOB',
  29.             Job_Type => 'STORED_PROCEDURE',
  30.             job_action => 'KULDEV.cm_ast_payment_date_populate',
  31.             Number_Of_Arguments => 0,
  32.             Start_Date => TO_TIMESTAMP_TZ('2016-03-14 10:00:00.468668000 AFRICA/HARARE','YYYY-MM-DD HH24:MI:SS.FF TZR'),
  33.             repeat_interval => 'FREQ=DAILY;BYHOUR=23;BYMINUTE=55;BYSECOND=0',
  34.             end_date => NULL,
  35.             enabled => FALSE,
  36.             auto_drop => FALSE,
  37.             comments => '');
  38.  
  39.     DBMS_SCHEDULER.SET_ATTRIBUTE(
  40.              name => '"KULDEV".CM_AST_PAYMENT_DATE_JOB',
  41.              attribute => 'logging_level', VALUE => DBMS_SCHEDULER.LOGGING_OFF);
  42.  
  43.  
  44.     DBMS_SCHEDULER.enable(
  45.              name => '"KULDEV".CM_AST_PAYMENT_DATE_JOB');
  46. END;: ORA-27465: invalid VALUE FREQ=DAILY;BYHOUR=23;BYMINUTE=55;BYSECOND=0 FOR attribute REPEAT_INTERVAL
  47. ORA-06512: AT "SYS.DBMS_ISCHED", line 124
  48. ORA-06512: AT "SYS.DBMS_SCHEDULER", line 271
  49. ORA-06512: AT line 2
  50.  
  51.     AT liquibase.executor.jvm.JdbcExecutor.EXECUTE(JdbcExecutor.JAVA:62)
  52.     AT liquibase.executor.jvm.JdbcExecutor.EXECUTE(JdbcExecutor.JAVA:122)
  53.     AT liquibase.database.AbstractJdbcDatabase.EXECUTE(AbstractJdbcDatabase.JAVA:1206)
  54.     AT liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.JAVA:1189)
  55.     AT liquibase.changelog.ChangeSet.EXECUTE(ChangeSet.JAVA:518)
  56.     AT liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.JAVA:43)
  57.     AT liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.JAVA:70)
  58.     AT liquibase.Liquibase.UPDATE(Liquibase.JAVA:195)
  59.     AT liquibase.Liquibase.UPDATE(Liquibase.JAVA:174)
  60.     AT org.liquibase.maven.plugins.LiquibaseUpdate.doUpdate(LiquibaseUpdate.JAVA:31)
  61.     AT org.liquibase.maven.plugins.AbstractLiquibaseUpdateMojo.performLiquibaseTask(AbstractLiquibaseUpdateMojo.JAVA:24)
  62.     AT org.liquibase.maven.plugins.AbstractLiquibaseMojo.EXECUTE(AbstractLiquibaseMojo.JAVA:367)
  63.     AT org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.JAVA:101)
  64.     AT org.apache.maven.lifecycle.internal.MojoExecutor.EXECUTE(MojoExecutor.JAVA:209)
  65.     AT org.apache.maven.lifecycle.internal.MojoExecutor.EXECUTE(MojoExecutor.JAVA:153)
  66.     AT org.apache.maven.lifecycle.internal.MojoExecutor.EXECUTE(MojoExecutor.JAVA:145)
  67.     AT org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.JAVA:84)
  68.     AT org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.JAVA:59)
  69.     AT org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.JAVA:183)
  70.     AT org.apache.maven.lifecycle.internal.LifecycleStarter.EXECUTE(LifecycleStarter.JAVA:161)
  71.     AT org.apache.maven.DefaultMaven.doExecute(DefaultMaven.JAVA:320)
  72.     AT org.apache.maven.DefaultMaven.EXECUTE(DefaultMaven.JAVA:156)
  73.     AT org.apache.maven.cli.MavenCli.EXECUTE(MavenCli.JAVA:537)
  74.     AT org.apache.maven.cli.MavenCli.doMain(MavenCli.JAVA:196)
  75.     AT org.apache.maven.cli.MavenCli.main(MavenCli.JAVA:141)
  76.     AT sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  77.     AT sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.JAVA:57)
  78.     AT sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.JAVA:43)
  79.     AT JAVA.lang.reflect.Method.invoke(Method.JAVA:606)
  80.     AT org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.JAVA:290)
  81.     AT org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.JAVA:230)
  82.     AT org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.JAVA:409)
  83.     AT org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.JAVA:352)
  84. Caused BY: JAVA.SQL.SQLException: ORA-27465: invalid VALUE FREQ=DAILY;BYHOUR=23;BYMINUTE=55;BYSECOND=0 FOR attribute REPEAT_INTERVAL
  85. ORA-06512: AT "SYS.DBMS_ISCHED", line 124
  86. ORA-06512: AT "SYS.DBMS_SCHEDULER", line 271
  87. ORA-06512: AT line 2
  88.  
  89.     AT oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.JAVA:445)
  90.     AT oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.JAVA:396)
  91.     AT oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.JAVA:879)
  92.     AT oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.JAVA:450)
  93.     AT oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.JAVA:192)
  94.     AT oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.JAVA:531)
  95.     AT oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.JAVA:193)
  96.     AT oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.JAVA:1033)
  97.     AT oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.JAVA:1329)
  98.     AT oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.JAVA:1909)
  99.     AT oracle.jdbc.driver.OracleStatement.EXECUTE(OracleStatement.JAVA:1871)
  100.     AT oracle.jdbc.driver.OracleStatementWrapper.EXECUTE(OracleStatementWrapper.JAVA:318)
  101.     AT liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.JAVA:310)
  102.     AT liquibase.executor.jvm.JdbcExecutor.EXECUTE(JdbcExecutor.JAVA:55)
  103.     ... 32 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement