Reputation: 11
I have a problem when executing it outside the form builder,
from the call
http: // localhost: 9001 / forms / frmservlet? Config = webutil_webstart
I do the validation on the server with showjobs the error that I have is
The report ended in error: REP-501: The specified database can not be connected ..
Maybe you can give me a hand where I would be missing some configuration.
thanks a lot.
Upvotes: 0
Views: 8654
Reputation: 1
Edit The RWBuilder.bat
Add Two Lines
set TNS_ADMIN=C:\Oracle\Middleware\Oracle_Home\network\ADMIN
set ORACLE_HOME=C:\Oracle\Middleware\Oracle_Home
Upvotes: 0
Reputation: 145
"If you're on Linux. The issues is due to special character in your password that could not be interpreted. If you change the password in the database without special character or replace the spacial character with an underscore (_). It should work." previous POST
100% correct
I had # in my password changed to &23 and it worked
https://www.w3schools.com/tags/ref_urlencode.ASP
Upvotes: 0
Reputation: 11
If you're on Linux. The issues is due to special character in your password that could not be interpreted. If you change the password in the database without special character or replace the spacial character with an underscore (_). It should work.
Upvotes: 1
Reputation: 65408
look at your db alias
(assume mydb01
) in tnsnames.ora
file under these paths:
$ORACLE_INSTANCE/config
for Linux
or Solaris
.
maybe like C:\Oracle\Middleware\asinst_1\config
for Windows
.
Try to ping that alias like :
tnsping mydb01
if succeeds, use it for your connections.
During call of run_report_object()
you have some parameter settings, whilst you may have such alike statement :
hidden_action := hidden_action ||’&userid=’
||get_application_property(username)||’/’||
get_application_property(password)||’@’||
get_application_property(connect_string);
Look at this arguments (connect_string,username&password) whether be set truely.
Upvotes: 1