question SAM cannot run properly. Running Any test case gives NoSuchMethodException and StorageException !! in Support Questions

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

qwikbaba — Tue, 21 Apr 2026 11:38:58 GMT

@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

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 !!!!

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

TimothySpann — Thu, 24 Jan 2019 17:34:42 GMT

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

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

qwikbaba — Thu, 24 Jan 2019 17:34:43 GMT

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 !!

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

qwikbaba — Thu, 24 Jan 2019 21:38:32 GMT

Update !!
The problem still seems to persist as I have installed HDP now as well !

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

qwikbaba — Thu, 24 Jan 2019 21:56:19 GMT

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

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

qwikbaba — Wed, 13 Feb 2019 19:55:48 GMT

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 !!!

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

qwikbaba — Wed, 13 Feb 2019 19:56:28 GMT

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 !!!