-->

This topic discusses SQLSTATE values for ODBC 2.x and ODBC 3.x. For more information on ODBC 3.x SQLSTATE values, see Appendix A: ODBC Error Codes.

SQLExecDirect failed with ODBC Error: state=23000, nativeErr=547, err=MicrosoftSQL Server Native Client 10.0SQL ServerThe INSERT statement conflicted with the FOREIGN KEY constraint 'FKStatDataStatID0F975522'. The conflict occurred in database 'poweradmin', table 'dbo.Statistic', column 'StatID'. Feb 21, 2013  Name Result Message; Getting the list of objects from 'DBName'. Failed: System.IndexOutOfRangeException: Index was outside the bounds of the array. At Microsoft.SqlServer.Management.SqlScriptPublish.GeneratePublishPage.workerDoWork(Object sender, DoWorkEventArgs e) at. Im using WAMP sever PHP 5.3.4 and sql server 2008 r2 connect using the driver odbc driver 2011 When i execute this query i got the correct answer, SELECT password,username FROM customer But. Apr 07, 2020  Connection failed: SQLState:'S1000' SQL Server Error: 0 MicrosoftODBC SQL Server Driver Cannot generate SSPI context followed by a SQL Server Login prompt where Trusted Connection is checked and the login ID is prefilled with my Windows username, although I had specified my SQL Server username in the new DSN file. Apr 19, 2018 'S1000: Microsoft ODBC SQL server driver sql server could not find the index entry for our ID (ID number) in index page (page number), index id (Number), database.

Generation

In ODBC 3.x, HYxxx SQLSTATEs are returned instead of S1xxx, and 42Sxx SQLSTATEs are returned instead of S00XX. This was done to align with Open Group and ISO standards. In many cases, the mapping is not one-to-one because the standards have redefined the interpretation of several SQLSTATEs.

When an ODBC 2.x application is upgraded to an ODBC 3.x application, the application has to be changed to expect ODBC 3.x SQLSTATEs instead of ODBC 2.x SQLSTATEs. The following table lists the ODBC 3.x SQLSTATEs that each ODBC 2.x SQLSTATE is mapped to.

When the SQL_ATTR_ODBC_VERSION environment attribute is set to SQL_OV_ODBC2, the driver posts ODBC 2.x SQLSTATEs instead of ODBC 3.x SQLSTATEs when SQLGetDiagField or SQLGetDiagRec is called. A specific mapping can be determined by noting the ODBC 2.x SQLSTATE in column 1 of the following table that corresponds to the ODBC 3.x SQLSTATE in column 2.

ODBC 2.x SQLSTATEODBC 3.x SQLSTATEComments
01S0301001
01S0401001
22003HY019
2200822007
2200522018
2400007005
3700042000
70100HY018
S000142S01
S000242S02
S001142S11
S001242S12
S002142S21
S002242S22
S002342S23
S1000HY000
S1001HY001
S100207009ODBC 2.x SQLSTATE S1002 is mapped to ODBC 3.x SQLSTATE 07009 if the underlying function is SQLBindCol, SQLColAttribute, SQLExtendedFetch, SQLFetch, SQLFetchScroll, or SQLGetData.
S1003HY003
S1004HY004
S1008HY008
S1009HY009Returned for an invalid use of a null pointer.
S1009HY024Returned for an invalid attribute value.
S1009HY092Returned for updating or deleting data by a call to SQLSetPos, or adding, updating, or deleting data by a call to SQLBulkOperations, when the concurrency is read-only.
S1010HY007 HY010SQLSTATE S1010 is mapped to SQLSTATE HY007 when SQLDescribeCol is called prior to calling SQLPrepare, SQLExecDirect, or a catalog function for the StatementHandle. Otherwise, SQLSTATE S1010 is mapped to SQLSTATE HY010.
S1011HY011
S1012HY012
S1090HY090
S1091HY091
S1092HY092
S109307009ODBC 3.x SQLSTATE 07009 is mapped to ODBC 2.x SQLSTATE S1093 if the underlying function is SQLBindParameter or SQLDescribeParam.
S1096HY096
S1097HY097
S1098HY098
S1099HY099
S1100HY100
S1101HY101
S1103HY103
S1104HY104
S1105HY105
S1106HY106
S1107HY107
S1108HY108
S1109HY109
S1110HY110
S1111HY111
S1C00HYC00
S1T00HYT00

Note

ODBC 3.x SQLSTATE 07008 is mapped to ODBC 2.x SQLSTATE S1000.


Not endorsed by or affiliated with SAP

Register Login

Want to sponsor BOB? (Opens a new window)

Index About

Sponsors Contact Us Calendar FAQ Rules and Guidelines Privacy Policy Search

Key Generation Failed Sql State S1000 In Sqlexecdirect Informix 12 10

General Notice: BOB is going to retire..please see details here.
General Notice: No events within the next 45 days.
SQL Generation Failed. WIS 00013.

Search this topic.. Search XI Server Discussion.. Search Box
Register or Login to Post Forum Index ->Server Administration, Installation, Upgrades ->XI Server Discussion
AuthorMessage
chopwood
Forum Member
Joined: 15 Jun 2007
Posts: 1

Posted: Mon Sep 08, 2008 12:32 pm
Post subject: SQL Generation Failed. WIS 00013.
I have seen some descriptions of this issue on the forums but none ever got so far as to answer my issue.
I'm getting the error message listed in the Subject line: SQL Generation Failed. WIS 00013.
I have tried setting the Connection Time Out in the CMC. While I have that setting in the CMC set to 45 minutes, WebI times out in 15 minutes with this error, when the report is left idle. Is this the correct setting?
Back to top
Bomada
Senior Member
Joined: 25 Jun 2008
Posts: 42
Location: Norway

Posted: Fri Nov 07, 2008 6:08 am
Post subject: Re: SQL Generation Failed. WIS 00013.
Hi chopwood,
you could try the following:
- Log on to the BO server.
- Open the folder <install directory>Program FilesBusiness ObjectsTomcatconf.
- Open the server.xml file (save a copy of the original file before doing any changes).
- Find the tag with the following comment:
<!-- Define a non-SSL Coyote HTTP/1.1 Connector on port 8080 -->
- Change connectionTimeout='20000' to connectionTimeout='-1'.
- Save and close the file.
- Open Central Configuration Manager (startAll ProgramsBusiness ObjectsBusiness Objects Crystal DecisionsCentral Configuration Manager).
- Restart the Apache Tomcat server.
Back to top
gajulas
Forum Member
Joined: 07 Jul 2009
Posts: 2

Posted: Tue Jul 07, 2009 1:52 pm
Post subject: Re: SQL Generation Failed. WIS 00013.
chopwood - Please let me know if the changes in serve.xml resolved the issue - we are also having same issues. - Thanks
Back to top
gary_scott
Principal Member
Joined: 17 Dec 2004
Posts: 151
Location: Gloucestershire, England

Posted: Tue May 18, 2010 3:32 am
Post subject: Re: SQL Generation Failed. WIS 00013.
Solution can be found here :-
http://www.forumtopics.com/busobj/viewtopic.php?t=69793&postdays=0&postorder=asc&highlight=wis+00013&start=15
Cheers,
Gary
Back to top

Key Generation Failed Sql State S1000 In Sqlexecdirect Informix 12 10

Register or Login to Post Forum Index ->Server Administration, Installation, Upgrades ->XI Server Discussion
Page 1 of 1All times are GMT - 5 Hours

Index About FAQ RAG Privacy Search Register Login

Get community updates via Twitter: Good mac podcast editing software.

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0271 seconds using 17 queries. (SQL 0.0023 Parse 0.0008 Other 0.0239)
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36
Hosted by ForumTopics.com Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com
Coments are closed
Scroll to top