The 81002 error relates to the unirpcservices file. Either the data source is not present or the service name is missing.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Harkin Sent: 19 November 2004 15:38 To: [EMAIL PROTECTED] Subject: [U2] ODBC Errors Some developers I work with have a daily processing batch that queries a UniVerse DB (10.0.3) and then writes the result set to an Oracle instance. The code is written in java. We use a product called JDataConnect as an ODBC/JDBC bridge. Last night the job failled. I have a lot of error code data that the app logs returned, but I do not know where to research the error codes. I do not have a support account either (the database is used for a commercial applciation, and that vendor actually has the support account for our licenses. ANd the vendor will take a while to figure this out). Any advice on how to troubleshoot this is appreciated. Here is a snippet from the logs: RetrieveTRvimHoldings.loadTRvimHoldings(): Begin process at Fri Nov 19 09:12:51 EST 2004 RetrieveTRvimHoldings.loadTRvimHoldings(): Querying TR Date at Fri Nov 19 09:12:52 EST 2004 RetrieveTRvimHoldings.loadTRvimHoldings(): TR Date = 2004-11-18 RetrieveTRvimHoldings.loadTRvimHoldings(): Starting TR Query at Fri Nov 19 09:12:55 EST 2004 RetrieveTRvimHoldings.loadTRvimHoldings(): Ending TR Query at Fri Nov 19 09:13:02 EST 2004 RetrieveTRvimHoldings.populateTRvimHOLDINGS(): ITERATING through TR Data at Fri Nov 19 09:13:03 EST 2004 RetrieveTRvimHoldings.populateTRvimHOLDINGS(): Insertion failed! Trying to roll back db transactions. -++-Regular Exception-++- RetrieveTRvimHoldings.loadTRvimHoldings(): ServerException: [ODBC Error], SQLFetchScroll DBVendorCode:81002:, DBState:S1000:. [IBM][UVODBC][27004 16]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: IM985; uniVerse code: 81002; Msg: [IBM][SQL Client] [RPC] error code = 81002. java.sql.SQLException: ServerException: [ODBC Error], SQLFetchScroll DBVendorCode:81002:, DBState:S1000:. [IBM][UVODBC][2700416]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: IM985; uniVerse code: 81002; Msg: [IBM][SQL Client][RPC] error code = 81002. at JData2_0.sql.$Connection.FromServer($Connection.java:954) at JData2_0.sql.$Connection.ToServer($Connection.java:1016) at JData2_0.sql.$Connection.ToServer($Connection.java(Inlined Compiled Code)) at JData2_0.sql.$ResultSet.getRowset($ResultSet.java(Compiled Code)) at JData2_0.sql.$ResultSet.Move($ResultSet.java(Compiled Code)) at JData2_0.sql.$ResultSet.next($ResultSet.java(Compiled Code)) at com.ohis.operations.reconciliation.RetrieveTRvimHoldings.populateTRvimHO LDINGS(Unknown Source) at com.ohis.operations.reconciliation.RetrieveTRvimHoldings.loadTRvimHoldin gs(Unknown Source) at com.ohis.operations.reconciliation.RetrieveTRvimHoldings.main(Unknown Source) java.sql.SQLException: ServerException:[ODBC Error], SQLFetchScroll DBVendorCode:81002:, DBState:S1000:. [IBM][UVODBC][2700416]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: IM985; uniVerse code: 81002; Msg: [IBM][SQL Client][RPC] error code = 81 002. at JData2_0.sql.$Connection.FromServer($Connection.java:954) at JData2_0.sql.$Connection.ToServer($Connection.java:1016) at JData2_0.sql.$Connection.ToServer($Connection.java(Inlined Compiled Code)) at JData2_0.sql.$ResultSet.getRowset($ResultSet.java(Compiled Code)) at JData2_0.sql.$ResultSet.Move($ResultSet.java(Compiled Code)) at JData2_0.sql.$ResultSet.next($ResultSet.java(Compiled Code)) at com.ohis.operations.reconciliation.RetrieveTRvimHoldings.populateTRvimHO LDINGS(Unknown Source) at com.ohis.operations.reconciliation.RetrieveTRvimHoldings.loadTRvimHoldin gs(Unknown Source) at com.ohis.operations.reconciliation.RetrieveTRvimHoldings.main(Unknown Source) RetrieveTRvimHoldings: ERROR - RetrieveTRvimHoldings FAIL ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/