Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1125
  • Last Modified:

what is this error?

while executing a sql query i got this error in toad:
ORA-6831047
0
st213497
Asked:
st213497
  • 4
  • 3
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
that's very suprising, as ORA- errors only have 5 digits.
so, it's a TOAD error (and you don't seem to be the only one having this issue)

you seem to have a toad version that is not 100% compatible with the server version/settings of some kind.
you can only make sure you get the correct versions, use another tool, or live with the problem  ,...
0
 
st213497Author Commented:
it is true i have a different version of road than the server .... but why this query only ...  and all the other queries run with no problem

SELECT * FROM RS@RIS_DB
           WHERE FINISH_TYPE in (0,1,2,3)
            AND  LENGTH(ROLL_ID)=6
         AND status =0
         AND roll_id in (100100,200200)
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>FROM RS@RIS_DB
so, additionally, a query over dblink ... makes things not easier :)

can you try the same query from sql*plus (or some other oracle/sql tool)?

can you check if you get any user trace file on either db server?
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
st213497Author Commented:
Actually i tried this from the same toad version but different database ... and i worked fine.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
it would be know the puzzle to know what different setting between the 2 databases make up this error ...
0
 
slightwv (䄆 Netminder) Commented:
A quick Google shows that appears to be a Toad specific error.

It also appears to be related to a dropped connection.

http://tech.groups.yahoo.com/group/toad/message/53015

Since you can connect fine to a different database I suggest you look into network issues between your client machine and the server running RIS_DB.
0
 
st213497Author Commented:
Thank you all.

it was the connection to the local DB not the remote one. I've reconnected to the local db once again and it worked.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now