Community forum

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
Offline jrtwynam  
#1 Posted : Wednesday, August 7, 2019 8:47:17 PM(UTC)
jrtwynam

Rank: Free support

Joined: 7/20/2017(UTC)
Posts: 131
Canada
Location: Ontario, Toronto

Thanks: 4 times
Was thanked: 16 time(s) in 16 post(s)
Hi,

When installing VC on my team's new server, I was having trouble with all of my Oracle connections since they had been using OraOLEDB.Oracle.1 as the provider. I believe it was Henrik from VC Support who suggested that I switch to the VC native Oracle connection, so I set up all of my existing connections using the native support. I then switched over most of my jobs to use those new connections, but I have a couple of scripts that refuse to run under the native connection, and I have no idea why. There's nothing wrong with the script itself - it ran perfectly using OraOLEDB.Oracle.1, and it runs perfectly when I run it manually in Oracle SQL Developer.

My problem now is that I was trying to install Oracle Express on this machine, and somehow it messed up the registration of OraOLEDB.Oracle.1, so now those connections don't work anymore. The error I get when I try using the native connection really isn't very descriptive:

Code:
Error in sql query: ORA03113

Exception in Task: ORA03113. ORA03113


Does anyone have any idea why the native connection doesn't work in this case? I'd post my script, but it's 360 lines long and I wouldn't expect anyone here to look through something like that in detail. Besides, as I said above, it's not the script that's the problem. At least, not the executable statements - I had thought that maybe the native driver doesn't like some of the comments, so I removed a bunch, but still no luck.


Thanks.

Edited by moderator Friday, August 9, 2019 12:12:27 PM(UTC)  | Reason: Not specified

Offline Support  
#2 Posted : Thursday, August 8, 2019 10:43:45 AM(UTC)
Support

Rank: Official support

Joined: 2/23/2008(UTC)
Posts: 11,167

Thanks: 868 times
Was thanked: 443 time(s) in 421 post(s)
It seems like a generic error so hard to trace the reason. Maybe it is a timeout? Does the script run long time normally?

I would try to cut out or simply the script to see which line is causing the issue.
Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!
Offline jrtwynam  
#3 Posted : Thursday, August 8, 2019 1:56:49 PM(UTC)
jrtwynam

Rank: Free support

Joined: 7/20/2017(UTC)
Posts: 131
Canada
Location: Ontario, Toronto

Thanks: 4 times
Was thanked: 16 time(s) in 16 post(s)
The script usually takes about 1 minute to run, but it's giving the error much sooner than that, after only a few seconds. I'll try your suggestion, but I'm not sure how much I can cut out because most things within the script are dependent on each other.
Offline jrtwynam  
#4 Posted : Thursday, August 8, 2019 2:28:45 PM(UTC)
jrtwynam

Rank: Free support

Joined: 7/20/2017(UTC)
Posts: 131
Canada
Location: Ontario, Toronto

Thanks: 4 times
Was thanked: 16 time(s) in 16 post(s)
Ok, now I feel like a complete idiot. :)

You were right about the timeout, but it wasn't an Oracle-related timeout. I had this set to 9 seconds:

SS1.png

I'm not sure how I managed to set that, because I certainly didn't do it on purpose. My guess is that I accidentally hit something as I was tabbing through the fields. Once I set it to 0, the script ran perfectly.

Thanks!
thanks 1 user thanked jrtwynam for this useful post.
Support on 8/9/2019(UTC)
Offline Support  
#5 Posted : Friday, August 9, 2019 12:12:19 PM(UTC)
Support

Rank: Official support

Joined: 2/23/2008(UTC)
Posts: 11,167

Thanks: 868 times
Was thanked: 443 time(s) in 421 post(s)
Glad it was resolved!
Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Scroll to Top