Re: [Dev] Error when generating/refreshing keys in APIM 1.9.0
HI,
I had configured revoke api url incorrectly.
Thanks Amilad for helping to fix this.
Thanks
On Fri, Jul 24, 2015 at 4:56 PM, Harsha Kumara wrote:
> Hi Amalka,
>
> When you new creating application, Is this coming during first click of
> generate token? I think your first attempt is failed and you get this when
> you click it for the second time?
>
> Thanks,
> Harsha
>
> On Fri, Jul 24, 2015 at 4:40 PM, Amalka Subasinghe
> wrote:
>
>> I'm getting this error when I create new application and try to generate
>> keys as well
>>
>> On Fri, Jul 24, 2015 at 4:33 PM, Roshan Wijesena wrote:
>>
>>> Yes, As Uvindra said there will be a duplicate record in
>>> AM_APPLICATION_REGISTRATION
>>> table.. Is it possible to delete your APIM application and try again ?
>>>
>>> On Fri, Jul 24, 2015 at 4:31 PM, Uvindra Dias Jayasinha <
>>> uvin...@wso2.com> wrote:
>>>
According to the exception seems there is a duplicate entry value when
trying to insert into AM_APPLICATION_REGISTRATION table. Seems that the
same Application is getting registered multiple times. Can you let us know
the exacts steps you are following?
On 24 July 2015 at 16:13, Amalka Subasinghe wrote:
> Hi,
>
> I'm upgrading API Manager to 1.9.0 in App Factory setup.
>
> When generating/refreshing keys I'm getting following exception.
> I removed consumer key from AM_APPLICATION_KEY_MAPPING and try to
> generate the key again -> but the exception is still throwing
>
> Any idea about this?
>
> TID: [0] [AM] [2015-07-24 10:23:06,385] INFO
> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
> -
> generateApplicationKey
> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
> TID: [0] [AM] [2015-07-24 10:23:06,389] INFO
> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
> - -store.getApplicationKey-
> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
> TID: [0] [AM] [2015-07-24 10:23:06,469] ERROR
> {org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO} - Error occurred while
> creating an Application Registration Entry for Application :
> DefaultApplication {org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO}
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
> Duplicate entry '1-1-PRODUCTION' for key 'SUBSCRIBER_ID'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
> at
> com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
> at
> org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO.createApplicationRegistrationEntry(ApiMgtDAO.java:308)
> at
> org.wso2.carbon.apimgt.impl.workflow.ApplicationRegistrationSimpleWorkflowExecutor.complete(ApplicationRegistrationSimpleWorkflowExecutor.java:80)
> at
> org.wso2.carbon.apimgt.impl.workflow.ApplicationRegistrationSimpleWorkflowExecutor.execute(ApplicationRegistrationSimpleWorkflowExecutor.java:58)
> at
> org.wso2.carbon.apimgt.impl.APIConsumerImpl.requestApprovalForApplicationRegistration(APIConsumerImpl.java:2179)
> at
> org.wso2.carbon.apimgt.impl.UserAwareAPIConsumer.requestApprovalForApplicationRegistration(UserAwareAPIConsumer.java:34)
> at
> org.wso2.carbon.apimgt.hostobjects.APIStoreHostObject.jsFunction_getApplicationKey(APIStoreHostObject.java:751)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)
> at
> org.mozilla.javascript.Func
Re: [Dev] Error when generating/refreshing keys in APIM 1.9.0
Hi Amalka,
When you new creating application, Is this coming during first click of
generate token? I think your first attempt is failed and you get this when
you click it for the second time?
Thanks,
Harsha
On Fri, Jul 24, 2015 at 4:40 PM, Amalka Subasinghe wrote:
> I'm getting this error when I create new application and try to generate
> keys as well
>
> On Fri, Jul 24, 2015 at 4:33 PM, Roshan Wijesena wrote:
>
>> Yes, As Uvindra said there will be a duplicate record in
>> AM_APPLICATION_REGISTRATION
>> table.. Is it possible to delete your APIM application and try again ?
>>
>> On Fri, Jul 24, 2015 at 4:31 PM, Uvindra Dias Jayasinha > > wrote:
>>
>>> According to the exception seems there is a duplicate entry value when
>>> trying to insert into AM_APPLICATION_REGISTRATION table. Seems that the
>>> same Application is getting registered multiple times. Can you let us know
>>> the exacts steps you are following?
>>>
>>> On 24 July 2015 at 16:13, Amalka Subasinghe wrote:
>>>
Hi,
I'm upgrading API Manager to 1.9.0 in App Factory setup.
When generating/refreshing keys I'm getting following exception.
I removed consumer key from AM_APPLICATION_KEY_MAPPING and try to
generate the key again -> but the exception is still throwing
Any idea about this?
TID: [0] [AM] [2015-07-24 10:23:06,385] INFO
{JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
-
generateApplicationKey
{JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
TID: [0] [AM] [2015-07-24 10:23:06,389] INFO
{JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
- -store.getApplicationKey-
{JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
TID: [0] [AM] [2015-07-24 10:23:06,469] ERROR
{org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO} - Error occurred while
creating an Application Registration Entry for Application :
DefaultApplication {org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO}
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry '1-1-PRODUCTION' for key 'SUBSCRIBER_ID'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
at
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
at
org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO.createApplicationRegistrationEntry(ApiMgtDAO.java:308)
at
org.wso2.carbon.apimgt.impl.workflow.ApplicationRegistrationSimpleWorkflowExecutor.complete(ApplicationRegistrationSimpleWorkflowExecutor.java:80)
at
org.wso2.carbon.apimgt.impl.workflow.ApplicationRegistrationSimpleWorkflowExecutor.execute(ApplicationRegistrationSimpleWorkflowExecutor.java:58)
at
org.wso2.carbon.apimgt.impl.APIConsumerImpl.requestApprovalForApplicationRegistration(APIConsumerImpl.java:2179)
at
org.wso2.carbon.apimgt.impl.UserAwareAPIConsumer.requestApprovalForApplicationRegistration(UserAwareAPIConsumer.java:34)
at
org.wso2.carbon.apimgt.hostobjects.APIStoreHostObject.jsFunction_getApplicationKey(APIStoreHostObject.java:751)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)
at
org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386)
at
org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52)
at
org.jaggeryjs.rhino.store.modules.subscription.c2._c_anonymous_2(/store/modules/subscription/key.jag:41)
at
org.jagger
Re: [Dev] Error when generating/refreshing keys in APIM 1.9.0
I'm getting this error when I create new application and try to generate
keys as well
On Fri, Jul 24, 2015 at 4:33 PM, Roshan Wijesena wrote:
> Yes, As Uvindra said there will be a duplicate record in
> AM_APPLICATION_REGISTRATION
> table.. Is it possible to delete your APIM application and try again ?
>
> On Fri, Jul 24, 2015 at 4:31 PM, Uvindra Dias Jayasinha
> wrote:
>
>> According to the exception seems there is a duplicate entry value when
>> trying to insert into AM_APPLICATION_REGISTRATION table. Seems that the
>> same Application is getting registered multiple times. Can you let us know
>> the exacts steps you are following?
>>
>> On 24 July 2015 at 16:13, Amalka Subasinghe wrote:
>>
>>> Hi,
>>>
>>> I'm upgrading API Manager to 1.9.0 in App Factory setup.
>>>
>>> When generating/refreshing keys I'm getting following exception.
>>> I removed consumer key from AM_APPLICATION_KEY_MAPPING and try to
>>> generate the key again -> but the exception is still throwing
>>>
>>> Any idea about this?
>>>
>>> TID: [0] [AM] [2015-07-24 10:23:06,385] INFO
>>> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
>>> -
>>> generateApplicationKey
>>> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
>>> TID: [0] [AM] [2015-07-24 10:23:06,389] INFO
>>> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
>>> - -store.getApplicationKey-
>>> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
>>> TID: [0] [AM] [2015-07-24 10:23:06,469] ERROR
>>> {org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO} - Error occurred while
>>> creating an Application Registration Entry for Application :
>>> DefaultApplication {org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO}
>>> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
>>> Duplicate entry '1-1-PRODUCTION' for key 'SUBSCRIBER_ID'
>>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>>> Method)
>>> at
>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>>> at
>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
>>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>>> at com.mysql.jdbc.Util.getInstance(Util.java:386)
>>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
>>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
>>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
>>> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
>>> at
>>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
>>> at
>>> com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
>>> at
>>> org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO.createApplicationRegistrationEntry(ApiMgtDAO.java:308)
>>> at
>>> org.wso2.carbon.apimgt.impl.workflow.ApplicationRegistrationSimpleWorkflowExecutor.complete(ApplicationRegistrationSimpleWorkflowExecutor.java:80)
>>> at
>>> org.wso2.carbon.apimgt.impl.workflow.ApplicationRegistrationSimpleWorkflowExecutor.execute(ApplicationRegistrationSimpleWorkflowExecutor.java:58)
>>> at
>>> org.wso2.carbon.apimgt.impl.APIConsumerImpl.requestApprovalForApplicationRegistration(APIConsumerImpl.java:2179)
>>> at
>>> org.wso2.carbon.apimgt.impl.UserAwareAPIConsumer.requestApprovalForApplicationRegistration(UserAwareAPIConsumer.java:34)
>>> at
>>> org.wso2.carbon.apimgt.hostobjects.APIStoreHostObject.jsFunction_getApplicationKey(APIStoreHostObject.java:751)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>> at java.lang.reflect.Method.invoke(Method.java:606)
>>> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)
>>> at
>>> org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386)
>>> at
>>> org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52)
>>> at
>>> org.jaggeryjs.rhino.store.modules.subscription.c2._c_anonymous_2(/store/modules/subscription/key.jag:41)
>>> at
>>> org.jaggeryjs.rhino.store.modules.subscription.c2.call(/store/modules/subscription/key.jag)
>>> at
>>> org.mozilla.javascript.ScriptRuntime.applyOrCall(ScriptRuntime.java:2430)
>>> at
>>> org.mozilla.javascript.BaseFunction.execIdCall(BaseFunction.java:269)
>>> at
>>> org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:97)
>>> at
>>> org.mo
Re: [Dev] Error when generating/refreshing keys in APIM 1.9.0
Yes, As Uvindra said there will be a duplicate record in
AM_APPLICATION_REGISTRATION
table.. Is it possible to delete your APIM application and try again ?
On Fri, Jul 24, 2015 at 4:31 PM, Uvindra Dias Jayasinha
wrote:
> According to the exception seems there is a duplicate entry value when
> trying to insert into AM_APPLICATION_REGISTRATION table. Seems that the
> same Application is getting registered multiple times. Can you let us know
> the exacts steps you are following?
>
> On 24 July 2015 at 16:13, Amalka Subasinghe wrote:
>
>> Hi,
>>
>> I'm upgrading API Manager to 1.9.0 in App Factory setup.
>>
>> When generating/refreshing keys I'm getting following exception.
>> I removed consumer key from AM_APPLICATION_KEY_MAPPING and try to
>> generate the key again -> but the exception is still throwing
>>
>> Any idea about this?
>>
>> TID: [0] [AM] [2015-07-24 10:23:06,385] INFO
>> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
>> -
>> generateApplicationKey
>> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
>> TID: [0] [AM] [2015-07-24 10:23:06,389] INFO
>> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
>> - -store.getApplicationKey-
>> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
>> TID: [0] [AM] [2015-07-24 10:23:06,469] ERROR
>> {org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO} - Error occurred while
>> creating an Application Registration Entry for Application :
>> DefaultApplication {org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO}
>> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
>> Duplicate entry '1-1-PRODUCTION' for key 'SUBSCRIBER_ID'
>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>> Method)
>> at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>> at
>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>> at com.mysql.jdbc.Util.getInstance(Util.java:386)
>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
>> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
>> at
>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
>> at
>> com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
>> at
>> org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO.createApplicationRegistrationEntry(ApiMgtDAO.java:308)
>> at
>> org.wso2.carbon.apimgt.impl.workflow.ApplicationRegistrationSimpleWorkflowExecutor.complete(ApplicationRegistrationSimpleWorkflowExecutor.java:80)
>> at
>> org.wso2.carbon.apimgt.impl.workflow.ApplicationRegistrationSimpleWorkflowExecutor.execute(ApplicationRegistrationSimpleWorkflowExecutor.java:58)
>> at
>> org.wso2.carbon.apimgt.impl.APIConsumerImpl.requestApprovalForApplicationRegistration(APIConsumerImpl.java:2179)
>> at
>> org.wso2.carbon.apimgt.impl.UserAwareAPIConsumer.requestApprovalForApplicationRegistration(UserAwareAPIConsumer.java:34)
>> at
>> org.wso2.carbon.apimgt.hostobjects.APIStoreHostObject.jsFunction_getApplicationKey(APIStoreHostObject.java:751)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:606)
>> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)
>> at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386)
>> at
>> org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52)
>> at
>> org.jaggeryjs.rhino.store.modules.subscription.c2._c_anonymous_2(/store/modules/subscription/key.jag:41)
>> at
>> org.jaggeryjs.rhino.store.modules.subscription.c2.call(/store/modules/subscription/key.jag)
>> at
>> org.mozilla.javascript.ScriptRuntime.applyOrCall(ScriptRuntime.java:2430)
>> at
>> org.mozilla.javascript.BaseFunction.execIdCall(BaseFunction.java:269)
>> at
>> org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:97)
>> at
>> org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:42)
>> at
>> org.jaggeryjs.rhino.store.modules.subscription.c0._c_anonymous_9(/store/modules/subscription/module.jag:32)
>> at
>> org.jaggeryjs.rhino.store.modules.subscription.c0
Re: [Dev] Error when generating/refreshing keys in APIM 1.9.0
According to the exception seems there is a duplicate entry value when
trying to insert into AM_APPLICATION_REGISTRATION table. Seems that the
same Application is getting registered multiple times. Can you let us know
the exacts steps you are following?
On 24 July 2015 at 16:13, Amalka Subasinghe wrote:
> Hi,
>
> I'm upgrading API Manager to 1.9.0 in App Factory setup.
>
> When generating/refreshing keys I'm getting following exception.
> I removed consumer key from AM_APPLICATION_KEY_MAPPING and try to generate
> the key again -> but the exception is still throwing
>
> Any idea about this?
>
> TID: [0] [AM] [2015-07-24 10:23:06,385] INFO
> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
> -
> generateApplicationKey
> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
> TID: [0] [AM] [2015-07-24 10:23:06,389] INFO
> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
> - -store.getApplicationKey-
> {JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
> TID: [0] [AM] [2015-07-24 10:23:06,469] ERROR
> {org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO} - Error occurred while
> creating an Application Registration Entry for Application :
> DefaultApplication {org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO}
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
> Duplicate entry '1-1-PRODUCTION' for key 'SUBSCRIBER_ID'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
> at
> com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
> at
> org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO.createApplicationRegistrationEntry(ApiMgtDAO.java:308)
> at
> org.wso2.carbon.apimgt.impl.workflow.ApplicationRegistrationSimpleWorkflowExecutor.complete(ApplicationRegistrationSimpleWorkflowExecutor.java:80)
> at
> org.wso2.carbon.apimgt.impl.workflow.ApplicationRegistrationSimpleWorkflowExecutor.execute(ApplicationRegistrationSimpleWorkflowExecutor.java:58)
> at
> org.wso2.carbon.apimgt.impl.APIConsumerImpl.requestApprovalForApplicationRegistration(APIConsumerImpl.java:2179)
> at
> org.wso2.carbon.apimgt.impl.UserAwareAPIConsumer.requestApprovalForApplicationRegistration(UserAwareAPIConsumer.java:34)
> at
> org.wso2.carbon.apimgt.hostobjects.APIStoreHostObject.jsFunction_getApplicationKey(APIStoreHostObject.java:751)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)
> at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386)
> at
> org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52)
> at
> org.jaggeryjs.rhino.store.modules.subscription.c2._c_anonymous_2(/store/modules/subscription/key.jag:41)
> at
> org.jaggeryjs.rhino.store.modules.subscription.c2.call(/store/modules/subscription/key.jag)
> at
> org.mozilla.javascript.ScriptRuntime.applyOrCall(ScriptRuntime.java:2430)
> at
> org.mozilla.javascript.BaseFunction.execIdCall(BaseFunction.java:269)
> at
> org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:97)
> at
> org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:42)
> at
> org.jaggeryjs.rhino.store.modules.subscription.c0._c_anonymous_9(/store/modules/subscription/module.jag:32)
> at
> org.jaggeryjs.rhino.store.modules.subscription.c0.call(/store/modules/subscription/module.jag)
> at
> org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52)
> at
> org.jaggeryjs.rhino.store.site.blocks.subscription.subscription_add.ajax.c0._c_anonymous_1(/store/site/blocks/subscription/subscription-add/ajax/subscription-add.jag:240)
> a
[Dev] Error when generating/refreshing keys in APIM 1.9.0
Hi,
I'm upgrading API Manager to 1.9.0 in App Factory setup.
When generating/refreshing keys I'm getting following exception.
I removed consumer key from AM_APPLICATION_KEY_MAPPING and try to generate
the key again -> but the exception is still throwing
Any idea about this?
TID: [0] [AM] [2015-07-24 10:23:06,385] INFO
{JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
-
generateApplicationKey
{JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
TID: [0] [AM] [2015-07-24 10:23:06,389] INFO
{JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
- -store.getApplicationKey-
{JAGGERY.site.blocks.subscription.subscription-add.ajax.subscription-add:jag}
TID: [0] [AM] [2015-07-24 10:23:06,469] ERROR
{org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO} - Error occurred while
creating an Application Registration Entry for Application :
DefaultApplication {org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO}
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry '1-1-PRODUCTION' for key 'SUBSCRIBER_ID'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
at
org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO.createApplicationRegistrationEntry(ApiMgtDAO.java:308)
at
org.wso2.carbon.apimgt.impl.workflow.ApplicationRegistrationSimpleWorkflowExecutor.complete(ApplicationRegistrationSimpleWorkflowExecutor.java:80)
at
org.wso2.carbon.apimgt.impl.workflow.ApplicationRegistrationSimpleWorkflowExecutor.execute(ApplicationRegistrationSimpleWorkflowExecutor.java:58)
at
org.wso2.carbon.apimgt.impl.APIConsumerImpl.requestApprovalForApplicationRegistration(APIConsumerImpl.java:2179)
at
org.wso2.carbon.apimgt.impl.UserAwareAPIConsumer.requestApprovalForApplicationRegistration(UserAwareAPIConsumer.java:34)
at
org.wso2.carbon.apimgt.hostobjects.APIStoreHostObject.jsFunction_getApplicationKey(APIStoreHostObject.java:751)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)
at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:386)
at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52)
at
org.jaggeryjs.rhino.store.modules.subscription.c2._c_anonymous_2(/store/modules/subscription/key.jag:41)
at
org.jaggeryjs.rhino.store.modules.subscription.c2.call(/store/modules/subscription/key.jag)
at
org.mozilla.javascript.ScriptRuntime.applyOrCall(ScriptRuntime.java:2430)
at org.mozilla.javascript.BaseFunction.execIdCall(BaseFunction.java:269)
at
org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:97)
at org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:42)
at
org.jaggeryjs.rhino.store.modules.subscription.c0._c_anonymous_9(/store/modules/subscription/module.jag:32)
at
org.jaggeryjs.rhino.store.modules.subscription.c0.call(/store/modules/subscription/module.jag)
at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:52)
at
org.jaggeryjs.rhino.store.site.blocks.subscription.subscription_add.ajax.c0._c_anonymous_1(/store/site/blocks/subscription/subscription-add/ajax/subscription-add.jag:240)
at
org.jaggeryjs.rhino.store.site.blocks.subscription.subscription_add.ajax.c0.call(/store/site/blocks/subscription/subscription-add/ajax/subscription-add.jag)
at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:23)
at
org.jaggeryjs.rhino.store.site.blocks.subscription.subscription_add.ajax.c0._c_script_0(/store/site/blocks/subscription/subscription-add/ajax/subscription-add.jag:3)
at
org.jaggeryjs.rhino.store.site.blocks.subscription.subscriptio
