4 Replies Latest reply: Jun 3, 2013 6:40 AM by user647184 RSS

    SOA Server issue

    972017
      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
          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
            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
              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
                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;