Error In The Module Sql Accessing The Database Interface
【知识库】深度学习知识图谱上线啦 [置顶] 解决Error in module RSQL of the database interface 标签: SAPABAPerrorsqlexception 2015-03-30 17:03 869人阅读 评论(1) 收藏 举报 本文章已收录于: 分类: ABAP(5) 作者同类文章X Web Dynpro for Java(5) 作者同类文章X 版权声明:本文为博主原创文章,未经博主允许不得转载。 关键词 Error in module RSQL of the database interface error key: RFC_ERROR_SYSTEM_FAILURE dbtran ERROR (set_input_da_spec): statement too big[dbtran.c#4854] marker count = 18655 > max. marker count = 16000 [dbtran.c#4854] sap note:13607 问题描述 【Problem】EP在开发机测试没问题,发布到生产机后执行查询出现了该问题: 错误信息: Error in module RSQL of the database interface, error key: RFC_ERROR_SYSTEM_FAILURE 问题分析 你可以先尝试过以下操作: 1、检查、测试RFC,并把相关的请求传输到生产环境; 2、在NWDS中Reimport RFC,重新发布工程(注意生产环境发布的操作和开发机的不一样); 3、重启EP; 若仍然未解决问题,请往下看。 https://scn.sap.com/thread/1774165 通过传输码ST22查看ABAP运行时错误日志 双击对应错误的日志,进入Runtime Error Long Text界面,里面有详细的错误报告。 我摘取部分的错误信息: Kategorie(范畴): ABAP Programming Error Laufzeitfehler(运行时错误): DBIF_RSQL_INVALID_RSQL Ausnahme(异常) : CX_SY_OPEN_SQL_DB ABAP Programm: SAPLZEWM_RFC2 【Kurztext】 (德文,意思是范畴) Error in module RSQL of the database interface 【发生了什么】 Error in the ABAP Application Program The current ABAP program “SAPLZEWM_RFC2” had to be terminated http://blog.csdn.net/imlanbin/article/details/44673777 because it has come across a statement that unfortunately cannot be executed. 【错误分析】 An exception occurred that is explained in detail below. The exception, which is assigned to class ‘CX_SY_OPEN_SQL_DB’, was not caught in procedure “ZTM_RFC_YSQSD_GETORDER_V2” (FUNCTION)”, nor was it propagated by a RAISING clause. Since the caller of the procedure could not have anticipated that the exception would occur, the current program is terminated. The reason for the exception is: The SQL statement generated from the SAP Open SQL statement violates a restriction imposed by the underlying database system of the ABAP system. Possible error causes: o The maximum size of an SQL statement was exceeded. o The statement contains too many input variables. o The input data requires more space than is available. o … You can generally find deta
conn:setautocommit Cursor Object cur:close cur:fetch cur:getcolnames cur:getcoltypes PostgreSQL Extensions env:connect cur:numrows MySQL Extensions env:connect cur:numrows Notes Oracle Extensions cur:numrows VERSION CREDITS LuaSQL 2.0 LuaSQL 1.0 CONTACT LICENSE NAME http://math2.org/luasearch/luasql.html luasql - database interface (LuaSQL) OVERVIEW LuaSQL is a simple interface from https://books.google.com/books?id=LDyarcerUu0C&pg=PA449&lpg=PA449&dq=error+in+the+module+sql+accessing+the+database+interface&source=bl&ots=vkbh0Qbhor&sig=WN4_HIm3E9g8UrYRUM1glNq8xzA&hl=en&sa=X&ved=0ahUKEwiI8OOP6szPAhUL Lua to a DBMS. It enables a Lua program to: Connect to ODBC, ADO, Oracle, MySQL, SQLite, JDBC, and PostgreSQL databases; Execute arbitrary SQL statements; Retrieve results in a row-by-row cursor fashion. LuaSQL is a simple interface from Lua to a number of database management error in systems. It includes a set of drivers to some popular databases (currently PostgreSQL, ODBC, JDBC, MySQL, SQLite, Oracle, and ADO; Interbase and Sybase are in our plans). LuaSQL defines a simple object-oriented API. All drivers should implement this common API, but each one is free to offer extensions. LuaSQL defines one single global variable, a table the database interface called luasql. This table is used to store the initialization methods of the loaded drivers. These methods are used to create an environment object which is used to create a connection object. A connection object can execute SQL statements and eventually create a cursor object which is used to retrieve data. EXAMPLES Here is an example of the basic use of the library. After that, another example shows how to create an iterator over the result of a SELECT query. Basic use -- load driver require "luasql.postgres" -- create environment object env = assert (luasql.postgres()) -- connect to data source con = assert (env:connect("luasql-test")) -- reset our table res = con:execute"DROP TABLE people" res = assert (con:execute[[ CREATE TABLE people( name varchar(50), email varchar(50) ) ]]) -- add a few elements list = { { name="Jose das Couves", email="jose@couves.com", }, { name="Manoel Joaquim", email="manoel.joaquim@cafundo.com", }, { name="Maria das Dores", email="maria@dores.com", }, } for i, p in pairs (list) do res = assert (con:execute(string.format([[ INSERT INTO people VALUES ('%s'
från GoogleLogga inDolda fältBöckerbooks.google.se - The book is designed to begin with the very basics and moves forward to cover the topics necessary to unleash the power of SAP - from the way tasks are handled in SAP to how Reports are executed in your task; from getting a complete know-how of SAP Administrative Utilities and Background Job Scheduling...https://books.google.se/books/about/Sap_R_3_Black_Book.html?hl=sv&id=LDyarcerUu0C&utm_source=gb-gplus-shareSap R/3 Black BookMitt bibliotekHjälpAvancerad boksökningSkaffa tryckt exemplarInga e-böcker finns tillgängligaAmazon.co.ukAdlibrisAkademibokandelnBokus.seHitta boken i ett bibliotekAlla försäljare»Handla böcker på Google PlayBläddra i världens största e-bokhandel och börja läsa böcker på webben, surfplattan, mobilen eller läsplattan redan idag.Besök Google Play nu »Sap R/3 Black BookDreamtech Press, 25 apr. 2006 - 1088 sidor 3 Recensionerhttps://books.google.se/books/about/Sap_R_3_Black_Book.html?hl=sv&id=LDyarcerUu0CThe book is designed to begin with the very basics and moves forward to cover the topics necessary to unleash the power of SAP - from the way tasks are handled in SAP to how Reports are executed in your task; from getting a complete know-how of SAP Administrative Utilities and Background Job Scheduling to SAP R/3 Basis System; from ABAP Workbench to ABAP Programming with MM and SD Modules and much more. With each topic building upon others, you are quickly able to utilize the R/3 functionality in a meaningful and productive manner. All this, as the book zips through the material and doesn t blather on or repeat points made earlier. A definitive informative guide that will help you make good on your company s sizable investment - no doubt, every aspect is worth the price of the entire book. Förhandsvisa den här boken » Så tycker andra-Skriv en recensionVi kunde inte hitta några recensioner.InnehållA Gateway to SAP 3 SAP Easy Access 17 SAP User Interface 43 Starting and Shutting the SAP System 63 Handling Tasks in SAP 81 Reports in SAP 97 Background Processing 117 SAP System Adminis