Its now resolved. I did this.
DELETE FROM AM_API_LC_EVENT WHERE API_ID = 7 ; DELETE FROM AM_API_LC_EVENT WHERE API_ID = 12 ; SELECT * FROM AM_API_LC_EVENT // No records now DELETE FROM AM_API issue resolved. Thanks Shib On Fri, Jun 8, 2018 at 5:26 PM, shibsankar <src...@gmail.com> wrote: > It did not delete records. > > First I executed delete and then run a select query to verify if those are > deleted properly. > > I see records did not delete. > > Please see the screenshot. > > Regards > Shib > > On Fri, Jun 8, 2018 at 4:59 PM, Dinusha Dissanayake <dinus...@wso2.com> > wrote: > >> Hi Shib, >> >> Yes. If it doesn't allow you to delete just in case because this API_ID >> is a foreign key of AM_API_LC_EVENT table, you have to first delete the >> records in AM_API_LC_EVENT table with those API_IDs and then try deleting >> entries from AM_API tables. >> >> Below are the queries. >> >> DELETE FROM AM_API_LC_EVENT WHERE API_ID = 7 AND API_ID = 12; >> DELETE FROM AM_API WHERE API_ID=7 AND API_ID =12; >> >> Regards >> DinushaD >> >> On Fri, Jun 8, 2018 at 4:50 PM, shibsankar <src...@gmail.com> wrote: >> >>> Yup. I can see the AM_DB now. >>> >>> Please see screenshot attached. >>> >>> I believe I should delete these records now. This should resolve >>> duplicate context value issue . right ? >>> >>> DELETE FROM AM_API >>> WHERE API_ID=7 AND API_ID=12; >>> >>> Is this okay ? >>> >>> Regards >>> Shib >>> >>> >>> >>> >>> >>> >>> >>> On Fri, Jun 8, 2018 at 4:36 PM, Dinusha Dissanayake <dinus...@wso2.com> >>> wrote: >>> >>>> Could you please logout from h2 console and try with >>>> *jdbc:h2:repository/database/WSO2AM_DB;DB_CLOSE_ON_EXIT=FALSE* as JDBC >>>> URL. >>>> Then you'd be able to see the tabls in the AM_DB. >>>> >>>> Regards, >>>> DinushaD >>>> >>>> On Fri, Jun 8, 2018 at 4:33 PM, shibsankar <src...@gmail.com> wrote: >>>> >>>>> Okay. Now I have connected H2 database through Web UI. >>>>> >>>>> But I don't see AM_DB , AM_API table there to verify >>>>> CONTEXT_TEMPLATE as per earlier replies. >>>>> >>>>> How to find that ? >>>>> >>>>> Please see the screenshot attached. >>>>> >>>>> >>>>> Regards >>>>> Shib >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Fri, Jun 8, 2018 at 2:49 PM, Dinusha Dissanayake <dinus...@wso2.com >>>>> > wrote: >>>>> >>>>>> Hi Shib, >>>>>> >>>>>> Yes. By default it is using embedded H2 database even though it is >>>>>> commented in carbon.xml. >>>>>> To browse though the database, please follow the instructions given >>>>>> in above provided document.[1] >>>>>> [1] https://docs.wso2.com/display/ADMIN44x/Browsing+the+H2+Database. >>>>>> >>>>>> Thanks, >>>>>> DinushaD >>>>>> >>>>>> On Fri, Jun 8, 2018 at 2:43 PM, shibsankar <src...@gmail.com> wrote: >>>>>> >>>>>>> I'm using default installation. I see <H2DatabaseConfiguration> is >>>>>>> *commented* in my WSO2/repository/conf/carbon.xml. Does it mean >>>>>>> its using embedded H2 DB? >>>>>>> >>>>>>> carbon.xml attached. >>>>>>> >>>>>>> Regards >>>>>>> Shib >>>>>>> >>>>>>> On Fri, Jun 8, 2018 at 2:13 PM, Nirothipan Mehalingam < >>>>>>> nirothi...@wso2.com> wrote: >>>>>>> >>>>>>>> Hi Shib, >>>>>>>> >>>>>>>> If you are using embedded H2 DB you may follow >>>>>>>> https://docs.wso2.com/display/ADMIN44x/Browsing+the+H2+Database. >>>>>>>> >>>>>>>> Thanks >>>>>>>> Nirothipan >>>>>>>> >>>>>>>> On Fri, Jun 8, 2018 at 2:09 PM, shibsankar <src...@gmail.com> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> How do I connect to this DB and view the rows of the mentioned >>>>>>>>> table? Can it be viewed from API management web-UI? >>>>>>>>> >>>>>>>>> Regards >>>>>>>>> Shib >>>>>>>>> >>>>>>>>> On Fri, Jun 8, 2018 at 1:50 PM, Dinusha Dissanayake < >>>>>>>>> dinus...@wso2.com> wrote: >>>>>>>>> >>>>>>>>>> Hi Shib, >>>>>>>>>> >>>>>>>>>> Probably there should be an database entry of the same "context" >>>>>>>>>> you are defining here. As above replies explain, this could be due to >>>>>>>>>> partially deleted APIs. >>>>>>>>>> Could you please check AM_API table in AM_DB and see whether >>>>>>>>>> there is a CONTEXT_TEMPLATE with the same context you are trying to >>>>>>>>>> define >>>>>>>>>> here? >>>>>>>>>> >>>>>>>>>> Thanks, >>>>>>>>>> DinushaD. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Fri, Jun 8, 2018 at 12:50 PM, shibsankar <src...@gmail.com> >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>>> There is no API in publisher application. >>>>>>>>>>> >>>>>>>>>>> I'm still getting * Duplicate Context Value *when trying to add >>>>>>>>>>> a new API in Design page. >>>>>>>>>>> >>>>>>>>>>> Please see the screenshot attached. >>>>>>>>>>> >>>>>>>>>>> Regards >>>>>>>>>>> Shib >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Fri, Jun 8, 2018 at 10:51 AM, Dushani Wellappili < >>>>>>>>>>> dusha...@wso2.com> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hi Shib, >>>>>>>>>>>> >>>>>>>>>>>> If you have deleted the API from the management console, then >>>>>>>>>>>> it is likely you are getting this issue since deleting api in >>>>>>>>>>>> the management console does not delete the whole api. It removes >>>>>>>>>>>> the data >>>>>>>>>>>> in the registry (meta data). To delete api use publisher >>>>>>>>>>>> application. >>>>>>>>>>>> >>>>>>>>>>>> Thank you. >>>>>>>>>>>> >>>>>>>>>>>> Regards, >>>>>>>>>>>> >>>>>>>>>>>> *Dushani Wellappili* >>>>>>>>>>>> Software Engineer - WSO2 >>>>>>>>>>>> >>>>>>>>>>>> Email : dusha...@wso2.com >>>>>>>>>>>> Mobile : +94779367571 >>>>>>>>>>>> Web : https://wso2.com/ >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Fri, Jun 8, 2018 at 10:01 AM Krishan Wijesena < >>>>>>>>>>>> krish...@wso2.com> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On Thu, Jun 7, 2018 at 6:50 PM, shibsankar <src...@gmail.com> >>>>>>>>>>>>> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>> I have *deleted *published API, subscribed API from WSO2. >>>>>>>>>>>>>> Now there is no more API in WSO2. >>>>>>>>>>>>>> You cannot delete API if active subscriptions exists, which >>>>>>>>>>>>>> apporach did you used to delete the API? >>>>>>>>>>>>>> >>>>>>>>>>>>> because basically this error occur if previous API have >>>>>>>>>>>>> same context value and it's partally deleted. >>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> Restarted the WSO2 server. >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> Now when I try to add a New API , I'm still getting *Duplicate >>>>>>>>>>>>>> context value *in API design page. >>>>>>>>>>>>>> >>>>>>>>>>>>>> Why is this happening? How to fix this? >>>>>>>>>>>>>> >>>>>>>>>>>>>> Please see the screenshot attached. >>>>>>>>>>>>>> >>>>>>>>>>>>>> WSo2 version is 2.1 >>>>>>>>>>>>>> >>>>>>>>>>>>>> Regards >>>>>>>>>>>>>> Shib >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>> Dev mailing list >>>>>>>>>>>>>> Dev@wso2.org >>>>>>>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> >>>>>>>>>>>>> *Krishan Wijesena* >>>>>>>>>>>>> Software Engineer | WSO2 >>>>>>>>>>>>> >>>>>>>>>>>>> Email : krish...@wso2.com >>>>>>>>>>>>> Mobile : +94776219923 >>>>>>>>>>>>> WSO2 Inc : http://wso2.com >>>>>>>>>>>>> [image: http://wso2.com/signature] <http://wso2.com/signature> >>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>> Dev mailing list >>>>>>>>>>>>> Dev@wso2.org >>>>>>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> Dev mailing list >>>>>>>>>>> Dev@wso2.org >>>>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Dinusha Dissanayake >>>>>>>>>> Software Engineer >>>>>>>>>> WSO2 Inc >>>>>>>>>> Mobile: +94712939439 >>>>>>>>>> <https://wso2.com/signature> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Dev mailing list >>>>>>>>> Dev@wso2.org >>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> >>>>>>>> M.Nirothipan >>>>>>>> Software Engineer >>>>>>>> WSO2 Inc. http://wso2.com , >>>>>>>> *Mobile : +94 77 2172692* >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Dinusha Dissanayake >>>>>> Software Engineer >>>>>> WSO2 Inc >>>>>> Mobile: +94712939439 >>>>>> <https://wso2.com/signature> >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Dinusha Dissanayake >>>> Software Engineer >>>> WSO2 Inc >>>> Mobile: +94712939439 >>>> <https://wso2.com/signature> >>>> >>> >>> >> >> >> -- >> Dinusha Dissanayake >> Software Engineer >> WSO2 Inc >> Mobile: +94712939439 >> <https://wso2.com/signature> >> > >
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev