You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Rayees Namathponnan (JIRA)" <ji...@apache.org> on 2013/09/26 23:22:02 UTC

[jira] [Updated] (CLOUDSTACK-4747) [Automation] Test cases creating account with more 100 character; account creation failing due to this

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-4747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rayees Namathponnan updated CLOUDSTACK-4747:
--------------------------------------------

    Description: 
You cannot create account more than 100 characters; 

We added test case's name in account;  but should trim the account name maximum to 99 characters to avoid these kind of failures 


integration.component.test_netscaler_nw_off.TestNOWithNetscaler.test_02_network_off_with_conserve_mode_netscaler



Execute cmd: createaccount failed, due to: errorCode: 530, errorText:DB Exception on: com.mysql.jdbc.PreparedStatement@4d345362: INSERT INTO account (account.account_name, account.type, account.domain_id, account.state, account.cleanup_needed, account.network_domain, account.uuid, account.default_zone_id, account.default) VALUES (_binary'test-test_netscaler_nw_off-TestNwOffSToDUpgrade-test_02_network_off_with_conserve_mode_netscaler-AZBFBO', 2, 1, 'enabled', 0, null, _binary'0c361f17-c605-456f-ad0b-b1952bce575a', null, 0)
Stacktrace

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/unittest/case.py", line 311, in run
    self.setUp()
  File "/Repo_30X/ipcl/cloudstack/test/integration/component/test_netscaler_nw_off.py", line 2428, in setUp
    domainid=self.domain.id
  File "/usr/local/lib/python2.7/site-packages/marvin/integration/lib/base.py", line 116, in create
    account = apiclient.createAccount(cmd)
  File "/usr/local/lib/python2.7/site-packages/marvin/cloudstackAPI/cloudstackAPIClient.py", line 495, in createAccount
    response = self.connection.marvin_request(command, response_type=response, method=method)
  File "/usr/local/lib/python2.7/site-packages/marvin/cloudstackConnection.py", line 222, in marvin_request
    response = jsonHelper.getResultObj(response.json(), response_type)
  File "/usr/local/lib/python2.7/site-packages/marvin/jsonHelper.py", line 148, in getResultObj
    raise cloudstackException.cloudstackAPIException(respname, errMsg)
cloudstackAPIException: Execute cmd: createaccount failed, due to: errorCode: 530, errorText:DB Exception on: com.mysql.jdbc.PreparedStatement@4d345362: INSERT INTO account (account.account_name, account.type, account.domain_id, account.state, account.cleanup_needed, account.network_domain, account.uuid, account.default_zone_id, account.default) VALUES (_binary'test-test_netscaler_nw_off-TestNwOffSToDUpgrade-test_02_network_off_with_conserve_mode_netscaler-AZBFBO', 2, 1, 'enabled', 0, null, _binary'0c361f17-c605-456f-ad0b-b1952bce575a', null, 0)

  was:
You cannot create account more than 100 characters; 

We added test case's name in account;  but should trim the account name maximum to 99 characters to avoid 


integration.component.test_netscaler_nw_off.TestNOWithNetscaler.test_02_network_off_with_conserve_mode_netscaler



Execute cmd: createaccount failed, due to: errorCode: 530, errorText:DB Exception on: com.mysql.jdbc.PreparedStatement@4d345362: INSERT INTO account (account.account_name, account.type, account.domain_id, account.state, account.cleanup_needed, account.network_domain, account.uuid, account.default_zone_id, account.default) VALUES (_binary'test-test_netscaler_nw_off-TestNwOffSToDUpgrade-test_02_network_off_with_conserve_mode_netscaler-AZBFBO', 2, 1, 'enabled', 0, null, _binary'0c361f17-c605-456f-ad0b-b1952bce575a', null, 0)
Stacktrace

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/unittest/case.py", line 311, in run
    self.setUp()
  File "/Repo_30X/ipcl/cloudstack/test/integration/component/test_netscaler_nw_off.py", line 2428, in setUp
    domainid=self.domain.id
  File "/usr/local/lib/python2.7/site-packages/marvin/integration/lib/base.py", line 116, in create
    account = apiclient.createAccount(cmd)
  File "/usr/local/lib/python2.7/site-packages/marvin/cloudstackAPI/cloudstackAPIClient.py", line 495, in createAccount
    response = self.connection.marvin_request(command, response_type=response, method=method)
  File "/usr/local/lib/python2.7/site-packages/marvin/cloudstackConnection.py", line 222, in marvin_request
    response = jsonHelper.getResultObj(response.json(), response_type)
  File "/usr/local/lib/python2.7/site-packages/marvin/jsonHelper.py", line 148, in getResultObj
    raise cloudstackException.cloudstackAPIException(respname, errMsg)
cloudstackAPIException: Execute cmd: createaccount failed, due to: errorCode: 530, errorText:DB Exception on: com.mysql.jdbc.PreparedStatement@4d345362: INSERT INTO account (account.account_name, account.type, account.domain_id, account.state, account.cleanup_needed, account.network_domain, account.uuid, account.default_zone_id, account.default) VALUES (_binary'test-test_netscaler_nw_off-TestNwOffSToDUpgrade-test_02_network_off_with_conserve_mode_netscaler-AZBFBO', 2, 1, 'enabled', 0, null, _binary'0c361f17-c605-456f-ad0b-b1952bce575a', null, 0)

    
> [Automation] Test cases creating account with more 100 character;  account creation failing due to this 
> --------------------------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-4747
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4747
>             Project: CloudStack
>          Issue Type: Test
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Automation, Test
>    Affects Versions: 4.2.1
>         Environment: Automation 
>            Reporter: Rayees Namathponnan
>            Priority: Blocker
>             Fix For: 4.2.1
>
>
> You cannot create account more than 100 characters; 
> We added test case's name in account;  but should trim the account name maximum to 99 characters to avoid these kind of failures 
> integration.component.test_netscaler_nw_off.TestNOWithNetscaler.test_02_network_off_with_conserve_mode_netscaler
> Execute cmd: createaccount failed, due to: errorCode: 530, errorText:DB Exception on: com.mysql.jdbc.PreparedStatement@4d345362: INSERT INTO account (account.account_name, account.type, account.domain_id, account.state, account.cleanup_needed, account.network_domain, account.uuid, account.default_zone_id, account.default) VALUES (_binary'test-test_netscaler_nw_off-TestNwOffSToDUpgrade-test_02_network_off_with_conserve_mode_netscaler-AZBFBO', 2, 1, 'enabled', 0, null, _binary'0c361f17-c605-456f-ad0b-b1952bce575a', null, 0)
> Stacktrace
> Traceback (most recent call last):
>   File "/usr/local/lib/python2.7/unittest/case.py", line 311, in run
>     self.setUp()
>   File "/Repo_30X/ipcl/cloudstack/test/integration/component/test_netscaler_nw_off.py", line 2428, in setUp
>     domainid=self.domain.id
>   File "/usr/local/lib/python2.7/site-packages/marvin/integration/lib/base.py", line 116, in create
>     account = apiclient.createAccount(cmd)
>   File "/usr/local/lib/python2.7/site-packages/marvin/cloudstackAPI/cloudstackAPIClient.py", line 495, in createAccount
>     response = self.connection.marvin_request(command, response_type=response, method=method)
>   File "/usr/local/lib/python2.7/site-packages/marvin/cloudstackConnection.py", line 222, in marvin_request
>     response = jsonHelper.getResultObj(response.json(), response_type)
>   File "/usr/local/lib/python2.7/site-packages/marvin/jsonHelper.py", line 148, in getResultObj
>     raise cloudstackException.cloudstackAPIException(respname, errMsg)
> cloudstackAPIException: Execute cmd: createaccount failed, due to: errorCode: 530, errorText:DB Exception on: com.mysql.jdbc.PreparedStatement@4d345362: INSERT INTO account (account.account_name, account.type, account.domain_id, account.state, account.cleanup_needed, account.network_domain, account.uuid, account.default_zone_id, account.default) VALUES (_binary'test-test_netscaler_nw_off-TestNwOffSToDUpgrade-test_02_network_off_with_conserve_mode_netscaler-AZBFBO', 2, 1, 'enabled', 0, null, _binary'0c361f17-c605-456f-ad0b-b1952bce575a', null, 0)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira