HANA SQL 错误代码.docx

1、HANA SQL 错误代码下表列出SAP HANA显示的错误代码和描述。1 General warning普通警告2 General error普通错误3 Fatal error致命错误4 Cannot allocate enough memory无法分配足够的内存5 Initialization error初始化错误6 Invalid data无效数据7 Feature not supported不支持该功能8 Invalid argument非法参数9 Index out of bounds下标越界10 Invalid username or password无效用户名或密码11 Inva

2、lid state无效状态12 Cannot open file无法打开文件13 Cannot create/write file无法创建/写文件14 Cannot allocate enough disk space无法分配足够的磁盘空间15 Cannot find file找不到文件16 Statement retry重试语句17Metadata schema versionincompatible between database andexecutable file数据库和可执行文件之间元数据集合版本不兼容18 Service shutting down服务正在关闭19 Invalid

3、 license无效证书128 Transaction error事务错误129Transaction rolled back byan internal内部错误，事务回滚error130Transaction rolled back by integrityconstraint violation违反完整性约束，事务回滚131Transaction rolled back by lock waittimeout等待锁定超时，事务回滚。132Transaction rolled back due tounavailable resource资源不可用，事务回滚。133Transaction r

4、olled back by detecteddeadlock检测到死锁，事务回滚。134 Failure in accessing checkpoint file获取检查点文件失败135 Failure in accessing anchor file获取锚文件失败136 Failure in accessing log file获取日志文件失败137 Failure in accessing archive file获取档案文件失败138 Transaction serialization failure事务序列化失败139Current operation cancelled by req

5、uestand transaction rolled back由于请求和事务回滚，取消当前操作140 Invalid write-transaction identifier无效的写事务标识符141 Failure in accessing invisible log file获取隐藏记录文件失败142Exceed max num of concurrenttransactions超过同步事务的最大值143Transaction serialization failure untiltimeout expires超时，事务序列化失败144Transaction rollback, unique

6、 constraintviolated事务回滚，违反唯一约束。145 Transaction distribution work failure事务分布任务失败146Resource busyand acquire withNOWAIT specified资源忙碌，需指定 NOWAIT 获取147 Inconsistency between data and log数据与记录不一致148Transaction start is blocked untilMaster_Restart finishesMaster_Restart 未完成，事务启动仍被锁定。149 Distributed tran

7、saction commit failure已分配的事务提交失败150Statement cancelled due to oldsnapshot语句被旧快照取消256 SQL processing errorSQL 处理错误257 SQL syntax errorSQL 语法错误258 Insufficient privilege权限不足259 Invalid table name无效的表名260 Invalid column name无效列名261 Invalid index name无效索引名262 Invalid query name无效查询名称263 Invalid alias na

8、me无效别名264 Invalid datatype无效数据类型265 Expression missing缺少表达式266 Inconsistent datatype数据类型不一致267Specified length too long for itsdatatype超出指定类型的长度268 Column ambiguously defined模糊的列定义269 Too many values数值太多270 Not enough values数值不足271 Duplicate alias重复别名272 Duplicate column name重复列名273 Not a single cha

9、racter string没有一个单一的字符串274 Inserted value too large for column插入的数值对于列来说过大275 Aggregate function not allowed聚集功能不被允许276 Missing aggregation or grouping缺少聚集或分组277 Not a GROUP BY expression不是 GROUP BY 表达式278Nested group function without GROUPBY嵌套分组函数没有使用 GROUP BY279 Group function is nested分组函数已嵌套。280

10、ORDER BY item must be the number ofa SELECT-listGROUP BY 项必须是 SELECT 列表数281Outer join not allowed in operand ofOR or IN在 OR 和 IN 的操作数中，不允许有外联结282Two tables cannot be outer-joined toeach other两个表格之间不能互相外联结283A table may be outer joined to at mostone other table一张表最多只能被外联接到一张表284 Join field does not m

11、atch联结字段不匹配285 Invalid join condition无效的联结条件286 Identifier is too long标识符名字过长287 Cannot insert NULL or update to NULL无法插入或更新 NULL288 Cannot use duplicate table name无法使用重复表名289 Cannot use duplicate index name无法使用重复索引名290 Cannot use duplicate query name无法使用重复查询名称291 Argument identifier must be positiv

12、e参数标识符必须是正值292 wrong number of arguments参数数目错误293 Argument type mismatch参数类别不匹配294Cannot have more than one primarykey不能存在多于一个主键295 Too long multi key length过长的多键长度296Replicated table must have a primarykey复制的表只能有一个主键297Cannot update primary key field inreplicated table无法在复制表中更新主键298 Cannot store DD

13、L无法储存 DDL299Cannot drop index used forenforcement of unique/primary key不能删除用于增强唯一键/主键的索引300 Argument index is out of range参数索引不在范围内301 Unique constraint violated违反唯一约束302 Invalid CHAR orVARCHAR value无效 CHAR 或 VARCHAR 值303Invalid DATE, TIME orTlMESTAMPvalue无效 DATE,TIME 或 IMESTAMP 值304 Division by zer

14、o undefined未定义除数为 0305Single-row query returns more thanone row单行索引返回至多行306 Invalid cursor无效游标307 Numeric value out of range数目值超出范围308 Column name alreadyexists列名已存在309Correlated subquery cannot have TOPor ORDER BY相互关联的子查询不能使用 TOP 或 ORDER BY310 SQL error in procedure存储过程中的 SQL 错误311 Cannot drop all

15、columns in a table无法删除表格中所有列312 Sequence is exhausted到达序列末尾313 Invalid sequence无效序列314 Numeric overflow数值溢出315 Invalid synonym无效同义词316wrong number of arguments infunction invocation函数调用参数的数目错误317P_QUERYPLANS not exists nor validformatP_QUERYPLANS 不存在或格式无效318Decimal precision specifier is out ofrange

16、十进制精确性指定符超出范围319 Decimal scale specifier is out of range十进制小数位数超出范围320Cannot create index on expressionwith datatype LOB在 LOB 数据类型的表达下无法创建索引321 Invalid view name无效的视图名称322 Cannot use duplicate view name无法使用重复的视图名称323 Duplicate replication ID重复更新 ID324 Cannot use duplicate sequence name无法使用重复的序列名325

17、Invalid escape sequence无效的转义序列326CURRVAL of given sequence is not yetdefined in this session未定义本次会话中 CURRVAL 的给定序列327 Cannot explain plan of given statement无法解释给定语句的计划328 Invalid name of function or procedure功能或过程的名称无效329Cannot use duplicate name of functionor procedure无法使用名字重复的函数或存储过程330 Cannot use

18、 duplicate synonym name无法使用重复的同义名331 User name already exists用户名已存在332 Invalid user name用户名无效333 Column not allowed列不被允许334 Invalid user privilege用户特权无效335 Field alias name alreadyexists字段别名已存在336 Invalid default value初始值无效337INTO clause not allowed for thisSELECT statement该 SELECT 语句中不可以出现 INTO 分句3

19、38 Zero-length collumns are not allowed不可以出现零长度的列339 Invalid number数目无效340 Not all variables bound所有的变量都没有界限341 Numeric underflow数目下溢342 Collation conflict校验名矛盾343 Invalid collate name无效的校验名344 Parse error in data loader数据加载中出现解析错误345 Not a replication table表格不可被更新346 Invalid replication ID无效更新 ID34

20、7 Invalid option in monitor监控器的选项无效348 Invalid datetime format无效的时间格式349 Cannot CREATE UNIQUE INDEX无法创建唯一索引350Cannot drop columns in the primarykey column list无法删除主键中的列351Column is referenced in a multicolumn constraint列在多列约束中被引用352Cannot create unique indexonCDXtable在 CDX 表中无法创建唯一索引353 Update log g

21、roup name alreadyexists更新日志名称已存在354 Invalid update log group name无效的更新日志组名称355The base table of the update log tablemust have a primary key更新日志的基表必须有一个主键356Exceed maximum number of updatelog group更新日志组数值超过最大值357The base table already has a update基表已有一张更新日志表log table358Update log table can not have a

22、 updatelog table更新日志表中不能包含更新日志表359 Concatenated string is too long连接字符串过长360View WITH CHECK OPTION where-clause violation违反 WITH CHECK OPTION 视图 where 子句361Data manipulation operation not legalon this view对该视图的数据操作运算不合法362 Invalid schema name无效的集合名363Number of index columns exceeds itsmaximum索引列数目超过

23、最大值364 Invalid partial key size部分键大小无效365No matching unique or primary key forthis column list列的列表中没有匹配的唯一键或主键366Referenced table does not have aprimary key被引用的表中没有主键367Number of referencing columns mustmatch referenced columns被引用的列必须与引用列数目相等368Unique constraint not allowed ontemporary table在临时表上不允许

24、唯一约束369 Exceed maximum view depth limit超过了最大视图宽度限制370Cannot perform DIRECT INSERToperation on table with unique indexes在表中无法直接插入唯一索引371 Invalid XML document无效 XML 文件372 Invalid XPATH无效的 XPATH373 Invalid XML duration value无效 XML 持续值374 Invalid XML function usage无效的 XML 函数应用375 Invalid XML index opera

25、tion无效的 XML 索引操作376 Python stored procedure errorPython 存储过程错误377 JIT operation errorJIT 操作错误378 Invalid column view无效的列视图379 Table schema mismatch表与模式不匹配380 Fail to change run level改变运行级别失败381 Fail to restart重启失败382 Fail to collect all version garbage收集所有无用数据版本失败383 Invalid identifier无效标识符384 Const

26、ant string is too long字符串常数过长385 Could not restore session无法恢复会话386 Cannot use duplicate schema name无法使用重复集合名387 Table ambiguously defined表格定义不清晰388 Role already exists角色已存在389 Invalid role name无效的角色名390 Invalid user type无效用户类别391 Invalidated view未验证的视图392 Cant assign cyclic role无法分配循环角色393Roles mus

27、t not receive a privilege withgrant option不能使用 grant 选项授权角色394 Error revoking role错误的撤销角色395 Invalid user-defined type name无效的自定义类别名称396Cannot use duplicate user-defined typename无法使用重复的自定义类别名称397 Invalid object name无效的对象名称398 Cannot have more than one order by只能存在一个 order by399 Role tree too deep对象树

28、过深400Primary key not allowed on insert-onlytable只允许插入的表中不允许主键401Unique constraint not allowed oninsert-only table只允许插入的表格中不允许唯一键402The user was already dropped beforequeryexecution执行查询前，该用户已被删除403 Internal error内部错误404Invalid (non-existent) structuredprivilege name无效（或不存在）结构化权限名405Cannot use duplica

29、te structuredprivilege name无法使用重复的结构化权限名406INSERT, UPDATE and UPSERT aredisallowed on the generated field生成的字段不允许 INSERT,UPDATE 以及 UPSERT407 Invalid date format无效的日期格式408Password or parameter required foruser用户必需的密码或参数409Multiple values for a parameter notsupported参数不支持有多个值410 Invalid privilege name

30、space无效的权限命名空间411 Invalid table type无效的表类型412 Invalid password layout无效的密码样式413 Last n passwords can not be reused上次用过的密码无法再次使用414 User is forced to change password用户被强制重设密码415 User is deactivated用户未激活416 User is locked用户被锁定417Cant drop without CASCADEspecification无法不使用 CASCADE 选项删除418 Invalid view query for creation视图查询无效创建419 Cant drop with RESTRICT specification.无法不使用 RESTRICT 选项删除