4 Replies Latest reply on Jun 3, 2013 11:40 AM by user647184-Oracle

    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