Skip to main content
qwikbaba
qwikbaba
Gold ⭐️
January 24, 2019
Solved

SAM cannot run properly. Running Any test case gives NoSuchMethodException and StorageException !!

@Sriharsha Chintalapani @Arun Mahadevan @Timothy Spann @pshah@Shu@George Vetticaden @mqureshi @amarnath reddy pappu@sree charan @Suresh Bonam @Sagar Shimpi @Satish Duggana @Sandeep Nemuri @Satish Anjaneyappa
@Rishit shah @Balakrishnan Ramasamy


I am running a basic Kafka source and sink with one rule in between

96775-screenshot-from-2019-01-22-14-16-11.png

both have different schemas and i am using a console consumer to read out the sink .
While I am adding the test data in the test case it throws the following exception :-

Caused by: com.hortonworks.registries.storage.exception.StorageException: java.lang.NoSuchMethodException: com.hortonworks.streamline.streams.catalog.TopologyTestRunCaseSource.setOccurrence(javalang.Long) at com.hortonworks.registries.storage.catalog.AbstractStorable.fromMap(AbstractStorable.java:93) atcom.hortonworks.registries.storage.impl.jdbc.provider.sql.factory.AbstractQueryExecutor$QueryExecution.getStorablesFromResultSet(AbstractQueryExecutor.java:480) at com.hortonworks.registries.storage.impl.jdbc.provider.sql.factory.AbstractQueryExecutor$QueryExecution.executeQuery(AbstractQueryExecutor.java:363) at com.hortonworks.registries.storage.impl.jdbc.provider.sql.factory.AbstractQueryExecutor.executeQuery(AbstractQueryExecutor.java:344) at com.hortonworks.registries.storage.impl.jdbc.provider.postgresql.factory.PostgresqlExecutor.select(PostgresqlExecutor.java:121) at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.find(JdbcStorageManager.java:128) ... 61 common frames omittedCaused by: java.lang.NoSuchMethodException: com.hortonworks.streamline.streams.catalog.TopologyTestRunCaseSource.setOccurrence(java.lang.Long)

Also why I am not being able to delete the test cases ???(it throws an exception in this case as well !!!!!)

ERROR [2019-01-22 14:21:58.894] [dw-288 - DELETE /api/v1/catalog/topologies/2/testcases/7] c.h.s.s.s.TopologyTestRunResource - Got exception: [StorageException] / message [com.hortonworks.registries.storage.exception.StorageException: java.lang.NoSuchMethodException: com.hortonworks.streamline.streams.catalog.TopologyTestRunCaseSource.setOccurrence(java.lang.Long)] / related resource location: [com.hortonworks.streamline.streams.service.TopologyTestRunResource.removeTestRunCase](TopologyTestRunResource.java:548)
com.hortonworks.registries.storage.exception.StorageException: com.hortonworks.registries.storage.exception.StorageException: java.lang.NoSuchMethodException: com.hortonworks.streamline.streams.catalog.TopologyTestRunCaseSource.setOccurrence(java.lang.Long)

Is there something wrong with my database configuration ???
I am using postgresql 9.5 which came with Ambari (I used the embedded DB option and created the registry and streamline DBs in the same)
Any help is much appreciated !!!!

    qwikbaba
    qwikbabaAnswer
    Gold ⭐️
    February 13, 2019

    I changed the column type from bigint to integer for the topology_test_run_case_source.occurence and it was resolved and the test cases also started to run !!!

    View in thread

    6 replies

    TimothySpann
    Platinum ⭐️⭐️⭐️
    TimothySpann
    Platinum ⭐️⭐️⭐️
    January 24, 2019

    See https://community.hortonworks.com/questions/107816/unable-to-get-schema-registry-working-in-hdf-30.html

    https://github.com/hortonworks/registry/issues/339

    You need permissions to your database from SAM. Did you install from HDF Ambari? Did you setup the database for SAM?

    https://docs.hortonworks.com/HDPDocuments/HDF3/HDF-3.3.1/getting-started-with-streaming-analytics/content/building_an_end-to-end_stream_application.html

    SAM needs HDP

    https://docs.hortonworks.com/HDPDocuments/HDF3/HDF-3.3.1/installing-hdf-and-hdp/content/deploying_an_hdp_cluster_using_ambari.html

    Translate
      qwikbaba
      qwikbabaAuthor
      Gold ⭐️
      January 24, 2019

      I have installed HDF ambari and also made the database for SAM as streamline. i cross checked in the database streamline all the data of test application is being stored by SAM and it was !!!
      I am able to see the schemas that I have written in schema registry inside SAM when I am configuring Kafka Source and Sink.

      Oh SAM needs HDP !!!! Is it ???
      I did not see in the HDF installation guide that it was necessary for SAM. I have not installed HDP or any of its components.

      Thanks for the quick reply its extremely kind of you !!
      I will start working for the same now !!
      They should atleast give a message during the installation that HDP is required for SAM working !!

      Translate
      qwikbaba
      qwikbabaAuthor
      Gold ⭐️
      January 24, 2019

      @Geoffrey Shelton Okot have you been able to reproduce the issue ??

      Translate
      qwikbaba
      qwikbabaAuthorAnswer
      Gold ⭐️
      February 13, 2019

      I changed the column type from bigint to integer for the topology_test_run_case_source.occurence and it was resolved and the test cases also started to run !!!

      Translate
      qwikbaba
      qwikbabaAuthor
      Gold ⭐️
      February 13, 2019

      I changed the column type from bigint to integer for the topology_test_run_case_source.occurence and it was resolved and the test cases also started to run !!!

      @Timothy Spann @Geoffrey Shelton Okot thanks for the help !!!

      Translate
      Terms & ConditionsAccessibility statement