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