错误码 当您调用API时，如果遇到“APIGW”开头的错误码，请参见API网关错误码进行处理。 类型 状态码 错误码 错误信息 描述 处理措施 访问方式 500 CAE.01500101 Remote creates access failed. 访问方式创建失败 需要联系技术支持工程师，检查报错具体内容。 500 CAE.01500102 Remote updates access failed. 访问方式更新失败 需要联系技术支持工程师，检查报错具体内容。 500 CAE.01500103 Remote deletes access failed. 访问方式删除失败 需要联系技术支持工程师，检查报错具体内容。 500 CAE.01500104 Delete ip group failed. 删除ip地址组失败 需要联系技术支持工程师，检查依赖服务是否正常。 500 CAE.01500107 ELB service connect failed. 访问ELB连接失败 需要联系技术支持工程师，检查依赖服务是否正常。 组件 500 CAE.01500201 Update component status failed. 更新组件状态失败 重试，组件状态展示正常。若有异常，联系技术支持工程师。 500 CAE.01500202 Execute component action failed. 操作组件失败 联系技术支持工程师，检查组件基本信息。 500 CAE.01500203 Get component config failed. 获取组件配置失败 联系技术支持工程师，一般为报文解析异常 500 CAE.01500204 Get component event failed. 获取组件事件失败 联系技术支持工程师，检查依赖服务是否正常。 400 CAE.01500206 The component name is invalid. 组件名称非法 根据要求修改组件名称。 400 CAE.01500205 The input component name already exists in the application. 当前应用存在同名组件 同一应用不能存在同名组件，根据要求修改组件名称。 400 CAE.01500211 Data type of imported configuration variable is not string. 下发组件配置类型非法 根据要求修改组件配置类型。 400 CAE.01500208 Component not exist. 组件不存在 确认操作组件是否正确，根据要求修改组件ID。 400 CAE.01500207 Component instance is exist. 组件实例有残留 删除组件实例失败，联系技术支持工程师。 应用 400 CAE.01500212 There are components under application, delete operation is forbidden. 当前应用存在组件，禁止删除应用 需删除所有组件才能删除应用。 404 CAE.01500213 App not exist. 应用不存在 确认操作应用是否正确，联系技术支持工程师。 环境 400 CAE.01500303 Engine with basic not found. 环境基础信息未找到 联系技术支持工程师。 500 CAE.01500301 Engine status is unavailable. 环境状态不可用 联系技术支持工程师。 400 CAE.01500311 Engine is already exist. 环境已存在 联系技术支持工程师。 500 CAE.01500302 Create engine failed. 创建环境失败 联系技术支持工程师。 500 CAE.01500401 Create environment failed. 创建环境失败 联系技术支持工程师。 500 CAE.01500402 Delete environment failed. 删除环境失败 联系技术支持工程师。 500 CAE.01500403 Env is deleting. 环境正在被删除 等待环境删除完成。 500 CAE.01500404 Environment not found. 环境不存在 查询环境是否存在。 400 CAE.01500405 The environment has unbound cloud storage resource. 环境存在未绑定的云存储资源 联系技术支持工程师。 400 CAE.01500406 There are applications under environment, delete operation is forbidden. 环境下存在应用，不允许删除环境。 删除应用后再删除环境。 400 CAE.01500407 The environment cannot be deleted because the event notice rule still exists. 环境存在事件通知规则。 删除事件通知规则后重试。 400 CAE.01500408 Environment cannot be deleted, as there are un-deleted network configurations in system settings. 环境下系统设置中存在系统网络配置，不允许删除环境。 删除系统设置下的系统网络配置，再删除环境。 400 CAE.01500409 VPC id is inconsistent with the vpc id of environment. vpc ingress/egress配置的vpc id和环境选择的vpc id不一致。不允许创建系统网络配置。 在CAE概览界面查看环境所在VPC（虚拟私有云），选择一致的VPC再创建系统网络配置。 400 CAE.01500410 VPC ingress can not be deleted, as some components is using vpc access. 系统网络配置下的"VPC访问CAE环境"不允许删除，因为还有组件在使用。 确认组件是否还需要继续使用，如果需要则不允许删除，如果不需要则在组件配置中删除后重试。 400 CAE.01500411 Current environment is too old, can not retry, you can delete the environment and create a new environment. 创建环境时报错：当前环境版本过低，不允许重试。请删除环境后重新创建新环境。 删除环境后重新创建。 500 CAE.01500412 Get embedded cidrs failed. 创建"CAE环境访问VPC"配置，获取内置网段失败。 联系技术支持工程师。 400 CAE.01500413 The environment cannot be deleted because it still has sub environments. 环境不能删除，因为还有其他子环境未删除。 删除子环境后再删除当前环境。 任务 500 CAE.01500501 Retry job failed. 重试任务失败 查看任务状态，任务状态失败或者超时方可重试。 云存储 500 CAE.01500601 Creates volume failed. 创建磁盘挂载失败 联系技术支持工程师。 500 CAE.01500602 Deletes volume failed. 删除磁盘挂载失败 联系技术支持工程师。 400 CAE.01500603 Conflicts with another volume or log path under component. 与同组件下云存储配置路径或日志采集路径冲突。 检查云存储配置路径或日志采集路径，修改冲突路径。 400 CAE.01500604 AK SK is invalid. ak sk无效 刷新页面重试。若仍然有异常，联系技术支持工程师。 配额 400 CAE.01500712 Quota is insufficient. 配额不足 联系技术支持工程师添加配额。 500 CAE.01500701 Increase used failed. 配额使用量增加修改失败 联系技术支持工程师。 500 CAE.01500702 Decrease used failed. 配额使用量减少修改失败 联系技术支持工程师。 500 CAE.01500703 Get quota failed. 获取配额失败 联系技术支持工程师。 委托 500 CAE.01500801 Service domain error, get service token failed. 获取服务token失败 联系技术支持工程师，检查服务依赖服务及配置项。 500 CAE.01500802 Switch token error, check iam service status. 转换token失败 重试，仍然失败则联系技术支持工程师，检查服务依赖服务及配置项。 500 CAE.01500803 Grant agency roles error, check iam service status or iam strategy. 授权失败 联系技术支持工程师，检查服务依赖服务及配置项。 500 CAE.01500804 Create or update agency failed, check if iam is ok. 创建或更新委托时失败 联系技术支持工程师，检查服务依赖服务IAM及相关配置项。 401 CAE.01500805 Get token by agency failed, agency is not exist. 项目里缺少委托或角色 联系技术支持工程师，检查IAM中委托及角色。 401 CAE.01500806 Not a domain user, or no security administrator role. 账号权限不足 检查当前IAM账号权限。 403 CAE.01500807 Roles in the agency for cae not enough, please re-create cae agency. CAE的委托中缺少部分部分服务访问权限 检查CAE相关委托中是否包含所有服务访问权限，可通过删除委托重建解决。 资源租户 500 CAE.01500901 Get resource tenant token failed, check if iam is ok. 获取资源租户token失败 联系技术支持工程师，检查服务依赖服务及配置项。 计费 500 CAE.01501001 List bills error,raw data fails to be aggregated or the charging process is abnormal. 获取账单失败 联系技术支持工程师。 账号冻结 401 CAE.01501101 User is restricted, can not execute create operation. 此账号因余额不足受限，请检查账号状态 账号充值后解冻。 401 CAE.01501102 User is suspended, can not execute any operation, except view. 此账号被冻结，请检查账号状态 联系技术支持工程师。 域名、证书 400 CAE.01501201 The domain has already existed. 域名配置冲突 配置了重复的域名，检查该域名是否已经配置。 500 CAE.01501203 Delete zone failed, check dns service status or component config. 域名正在被组件使用，不能删除 检查已有组件，查看是否有组件正在使用该域名。 500 CAE.01501205 Create tls certificate failed in k8s. 证书创建失败 联系技术支持工程师，检查服务依赖服务及配置项。 500 CAE.01501206 Update tls certificate failed in k8s. 证书更新失败 联系技术支持工程师，检查服务依赖服务及配置项。 500 CAE.01501207 Delete tls certificate failed, check cluster status or component config. 证书删除失败 联系技术支持工程师，检查服务依赖服务及配置项。 400 CAE.01501208 The certificate format is invalid or the certificate private key does not match. 操作证书时请求体错误 检查操作证书的请求体是否与api规则内容一致 资源 404 CAE.01501301 Resource not exist. 请求的资源不存在 确认该资源是否仍然存在 400 CAE.01501302 Resource already exist. 资源已存在。 确认是否已创建过同一资源。 配置 400 CAE.01501401 The component access configuration parameter is not valid, please check your parameter. 访问方式配置有错误，可能的原因有 端口数字超过限制、端口冲突 修改端口至[1,65535]范围，且检查可能涉及的配置（cae的组件占用的端口、所使用的独享型elb的监听器），保证端口占用不冲突。 400 CAE.01501404 The path of access configuration is invalid. 不符合url的正则规则 应在访问方式配置项里填写符合url正则规则的路径。 400 CAE.01501402 The input port will result in port conflict. 所选elb的端口已被占用 使用其他端口，如果使用的是独享型ELB，可检查该端口对应监听器使用情况，删除该监听器后，组件即可正常使用该端口。 400 CAE.01501403 The port of ingress rule conflicts. 七层访问方式策略冲突 修改域名、端口、elb、url中的任意一项，使【域名+监听端口+elb+url】不完全相同。 400 CAE.01501405 There is no monitor system config under environment, please create first. 创建性能管理配置，未配置系统设置-监控系统。 先配置在系统设置-监控系统配置监控系统，再创建组件性能管理配置。 权限 403 CAE.01501700 Not authorized for create. 缺少权限 添加对应权限，联系技术支持工程师。 403 CAE.01501701 Not real name authorized. 认证失败 联系技术支持工程师。 参数 400 CAE.01501800 The project in request url and the user token is not matched. url中project id与当前用户token不匹配 检查url中project id或当前token是否正确。 400 CAE.01501801 The input time should be at least 2 mins later than now. 配置启停规则时间距离当前时间太近 配置距离当前时间超过2分钟的启停规则执行时间。 400 CAE.01501802 Timer rule conflicts with scaling rule. 启停规则与生效范围内组件弹性伸缩策略冲突。 解决同一组件启停规则与弹性伸缩策略冲突，关闭其中一个。 400 CAE.01501803 Scaling rule conflicts with timer rule. 组件弹性策略与作用于该组件的启停策略冲突。 解决同一组件启停规则与弹性伸缩策略冲突，关闭其中一个。 400 CAE.01501804 Scaling rule unique param duplicate. 伸缩策略中时间配置冲突 检查伸缩策略中配置的时间策略。 400 CAE.01501805 VPC cidr conflict with embedded cidrs. vpc网段与CAE环境内置网段冲突 联系技术支持工程师。 400 CAE.01501806 Monitor system agent version is invalid. 监控系统探针版本无效 填写有效的监控系统探针版本。 400 CAE.01500108 Cannot modify health check protocol, please switch off first. 修改访问方式-健康检查协议失败 先关闭访问方式-健康检查后配置需切换的健康检查协议。 事件通知 400 CAE.01501901 The maximum number of noticeRules is 50. 事件通知规则上限50条 联系技术支持工程师。 403 CAE.01501902 Your account does not have the SMN permission. 账号无SMN权限 联系账号管理员配置权限。 DEW凭据 400 CAE.01502000 The maximum number of DEW secrets is 20. DEW凭据上线20条 联系技术支持工程师。 400 CAE.01502001 There are components using the secret. 有组件正在使用此凭据 请取消组件的相应的配置后重试。 403 CAE.01502002 You do not have permissions to get secret info, please check your current agency roles. 当前没有权限获取DEW凭据信息，请检查您当前账号下的权限 请增加DEW服务相应权限后再次重试。 集群 500 CAE.01502101 The cluster cannot be operated in the current state. CAE底层集群无法操作 联系技术支持工程师。 父主题： 附录

SQL20 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 select i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(cs_ext_sales_price) as itemrevenue ,sum(cs_ext_sales_price)*100/sum(sum(cs_ext_sales_price)) over (partition by i_class) as revenueratio from catalog_sales ,item ,date_dim where cs_item_sk = i_item_sk and i_category in ('Sports', 'Shoes', 'Women') and cs_sold_date_sk = d_date_sk and d_date between cast('2001-03-21' as date) and (cast('2001-03-21' as date) + 30) group by i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio limit 100;

SQL18 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 select i_item_id, ca_country, ca_state, ca_county, avg( cast(cs_quantity as decimal(12,2))) agg1, avg( cast(cs_list_price as decimal(12,2))) agg2, avg( cast(cs_coupon_amt as decimal(12,2))) agg3, avg( cast(cs_sales_price as decimal(12,2))) agg4, avg( cast(cs_net_profit as decimal(12,2))) agg5, avg( cast(c_birth_year as decimal(12,2))) agg6, avg( cast(cd1.cd_dep_count as decimal(12,2))) agg7 from catalog_sales, customer_demographics cd1, customer_demographics cd2, customer, customer_address, date_dim, item where cs_sold_date_sk = d_date_sk and cs_item_sk = i_item_sk and cs_bill_cdemo_sk = cd1.cd_demo_sk and cs_bill_customer_sk = c_customer_sk and cd1.cd_gender = 'M' and cd1.cd_education_status = 'Primary' and c_current_cdemo_sk = cd2.cd_demo_sk and c_current_addr_sk = ca_address_sk and c_birth_month in (10,1,8,7,3,5) and d_year = 1998 and ca_state in ('NE','OK','NC' ,'CO','ID','AR','MO') group by rollup (i_item_id, ca_country, ca_state, ca_county) order by ca_country, ca_state, ca_county, i_item_id limit 100;

SQL13 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 select avg(ss_quantity) ,avg(ss_ext_sales_price) ,avg(ss_ext_wholesale_cost) ,sum(ss_ext_wholesale_cost) from store_sales ,store ,customer_demographics ,household_demographics ,customer_address ,date_dim where s_store_sk = ss_store_sk and ss_sold_date_sk = d_date_sk and d_year = 2001 and((ss_hdemo_sk=hd_demo_sk and cd_demo_sk = ss_cdemo_sk and cd_marital_status = 'U' and cd_education_status = '4 yr Degree' and ss_sales_price between 100.00 and 150.00 and hd_dep_count = 3 )or (ss_hdemo_sk=hd_demo_sk and cd_demo_sk = ss_cdemo_sk and cd_marital_status = 'D' and cd_education_status = '2 yr Degree' and ss_sales_price between 50.00 and 100.00 and hd_dep_count = 1 ) or (ss_hdemo_sk=hd_demo_sk and cd_demo_sk = ss_cdemo_sk and cd_marital_status = 'S' and cd_education_status = 'Advanced Degree' and ss_sales_price between 150.00 and 200.00 and hd_dep_count = 1 )) and((ss_addr_sk = ca_address_sk and ca_country = 'United States' and ca_state in ('IL', 'WI', 'TN') and ss_net_profit between 100 and 200 ) or (ss_addr_sk = ca_address_sk and ca_country = 'United States' and ca_state in ('MO', 'OK', 'WA') and ss_net_profit between 150 and 300 ) or (ss_addr_sk = ca_address_sk and ca_country = 'United States' and ca_state in ('NE', 'VA', 'GA') and ss_net_profit between 50 and 250 )) ;

SQL17 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 select i_item_id ,i_item_desc ,s_state ,count(ss_quantity) as store_sales_quantitycount ,avg(ss_quantity) as store_sales_quantityave ,stddev_samp(ss_quantity) as store_sales_quantitystdev ,stddev_samp(ss_quantity)/avg(ss_quantity) as store_sales_quantitycov ,count(sr_return_quantity) as store_returns_quantitycount ,avg(sr_return_quantity) as store_returns_quantityave ,stddev_samp(sr_return_quantity) as store_returns_quantitystdev ,stddev_samp(sr_return_quantity)/avg(sr_return_quantity) as store_returns_quantitycov ,count(cs_quantity) as catalog_sales_quantitycount ,avg(cs_quantity) as catalog_sales_quantityave ,stddev_samp(cs_quantity) as catalog_sales_quantitystdev ,stddev_samp(cs_quantity)/avg(cs_quantity) as catalog_sales_quantitycov from store_sales ,store_returns ,catalog_sales ,date_dim d1 ,date_dim d2 ,date_dim d3 ,store ,item where d1.d_quarter_name = '2000Q1' and d1.d_date_sk = ss_sold_date_sk and i_item_sk = ss_item_sk and s_store_sk = ss_store_sk and ss_customer_sk = sr_customer_sk and ss_item_sk = sr_item_sk and ss_ticket_number = sr_ticket_number and sr_returned_date_sk = d2.d_date_sk and d2.d_quarter_name in ('2000Q1','2000Q2','2000Q3') and sr_customer_sk = cs_bill_customer_sk and sr_item_sk = cs_item_sk and cs_sold_date_sk = d3.d_date_sk and d3.d_quarter_name in ('2000Q1','2000Q2','2000Q3') group by i_item_id ,i_item_desc ,s_state order by i_item_id ,i_item_desc ,s_state limit 100;

SQL10 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 select cd_gender, cd_marital_status, cd_education_status, count(*) cnt1, cd_purchase_estimate, count(*) cnt2, cd_credit_rating, count(*) cnt3, cd_dep_count, count(*) cnt4, cd_dep_employed_count, count(*) cnt5, cd_dep_college_count, count(*) cnt6 from customer c,customer_address ca,customer_demographics where c.c_current_addr_sk = ca.ca_address_sk and ca_county in ('Clark County','Richardson County','Tom Green County','Sullivan County','Cass County') and cd_demo_sk = c.c_current_cdemo_sk and exists (select * from store_sales,date_dim where c.c_customer_sk = ss_customer_sk and ss_sold_date_sk = d_date_sk and d_year = 2000 and d_moy between 1 and 1+3) and (exists (select * from web_sales,date_dim where c.c_customer_sk = ws_bill_customer_sk and ws_sold_date_sk = d_date_sk and d_year = 2000 and d_moy between 1 ANd 1+3) or exists (select * from catalog_sales,date_dim where c.c_customer_sk = cs_ship_customer_sk and cs_sold_date_sk = d_date_sk and d_year = 2000 and d_moy between 1 and 1+3)) group by cd_gender, cd_marital_status, cd_education_status, cd_purchase_estimate, cd_credit_rating, cd_dep_count, cd_dep_employed_count, cd_dep_college_count order by cd_gender, cd_marital_status, cd_education_status, cd_purchase_estimate, cd_credit_rating, cd_dep_count, cd_dep_employed_count, cd_dep_college_count limit 100;

SQL12 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 select i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(ws_ext_sales_price) as itemrevenue ,sum(ws_ext_sales_price)*100/sum(sum(ws_ext_sales_price)) over (partition by i_class) as revenueratio from web_sales ,item ,date_dim where ws_item_sk = i_item_sk and i_category in ('Music', 'Shoes', 'Children') and ws_sold_date_sk = d_date_sk and d_date between cast('2000-05-14' as date) and (cast('2000-05-14' as date) + 30 ) group by i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio limit 100;

SQL7 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 select i_item_id, avg(ss_quantity) agg1, avg(ss_list_price) agg2, avg(ss_coupon_amt) agg3, avg(ss_sales_price) agg4 from store_sales, customer_demographics, date_dim, item, promotion where ss_sold_date_sk = d_date_sk and ss_item_sk = i_item_sk and ss_cdemo_sk = cd_demo_sk and ss_promo_sk = p_promo_sk and cd_gender = 'M' and cd_marital_status = 'U' and cd_education_status = 'College' and (p_channel_email = 'N' or p_channel_event = 'N') and d_year = 1999 group by i_item_id order by i_item_id limit 100;

SQL5 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 with ssr as (select s_store_id, sum(sales_price) as sales, sum(profit) as profit, sum(return_amt) as returns, sum(net_loss) as profit_loss from ( select ss_store_sk as store_sk, ss_sold_date_sk as date_sk, ss_ext_sales_price as sales_price, ss_net_profit as profit, cast(0 as decimal(7,2)) as return_amt, cast(0 as decimal(7,2)) as net_loss from store_sales union all select sr_store_sk as store_sk, sr_returned_date_sk as date_sk, cast(0 as decimal(7,2)) as sales_price, cast(0 as decimal(7,2)) as profit, sr_return_amt as return_amt, sr_net_loss as net_loss from store_returns ) salesreturns, date_dim, store where date_sk = d_date_sk and d_date between cast('2002-08-05' as date) and (cast('2002-08-05' as date) + 14 ) and store_sk = s_store_sk group by s_store_id) , csr as (select cp_catalog_page_id, sum(sales_price) as sales, sum(profit) as profit, sum(return_amt) as returns, sum(net_loss) as profit_loss from ( select cs_catalog_page_sk as page_sk, cs_sold_date_sk as date_sk, cs_ext_sales_price as sales_price, cs_net_profit as profit, cast(0 as decimal(7,2)) as return_amt, cast(0 as decimal(7,2)) as net_loss from catalog_sales union all select cr_catalog_page_sk as page_sk, cr_returned_date_sk as date_sk, cast(0 as decimal(7,2)) as sales_price, cast(0 as decimal(7,2)) as profit, cr_return_amount as return_amt, cr_net_loss as net_loss from catalog_returns ) salesreturns, date_dim, catalog_page where date_sk = d_date_sk and d_date between cast('2002-08-05' as date) and (cast('2002-08-05' as date) + 14 ) and page_sk = cp_catalog_page_sk group by cp_catalog_page_id) , wsr as (select web_site_id, sum(sales_price) as sales, sum(profit) as profit, sum(return_amt) as returns, sum(net_loss) as profit_loss from ( select ws_web_site_sk as wsr_web_site_sk, ws_sold_date_sk as date_sk, ws_ext_sales_price as sales_price, ws_net_profit as profit, cast(0 as decimal(7,2)) as return_amt, cast(0 as decimal(7,2)) as net_loss from web_sales union all select ws_web_site_sk as wsr_web_site_sk, wr_returned_date_sk as date_sk, cast(0 as decimal(7,2)) as sales_price, cast(0 as decimal(7,2)) as profit, wr_return_amt as return_amt, wr_net_loss as net_loss from web_returns left outer join web_sales on ( wr_item_sk = ws_item_sk and wr_order_number = ws_order_number) ) salesreturns, date_dim, web_site where date_sk = d_date_sk and d_date between cast('2002-08-05' as date) and (cast('2002-08-05' as date) + 14 ) and wsr_web_site_sk = web_site_sk group by web_site_id) select channel , id , sum(sales) as sales , sum(returns) as returns , sum(profit) as profit from (select 'store channel' as channel , 'store' || s_store_id as id , sales , returns , (profit - profit_loss) as profit from ssr union all select 'catalog channel' as channel , 'catalog_page' || cp_catalog_page_id as id , sales , returns , (profit - profit_loss) as profit from csr union all select 'web channel' as channel , 'web_site' || web_site_id as id , sales , returns , (profit - profit_loss) as profit from wsr ) x group by rollup (channel, id) order by channel ,id limit 100;

SQL3 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 select dt.d_year ,item.i_brand_id brand_id ,item.i_brand brand ,sum(ss_ext_sales_price) sum_agg from date_dim dt ,store_sales ,item where dt.d_date_sk = store_sales.ss_sold_date_sk and store_sales.ss_item_sk = item.i_item_sk and item.i_manufact_id = 125 and dt.d_moy=11 group by dt.d_year ,item.i_brand ,item.i_brand_id order by dt.d_year ,sum_agg desc ,brand_id limit 100;

SQL2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 with wscs as (select sold_date_sk ,sales_price from (select ws_sold_date_sk sold_date_sk ,ws_ext_sales_price sales_price from web_sales union all select cs_sold_date_sk sold_date_sk ,cs_ext_sales_price sales_price from catalog_sales)), wswscs as (select d_week_seq, sum(case when (d_day_name='Sunday') then sales_price else null end) sun_sales, sum(case when (d_day_name='Monday') then sales_price else null end) mon_sales, sum(case when (d_day_name='Tuesday') then sales_price else null end) tue_sales, sum(case when (d_day_name='Wednesday') then sales_price else null end) wed_sales, sum(case when (d_day_name='Thursday') then sales_price else null end) thu_sales, sum(case when (d_day_name='Friday') then sales_price else null end) fri_sales, sum(case when (d_day_name='Saturday') then sales_price else null end) sat_sales from wscs ,date_dim where d_date_sk = sold_date_sk group by d_week_seq) select d_week_seq1 ,round(sun_sales1/sun_sales2,2) ,round(mon_sales1/mon_sales2,2) ,round(tue_sales1/tue_sales2,2) ,round(wed_sales1/wed_sales2,2) ,round(thu_sales1/thu_sales2,2) ,round(fri_sales1/fri_sales2,2) ,round(sat_sales1/sat_sales2,2) from (select wswscs.d_week_seq d_week_seq1 ,sun_sales sun_sales1 ,mon_sales mon_sales1 ,tue_sales tue_sales1 ,wed_sales wed_sales1 ,thu_sales thu_sales1 ,fri_sales fri_sales1 ,sat_sales sat_sales1 from wswscs,date_dim where date_dim.d_week_seq = wswscs.d_week_seq and d_year = 1999) y, (select wswscs.d_week_seq d_week_seq2 ,sun_sales sun_sales2 ,mon_sales mon_sales2 ,tue_sales tue_sales2 ,wed_sales wed_sales2 ,thu_sales thu_sales2 ,fri_sales fri_sales2 ,sat_sales sat_sales2 from wswscs ,date_dim where date_dim.d_week_seq = wswscs.d_week_seq and d_year = 1999+1) z where d_week_seq1=d_week_seq2-53 order by d_week_seq1;

命令生成方法 TPC-DS标准99个SQL查询语句可用如下方法生成： 准备工作。生成TPC-DS查询语句前需要修改query_templates目录下的文件： 登录测试过程申请的ECS，进入/data1/script/tpcds-kit/DSGen-software-code-3.2.0rc1/query_templates目录： 1 cd /data1/script/tpcds-kit/DSGen-software-code-3.2.0rc1/query_templates 新建文件hwdws.tpl，内容为： 1 2 3 4 5 define __LIMITA = ""; define __LIMITB = ""; define __LIMITC = "limit %d"; define _BEGIN = "-- begin query " + [_QUERY] + " in stream " + [_STREAM] + " using template " + [_TEMPLATE]; define _END = "-- end query " + [_QUERY] + " in stream " + [_STREAM] + " using template " + [_TEMPLATE]; 因TPC-DS工具中SQL语句生成模板有语法错误，需修改query77.tpl，将135行的‘, coalesce(returns, 0) returns’改为‘, coalesce(returns, 0) as returns’。 执行以下命令生成查询语句： 1 ./dsqgen -input ../query_templates/templates.lst -directory ../query_templates/ -scale 1000 -dialect hwdws 执行后会生成query_0.sql文件，里面放着99个标准SQL语句，需要手动去切分成99个文件。 生成的标准查询中如下日期函数语法在GaussDB(DWS)暂不支持，需要手动进行修改： 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 Q5: and (cast('2001-08-19' as date) + 14 days) 修改为 and (cast('2001-08-19' as date) + 14) Q12:and (cast('1999-02-28' as date) + 30 days) 修改为 and (cast('1999-02-28' as date) + 30) Q16:(cast('1999-4-01' as date) + 60 days) 修改为 (cast('1999-4-01' as date) + 60) Q20:and (cast('1998-05-05' as date) + 30 days) 修改为 and (cast('1998-05-05' as date) + 30) Q21:and d_date between (cast ('2000-05-19' as date) - 30 days) 修改为 and d_date between (cast ('2000-05-19' as date) - 30) and (cast ('2000-05-19' as date) + 30 days) 修改为 and (cast ('2000-05-19' as date) + 30) Q32:(cast('1999-02-22' as date) + 90 days) 修改为 (cast('1999-02-22' as date) + 90) Q37:and d_date between cast('1998-04-29' as date) and (cast('1998-04-29' as date) + 60 days) 修改为 and d_date between cast('1998-04-29' as date) and (cast('1998-04-29' as date) + 60) Q40:and d_date between (cast ('2002-05-10' as date) - 30 days) 修改为 and d_date between (cast ('2002-05-10' as date) - 30) and (cast ('2002-05-10' as date) + 30 days) 修改为 and (cast ('2002-05-10' as date) + 30) Q77:and (cast('1999-08-29' as date) + 30 days) 修改为 and (cast('1999-08-29' as date) + 30) Q80:and (cast('2002-08-04' as date) + 30 days) 修改为 and (cast('2002-08-04' as date) + 30) Q82:and d_date between cast('1998-01-18' as date) and (cast('1998-01-18' as date) + 60 days) 修改为 and d_date between cast('1998-01-18' as date) and (cast('1998-01-18' as date) + 60) Q92:(cast('2001-01-26' as date) + 90 days) 修改为 (cast('2001-01-26' as date) + 90) Q94:(cast('1999-5-01' as date) + 60 days) 修改为 (cast('1999-5-01' as date) + 60) Q95:(cast('1999-4-01' as date) + 60 days) 修改为 (cast('1999-4-01' as date) + 60) Q98:and (cast('2002-04-01' as date) + 30 days) 修改为 and (cast('2002-04-01' as date) + 30)

错误码 当您调用API时，如果遇到“APIGW”开头的错误码，请参见API网关错误码进行处理。 表1 错误码 状态码 错误码 错误信息 描述 处理措施 400 rgcservice.400 Bad Request: {0}. 云服务内部错误，请重试。 请联系技术支持。 400 rgcservice.1001 bad request for query icc instance. 查询是否开通IAM身份中心实例失败。 请稍后重试。 400 rgcservice.1002 bad request for register region. 注册区域失败。 请稍后重试。 400 rgcservice.1003 bad request for start identity center. 启动IAM身份中心失败。 请稍后重试。 400 rgcservice.1004 bad request for get registered regions. 查询IAM身份中心实例已开通的区域列表失败。 请稍后重试。 400 rgcservice.1005 the queried region is different from the registered region. 所选主区域和已注册的IAM身份中心的区域不一致。 请重新选择主区域。 400 rgcservice.1006 create instance fail. 创建IAM身份中心实例失败。 请稍后重试。 400 rgcservice.1007 create instance status is not enable. IAM身份中心实例状态不可用。 请稍后重试。 400 rgcservice.1008 create permission set fail. 创建权限失败。 请稍后重试。 400 rgcservice.1009 create user fail. 创建用户失败。 请稍后重试。 400 rgcservice.1010 bad request for get identity center service status. 获取IAM身份中心状态失败。 请稍后重试。 400 rgcservice.1011 bad request for create permission set. 在IIC实例中创建权限集失败。 请稍后重试。 400 rgcservice.1012 bad request for attach managed policy to permission set. 将系统管理策略附加到权限集失败。 请稍后重试。 400 rgcservice.1013 bad request for create account assignment. 给账号分配权限失败。 请稍后重试。 400 rgcservice.1014 bad request for describe account assignment creation status. 获取账号分配创建状态失败。 请稍后重试。 400 rgcservice.1015 bad request for create group membership. 用户组绑定用户失败。 请稍后重试。 400 rgcservice.1016 bad request for create group. 创建用户组失败。 请稍后重试。 400 rgcservice.1017 bad request for create user. 创建IIC用户失败。 请稍后重试。 400 rgcservice.1018 bad request for get projects. 查询项目信息失败。 请稍后重试。 403 rgcservice.1019 does not have {0} permissions. 当前账号没有权限。 请检查账号权限。 400 rgcservice.1021 bad request for create agency. 创建委托失败。 请稍后重试。 400/403 rgcservice.1022 fail request for assume with service principal. 委托切换失败。 请稍后重试。 400 rgcservice.1024 bad request for create service linked agency. 创建服务关联委托失败。 请稍后重试。 403 rgcservice.1028 Not a management account. 当前账号不是管理账号。 请检查账号是否管理账号。 400 rgcservice.1032 bad request for enable trust service. 启用可信服务失败。 请稍后重试。 400 rgcservice.1033 organizations service not provision. 组织服务未开通。 请开通组织服务。 400 rgcservice.1034 bad request for authorization header pattern. Token请求头非法。 请检查authorization请求头是否合法传入。 403 rgcservice.1035 not found for http header:{0}. 无法找到HTTP请求头。 请检查HTTP请求头是否存在。 400 rgcservice.1036 bad request for request proof. proof请求头非法。 请检查proof请求头是否合法传入。 400 rgcservice.1037 bad request for impersonate. 获取凭据失败。 请联系技术支持。 400 rgcservice.1038 bad request for listRoles. 查询权限列表失败。 请联系技术支持。 400 rgcservice.1039 create base line group fail. 创建基线用户组失败。 请联系技术支持。 400 rgcservice.1040 retrieve user fail. 检索用户失败。 请联系技术支持。 400 rgcservice.1041 describe user fail. 查询用户详情失败。 请联系技术支持。 400 rgcservice.1042 show compliance details fail. 查询合规性信息失败。 请联系技术支持。 400 rgcservice.1043 list aggregate compliance fail. 查询资源聚合器合规规则列表失败。 请联系技术支持。 400 rgcservice.1044 list aggregator fail. 查询资源聚合器列表失败。 请联系技术支持。 400 rgcservice.1045 bad request for list groups. 请求用户组列表失败。 请联系技术支持。 400 rgcservice.1046 The user already exists, but the user name is different. IAM身份中心用户已存在，但用户名与预留用户名不同。 请检查用户名是否正确，填写保持一致。 500 rgcservice.1049 create account failed,failure reason {0}. 创建账号失败。 请稍后重试。 400 rgcservice.1050 Bad Request:{0} not found. 请求错误，未找到相关资源。 请确认资源是否存在。 400 rgcservice.1052 The parent is not managed by RGC. 父级组织单元未注册。 请检查父级组织单元是否已注册。 400 rgcservice.1053 The organization unit child resource is not empty. 当前组织单元的子资源不为空。 请检查是否存在子组织单元或成员账号 400 rgcservice.1054 The account is not managed by RGC. 当前账号未纳管。 请检查当前账号。 400 rgcservice.1055 The organization unit is not managed by RGC. 当前组织单元未注册。 请检查当前组织单元。 400 rgcservice.1056 bad request for query iam assume agency. 切换到成员账号身份失败。 请联系技术支持。 400 rgcservice.1057 The organization unit is not found. 组织单元不存在。 请检查组织单元是否已注册成功。 400 rgcservice.1058 The requested control policy does not exist. 控制策略不存在。 请检查操作的控制策略是否存在。 400 rgcservice.1059 The relationship between the control and the specified target does not exist. 组织单元未启用请求的控制策略。 不允许关闭未开启的控制策略。 400 rgcservice.1060 The Root and core organizational units cannot implement additional control strategies. root和基础组织单元不允许开启或禁用控制策略。 根组织单元和基础组织单元不允许进行控制策略开启与关闭操作。 400 rgcservice.1062 Not allowed to perform operations on an OU that is not successfully registered. 未注册的组织单元不能开启或禁用控制策略。 请操作注册成功的组织单元。 400 rgcservice.1065 The {0} operation is not complete. 操作尚未完成，请稍后重试。 请稍后重试。 400 rgcservice.1067 The landing zone environment is not set. Landing Zone环境未设置。 请设置Landing Zone环境。 400 rgcservice.1068 The selected region is invalid. 所选主区域无效。 请检查主区域可用性状态。 400 rgcservice.1069 The bucket policy is empty. 桶策略为空。 请联系技术支持。 400 rgcservice.1070 bad request for obs. 请求云服务OBS失败。 请稍后重试。 400 rgcservice.1072 Get a unexpected status code. 请求云服务Organizations失败。 请联系技术支持。 400 rgcservice.1073 Org list accounts occur error. 查询组织单元中账号列表失败。 请稍后重试。 400 rgcservice.1074 Failed to call the API for deleting a stackSetInstance. 调用云服务RFS删除stackSet实例失败。 请检查云服务RFS运行是否正常，stackSet实例资源是否正常。 400 rgcservice.1075 The baseLine control cannot be operated. 基线控制策略不支持开启与禁用操作。 基线控制策略不允许进行控制策略开启与关闭操作。 400 rgcservice.1076 The control state is {0}, can not do current organization unit operation. 控制策略操作状态异常，不允许进行操作。 请确认控制策略与组织单元的关系处于正确的结束态后再进行操作。 500 rgcservice.1077 This account has existed,should not be our account,failed reason {0}. 账号已存在。 请检查当前账号是否已存在。 400 rgcservice.1078 Manage account should not be our set up account. 管理账号不能作为核心账号。 请检查账号，管理账号不能作为核心账号。 500 rgcservice.1079 Move account Organizations report failed. 移动账号失败。 请联系技术支持。 400 rgcservice.1080 The core and root organization unit can not be delete or deregister. 不能删除或取消注册基础组织单元和根组织单元。 不能删除或取消注册基础组织单元和根组织单元。 400 rgcservice.1081 The parent organization unit type could not be core. 父组织单元不能是基础组织单元。 父组织单元不能是基础组织单元。 400 rgcservice.1082 bad request for create iic user. 创建IAM身份中心用户失败。 请稍后重试。 400 rgcservice.1083 Create account failed. Reason: The ou type is incorrect. 创建账号失败，组织单元类型不正确。 请检查组织单元类型。 400 rgcservice.1084 Create account failed. The action is not supported. 创建账号失败，账号状态不支持。 请检查账号当前状态是否为纳管中。 400 rgcservice.1085 The account already exists or is not managed by the RGC. 账号已经存在或没有被RGC纳管。 请检查账号是否由RGC纳管。 400 rgcservice.1086 fixed parameters cannot be changed. 固定参数不允许被修改。 请不要修改固定参数。 400 rgcservice.1087 The landing zone environment has been set, any parameter cannot be changed. Landing Zone环境已经设置完成，参数不能被修改。 请不要修改参数。 400 rgcservice.1088 organizationUnitId and accountId can not exist together. 组织单元ID与账号ID不能同时作为查询条件。 仅使用组织单元ID或账号ID进行查询。 404 rgcservice.1089 The account is not found. 账号不存在。 请检查账号是否存在。 400 rgcservice.1090 create assignment failed, failure reason is {0}. 给账号的IIC用户分配权限失败。 请联系技术支持。 400 rgcservice.1091 The resource {0} create or deploy failed, you can check detail at RFS view. 资源创建或部署失败，请前往RFS查看详情。 请前往RFS查看详情。 400 rgcservice.1092 [RFS]The RFS returns a failure message to deploy stackSet instances. 调用云服务RFS部署stackSet实例返回失败。 请检查云服务RFS或对应资源stackSet实例是否正常，正常后请再次重试。 400 rgcservice.1093 [RFS]The RFS returns a failure message to create stackSet instances. 调用云服务RFS创建stackSet实例返回失败。 请检查云服务RFS或对应资源stackSet实例是否正常，正常后请再次重试。 400 rgcservice.1094 [RFS]The RFS returns a failure message to create stackSet. 调用云服务RFS创建stackSet返回失败。 请检查云服务RFS或对应资源stackSet是否正常，正常后请再次重试。 400 rgcservice.1095 The user already exists, but the user details cannot be queried. 用户已存在，但无法查询用户详情。 请稍后重试。 400 rgcservice.1096 The user already exists, but the email address of the user is different. 账号已存在，账号邮箱与用户之前配置的邮箱不同。 请检查账号邮箱，填写保持一致。 404 rgcservice.1097 No user information is found. 找不到用户信息。 请联系技术支持。 400 rgcservice.1098 The account type is not custom, can not be un-enroll. 非自定义账号，不能取消纳管。 请检查要取消纳管的账号是否正确。 400 rgcservice.1099 The pap returned error. 调用云服务PAP接口失败。 请稍后重试。 400 rgcservice.1100 The account already exists and is managed by the RGC. 该账号已被RGC纳管。 请检查纳管的账号是否正确。 400 rgcservice.1102 The account already exists, but the parentOrganizationUnitId is different. 该账号已存在，但父组织单元ID与预留ID不同。 请检查账号所属父组织单元是否正确，填写保持一致。 400 rgcservice.1103 The account already exists, but the parentOrganizationUnitName is different. 该账号已存在，但父组织单元名称与预留名称不同。 请检查账号所属父组织单元是否正确，填写保持一致。 400 rgcservice.1104 The create account task is timeout. 创建账号超时。 请稍后重试。 400 rgcservice.1105 bad request for list entrity. The entrity is empty. 查询账号所属父组织单元失败。 请检查账号信息是否正确。 400 rgcservice.1106 Org list create account status occur error. 查询创建的账号状态异常。 请检查Organization账号是否正在创建中或Organization服务是否正常，正常后请再次尝试。 400 rgcservice.1107 The administrator user does not exist. IAM身份中心管理员用户不存在。 请检查账号信息是否正确。 400 rgcservice.1108 The control detail is not found. 查询控制策略详情失败，控制策略不存在。 请检查控制策略ID是否正确。 400 rgcservice.1109 The bucket policy does not exist. 查询桶策略失败，该桶策略不存在。 请稍后重试。 400 rgcservice.1110 Please accept the open beta of resource access service. 账号未开通RGC公测。 请申请开通RGC公测。 404 rgcservice.1111 not found for http header. HTTP请求头不存在。 请稍后重试。 400 rgcservice.1112 bad request for invalid user profile. 获取用户配置文件失败。 请稍后重试。 400 rgcservice.1113 get op svc pki token fail. 获取pkiToken失败。 请联系技术支持。 400 rgcservice.1114 The account already exists, but the account phone number is different. 设置Landing Zone失败，手机号与之前填写不一致。 请检查账号的电话号码。 400 rgcservice.1115 phone number is required in domestic. 请填写手机号。 请检查基础组织单元下的账号的手机号码是否存在。 400 rgcservice.1116 get a empty pki token. 获取 PKIToken 为空。 请联系技术支持。 500 rgcservice.1117 can't find {0} in v3 or v5 policy. 查询策略失败，策略不存在。 请检查策略名是否正确。 404 rgcservice.1118 The account type is invalid. 查询核心账号详情失败，账号类型不合法。 请检查查询的核心账号类型是否正确。 500/400 rgcservice.1119 Rfs list templates occur error. 查询RFS模版失败。 请联系技术支持。 409 rgcservice.1200 concurrent modification. 设置Landing Zone冲突。 请稍后重试。 400 rgcservice.1201 The core and root organization unit can not be register. 无法注册根和基础组织单元。 请检查注册的组织单元是否已存在并检查类型。 400 rgcservice.1202 The account already exists, but the account type is not custom. 当前的账号非自定义账号。 请检查纳管的账号的类型。 400 rgcservice.1203 The account status is {0}, can not do current account operation. 当前账号无法执行该操作，请检查账号状态。 请检查账号状态。 400 rgcservice.1204 The organization unit status is {0}, can not do current account operation. 组织单元状态异常，无法进行账户操作。 请检查账号所属的组织单元状态。 400 rgcservice.1205 The organization unit status is {0}, can not do current organization unit operation. 组织单元状态异常，无法进行组织单元操作。 请检查组织单元状态。 409 rgcservice.1206 The organization unit conflict, the organization unit is registered. 组织单元已注册成功，不能再次注册。 如果需要再次注册请调用重注册接口。 400 rgcservice.1207 The parent organization unit type could not be core or root. 父组织单元类型不能是根组织单元。 请检查父组织单元类型。 400 rgcservice.1208 The organization unit is managed by other management account. 组织单元由其他管理账号管理。 请检查组织单元ID。 404 rgcservice.1209 No landing zone has been created for this account. 当前账号未开通Landing Zone。 请检查当前账号是否已开通LandingZone。 404 rgcservice.1210 The landing zone environment status is failed. Landing Zone开通失败，暂不支持该操作。 请检查当前账号是否已成功开通LandingZone。 400 rgcservice.1211 The organization unit name has existed in Organization,please input unique and unused organization unit name. 组织单元名称重复，请输入唯一的组织单元名称。 请检查要注册的组织单元是否正确。 400 rgcservice.1212 Failed to query role id from pap. 调用云服务PAP查询权限失败。 请联系技术支持。 400 rgcservice.1213 Failed to create agency pap. 调用云服务PAP创建委托失败。 请联系技术支持。 400 rgcservice.1214 Failed to allpy role id pap. 调用云服务PAP为委托授予项目的权限失败。 请联系技术支持。 400 rgcservice.1215 The account maybe invited to Organization,you need manually create a full access agency named OrganizationAccountAccessAgency to its manage account. 邀请作为Landing Zone核心账号的子账号，需要创建该账号到管理账号的委托，委托应该包括子账号所有权限，该权限名称为OrganizationAccountAccessAgency。 请为邀请的子账号创建Full Access权限的委托OrganizationAccountAccessAgency，委托给管理账号。 400 rgcservice.1216 bad request for delete service linked agency. 调用云服务PAP删除服务关联委托失败。 请联系技术支持。 400 rgcservice.1217 IAM list projects occur error. 调用云服务IAM列出项目失败。 请联系技术支持。 400 rgcservice.1218 The account status conflict, the account is enrolled. 当前账号已纳管。 当前账号已为纳管状态，无需再次纳管。 400 rgcservice.1220 Domain tag not found, domainId is {0}. 未查询到租户标签。 请确认租户ID是否正确。 400 rgcservice.1221 Domain info not found, domainId is {0}. 未查询到租户信息。 请确认租户ID是否正确。 400 rgcservice.1222 email is required in global. 请填写Email信息。 请输入Email。 400 rgcservice.1223 Failed to create role. 创建自定义策略失败。 请联系技术支持。 400 rgcservice.1224 startTime should not be later than endTime. 请正确填写时间段，开始时间不能晚于结束时间。 请正确填写时间区域。 400 rgcservice.1225 Some accounts under the organization unit are in the Operation state. 组织单元下存在正在操作的账号。 请稍后重试。 403 rgcservice.1226 Can't find the ou, ouId is {0}. 组织单元不存在。 请检查组织单元ID。 403 rgcservice.1227 Can't find the account, accountId is {0}. 账号不存在。 请检查账号ID。 400 rgcservice.1230 Should not have custom account. 不支持自定义账号。 请检查账号类型。 400 rgcservice.1231 Should have one Core Organization Unit. 必须包含基础组织单元。 请检查组织单元类型。 400 rgcservice.1232 Core Organization Unit should has two accounts. 基础组织单元必须包含两个账号。 请检查账号个数。 400 rgcservice.1233 Core Organization can only has two accounts,one must be AUDIT type,another one must be LOGGING type. Landing Zone只有两个核心账号，一个为审计账号，一个为日志账号。 请调整输入参数。 400 rgcservice.1234 An existed Core Account has been created,the same name should be given. Landing Zone重新设置时，核心账号不能修改名称。 请调整输入参数。 400 rgcservice.1235 Audit account's notification email should be given. 审计账号需要填写通知邮箱。 请调整输入参数。 400 rgcservice.1236 When exist account scene, account name should be given. 账号已存在，但账号名称为空。 请调整输入参数。 400 rgcservice.1237 The organization name is empty. 组织单元名称为空。 请正确填写组织单元名称。 403 rgcservice.1238 The parent organization unit not found. 父组织单元不存在。 请检查是否存在父组织单元。 400 rgcservice.1239 When exist account scene, account id and name does not match. 账号已存在，但账号ID和名称不匹配。 请调整输入参数。 父主题： 附录

调用API获取项目ID 项目ID还可通过调用查询指定条件下的项目信息API获取。 获取项目ID的接口为“GET https://{Endpoint}/v3/projects/”，其中{Endpoint}为IAM的终端节点，可以从地区和终端节点获取。 响应示例如下，其中projects下的“id”即为项目ID。 { "projects": [ { "domain_id": "65382450e8f64ac0870cd180d14e684b", "is_domain": false, "parent_id": "65382450e8f64ac0870cd180d14e684b", "name": "cn-north-4", "description": "", "links": { "next": null, "previous": null, "self": "https://www.example.com/v3/projects/a4a5d4098fb4474fa22cd05f897d6b99" }, "id": "a4a5d4098fb4474fa22cd05f897d6b99", "enabled": true } ], "links": { "next": null, "previous": null, "self": "https://www.example.com/v3/projects" } }

调用API获取项目ID 项目ID可以通过调用查询指定条件下的项目信息API获取。 获取项目ID的接口为“GET https://{Endpoint}/v3/projects”，其中{Endpoint}为IAM的终端节点，可以从管理员处地区和终端节点获取。接口的认证鉴权请参见认证鉴权。 响应示例如下，其中projects下的“id”即为项目ID。 { "projects": [ { "domain_id": "65382450e8f64ac0870cd180d14e684b", "is_domain": false, "parent_id": "65382450e8f64ac0870cd180d14e684b", "name": "xxxxxxxx", "description": "", "links": { "next": null, "previous": null, "self": "https://www.example.com/v3/projects/a4a5d4098fb4474fa22cd05f897d6b99" }, "id": "a4a5d4098fb4474fa22cd05f897d6b99", "enabled": true } ], "links": { "next": null, "previous": null, "self": "https://www.example.com/v3/projects" } }