otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
MavenWire

Go Back   Oracle OTM / G-Log GC3 Community Support > OTM / G-Log - Functional Topics > Data Loading
Reload this Page

OTM 5.5 - error attempting to run ClientUtil.py python script


Data Loading Loading data into OTM / G-Log through CSVs, XML, and the UI.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old January 14th, 2009, 15:02
Junior Member
 
Join Date: Jul 2007
Posts: 5
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
rlukes is on a distinguished road
OTM 5.5 - error attempting to run ClientUtil.py python script

Hello. First time post for me.

We recently upgraded from OTM 5.0 to OTM 5.5 and have both versions running on separate servers. We have always used the python upload method to load freight rates into OTM using ClientUtil.py which worked well in OTM 5.0. However, when we try running the same scripts on the OTM 5.5 server we get the following error:

Traceback (most recent call last):
File "/appsoft/otm55/utils/integration/python/ClientUtil.py", line 640, in ?
args.argValue("localDir"),args.argValue("localFile Name"),args.argValue("csvUtilCommand"),args.argVal ue("xvalidate"))
File "/appsoft/otm55/utils/integration/python/ClientUtil.py", line 363, in csvImport
encoding=commonTools.getCharacterEncoding()
File "/appsoft/otm55/utils/integration/python/commonTools.py", line 740, in getCharacterEncoding
return site.encoding
AttributeError: 'module' object has no attribute 'encoding'

Since we didn't change any code, I suspect that this is due to an installation or configuration issue with Python. Unfortunately, my python skills are minimal.

Any ideas or suggestions on what is happening and how I can get our python rate loads working again?

Help is greatly appreciated.

Thank you!
--Richard
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old January 15th, 2009, 17:55
Junior Member
 
Join Date: Jul 2007
Posts: 5
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
rlukes is on a distinguished road
Re: OTM 5.5 - error attempting to run ClientUtil.py python script

I found the answer on MetaLink:
Cause

The cause is that there is a difference in the python versions used and one has a change in one of the modules. Current python code reference as used by OTM needs to be updated to reflect the change.

This is explained in the following bug:
Bug.<7647979> RECEIVE AN ERROR WHEN RUNNING CLIENTUTIL.PY


Solution

-- To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for 5.5 CU5 RU3 when made available, currently scheduled for release at the end of Jan 2009.

2. Ensure that you have taken a backup of your system before applying Version 5.5 CU5 RU3

3. Apply Version 5.5 CU5 RU3 in a test environment.

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old January 19th, 2009, 22:55
chrisplough's Avatar
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 1,167
Blog Entries: 8
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 143
Thanked 257 Times in 160 Posts
Rep Power: 10
chrisplough is a jewel in the roughchrisplough is a jewel in the roughchrisplough is a jewel in the rough
Send a message via AIM to chrisplough
Re: OTM 5.5 - error attempting to run ClientUtil.py python script

Thanks for the update. If you test 5.5 CU5 RU03 and it works, please post back. This is a big deal to a lot of OTM users out there.

--Chris
__________________
Chris Plough
MavenWire

www.MavenWire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old April 14th, 2009, 18:19
Junior Member
 
Join Date: Jul 2007
Posts: 5
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
rlukes is on a distinguished road
Re: OTM 5.5 - error attempting to run ClientUtil.py python script

Sorry for not replying sooner... Bug No. 7647979 now includes details on the exact line(s) in commonTools.py which need to be updated. We made this change and deferred applying the roll-up until later. Our problem is resolved now.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
python script to execute CacheClearServlet? rlukes SysAdmin and Management 3 July 19th, 2009 10:41
Python For Integration gurujala Integration and Data Mapping 1 November 24th, 2008 15:19
Invoking a Custom python or Shell script prasad Feature Requests and Inquiries 2 March 16th, 2008 22:08
Using ClientUtil.py through a Proxy andyp222 Integration and Data Mapping 2 January 21st, 2008 12:26
[SCRIPT] Remote Restart of OTM via SSH chrisplough SysAdmin and Management 0 June 12th, 2007 16:37



All times are GMT. The time now is 04:01.
Copyright © 2006-2009, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40