Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

Progress 9.x
OpenEdge 10.x

SYMPTOM(s):

Connection using sysprogress (blanc password) fails with Java exception.

java.lang.NoClassDefFoundError
at sun/rmi/server/RemoteProxy.getSkeleton
at sun/rmi/server/UnicastServerRef.setSkeleton
at sun/rmi/server/UnicastServerRef.exportObject
at java/rmi/server/UnicastRemoteObject.exportObject
at java/rmi/server/UnicastRemoteObject.<init>
at com/progress/common
etworkevents/EventBroker.<init>
at com/progress/vj/explorer/ProgressExplorer.getClientEventBroker
at com/progress/vj/util/ProDialog.<clinit>
at com/progress/vj/util/ProDialog.getActiveProDlg
at com/progress/vj/util/ProMsgBox.show
at com/progress/vj/util/ProMsgBox.error
at com/progress/vj/util/ProMsgBox.error
at com/progress/vj/sql/explorer/SQLExplorerGUI.workingCallback
at com/ms/lang/Delegate.dynamicInvoke0
at com/ms/lang/Delegate.dynamicInvoke
at com/ms/wfc/ui/Control.invokeMarshaledCallback
at com/ms/wfc/ui/Control.wndProc
at com/ms/wfc/ui/Form.wndProc
at com/ms/wfc/app/Application$ParkingForm.wndProc
at com/ms/wfc/ui/Control$ControlWindow.wndProc
at com/ms/wfc/app/Window.callback
at com/ms/wfc/win32/Windows.DispatchMessage
at com/ms/wfc/app/Application$ThreadContext.runMessageLoop
at com/ms/wfc/app/Application.run
at com/progress/vj/sql/explorer/SQLExplorerGUI.main

SQL-92

SQL92

CAUSE:

Progress does not support SQL connection using a user that does not have a password created. Progress does not support blank user ID nor blank passwords when connecting to the SQL engine. A valid user ID and password must be used. This security feature is part of Progress SQL-92 implementation.

FIX:

Got to Data Administration - Security - Edit User List and delete the 'sysprogress' account created with a blank password, click OK on the warning before recreating the 'sysprogress' then add a password. The SQL connection should now work.