This discussion is archived
4 Replies Latest reply: Jun 3, 2013 4:40 AM by user647184 RSS

SOA Server issue

972017 Newbie
Currently Being Moderated
Hi ,


when i test my AIA services in EM all Instances are in running state only and unable to poll the data from DB also i get below error from SOA server End:please any body help me on this issue..........

<May 31, 2013 4:36:17 PM GMT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "LifeCycleDataSource": ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "SIEBEL"."CX_S_AUD_TXNADT"."LAST_UPD_BY" (actual: 18, maximum: 15)
ORA-06512: at "SIEBEL.INS_CX_S_AUD_TXNADT", line 62
ORA-06512: at line 32
>
<May 31, 2013 4:36:19 PM GMT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "LifeCycleDataSource": ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "SIEBEL"."CX_S_AUD_TXNADT"."LAST_UPD_BY" (actual: 18, maximum: 15)
ORA-06512: at "SIEBEL.INS_CX_S_AUD_TXNADT", line 62
ORA-06512: at line 32
>
[TopLink Warning]: 2013.05.31 16:36:21.147--ClientSession(1605064101)--Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.5.0) (Build 110305)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-01653: unable to extend table DEV_SOAINFRA.COMPOSITE_INSTANCE_FAULT by 1024 in tablespace DEV_SOAINFRA

Error Code: 1653
<May 31, 2013 4:36:30 PM GMT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "LifeCycleDataSource": ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "SIEBEL"."CX_S_AUD_TXNADT"."LAST_UPD_BY" (actual: 18, maximum: 15)
ORA-06512: at "SIEBEL.INS_CX_S_AUD_TXNADT", line 62
ORA-06512: at line 32
>
[TopLink Warning]: 2013.05.31 16:36:31.245--ClientSession(48888088)--Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.5.0) (Build 110305)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-01653: unable to extend table DEV_SOAINFRA.COMPOSITE_INSTANCE_FAULT by 1024 in tablespace DEV_SOAINFRA

Error Code: 1653
<May 31, 2013 4:36:32 PM GMT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "LifeCycleDataSource": ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "SIEBEL"."CX_S_AUD_TXNADT"."LAST_UPD_BY" (actual: 18, maximum: 15)
ORA-06512: at "SIEBEL.INS_CX_S_AUD_TXNADT", line 62
ORA-06512: at line 32
>
<May 31, 2013 4:36:34 PM GMT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "LifeCycleDataSource": ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "SIEBEL"."CX_S_AUD_TXNADT"."LAST_UPD_BY" (actual: 18, maximum: 15)
ORA-06512: at "SIEBEL.INS_CX_S_AUD_TXNADT", line 62
ORA-06512: at line 32
>
<May 31, 2013 4:36:37 PM GMT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "LifeCycleDataSource": ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "SIEBEL"."CX_S_AUD_TXNADT"."LAST_UPD_BY" (actual: 18, maximum: 15)
ORA-06512: at "SIEBEL.INS_CX_S_AUD_TXNADT", line 62
ORA-06512: at line 32
>
<May 31, 2013 4:36:39 PM GMT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "LifeCycleDataSource": ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "SIEBEL"."CX_S_AUD_TXNADT"."LAST_UPD_BY" (actual: 18, maximum: 15)
ORA-06512: at "SIEBEL.INS_CX_S_AUD_TXNADT", line 62
ORA-06512: at line 32
>
[TopLink Warning]: 2013.05.31 16:36:41.345--ClientSession(1063624828)--Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.5.0) (Build 110305)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-01653: unable to extend table DEV_SOAINFRA.COMPOSITE_INSTANCE_FAULT by 1024 in tablespace DEV_SOAINFRA

Error Code: 1653
<May 31, 2013 4:36:51 PM GMT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "LifeCycleDataSource": ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "SIEBEL"."CX_S_AUD_TXNADT"."LAST_UPD_BY" (actual: 18, maximum: 15)
ORA-06512: at "SIEBEL.INS_CX_S_AUD_TXNADT", line 62
ORA-06512: at line 32
>
[TopLink Warning]: 2013.05.31 16:36:51.857--ClientSession(461470963)--Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.5.0) (Build 110305)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-01653: unable to extend table DEV_SOAINFRA.COMPOSITE_INSTANCE_FAULT by 1024 in tablespace DEV_SOAINFRA

Error Code: 1653
<May 31, 2013 4:36:53 PM GMT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "LifeCycleDataSource": ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "SIEBEL"."CX_S_AUD_TXNADT"."LAST_UPD_BY" (actual: 18, maximum: 15)
ORA-06512: at "SIEBEL.INS_CX_S_AUD_TXNADT", line 62
ORA-06512: at line 32
>

Thanku,
Ram
  • 1. Re: SOA Server issue
    vladodias Guru
    Currently Being Moderated
    ORA-01653: unable to extend table DEV_SOAINFRA.COMPOSITE_INSTANCE_FAULT by 1024 in tablespace DEV_SOAINFRA
    There's an issue with the database...
    Ask the DBAs to have a look at this...
    http://www.dba-oracle.com/t_ora_01653_unable_to_extend_table_string_string_by_string_in_tablespace_string.htm

    Cheers,
    Vlad
  • 2. Re: SOA Server issue
    user647184 Newbie
    Currently Being Moderated
    You will need to extend the tablespace on the table - DEV_SOAINFRA by adding a new .dbf file and to ensure you don't encounter this problem again in the future - set Autoextend to ON.
  • 3. Re: SOA Server issue
    972017 Newbie
    Currently Being Moderated
    Hi thanku for given responce ,

    where can i put - set Autoextend to ON.in weblogic end or in DB please can you give me details on it

    Thanku,
    Ram,

    Edited by: 969014 on Jun 3, 2013 4:38 AM
  • 4. Re: SOA Server issue
    user647184 Newbie
    Currently Being Moderated
    this has to be set at the DB level.

    the querry will be something like - alter tablespace DEV_SOAINFRA add datafile '<PATH TO DB_HOME>/DEV_SOAINFRA01.dbf' size 1024M autoextend on;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points