Informix Odbc Unspecified System Error 21005
sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: Error -21005 - Database LOCALE Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-14-04,15:52 #1 alexhbs View Profile View Forum Posts Registered User Join Date Sep 2004 Posts 2 Unanswered: Error -21005 - Database LOCALE Hey there folks, I'm running a Informix 7.31 database server on windows 2000. This database has the single purpose of holding all of our ERP data (built by a brazilian company) and is accessed only by this application that handles data interaction via ODBC, clients don't access the DB directly. They have access to an application server that talks to the database layer application that talks to informix. (hope i made myself clear there.. ). My problem seems to be due to diferent locales on the database and on the data that is entered into it. The DB uses en_US.819 (which i believe is informix' default) and the clients enter data that has iso-8859-1 characters, brazilian ones. Here's the error i get in ODBC: Error=21005[Informix][Informix ODBC Driver]Unspecified System Error = -21005. and then the row doesn't get updated. i coudn't find anything related to that error anywhere, but i'm pretty sure that's the problem. my question is. Is there anyway to change the database locale without having to export all the data, dropping the database, recreating the database with a different charset (which i'm not entirely sure how to do) and then re-importing the data back? the server in question (HP Proliant 370, 2x 3,06 GHz HT, 4GB RAM, ~60GB RAID 5) takes about 2 hours to export the data (~ 6 GB) and around 3,5 hours to import it back using dbexport and dbimport (is it too slow?). Any help is greatly appreciated as i've just started managing this database a couple of weeks ago and am still getting the hang of it. Thank you! Reply With Quote 09-16-04,08:47 #2 gurey View Profile View Forum Posts Registered User Join Date Aug 2003 Location Argentina Posts 780 Hi, Please check the environment variables CLIENT_LOCALE and DB_LOCALE, next look in systables (select * from systables where tabid = 91) Gustavo. Reply With Quote 09-16-04,10:25 #3 Big Kahuna View Pr
This question is answered. Helpful answers available: 2. Correct answers available: 1. Reply to this Thread Search Forum Back to Thread List Replies: 2 - Last Post: Oct 8, 2016 1:34 PM Last Post By: Hernando Duque Hernando Duque Posts: 31 Registered: 10/22/00 DXE6 FDac Informix system error -21005 Reply Posted: Mar 20, 2015 1:04 PM Hi to all, I im doing a select to a table that has a BLOB text field but it happens that if the BLOB field http://www.dbforums.com/showthread.php?1022518-Error-21005-Database-LOCALE has non ASCII characters, the application hangs with this error: [FireDAC][Phys][ODBC][Informix ODBC Driver]Unspecified System Error = -21005. If the BLOB field has ASCII chars then it runs fine. Any help will be appreciated. Regards, Hernando. Lajos Juhasz Posts: 505 Registered: 3/14/14 Re: DXE6 FDac Informix system error -21005 Reply Posted: Mar 23, 2015 1:54 PM https://forums.embarcadero.com/message.jspa?messageID=693986 in response to: Hernando Duque Hernando Duque wrote: Hi to all, I im doing a select to a table that has a BLOB text field but it happens that if the BLOB field has non ASCII characters, the application hangs with this error: [FireDAC][Phys][ODBC][Informix ODBC Driver]Unspecified System Error = -21005. If the BLOB field has ASCII chars then it runs fine. Any help will be appreciated. Regards, Hernando. The error code -21005 means: Inexact character conversion during translation. One or more characters were translated using a substitution character. Translation in the reverse direction would not produce the original string. Make sure that the values of the CLIENT_LOCALE and DB_LOCALE environment variables are compatible. Check out for client and server locale. I never got this error message. Hernando Duque Posts: 31 Registered: 10/22/00 Re: DXE6 FDac Informix system error -21005 Reply Posted: Oct 8, 2016 1:34 PM in response to: Lajos Juhasz Just closing this thead Back to Thread List Legend Helpful Answer (5 pts) Correct
Marketplace View all Dashboard Gallery Visualization Library General Discussions View all Getting Started with the Community Community News Get Connected Business Strategy & Best Practices Suggestions for this Community Technical Discussions View https://community.microstrategy.com/t5/Architect/TN230267-quot-Unspecified-System-Error-21005-quot-or-quot/ta-p/230267 all Announcements Tech Corner Idea Exchange Platform (Installation & Deployment) Object Development Reporting, Dashboards, and Document Development MicroStrategy Desktop Clients (Interfaces & Visualizations) Administration Tools Intelligence Server Mobile Enterprise Assets (Data Sources & Gateways) MicroStrategy Software Development Kit (SDK) Security (Usher) Performance Events View all Events Blog Symposia 2016 Symposia 2015 Education World 2016 Discussions World 2015 Discussions World 2015 Track Sessions & Customer Presentations Community informix odbc Menu Register · Sign In · Help Architect MicroStrategy > Architect > TN230267: "Unspecified System Error = -21005" or "Inexact character conversion during translation" error returned when t... CommunityCategoryKnowledge BaseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. TN230267: "Unspecified System Error = -21005" or informix odbc unspecified "Inexact character conversion during translation" error returned when trying to upgrade an Informix metadata in MicroStrategy 9.x. Started 03-18-2015 by NickV Modified 03-27-2015 by NickV Article Options Article History Subscribe to RSS Feed Mark as New Mark as Read Bookmark Subscribe Email to a Friend Printer Friendly Page Report Content Labels: Upgrade 0 Likes SUMMARY This technical note is about an issue that arises when trying to upgrade an Informix metadata. This issue is related to using an outdated code page for the metadata. This issue has been seen in other contexts, such as importing objects or adding translations to objects. SYMPTOMS When trying to upgrade an Informix metadata, users may encounter one of the following errors: Unspecified System Error = -21005 Inexact character conversion during translation These errors can be seen in other contexts that deal with translations. CAUSE This is due to an incorrect code page being used in the metadata. Starting in MicroStrategy 9.x, only databases that support and use Unicode code pages are supported. In this particular instance, the Informix database is using an older code page that is non-Unicode and doesn't contain support for internatio