Main Region

Blob Download in grid - Prmary Key with "+" Symbol Issue
8 answers | 792 views

AW
Oct 11, 2013 16:09 +00:00

Hi Matt,

Thanks for pointing me in the right direction. Does this method rely on using the ROWID as the primary key column? I set it up that way, but I'm getting invalid ROWID errors when I click the download link. When I change to the real primary key, Strangely I get the same error.

Any ideas?

Thanks

Alan

9 comments

MN
Matt Nolan Oct 12, 2013 07:53 +00:00 

One question did you include the primary key column i.e. ROWID in the report query?

e.g.

SELECT ROWID, ...

MN
Matt Nolan Oct 13, 2014 11:21 +00:00 

Did you include your ROWID in the grid query? and did you make it the primary Key in the grid plugin attribute settings?

If you continue to have problems please create a simple test case on demo.tryfoexnow.com that reproduces the problem.

CH
Christian86 Oct 13, 2014 11:33 +00:00 

Yes I have. I think the "+" in the ROWID is the problem.

MN
Matt Nolan Oct 13, 2014 13:30 +00:00 

Please put the page in debug mode and send the full output of the debug list entry that has the Invalid ROWID error.

MN
Matt Nolan Oct 13, 2014 15:08 +00:00 

What does your ROWID value look like?

I can see in the AJAX call that it comes through looking like "AAC6HsAAPAAApq AAX "

MN
Matt Nolan Oct 14, 2014 07:27 +00:00 

Thanks, I'm investigating

MN
Matt Nolan Oct 15, 2014 12:48 +00:00 

Hi Alan my apologies for this slipping off the radar after not hearing back from you. Another customer pressed us on the issue and provided some very useful debug information which allowed me to pinpoint the issue. It will be fixed in v2.0.

CH
Christian86 Oct 17, 2014 08:10 +00:00 

or is there a workaround?

MN
Matt Nolan Oct 17, 2014 08:15 +00:00 

If you cannot wait to upgrade to v2.0 or for the next patch release and require immediate resolution you can request a hot fix for the problem. It will require you to use 2 support credits from your support contract.

MN
Oct 15, 2014 12:47 +00:00

I can confirm that I have located the bug and is now fixed in v2.0 due out very soon.

0 comments

MN
Oct 11, 2013 18:21 +00:00

Hi Alan

I will need you to create a test case on demo.tryfoexnow.com so that I can investigate what the issue is.

0 comments

AW
Oct 11, 2013 23:18 +00:00

Hi Matt

OK I'll try and set this up. I suspect that the issue is something to do with none alpha characters in the ROWIDs (my data has + signs in the rowids). I've seen this issue in Apex before in a different context where rowids are used in Apex URLs and the none alpha characters cause issues.

Alan

0 comments

CH
Oct 13, 2014 11:08 +00:00

Hi Matt, hi Alan

I´ve the same Problem. In an Grid I get an error - invalid rowid. In an APEX Report it works fine. Do you have solved this problem yet?

Christian

0 comments

CH
Oct 13, 2014 13:51 +00:00

S H O W: application="500" page="1116" workspace="" request="PLUGIN=B161FE0D4FC347B3E1507F40B6F169CF14B7E082321E8E27E6C438C9DB92A92B" session="3250062331717" Reset NLS settings alter session set NLS_LANGUAGE="GERMAN" alter session set NLS_TERRITORY="GERMANY" alter session set NLS_CALENDAR="GREGORIAN" alter session set NLS_SORT="GERMAN" alter session set NLS_COMP="BINARY" ...NLS: Set Decimal separator="," ...NLS: Set NLS Group separator="." ...NLS: Set g_nls_date_format="DD.MM.RR" ...NLS: Set g_nls_timestamp_format="DD.MM.RR HH24:MI:SSXFF" ...NLS: Set g_nls_timestamp_tz_format="DD.MM.RR HH24:MI:SSXFF TZR" NLS of database and client differs, characterset conversion needed ...Setting session time_zone to +02:00 Language derived from: FLOW_PRIMARY_LANGUAGE, current browser language: de-at alter session set nls_language="GERMAN" alter session set nls_territory="AUSTRIA" NLS: CSV charset=WE8MSWIN1252 ...NLS: Set Decimal separator="," ...NLS: Set NLS Group separator="." ...NLS: Set g_nls_date_format="DD.MM.RR" ...NLS: Set g_nls_timestamp_format="DD.MM.RR HH24:MI:SSXFF" ...NLS: Set g_nls_timestamp_tz_format="DD.MM.RR HH24:MI:SSXFF TZR" Setting NLS_DATE_FORMAT to application date format: YYYY-MM-DD ...NLS: Set g_nls_date_format="YYYY-MM-DD" ...NLS: Set g_nls_timestamp_format="DD.MM.RR HH24:MI:SSXFF" ...NLS: Set g_nls_timestamp_tz_format="DD.MM.RR HH24:MI:SSXFF TZR" NLS: Language=de-at Application 500, Authentication: PLUGIN, Page Template: 18227403703589384 Authentication check: Database Account (NATIVE_DB_ACCOUNTS) ...fetch session state from database fetch items (exact) ... sentry+verification success ...Session ID 3250062331717 can be used ...Setting session time_zone to +02:00 ...Check for session expiration: ...Session State: Saved Item "FSP_SESSION_TIME" New Value="20141013154553::" Session: Fetch session header information Authorization Check: "Admin oder Agent oder Superuser oder Info" Caching: "BY_USER_BY_SESSION" Component: "APPLICATION" ... passed (using cache) Run NATIVE/PLUGIN= request ...Execute Statement: begin declare begin wwv_flow_plugin_api.g_region_ajax_result := fx_p_grid.ajax (p_region => wwv_flow_plugin_api.g_region,p_plugin => wwv_flow_plugin_api.g_plugin );end; end; ... Start FX_P_GRID.ajax Plugin meta data: file_prefix: attribute_01: "frame": true attribute_02: attribute_03: attribute_04: attribute_05: attribute_06: attribute_07: attribute_08: attribute_09: attribute_10: attribute_11: attribute_12: attribute_13: attribute_14: attribute_15: Region meta data: id: 25586211302223650 static_id: R25586211302223650 name: Hochgeladene Anhänge type: PLUGIN_COM.FOEX.PLUGIN.GRID source: ajax_items_to_submit: fetched_rows: 15 escape_output: true no_data_found_message: Keine Daten gefunden attribute_01: ETS_TICKET_ANHANG attribute_02: BEFORE_AFTER attribute_03: attribute_04: attribute_05: attribute_06: CELLEDIT attribute_07: ROWID attribute_08: attribute_09: CREATE:UPDATE:DELETE attribute_10: attribute_11: "frame":false, "preventHeader":false, "autoScroll":true, "flex":1, "excludeSearchPlugin":false, "hidePagination":false, "addRowNumbers":false, "columnLines":false, "autoLoad":false, "autoLoadOnRender":true, "height":600, "width":"100%", "collapsible":false, "stateful":true, "resizeHandles":"" attribute_12: attribute_13: attribute_14: attribute_15: INHERIT attribute_16: attribute_17: attribute_18: attribute_19: attribute_20: attribute_21: attribute_22: attribute_23: attribute_24: attribute_25: AJAX PARAMETERS p_widget_name: Ext.foex.Grid p_widget_action: download p_widget_action_mod: p_request: PLUGIN=B161FE0D4FC347B3E1507F40B6F169CF14B7E082321E8E27E6C438C9DB92A92B x01: 25591409046346278 x02: AAC6HsAAPAAApq AAX x03: x04: N x05: x06: x07: x08: x09: x10: f01: ... application_item_check START ... application_item_check END ...Session State: Save "FOEX_CTX_ID" - saving same value: "" ...Session State: Save "FOEX_CTX_TEXT" - saving same value: "" ... Start FX_P_GRID.download_file ... Proc/Func: FX_P_GRID.download_file ... Error: ORA-01410: Ungültige ROWID ... Back Trace: ORA-06512: in "FOEX_010204.FX_P_GRID", Zeile 6318 ... Proc/Func: FX_P_GRID.ajax ... Error: ORA-01410: Ungültige ROWID ... Back Trace: ORA-06512: in "FOEX_010204.FX_P_GRID", Zeile 6353 ORA-06512: in "FOEX_010204.FX_P_GRID", Zeile 6605 Stop APEX Engine detected Final commit

0 comments

CH
Oct 14, 2014 04:18 +00:00

So I think thats the problem. The rowid is: AAC6HsAAPAAApq+AAX The "+" is the problem.

0 comments

CH
Oct 15, 2014 12:52 +00:00

Thank you. Christian

0 comments

CH
Oct 17, 2014 08:09 +00:00

Hi

is there planned a bugfix because we designed this application using rowid and we would really need this feature. We use it in different parts of the application.

Christian

0 comments

You must log in or sign up to post questions and answers.