Hi
In my job I am extracting data from oracle tables and inserting it into sql server tables. I am getting following warning messages .. any idea how to resolved it ?
Oracle_Enterprise_5,0: Column POUNDS floating point decimal is not fully supported; adjusting the scale. [orautils.C:2383]
Thanx in advance
How to get the rid of Warning messages
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 88
- Joined: Wed Apr 05, 2006 1:04 am
Re: How to get the rid of Warning messages
You can supress the Warning message using the Message handler,ketanshah123 wrote:Hi
In my job I am extracting data from oracle tables and inserting it into sql server tables. I am getting following warning messages .. any idea how to resolved it ?
Oracle_Enterprise_5,0: Column POUNDS floating point decimal is not fully supported; adjusting the scale. [orautils.C:2383]
Thanx in advance
Hope this help you,
viewtopic.php?t=132459&highlight=floati ... +supported
RAJ
-
- Participant
- Posts: 88
- Joined: Wed Apr 05, 2006 1:04 am
go to the director, click on one of the warning messages, the right-mouse click and choose "add rule to message handler" to get the window where you can choose your settings.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
That will add the message handler for an individual job. If you want to have that message mapped to informational (my recommendation) for all jobs in a project then do the same thing (add it to a message handler) and then have the administrator add that message handler as the default message handler for the entire project in the admin client.
You can only have one default message handler for a project, so I'd name it something generic like "Project_MH" because it may get additional rules later.
By the way - don't go crazy with mapping stuff to informational - this is one of the rare messages that it is a reasonable solution to stop the warnings. Most warnings are there for a reason and can be resolved without using the message handler.
You can only have one default message handler for a project, so I'd name it something generic like "Project_MH" because it may get additional rules later.
By the way - don't go crazy with mapping stuff to informational - this is one of the rare messages that it is a reasonable solution to stop the warnings. Most warnings are there for a reason and can be resolved without using the message handler.