| ora 01013 [message #178798] |
Thu, 22 June 2006 12:16  |
maryannallen
Messages: 2
Registered: June 2006
|
Junior Member |
|
|
I am running an access query to 3 linked Oracle tables. Some times it runs just fine and other times I get the error msg
ora-01013 User Requested cancel of current operation.
When I run the same query in VBA (ado) sometimes it runs and sometimes I get runtim 2147467259 (80004005) Odbc called failed.
They both run fine in the early mornings, but during the day, they wont run at all......(strange) Its the same query.
I want to run it in vba ultimately using ado (I set the commandtimeout to 0) ..
Any thoughts on what is causing this?
condition is an access table, the mra_ tables are oracle.
sqlstmt2 = "insert into condition (prov_key, prov_grouper_name, condition_count) " & _
"SELECT a.prov_key, c.prov_grouper_name, count(b.cond_key) " & _
"FROM mra_member AS a, mra_condition AS b, mra_provider AS c " & _
"where a.memb_key = b.memb_key " & _
"and b.cond_status in ('51','52','53','55') " & _
"and a.prov_key = c.prov_key " & _
"and b.cond_year = " & myyear & " " & _
" and a.memb_elig_status = '01' " & _
" and c.prov_grouper_nbr in " & mygrouper & " group by " & _
" a.prov_key, c.prov_grouper_name order by a.prov_key, c.prov_grouper_name "
With ADOCmd
.CommandText = sqlstmt2
.ActiveConnection = CurrentProject.Connection
.CommandTimeout = 0
.ActiveConnection.CommandTimeout = 0
.Execute
End With
|
|
|
|
|
|
| Re: ora 01013 [message #178884 is a reply to message #178873] |
Fri, 23 June 2006 04:52  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
| Trawled from Metalink |
Except for information in Web sites controlled by third parties that are accessible via hyperlinks from MetaLink, the information contained in the Materials is the confidential proprietary information of Oracle. You may not use, disclose, reproduce, transmit, or otherwise copy in any form or by any means the information contained in the Materials for any purpose, other than to support your authorized use of the Oracle Programs for which you hold a supported license from Oracle, without the prior written permission of Oracle. Oracle will take reasonable measures to keep third parties from obtaining unauthorized access to iSRs that you submit using MetaLink; however, Oracle does not guarantee that third parties will not have access to any information, comments, feedback, or materials that you submit to Oracle through or in association with MetaLink.
|
Mr Rowbottom, please edit your post. You can reference MetaLink notes but you cannot copy them as they are copyrighted.
MHE
|
|
|
|
|
|
|
|
| Re: ora 01013 [message #178918 is a reply to message #178887] |
Fri, 23 June 2006 07:10 |
maryannallen
Messages: 2
Registered: June 2006
|
Junior Member |
|
|
How do I get to Metalink (Note 369592.1 )?
I searched this site and the one message out there wasnt the problem. However I may have figured it out......... I think when theres an error it just doesnt always come back and tell you whats wrong. I had the AS statement in the From clause and that may be whats wrong. I just dont have the query working just yet to know for sure...Now Im getting another error but I should be able to figure that out when I get a chance to get back on it! Thanks! MA
|
|
|
|
| Re: ora 01013 [message #178920 is a reply to message #178918] |
Fri, 23 June 2006 07:17 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Go to https://metalink.oracle.com and log on.
If you don't have a login, you need to talk to you DBA/Sysadmin and get him to set you up with one.
From here: http://www.leeds.ac.uk/infosystems/sims/support/technical/odbc/connecting.htm
is the suggestion that if you get a problem like this, you should go change the query timeout settings.
"open the query in design mode, then right click in a background area and select "properties", if they are not already open. (Be careful not to select the field or field-list properties). Item "ODBC Timeout" value can then be increased to give the query longer to run. For example, 300 and 600 are often used. Also note that setting the value to 0 essentially switches the time-out function off for that query, but may mean that Access has to be aborted via the "Control, Alt and Delete"” method if it runs for too long"
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
