Home » Developer & Programmer » Forms » ORA-03106 two-task error: when scrolling in Forms
ORA-03106 two-task error: when scrolling in Forms [message #222182] Fri, 02 March 2007 03:38 Go to next message
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 #222470 is a reply to message #222182] Mon, 05 March 2007 00:32 Go to previous messageGo to next message
ommin
Messages: 22
Registered: June 2006
Location: pune,India
Junior Member

hi

might be this problem occurs due to rowid format get changed, after migration of DB.

setting TWO_TASK variable on server may solve your problem.

Omkar
Re: ORA-03106 two-task error: when scrolling in Forms [message #222598 is a reply to message #222470] Mon, 05 March 2007 10:20 Go to previous messageGo to next message
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 #225402 is a reply to message #222598] Mon, 19 March 2007 20:09 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: ORA-03106 two-task error: when scrolling in Forms [message #225495 is a reply to message #225402] Tue, 20 March 2007 02:12 Go to previous messageGo to next message
marxello
Messages: 9
Registered: March 2007
Junior Member
No, I haven't. Can you help me.

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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Hide check box if not needed
Next Topic: To call crystal report from oracle forms6i
Goto Forum:
  


Current Time: Sun Dec 11 04:33:33 CST 2016

Total time taken to generate the page: 0.13231 seconds