Giter VIP home page Giter VIP logo

Comments (3)

GoogleCodeExporter avatar GoogleCodeExporter commented on May 24, 2024

Original comment by [email protected] on 9 Nov 2012 at 8:12

  • Changed state: Accepted

from oracle-ddl2svn.

GoogleCodeExporter avatar GoogleCodeExporter commented on May 24, 2024
Stacktrace from scheme2ddl version 2.0

Encountered an error executing the step
[13:30:41][java] org.springframework.jdbc.UncategorizedSQLException: 
CallableStatementCallback; uncategorized SQLException for SQL [DECLARE
[13:30:41][java]  callstr VARCHAR2(4096);
[13:30:41][java] BEGIN
[13:30:42][java]   dbms_job.user_export(85441, callstr);
[13:30:42][java] :done := callstr; END;]; SQL state [99999]; error code 
[23421]; ORA-23421: job number 85441 is not a job in the job queue
[13:30:42][java] ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
[13:30:42][java] ORA-06512: at "SYS.DBMS_IJOB", line 592
[13:30:42][java] ORA-06512: at "SYS.DBMS_JOB", line 294
[13:30:42][java] ORA-06512: at line 4
[13:30:42][java] ; nested exception is java.sql.SQLException: ORA-23421: job 
number 85441 is not a job in the job queue
[13:30:42][java] ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
[13:30:42][java] ORA-06512: at "SYS.DBMS_IJOB", line 592
[13:30:42][java] ORA-06512: at "SYS.DBMS_JOB", line 294
[13:30:42][java] ORA-06512: at line 4
[13:30:42][java] 
[13:30:42][java]    at 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translat
e(AbstractFallbackSQLExceptionTranslator.java:83)
[13:30:42][java]    at 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translat
e(AbstractFallbackSQLExceptionTranslator.java:80)
[13:30:42][java]    at 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translat
e(AbstractFallbackSQLExceptionTranslator.java:80)
[13:30:42][java]    at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:952)
[13:30:42][java]    at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:964)
[13:30:42][java]    at 
com.googlecode.scheme2ddl.dao.UserObjectDaoImpl.findDbmsJobDDL(UserObjectDaoImpl
.java:110)
[13:30:42][java]    at 
com.googlecode.scheme2ddl.UserObjectProcessor.map2Ddl(UserObjectProcessor.java:6
2)
[13:30:42][java]    at 
com.googlecode.scheme2ddl.UserObjectProcessor.process(UserObjectProcessor.java:3
0)
[13:30:42][java]    at 
com.googlecode.scheme2ddl.UserObjectProcessor.process(UserObjectProcessor.java:1
6)
[13:30:42][java]    at 
org.springframework.batch.core.step.item.SimpleChunkProcessor.doProcess(SimpleCh
unkProcessor.java:125)
[13:30:42][java]    at 
org.springframework.batch.core.step.item.SimpleChunkProcessor.transform(SimpleCh
unkProcessor.java:291)
[13:30:42][java]    at 
org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChun
kProcessor.java:190)
[13:30:42][java]    at 
org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrien
tedTasklet.java:74)
[13:30:42][java]    at 
org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback
.doInTransaction(TaskletStep.java:386)
[13:30:42][java]    at 
org.springframework.transaction.support.TransactionTemplate.execute(TransactionT
emplate.java:128)
[13:30:42][java]    at 
org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(Taskl
etStep.java:264)
[13:30:42][java]    at 
org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInItera
tion(StepContextRepeatCallback.java:76)
[13:30:42][java]    at 
org.springframework.batch.repeat.support.TaskExecutorRepeatTemplate$ExecutingRun
nable.run(TaskExecutorRepeatTemplate.java:258)
[13:30:42][java]    at 
org.springframework.core.task.SimpleAsyncTaskExecutor$ConcurrencyThrottlingRunna
ble.run(SimpleAsyncTaskExecutor.java:192)
[13:30:42][java]    at java.lang.Thread.run(Thread.java:662)
[13:30:42][java] Caused by: java.sql.SQLException: ORA-23421: job number 85441 
is not a job in the job queue
[13:30:42][java] ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
[13:30:42][java] ORA-06512: at "SYS.DBMS_IJOB", line 592
[13:30:42][java] ORA-06512: at "SYS.DBMS_JOB", line 294
[13:30:42][java] ORA-06512: at line 4

Original comment by [email protected] on 22 Nov 2012 at 9:36

from oracle-ddl2svn.

GoogleCodeExporter avatar GoogleCodeExporter commented on May 24, 2024
fixed in release 2.0.1 

Original comment by [email protected] on 22 Nov 2012 at 10:05

  • Changed state: Fixed

from oracle-ddl2svn.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.