Error Sqlcode=-10 Sqlstate=42603
Contents |
BPF INBASKET FILTER VALUE Subscribe You can track all active APARs for this component. APAR status Closed as program error. Error description Description of Problem (full details) : db2 sqlstate 42601 This problem was originally reported when the Bp8Metastore was on Oracle - Oracle sqlcode=-104 error ORA-01756: quoted string not properly terminated - but the same problem occurs on DB2 - DB2 SQL error: SQLCODE: -10, SQLSTATE: 42603, SQLERRMC: THE STRING CONSTANT BEGINNING IS NOT TERMINATED - as well and most likely MSSQL too. The problem happens when a user enters a value in an inbasket filter (type STRING) https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n010.html that contains the string/substring "order", which is a SQL keyword. How long has the problem been occurring (recent changes)? : Always Does this occur on more than one station / server? : Yes Is there a workaround? : Only to avoid the problem by searching for a substring of the string "order", such as "orde", which works correctly (although it makes for a less granular search) and does http://www-01.ibm.com/support/docview.wss?uid=swg1PJ38241 not cause the error. What is the impact to the customer/system? : Unable to use the string/substring "order" in an inbasket filter value in a situation where the substring "order" is a valid value for the field being searched. Can the problem be replicated on an internal system? Y or N Y By Who (L3, Support, etc..) L3 Steps to Reproduce: 1. Create a case with value 'Money Order' for any field. Example: Specify value 'Money Order' for CompanyName (in the Case Management sample application). 2. Search for Company 'Money Order' in the Company Name Inbasket Filter. Actual Results: Depending on the RDBMS used for the Bp8Metastore, the user sees an error, such as: Oracle error ORA-01756: quoted string not properly terminated DB2 SQL error: SQLCODE: -10, SQLSTATE: 42603, SQLERRMC: THE STRING CONSTANT BEGINNING IS NOT TERMINATED Expected Results: We should be able to search using item 'Money order'. Local fix Only to avoid the problem by searching for a substring of the string "order", such as "orde", which works correctly (although it makes for a less granular search) and does not cause the error. Problem summary **************************************************************** * USERS AFFECTED: * * BPF Web Application users * **************************************************************** * PROBLEM DESCR
that is not terminated properly. There must http://trail-error.blogspot.com/2013/02/sql-code-010-sqlstate42603.html be some problem with quotations used for strings. System Says: The statement cannot be processed Remedy: Check the statement for any strings with proper quotes. It should be like ‘STRING'. Posted by vamsi krishna at 11:06 PM Email ThisBlogThis!Share sql error to TwitterShare to FacebookShare to Pinterest Labels: -010, 42603, Quotations, Quotes, Sql, Sql Code, Sql State, Strings, Termination No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Labels -007 (1) -010 (1) -011 error sqlcode=-10 sqlstate=42603 (1) 42601 (1) 42603 (2) capitals (1) Character (1) Closed (1) Comments (1) countries (1) Countries and their Capitals (1) error (1) Illegal (1) Quotations (1) Quotes (1) Sql (3) Sql Code (3) Sql State (3) Statements (1) Strings (1) Syntactical (1) Termination (1) validator (1) About Me vamsi krishna View my complete profile Cheeky Quotes Wikipedia Search results Blog Archive ▼ 2013 (29) ► April (24) ▼ February (5) SQL CODE:-011 SQLSTATE:42603 SQL CODE:-010 SQLSTATE:42603 SQL CODE:-007 SQLSTATE: 42601 SQL CODES AND SQL STATES Computer Viruses ► 2011 (16) ► December (1) ► July (3) ► April (6) ► February (6) ► 2010 (5) ► November (5) Followers Translate Watermark template. Powered by Blogger.