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

["Rayees Namathponnan (JIRA)" <ji...@apache.org>]

Rayees Namathponnan created CLOUDSTACK-4747:
-----------------------------------------------

             Summary: [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 


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