APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problems Exporting to excel

Gui Rocha-OracleMar 18 2015 — edited Mar 18 2015

Hi everyone,

I`m trying to export my interactive report to a excel file.

In the attributes of my interactive report i check the pdf, excel and csv options to be downloadable.

The problem is, only the csv file works ( and barely since it doesn t come separated by columns, even with the rules to automatically separate them in apex are checked - but this is ok, i can change them in excel)

The real issue is when i try to open the pdf or xls files they return me errors. the pdf file doesn`t even open and the excel gives me an error

" The file you are trying to open is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?""

(i tried a solution i find in one of the posts here to edit regedit but it was a solution for excel 2007, even tough mine is 2010, and it didn`t work) and after i close the error message excel opens with the following message " ORA-06502: PL/SQL: numeric or value error: character string buffer too small"

Does anyone knows how to fix this

Matthias Edelhof

Hello, what Client can i use to connect to 19c Database? When I install 21xe ( windows ) the path is modify to 21xe first. Must i create new net connection with the 21 net?
Matthias

MadMexx

Hi
Installation of 21c XE failed during configuration.
{IDS_OracleConfigDlg_DatabaseConfigFailedMsg} An error occurred while configuring Oracle XE database. Check the logs at... [FATAL] [DBT-50000] Prüfung auf verfügbaren Speicher nicht möglich.
In the Eventviewer there is also a entry for "OracleRemExecServiceV2". The service was not started because of an error.
I am using Windows 10 Professional Version 21H1 (Build 19043.1288) on a AMD Ryzen. Microsoft Hyper-V is installed.

L. Fernigrini

Hi, do no hijack an existing thread, open a new question and include a proper title and the description of the issue.

Christian.Shay -Oracle

Hi MadMexx,
I will need to have a look at your logs.
Can you please zip up the contents of the [Oracle_Base]\cfgtoollogs\dbca directory and email them to me at christian dot shay at oracle dot com?
For example: c:\app\username\product\21c\cfgtoollogs\dbca
Then post here to let me know you emailed it?

MadMexx

Hello Christian,
I just send you a mail with the logs. Thanks

User_DKB06

I have the same issue and these are my logs, please help me with it
dbca.zip (297.61 KB)

User_MD054

I also have the same issue in please find error .
Configuring Oracle XE listener...
Oracle XE listener configured successfully.
Configuring Oracle XE database...
7% complete
8% complete

[FATAL] ORA-12560: TNS:protocol adapter error

29% complete
100% complete
[FATAL] ORA-12560: TNS:protocol adapter error

[FATAL] ORA-12560: TNS:protocol adapter error

29
7% complete
[FATAL] ORA-12560: TNS:protocol adapter error

29
0% complete
[FATAL] ORA-12560: TNS:protocol adapter error

29
Performing post XE database creation actions...
Post XE database creation actions completed.
{IDS_OracleConfigDlg_DatabaseConfigFailedM

User_YGSMU

i am unable to install a version of oracle database without problem, same issue {IDS_OracleConfigDlg_DatabaseConfigFailedMsg} An error occurred while configuring Oracle XE database.

User_MD054

Please try to use small name of your system and try In my case when change system name to small like 4 latter I am able to do installation such a weird but it rectify my error.

User_M27IT

it's really works, thanks man

User_G0SPM

{IDS_OracleConfigDlg_DatabaseConfigFailedMsg}
Anyone please help iam stuck out with these

User_G0SPM

Where to use small name of system?

Eusebius

Have a look here :
Maximum length of SID - Ask TOM (0 Bytes)

Eusebius

look here :
asktom.oracle.com/pls/apex/asktom.search?tag=maximum-length-of-sid

User_CNNKW

In my experience, I had tried reinstalling Oracle 21C XE on my Windows 10 Pro laptop for five times without success. Eventually, I followed the steps below:

Uninstalled the Oracle 21C XE
Deleted the folder app/..../product/21c
This PC --> Manage --> Local Users and Groups --> Groups
Deleted all the groups that had ORA associated with it, example name such as ORA_ASMADMIN
Went to the registry as suggested above and deleted entries of my previous Oracle 21C XE installations.
Opened the folder where I extracted Oracle 21C XE and then opened the ISSetupPrerequisites folder.
Navigated to the file named vcredist_x64.exe
Opened the file as Administrator and followed the installation wizard.
Having installed the vcredist_64.exe, I restarted the computer.
10. Now, I went ahead to install Oracle 21C XE. It took more than one hour to complete the installation.
For now, I am able to connect to the XEPDB1 database and create table, add values to the table and view the table. I have no idea if other issues will crop up, but I have at least been able to install the software. I hope this helps someone.

User_CNNKW

I forgot to list a step.
Let say step 5a. Went to Environment variables and deleted the line that had oracleHome in it.

User_B2O2X

I have a same problem when install oracle xe,
here is the error message
{IDS_OracleConfigDlg_DatabaseConfigFailedMsg} An error occurred while configuring Oracle XE database. Check the logs at C:\app\user\product\21c\cfgtoollogs\dbca and try again.

I have attached the \dbca file, I have reinstalled it many times, but still can not figure out what the problem is, could someone help me, many thanks!!!
trace.zip (41.26 KB)

APEX

Problems Exporting to excel

Comments

Post Details