| ORA-03106 two-task error: when scrolling in Forms [message #222182] |
Fri, 02 March 2007 03:38  |
marxello
Messages: 9
Registered: March 2007
|
Junior Member |
|
|
Hello,
I've a form done with 6i version that gives data from 8i version DB.
This DB uses a DBLink to another 8i DB to get the data table whose the form uses.
In this case all is running well.
I've migrated the final DB 8i whose has the DBLink to 8i to get the data table. Now I have the same form that gives data from 9i version DB. This have the DBLink its antecessor to another 8i DB. Now, at first, seems to go well. But when I want to scroll the form to see more data, then the form shows the ORA-03106 Error, two-task error in protocol communication.
I've seen that the same query in TOAD goes well. Only I've problems when I need to scroll data. What can I do? Help me please. Thanks in advance,
Marxello
|
|
|
|
|
|
| Re: ORA-03106 two-task error: when scrolling in Forms [message #222598 is a reply to message #222470] |
Mon, 05 March 2007 10:20  |
marxello
Messages: 9
Registered: March 2007
|
Junior Member |
|
|
First of all, thanks for your answer.
I don't understand why the same query that gives me problems on Forms, it goes well on Toad. They use the same environment, aren't they? Because they query to 9i and 9i uses the same DBLink to 8i. Then, why do you think setting a varibale (TWO_TASK) it will go well?
And, if I put this variable, Can I do another queries to other different DB than which I set in the variable?
Thanks for your answers.
Marxello
|
|
|
|
|
|
|
|
| Re: ORA-03106 two-task error: when scrolling in Forms [message #225892 is a reply to message #225495] |
Wed, 21 March 2007 19:24 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Okay. First off, the message is not "ORA-03106 Error, two-task error in protocol communication" but "ORA-03106: fatal two-task communication protocol error". Please post the message as displayed, it saves us 10 minutes each time.
I searched the forum for 'ORA-03106: fatal two-task communication protocol error' without success but searching the website gave quite a few hits.
In one it suggests "Try synching the NLS_LANG variable on the client and server". I would suggest having the same NLS_LANG in all three, that is, the two databases and the application server. However, I think that the latter is less important than having the two databases matching.
Also, see this one and this one and especially this one.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
