Comments (3)
Original comment by [email protected]
on 9 Nov 2012 at 8:12
- Changed state: Accepted
from oracle-ddl2svn.
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.
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)
- PUBLIC DB_LINKS HOT 1
- Exception in thread "main" java.util.zip.ZipException: ═х єфрхЄё эрщЄш єърчрээ√ щ Їрщы HOT 3
- exclude_map_suffixes HOT 3
- rename PUBLIC_DATABASE LINK to PUBLIC DATABASE LINK in config HOT 1
- ORA-31603: объект "SYS_PLSQL_77728_DUMMY_1" с типом TYPE не найден в схеме HOT 6
- Add --parallel option HOT 1
- Stop ddl2svn if exception in sheme2ddl HOT 1
- Add support for exporting job objects craeted with SYS.DBMS_SCHEDULER.CREATE_JOB HOT 2
- Add support for exporting dbms_job created with sys.dbms_job.submit HOT 2
- ORA-31600: invalid input value TABLE_PARTITION for parameter OBJECT_TYPE in function GET_DDL HOT 6
- ORA-31603: object "XXXXX" of type DB_LINK not found in schema "PUBLIC" HOT 30
- ORA-31600: invalid input value LOB for parameter OBJECT_TYPE in function GET_DDL HOT 2
- More verbose error logging HOT 2
- BadSqlGrammarException in REFRESH GROUP HOT 3
- Add to gradle.build task with publish release to googlecode.com HOT 1
- DDL_Get fails on queue object HOT 3
- ORA-31600: invalid input value PACKAGE BODY for parameter OBJECT_TYPE in function GET_DDL
- add support for git
- .svn folder clears with workdir on windows HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from oracle-ddl2svn.