cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

How to solve Connection property: format error

RS_10128209
11-Garnet

How to solve Connection property: format error

Im getting this error while extracting DataMapping files from W2W

 

com.ptc.windchill.migration.wbm.wc2wc.util.WBMException: java.sql.SQLException: Connection property: format error: Property is 'v$session.osuser' and value is '************************************.com' .

 

RS_10128209_1-1673852213865.png

 

1 REPLY 1
DaveBfoot
5-Regular Member
(To:RS_10128209)

I'm aware this is a bit old but if anyone else comes up against this issue I belive it is casued by the fact the v$session.osuser uses the logged on username for this property & the username is more than 30 characters long.

 

I've only verified the workaound for this in trying to launch SQLDeveloper but the solution for it was editing the following config in the SQLDeveloper direcory:

\ide\bin\ide.conf -At the end add the following line:

 

# Custom VM Option
AddVMOption  -Duser.name=<UsernameToRunWith> 

 

Announcements
Top Tags