2 Replies Latest reply on Dec 15, 2017 3:17 AM by A K

    SearchMatch API Failure

    A K Guru

      We are getting below error while searchin "Chinese " population records. Any thoughts ?

       

      SIP-10226: Error in building query to run MATCH verb.

      -99: SIP-09045: Unknown external system {0}.

      Review the server log for more details.

        • 1. Re: SearchMatch API Failure
          A K Guru

          CleanseLogs:

           

          [2017-12-07 04:44:23,099] [pool-9-thread-1] [DEBUG] com.informatica.mdm.util.SqlHelper: binded stmt: SELECT LAST_CHANGE_DATE FROM C_REPOS_DB_RELEASE

          [2017-12-07 04:44:24,880] [pool-12-thread-4] [ERROR] com.siperian.mrm.match.searcher.SearcherDatabaseWorker: Error during result set close, error is

          java.lang.NullPointerException

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.openResultSet(SearcherDatabaseWorker.java:186)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:248)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:28)

          at java.util.concurrent.FutureTask.run(FutureTask.java:266)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

          at java.lang.Thread.run(Thread.java:745)

          [2017-12-07 04:44:24,880] [pool-12-thread-5] [ERROR] com.siperian.mrm.match.searcher.SearcherDatabaseWorker: Error during result set close, error is

          java.lang.NullPointerException

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.openResultSet(SearcherDatabaseWorker.java:186)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:248)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:28)

          at java.util.concurrent.FutureTask.run(FutureTask.java:266)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

          at java.lang.Thread.run(Thread.java:745)

          [2017-12-07 04:44:24,880] [pool-12-thread-7] [ERROR] com.siperian.mrm.match.searcher.SearcherDatabaseWorker: Error during result set close, error is

          java.lang.NullPointerException

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.openResultSet(SearcherDatabaseWorker.java:186)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:248)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:28)

          at java.util.concurrent.FutureTask.run(FutureTask.java:266)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

          at java.lang.Thread.run(Thread.java:745)

          [2017-12-07 04:44:24,880] [pool-12-thread-6] [ERROR] com.siperian.mrm.match.searcher.SearcherDatabaseWorker: Error during result set close, error is

          java.lang.NullPointerException

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.openResultSet(SearcherDatabaseWorker.java:186)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:248)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:28)

          at java.util.concurrent.FutureTask.run(FutureTask.java:266)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

          at java.lang.Thread.run(Thread.java:745)

          [2017-12-07 04:44:24,880] [pool-12-thread-2] [ERROR] com.siperian.mrm.match.searcher.SearcherDatabaseWorker: Error during result set close, error is

          java.lang.NullPointerException

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.openResultSet(SearcherDatabaseWorker.java:186)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:248)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:28)

          at java.util.concurrent.FutureTask.run(FutureTask.java:266)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

          at java.lang.Thread.run(Thread.java:745)

          [2017-12-07 04:44:24,880] [pool-12-thread-3] [ERROR] com.siperian.mrm.match.searcher.SearcherDatabaseWorker: Error during result set close, error is

          java.lang.NullPointerException

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.openResultSet(SearcherDatabaseWorker.java:186)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:248)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:28)

          at java.util.concurrent.FutureTask.run(FutureTask.java:266)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

          at java.lang.Thread.run(Thread.java:745)

          [2017-12-07 04:44:24,880] [pool-12-thread-10] [ERROR] com.siperian.mrm.match.searcher.SearcherDatabaseWorker: Error during result set close, error is

          java.lang.NullPointerException

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.openResultSet(SearcherDatabaseWorker.java:186)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:248)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:28)

          at java.util.concurrent.FutureTask.run(FutureTask.java:266)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

          at java.lang.Thread.run(Thread.java:745)

          [2017-12-07 04:44:24,880] [pool-12-thread-8] [ERROR] com.siperian.mrm.match.searcher.SearcherDatabaseWorker: Error during result set close, error is

          java.lang.NullPointerException

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.openResultSet(SearcherDatabaseWorker.java:186)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:248)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:28)

          at java.util.concurrent.FutureTask.run(FutureTask.java:266)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

          at java.lang.Thread.run(Thread.java:745)

          [2017-12-07 04:44:24,880] [pool-12-thread-1] [ERROR] com.siperian.mrm.match.searcher.SearcherDatabaseWorker: Error during result set close, error is

          java.lang.NullPointerException

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.openResultSet(SearcherDatabaseWorker.java:186)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:248)

          at com.siperian.mrm.match.searcher.SearcherDatabaseWorker.call(SearcherDatabaseWorker.java:28)

          at java.util.concurrent.FutureTask.run(FutureTask.java:266)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

          at java.lang.Thread.run(Thread.java:745)

          [2017-12-07 04:44:24,896] [http-0.0.0.0:8443-3] [ERROR] com.siperian.mrm.match.cmxma.GetMatch: SIP-09045: Unknown external system {0}. -99

          • 2. Re: SearchMatch API Failure
            A K Guru

            Issue fixed after disabling multithreads confiruration in cleanse properties.