1 2 Previous Next 16 Replies Latest reply on Aug 14, 2017 10:22 AM by Krishna Hanumantharao

    Composite instances not appearing in EM console

    Prabu

      Hi,

       

      The logs throw the below errors and then all instances stop apperaing in the Emconsole.Not syre how to fix this.The Audit level was Production and there were no sensors on this composite.Not just this composite instead all the composite instances wont shw up in Em console.

       

      [2017-08-10T09:17:02.133+10:00] [soa_server1] [WARNING] [] [oracle.soa.sql.trc.fabric.toplink_session.tracking-session] [tid: Workmanager: , Version: 0, Scheduled=false, Started=false, Wait time: 0 ms\r\n] [userId: <anonymous>] [ecid: 76e58966f971ea1c:-20770469:15dc6e99aba:-8000-0000000000002c31,1:21049] [APP: soa-infra] [composite_instance_id: 96930001] [composite_name: Brdge!1.4] [component_name: QueueBridge] [[

      Local Exception Stack:

      Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.6.0) (Build 111018)): oracle.toplink.exceptions.DatabaseException

      Internal Exception: weblogic.jdbc.sqlserverbase.ddc: [FMWGEN][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

       

      [2017-08-10T09:26:20.460+10:00] [soa_server1] [ERROR] [] [oracle.integration.platform.instance.store.async] [tid: Workmanager: , Version: 0, Scheduled=false, Started=false, Wait time: 0 ms\r\n] [userId: <anonymous>] [ecid: 76e58966f971ea1c:-20770469:15dc6e99aba:-8000-0000000000002c31,1:21049] [APP: soa-infra] [composite_instance_id: 96930001] [composite_name: Bridge!1.4] [component_name: QueueBridge] oracle.integration.platform.instance.store.DOStore$RetryableException: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.6.0) (Build 111018)): oracle.toplink.exceptions.DatabaseException[[

      Internal Exception: weblogic.jdbc.sqlserverbase.ddc: [FMWGEN][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

      Error Code: 8152

        • 1. Re: Composite instances not appearing in EM console
          Krishna Hanumantharao

          String or binary data would be truncated.Error Code: 8152

           

          There is an attempt to insert more data into a table column than the allowed limit. Please increase the logging levels to get additional information about this error.

          • 2. Re: Composite instances not appearing in EM console
            Prabu

            Its difficult to do so on the restricted Production server.Do you mean to change the weblogic log levels?

             

            Further the composite flow as such has no Database inserts so most likely the errors is from the SOA Infra database.

            • 3. Re: Composite instances not appearing in EM console
              Krishna Hanumantharao

              Login into EM. Right click on soa_infra and select Logs -> Logs Configuration. Increase the logging levels (TRACE 16 or TRACE 32) for oracle.soa.* loggers.

              1 person found this helpful
              • 4. Re: Composite instances not appearing in EM console
                Prabu

                DId that. I cant find more infor in the logs.This time it doesnt say which compiste caused it.All I could see is a mediator reference.

                 

                [2017-08-11T10:24:26.596+10:00] [soa_server1] [ERROR] [] [oracle.integration.platform.instance.store.async] [tid: Workmanager: , Version: 0, Scheduled=false, Started=false, Wait time: 0 ms\r\n] [userId: <anonymous>] [ecid: 76e58966f971ea1c:4d475d27:15dcc0617a6:-8000-000000000000318c,0] [APP: soa-infra] oracle.integration.platform.instance.store.DOStore$RetryableException: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.6.0) (Build 111018)): oracle.toplink.exceptions.DatabaseException[[

                Internal Exception: weblogic.jdbc.sqlserverbase.ddc: [FMWGEN][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

                Error Code: 8152

                • 5. Re: Composite instances not appearing in EM console
                  Prabu

                  Is there a way to find what is triggerring this and stop that.This is occuring throughout.

                   

                  [2017-08-11T13:00:01.346+10:00] [soa_server1] [WARNING] [] [oracle.soa.sql.trc.fabric.toplink_session.tracking-session] [tid: Workmanager: , Version: 0, Scheduled=false, Started=false, Wait time: 0 ms\r\n] [userId: <anonymous>] [ecid: 76e58966f971ea1c:4d475d27:15dcc0617a6:-8000-000000000000318c,0] [APP: soa-infra] [[

                  Local Exception Stack:

                  Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.6.0) (Build 111018)): oracle.toplink.exceptions.DatabaseException

                  Internal Exception: weblogic.jdbc.sqlserverbase.ddc: [FMWGEN][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

                  Error Code: 8152

                  • 6. Re: Composite instances not appearing in EM console
                    Krishna Hanumantharao

                    If you had set the logs to TRACE, you should be seeing log messages starting with [<timestamp>] [soa_server1][TRACE]  . Nothing with [TRACE]?

                     

                    Are there loggers for "oracle.soa.sql" , "oracle.integration.platform", "oracle.toplink"? If present set it to FINEST (Trace 32) and check the logs for any additional information

                    • 7. Re: Composite instances not appearing in EM console
                      Krishna Hanumantharao

                      Try setting this logger to FINEST and check the log file. click on "*-handler" to see the log file path.

                       

                      1 person found this helpful
                      • 8. Re: Composite instances not appearing in EM console
                        Prabu

                        [ecid: 76e58966f971ea1c:4d475d27:15dcc0617a6:-8000-000000000000318c,0] [APP: soa-infra] [[

                        Local Exception Stack:

                        Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.6.0) (Build 111018)): oracle.toplink.exceptions.DatabaseException

                        Internal Exception: weblogic.jdbc.sqlserverbase.ddc: [FMWGEN][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

                        Error Code: 8152

                         

                        this ecid [ecid: 76e58966f971ea1c:4d475d27:15dcc0617a6:-8000-000000000000318c,0]  is present throughout the logs.Is there a way to find the trace for this exception and all related logs?

                         

                        [ecid: 76e58966f971ea1c:4d475d27:15dcc0617a6:-8000-000000000000318c,0]  is apperaing throughout the logs and I cant arrive at any decision.

                         

                        Thanks Krishna

                        • 9. Re: Composite instances not appearing in EM console
                          Prabu

                          Also is it possible to remove this transaction.This somehow retrying for ever and rolling back I guess.See this one "rollback_transaction"

                           

                          [2017-08-11T19:10:39.467+10:00] [soa_server1] [TRACE:16] [] [oracle.soa.sql.trc.fabric.toplink_session.tracking-session] [tid: Workmanager: , Version: 0, Scheduled=false, Started=false, Wait time: 0 ms\r\n] [userId: <anonymous>] [ecid: 76e58966f971ea1c:4d475d27:15dcc0617a6:-8000-000000000000318c,0] [APP: soa-infra] [SRC_CLASS: oracle.integration.platform.instance.store.ToplinkSessionLogger] [SRC_METHOD: log] rollback_transaction

                          [2017-08-11T19:10:39.469+10:00] [soa_server1] [TRACE:16] [] [oracle.soa.sql.trc.fabric.toplink_session.tracking-session] [tid: Workmanager: , Version: 0, Scheduled=false, Started=false, Wait time: 0 ms\r\n] [userId: <anonymous>] [ecid: 76e58966f971ea1c:4d475d27:15dcc0617a6:-8000-000000000000318c,0] [APP: soa-infra] [SRC_CLASS: oracle.integration.platform.instance.store.ToplinkSessionLogger] [SRC_METHOD: log] client_released

                          [2017-08-11T19:10:39.470+10:00] [soa_server1] [ERROR] [] [oracle.integration.platform.instance.store.async] [tid: Workmanager: , Version: 0, Scheduled=false, Started=false, Wait time: 0 ms\r\n] [userId: <anonymous>] [ecid: 76e58966f971ea1c:4d475d27:15dcc0617a6:-8000-000000000000318c,0] [APP: soa-infra] oracle.integration.platform.instance.store.DOStore$RetryableException: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.6.0) (Build 111018)): oracle.toplink.exceptions.DatabaseException[[

                          Internal Exception: weblogic.jdbc.sqlserverbase.ddc: [FMWGEN][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

                          Error Code: 8152

                          • 10. Re: Composite instances not appearing in EM console
                            Krishna Hanumantharao

                            In EM do a search based on ECID "76e58966f971ea1c:4d475d27:15dcc0617a6:-8000-000000000000318c" and see what set of composite instances comes up. Try aborting/terminating them.

                            1 person found this helpful
                            • 12. Re: Composite instances not appearing in EM console
                              Prabu

                              I checked the and it shows the INSTANCE state as "?"

                              • 13. Re: Composite instances not appearing in EM console
                                Krishna Hanumantharao

                                Prabu wrote:

                                 

                                I checked the and it shows the INSTANCE state as "?"

                                Click on the instance and see the flow. See the status for each of the component. Look for any component which is being retried

                                • 14. Re: Composite instances not appearing in EM console
                                  Prabu

                                  This is the most mysterious instance ever.I deleted the instances.Infact it showed completed.I have terminated it and it no more appears in the console but the "ghost" is tsill some where fillling in the logs and repaeting the same story

                                   

                                  [oracle.soa.sql.trc.fabric.toplink_session.tracking-session] [tid: Workmanager: , Version: 0, Scheduled=false, Started=false, Wait time: 0 ms\r\n] [userId: <anonymous>] [ecid: 76e58966f971ea1c:4d475d27:15dcc0617a6:-8000-000000000000318c,0] [APP: soa-infra] [SRC_CLASS: oracle.integration.platform.instance.store.ToplinkSessionLogger] [SRC_METHOD: log] rollback_transaction

                                  1 2 Previous Next