search

term73 / oracle-ddl2svn

Automatically exported from code.google.com/p/oracle-ddl2svn
0 stars 0 forks source link

java.sql.SQLException: ORA-23421 dbms_job.user_export(101, callstr) #38

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
INFO: Loading XML bean definitions from file 
[/home/pimenov_pa/sql/scheme2ddl.config.xml]
08.11.2012 9:48:53 
org.springframework.beans.factory.support.DefaultListableBeanFactory 
preInstantiateSingletons
INFO: Pre-instantiating singletons in 
org.springframework.beans.factory.support.DefaultListableBeanFactory@4e044e04: 
defining beans [dataSource,dao,ty
pes_for_getting_DDL,exclude_map_prefixes,exclude_map_pattern,fileWorker,transfor
mParams_for_dbms_metadata,ddlFormatter,worker]; root of factory hierar
chy
start getting of user object list for processing
list.size() before filter = 60
get 60 objects
08.11.2012 9:48:54 
org.springframework.beans.factory.xml.XmlBeanDefinitionReader 
loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource 
[org/springframework/jdbc/support/sql-error-codes.xml]
08.11.2012 9:48:54 org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, 
Oracle, PostgreSQL, Sybase]
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: 
CallableStatementCallback; uncategorized SQLException for SQL [DECLARE
 callstr VARCHAR2(4000);
BEGIN
  dbms_job.user_export(101, callstr);
:done := callstr; END;]; SQL state [99999]; error code [23421]; ORA-23421: 
íîìåð çàäàíèÿ 101 íå ñîîòâåòñòâóåò çàäàíèþ â 
î÷åðåäè çàäàíèé
ORA-06512: íà  "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: íà  "SYS.DBMS_IJOB", line 529
ORA-06512: íà  "SYS.DBMS_JOB", line 284
ORA-06512: íà  line 4
; nested exception is java.sql.SQLException: ORA-23421: íîìåð 
çàäàíèÿ 101 íå ñîîòâåòñòâóåò çàäàíèþ â 
î÷åðåäè çàäàíèé
ORA-06512: íà  "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: íà  "SYS.DBMS_IJOB", line 529
ORA-06512: íà  "SYS.DBMS_JOB", line 284
ORA-06512: íà  line 4

        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:944)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:956)
        at ru.qwazer.scheme2ddl.Dao.findDbmsJobDDL(Unknown Source)
        at ru.qwazer.scheme2ddl.Dao.getPrimaryDDL(Unknown Source)
        at ru.qwazer.scheme2ddl.Dao.fillDDL(Unknown Source)
        at ru.qwazer.scheme2ddl.Worker.work(Unknown Source)
        at ru.qwazer.scheme2ddl.Main.main(Unknown Source)
Caused by: java.sql.SQLException: ORA-23421: íîìåð çàäàíèÿ 101 íå 
ñîîòâåòñòâóåò çàäàíèþ â î÷åðåäè çàäàíèé
ORA-06512: íà  "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: íà  "SYS.DBMS_IJOB", line 529
ORA-06512: íà  "SYS.DBMS_JOB", line 284
ORA-06512: íà  line 4

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
        at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
        at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
        at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4719)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
        at ru.qwazer.scheme2ddl.Dao$CallableStatementCallbackImpl.doInCallableStatement(Unknown Source)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:928)
        ... 6 more

Original issue reported on code.google.com by Pavel.Pimenov@gmail.com on 8 Nov 2012 at 5:54

GoogleCodeExporter commented 8 years ago

Original comment by resh...@gmail.com on 9 Nov 2012 at 8:12

GoogleCodeExporter commented 8 years ago 
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 rt.aresh...@gmail.com on 22 Nov 2012 at 9:36

GoogleCodeExporter commented 8 years ago 
fixed in release 2.0.1

Original comment by resh...@gmail.com on 22 Nov 2012 at 10:05