Unable to download xlsx even with new version of plugin

[stephhend]

Hi,

I installed the latest version https://github.com/glebovpavel/IR_to_MSExcel/archive/master.zip but I am still receiving the following error.

Can you help?

Error in PLSQL code raised during plug-in processing.

Contact your application administrator. Technical Info (only visible for developers)

is_internal_error: true apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR ora_sqlcode: -20001 ora_sqlerrm: ORA-20001: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APEX_MA.IR_TO_XLSX", line 1270 ORA-06512: at "APEX_MA.IR_TO_XLSX", line 1289 ORA-06512: at "APEX_MA.IR_TO_XLSX", line 1762 ORA-06512: at "APEX_MA.IR_TO_XLSX", line 1929 ORA-06512: at "APEX_MA.IR_TO_XLSX", line 2099 ORA-06512: at "APEX_MA.IR_TO_MSEXCEL", line 306 component.type: APEX_APPLICATION_PAGE_DA_ACTS component.id: 1717688679702666513 component.name: PLUGIN_AT.FRT.GPV_IR_TO_MSEXCEL error_backtrace:

ORA-06512: at "APEX_MA.IR_TO_MSEXCEL", line 336 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2107 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 599 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2486 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 1500 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 1383

error_statement:

begin declare

begin wwv_flow_plugin_api.g_dynamic_action_ajax_result := IR_TO_MSEXCEL.ajax (p_dynamic_action => wwv_flow_plugin_api.g_dynamic_action,p_plugin => wwv_flow_plugin_api.g_plugin );end; end;

Thanks! Stephanie

[stephhend]

Hi,

I installed the latest version https://github.com/glebovpavel/IR_to_MSExcel/archive/master.zip but I am still receiving the following error.

Can you help?

Error in PLSQL code raised during plug-in processing.

Contact your application administrator. Technical Info (only visible for developers)

is_internal_error: true apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR ora_sqlcode: -20001 ora_sqlerrm: ORA-20001: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APEX_MA.IR_TO_XLSX", line 1270 ORA-06512: at "APEX_MA.IR_TO_XLSX", line 1289 ORA-06512: at "APEX_MA.IR_TO_XLSX", line 1762 ORA-06512: at "APEX_MA.IR_TO_XLSX", line 1929 ORA-06512: at "APEX_MA.IR_TO_XLSX", line 2099 ORA-06512: at "APEX_MA.IR_TO_MSEXCEL", line 306 component.type: APEX_APPLICATION_PAGE_DA_ACTS component.id: 1717688679702666513 component.name: PLUGIN_AT.FRT.GPV_IR_TO_MSEXCEL error_backtrace:

ORA-06512: at "APEX_MA.IR_TO_MSEXCEL", line 336 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2107 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 599 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2486 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 1500 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 1383

error_statement:

begin declare

begin wwv_flow_plugin_api.g_dynamic_action_ajax_result := IR_TO_MSEXCEL.ajax (p_dynamic_action => wwv_flow_plugin_api.g_dynamic_action,p_plugin => wwv_flow_plugin_api.g_plugin );end; end;

Thanks! Stephanie

[stephhend]

I figured out I had an aggregate sum on one column that was causing the error.

[glebovpavel]

Hi Stephanie, Thank you very much for posting the reason of the error. It's very rare to be so courteous! Your short message will help another user (i know at least one user have the same problem right now).

Regards, Pavel

[stephhend]

Hi,

 

By chance you would know a solution to allow that aggregate sum on my xlsx download? I really need to have the downloaded report to look like that:

 

 

But right now because of the Aggregate sum of column “# Of Agreements”, the plug in result in error.

 

Or maybe do you know of a different plug in that will allow me to have this format?

 

 

-- Regards,

http://www.oracle.com/ Stephanie Hendrick | M&A Integration Lead Phone: HYPERLINK "tel:+1%209163155025"+1 9163155025 | Fax: HYPERLINK "fax:+1%209163155025"+1 9163155025 Royalty Reporting and Contract Compliance Oracle Global Controller Organization 1001 Sunset Blvd | Rocklin, CA 95765

http://www.oracle.com/commitment

Oracle is committed to developing practices and products that help protect the environment

HYPERLINK "https://oradocs-corp.sites.us2.oraclecloud.com/authsite/rrcc-global/"Royalty Reporting and Contract Compliance

 

 

 

 

From: Pavel Glebov notifications@github.com Sent: Tuesday, May 7, 2019 2:22 AM To: glebovpavel/IR_to_MSExcel IR_to_MSExcel@noreply.github.com Cc: stephhend stephanie.hendrick@oracle.com; Author author@noreply.github.com Subject: Re: [glebovpavel/IR_to_MSExcel] Unable to download xlsx even with new version of plugin (#60)

 

Hi Stephanie, Thank you very much for posting the reason of the error. It's very rare to be so courteous! Your short message will help another user (i know at least one user have the same problem right now).

Regards, Pavel

— You are receiving this because you authored the thread. Reply to this email directly, HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_glebovpavel_IR-5Fto-5FMSExcel_issues_60-23issuecomment-2D490004292&d=DwMCaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=BoWQzaGwmZnrG7ciWVmmsB3G07t7C5OUszs7oOQSOjs&m=HaLVbSt_27-GzZuaomSgC8X79FkJWwGkr_hDNxOvLww&s=kzRvi5Z98oSMtgu7TXBRkEVTXtsi3w_3HhArbTFd-Zo&e="view it on GitHub, or HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_AL6VB2TTS2CHPD23NXYSZBLPUFC5HANCNFSM4HJQP73A&d=DwMCaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=BoWQzaGwmZnrG7ciWVmmsB3G07t7C5OUszs7oOQSOjs&m=HaLVbSt_27-GzZuaomSgC8X79FkJWwGkr_hDNxOvLww&s=b_3sVMxrlh0JB5-zA-_g4IZHQBsj1ocT_JO-H-PlOEI&e="mute the thread. https://github.com/notifications/beacon/AL6VB2QITC2ORPPT227JXUDPUFC5HA5CNFSM4HJQP73KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODU2N6RA.gif

[glebovpavel]

Hi, looks like you are using Pl/SQL compiler optimization level >=3 - at result i get wron linen numbers by errors listed abowe. For example,
IR_TO_MSEXCEL", line 306 is v_affected_region_id apex_application_page_da_acts.affected_region_id%type; this code can't raise exception.

http://stevenfeuersteinonplsql.blogspot.com/2017/01/confused-by-your-error-backtrace-check.html

It is possible to compile the packages with optimization level = 2 , because right now it is impossible to find the reason of the error because of wrong line numbers.

P.S. I was trying to play with aggregate functions on apex.oracle.com (include null values etc) but can#t reproduce an error.

P.S.2 Could you try to download CSV? Do you use computations?

[glebovpavel]

Hallo Christine,

Unfortunately i still can't reproduce this error on my notebook or on apex.oracle.com. I will be very grateful to you, if you can reproduce this error on any dummy sample application on apex.oracle.com.

Anyway i will switch to the build-in apex logging in the next release - that can help to cach the error.

Regards, Pavel

[stephhend]

Hi,

 

I am not sure how to reproduce an error in a dummy application. I am pretty novice with APEX and tough myself everything I know which is pretty limited.

 

Is there another plugin what would allow to have computed/aggregated column?

 

 

-- Regards,

http://www.oracle.com/ Stephanie Hendrick | M&A Integration Lead Phone: HYPERLINK "tel:+1%209163155025"+1 9163155025 | Fax: HYPERLINK "fax:+1%209163155025"+1 9163155025 Royalty Reporting and Contract Compliance Oracle Global Controller Organization 1001 Sunset Blvd | Rocklin, CA 95765

http://www.oracle.com/commitment

Oracle is committed to developing practices and products that help protect the environment

HYPERLINK "https://oradocs-corp.sites.us2.oraclecloud.com/authsite/rrcc-global/"Royalty Reporting and Contract Compliance

 

 

 

 

From: Pavel Glebov notifications@github.com Sent: Friday, May 24, 2019 5:20 AM To: glebovpavel/IR_to_MSExcel IR_to_MSExcel@noreply.github.com Cc: stephhend stephanie.hendrick@oracle.com; Author author@noreply.github.com Subject: Re: [glebovpavel/IR_to_MSExcel] Unable to download xlsx even with new version of plugin (#60)

 

Hallo Christine,

Unfortunately i still can't reproduce this error on my notebook or on apex.oracle.com. I will be very grateful to you, if you can reproduce this error on any dummy sample application on apex.oracle.com.

Anyway i will switch to the build-in apex logging in the next release - that can help to cach the error.

Regards, Pavel

— You are receiving this because you authored the thread. Reply to this email directly, HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_glebovpavel_IR-5Fto-5FMSExcel_issues_60-3Femail-5Fsource-3Dnotifications-26email-5Ftoken-3DAL6VB2TGXIE7KK65XYSJKCLPW7MQPA5CNFSM4HJQP73KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODWFELBA-23issuecomment-2D495601028&d=DwMCaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=BoWQzaGwmZnrG7ciWVmmsB3G07t7C5OUszs7oOQSOjs&m=F6bYiiz6V3nEcP4gBGW2LugN5e7kaaqXVfw-7gUVxsE&s=en4yULJ0CicjbM973dHeKemy16q8cJ4QvzIQHkISH-I&e="view it on GitHub, or HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_AL6VB2W7PUVFUM4LPQXKCKLPW7MQPANCNFSM4HJQP73A&d=DwMCaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=BoWQzaGwmZnrG7ciWVmmsB3G07t7C5OUszs7oOQSOjs&m=F6bYiiz6V3nEcP4gBGW2LugN5e7kaaqXVfw-7gUVxsE&s=qb8bqmlQtHaRxEM-D0r-OZBbdud9nDbA_Oy_KCAdD0U&e="mute the thread. https://github.com/notifications/beacon/AL6VB2XSSBJ34SAF2GXASLTPW7MQPA5CNFSM4HJQP73KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODWFELBA.gif

[dennyssistema]

I'm going through the same problem

[glebovpavel]

Probably fixed in newest version 3.2. Anyway there are new logging feature to collect more data for detecting errors.

[glebovpavel]

After some findings fixed in 3.24