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

[#1]

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

[#2]

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

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/co...

SAM needs HDP

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

[#3]

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

[#4]

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

[#5]

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

[#6 · Accepted solution]

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

[#7]

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