Skip to main content
R
RS_1012820912-Amethyst
12-Amethyst
January 16, 2023
Question

How to solve Connection property: format error

  • January 16, 2023
  • 1 reply
  • 1706 views

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

D
DaveBfoot10-Marble
10-Marble
April 16, 2024

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>

 

    Terms & ConditionsCookie settingsAccessibility statement