Re: [Dev] Duplicate Context Value

[shibsankar]

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  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 
> 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  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 
>>> 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  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  > 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  wrote:
>>
>>> I'm using default installation.  I see   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 
 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 
>> 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,

Re: [Dev] Duplicate Context Value

[Dinusha Dissanayake]

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  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 
> 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  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 
>>> 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  wrote:

> I'm using default installation.  I see   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  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 
 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 
>>> 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 

Re: [Dev] Duplicate Context Value

[Dinusha Dissanayake]

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  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 
> 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  wrote:
>>
>>> I'm using default installation.  I see   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/d
 isplay/ADMIN44x/Browsing+the+H2+Database.

 Thanks
 Nirothipan

 On Fri, Jun 8, 2018 at 2:09 PM, shibsankar  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  > 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  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 
 wrote:

>
>
> On Thu, Jun 7, 2018 at 6:50 PM, shibsankar 
> 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] 
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>

>>>
>>> ___
>>> Dev mailing list

Re: [Dev] Duplicate Context Value

[Dinusha Dissanayake]

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  wrote:

> I'm using default installation.  I see   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  > wrote:
>
>> Hi Shib,
>>
>> If you are using embedded H2 DB you may follow https://docs.wso2.com/d
>> isplay/ADMIN44x/Browsing+the+H2+Database.
>>
>> Thanks
>> Nirothipan
>>
>> On Fri, Jun 8, 2018 at 2:09 PM, shibsankar  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 
>>> 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  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  > 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 
>> wrote:
>>
>>>
>>>
>>> On Thu, Jun 7, 2018 at 6:50 PM, shibsankar  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] 
>>> ___
>>> 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
 

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

___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Duplicate Context Value

[shibsankar]

I'm using default installation.  I see   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 
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  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 
>> 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  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 
 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 
> wrote:
>
>>
>>
>> On Thu, Jun 7, 2018 at 6:50 PM, shibsankar  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] 
>> ___
>> 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
>>> 
>>>
>>
>>
>> ___
>> 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*
>
>




http://wso2.org/projects/carbon/carbon.xml;>


WSO2 API Manager


AM


2.1.0








local:/${carbon.context}/services/

 




APIManager






org.wso2.carbon


/








15








0






1





10389

8000

	
	
	
	
	10500








org.wso2.carbon.tomcat.jndi.CarbonJavaURLContextFactory








java









false


false


600



false

Re: [Dev] Duplicate Context Value

[Nirothipan Mehalingam]

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  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 
> 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  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 
>>> 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 
 wrote:

>
>
> On Thu, Jun 7, 2018 at 6:50 PM, shibsankar  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] 
> ___
> 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
>> 
>>
>
>
> ___
> 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*
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Duplicate Context Value

[shibsankar]

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 
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  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 
>> 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 
>>> wrote:
>>>


 On Thu, Jun 7, 2018 at 6:50 PM, shibsankar  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] 
 ___
 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
> 
>
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Duplicate Context Value

[Dinusha Dissanayake]

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  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 
> 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 
>> wrote:
>>
>>>
>>>
>>> On Thu, Jun 7, 2018 at 6:50 PM, shibsankar  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] 
>>> ___
>>> 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

___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Duplicate Context Value

[shibsankar]

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 
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 
> wrote:
>
>>
>>
>> On Thu, Jun 7, 2018 at 6:50 PM, shibsankar  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] 
>> ___
>> 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

Re: [Dev] Duplicate Context Value

[Dushani Wellappili]

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  wrote:

>
>
> On Thu, Jun 7, 2018 at 6:50 PM, shibsankar  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] 
> ___
> 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

Re: [Dev] Duplicate Context Value

[Krishan Wijesena]

On Thu, Jun 7, 2018 at 6:50 PM, shibsankar  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] 
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Duplicate Context Value

[shibsankar]

Is there any solution to this?

Regards
Shib

On Thu, Jun 7, 2018 at 6:50 PM, shibsankar  wrote:

> Hi,
> I have *deleted *published API, subscribed API  from WSO2. Now there is
> no more API  in WSO2.
>
>
> 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

[Dev] Duplicate Context Value

[shibsankar]

Hi,
I have *deleted *published API, subscribed API  from WSO2. Now there is no
more API  in WSO2.


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