Skip to Content (Press Enter)
2021-04-17 09-53-48
José Gonçalves
35Views
23Comments
[ReactFilePondUpload] ORA-01460: unimplemented or unreasonable conversion requested
Question
Forge
reactfilepondupload
Reactive icon
ReactFilePondUpload (O11)
Forge asset by Stuart Harris

Hi,

there's this error in Oracle version:

  • Error executing query. Error in advanced query SQLAddChunk_Oracle in FilePondUpload_ChunkedFileAppend in ReactFilePondUpload_CW (DECLARE blob1 BLOB;    BEGIN        UPDATE {UploadedFile}      SET {UploadedFile}.[LastChunkNum] = @ChunkNumber,      {UploadedFile}.[ChangedByUserId] = @CurrUserId,      {UploadedFile}.[ChangedDateTime] = @CurrDateTime      WHERE {UploadedFile}.[Id] = @UploadedFileId;        SELECT {UploadedFile}.[BinaryContent] INTO blob1      FROM {UploadedFile}      WHERE {UploadedFile}.[Id] = @UploadedFileId      FOR UPDATE;        -- If there is no data, NULL is returned      IF (DBMS_LOB.GETLENGTH(blob1) IS NULL OR DBMS_LOB.GETLENGTH(blob1) = 0)      THEN          UPDATE {UploadedFile}          SET {UploadedFile}.[BinaryContent] = @ChunkContent          WHERE {UploadedFile}.[Id] = @UploadedFileId;          ELSE          DBMS_LOB.APPEND(blob1, @ChunkContent);      END IF;    END;  ): ORA-01460: unimplemented or unreasonable conversion requested 


What causes the ORA-01460 and how can I avoid it? Cause: The requested format conversion is not supported. Action: Remove the requested conversion from the SQL statement. Check the syntax for the TO_CHAR, TO_DATE, and TO_NUMBER functions to see which conversions are supported.

I couldn't find any conversion in the query:


Regards

 


0
0
14 Apr 2023
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi José,

Implicit conversions take place when an assignment or compare is done with different datatypes. Are you sure all your input parameters have compatible data types with how they're used? 

0
0
14 Apr 2023
Copy Link
2021-04-17 09-53-48
José Gonçalves

This is related to forge component ReactFilePondUpload.

The query is part of the component with no inputs from the user except a file. 

0
0
14 Apr 2023
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Replying to José Gonçalves' comment on 14 Apr 2023 12:57:45

Right, that wasn't clear to me, sorry for the confusion.

0
0
14 Apr 2023
Copy Link
2024-11-07 03-28-42
Stuart Harris
Champion

Hi Jose,

I have had problems in the past with older versions of Oracle. What version of Oracle are you using?

I have checked these queries on a new Oracle instance, but have struggled to debug older versions, when I needed it, I couldn't find a cloud service to create an older Oracle instance.

Kind regards,

Stuart


0
0
16 Apr 2023
Copy Link
2021-04-17 09-53-48
José Gonçalves

Hi Stuart,

Oracle standard edition two. Engine version 19.

Regards

0
0
17 Apr 2023
Copy Link
2024-11-07 03-28-42
Stuart Harris
Champion

Replying to José Gonçalves' comment on 17 Apr 2023 10:07:38

Thanks Jose.

Seeing as I am unable to debug Oracle issues like this due to lack of an environment, I'm going to remove the Oracle specific code.  This will mean slightly slower upload for larger files, but at least it will work.

Would that be acceptable for you?

Kind regards,

Stuart

0
0
17 Apr 2023
Copy Link
UserImage.jpg
Ronaldo David

Hi,

I'm still encountering this error using the latest version of ReactFilePondUpload. 

  • Error executing query. Error in advanced query SQLAddChunk_Oracle in FilePondUpload_ChunkedFileAppend in ReactFilePondUpload_CW (DECLARE blob1 BLOB;    BEGIN        UPDATE {UploadedFile}      SET {UploadedFile}.[LastChunkNum] = @ChunkNumber,      {UploadedFile}.[ChangedByUserId] = @CurrUserId,      {UploadedFile}.[ChangedDateTime] = @CurrDateTime      WHERE {UploadedFile}.[Id] = @UploadedFileId;        SELECT {UploadedFile}.[BinaryContent] INTO blob1      FROM {UploadedFile}      WHERE {UploadedFile}.[Id] = @UploadedFileId      FOR UPDATE;        -- If there is no data, NULL is returned      IF (DBMS_LOB.GETLENGTH(blob1) IS NULL OR DBMS_LOB.GETLENGTH(blob1) = 0)      THEN          UPDATE {UploadedFile}          SET {UploadedFile}.[BinaryContent] = @ChunkContent          WHERE {UploadedFile}.[Id] = @UploadedFileId;          ELSE          DBMS_LOB.APPEND(blob1, @ChunkContent);      END IF;    END;  ): ORA-01460: unimplemented or unreasonable conversion requested 

Tagging @Stuart Harris.

Regards.

0
0
11 Jul 2023
Copy Link
2024-11-07 03-28-42
Stuart Harris
Champion

Hi Ronaldo, thanks for your comment. It should be fixed in the latest version. Which version are you using?

Kind regards,

Stuart

0
0
11 Jul 2023
Copy Link
UserImage.jpg
Ronaldo David

Replying to Stuart Harris' comment on 11 Jul 2023 07:08:21

Hi Stuart,

I am currently using the latest version. I encountered the error while using the demo app.


Demo app


Service Center Error Log


Regards.


EDIT: Added few screenshots.


1
0
11 Jul 2023
Copy Link
2024-11-07 03-28-42
Stuart Harris
Champion

Replying to Ronaldo David's comment on 11 Jul 2023 07:13:32

Hi Ronaldo,

Thanks for a fast response.

Yes that is the correct version. I wonder if the demo you have is an older version?

The reason I mention this is because the Advanced SQL element in your error message ("SQLAddChunk_Oracle in FilePondUpload_ChunkedFileAppend") is not present in the latest version, so the demo you have must be referencing code from the older version.  As it uses Server actions instead of Service Actions it needs its references updated to get the new code.

Try updating references on the demo app, that should fix it.

Kind regards,

Stuart

0
0
11 Jul 2023
Copy Link
UserImage.jpg
Ronaldo David

Replying to Stuart Harris' comment on 11 Jul 2023 07:21:22

Hi Stuart,

I tried installing it again in my personal environment and it works properly but when I use this forge in another environment (company's environment) the error appears again.

I also noticed that SQLAddChunk_Oracle in FilePondUpload_ChunkedFileAppend exists in the latest version I just downloaded in my personal environment. Should this not exist according to your reply? Please screenshot below.

Regards.

0
0
12 Jul 2023
Copy Link
2024-11-07 03-28-42
Stuart Harris
Champion

Replying to Ronaldo David's comment on 12 Jul 2023 07:53:47

Hi Ronaldo,

Thats correct, that image shows the logic for the previous version.

I wonder why its not using the latest.

Your personal environment will be using SQL server so wouldn't be affected anyway.

Kind regards,

Stuart

0
0
12 Jul 2023
Copy Link
UserImage.jpg
Ronaldo David

Replying to Stuart Harris' comment on 12 Jul 2023 08:25:40

Hi Stuart,

I am wondering too why is this the one being downloaded if it is not the latest. Is it possible to know the fix on this issue? Maybe I can apply it manually on our copy.

Regards.

0
0
12 Jul 2023
Copy Link
2024-11-07 03-28-42
Stuart Harris
Champion

Replying to Ronaldo David's comment on 12 Jul 2023 09:01:57

Hi Ronaldo,

Many apologies, it appears I had not uploaded the changes. I have uploaded a new version now which should resolve the issue.

Thanks for your help and perseverance.

Kind regards,

Stuart

0
0
13 Jul 2023
Copy Link
UserImage.jpg
Ronaldo David

Replying to Stuart Harris' comment on 13 Jul 2023 00:06:16

Hi Stuart,

I have updated my copy and it is now working properly. Thank you for helping me and Diego.

Regards.

1
0
13 Jul 2023
Copy Link
2024-11-07 03-28-42
Stuart Harris
Champion

Replying to Ronaldo David's comment on 13 Jul 2023 01:46:56

Thats great to hear! Thanks Ronaldo for letting me know.

Kind regards,

Stuart

0
0
13 Jul 2023
Copy Link
UserImage.jpg
Diego Velilla

Hello Stuart, 

I'm having the exact same problem in the demo app and other app that uses the component.

I have installed the latest version of the forge component and demo. 

What is strange is that happens only with certain file formats. The error happens with .pdf but works with .xml for example. 

I'm assuming it happens in the attached advanced query

test.PNG
0
0
11 Jul 2023
Copy Link
2024-11-07 03-28-42
Stuart Harris
Champion

Hi Diego, 

Looks like you need to upgrade to the latest component. The version you have won't work.

Kind regards,

Stuart

0
0
11 Jul 2023
Copy Link
UserImage.jpg
Diego Velilla

Replying to Stuart Harris' comment on 11 Jul 2023 23:24:13

Hi Stuart, 

As I said, I did upgrade to the latest version (1.2.9), but the code for SQLAddChunk_Oracle in FilePondUpload_ChunkedFileAppend still exists. It's the same scenario as described by Ronaldo. 


0
0
12 Jul 2023
Copy Link
2024-11-07 03-28-42
Stuart Harris
Champion
0
0
12 Jul 2023
Copy Link
UserImage.jpg
Diego Velilla

I'm gonna delete the apps, modules and tables created by the component, download the latest version from the Forge again and retry. I would get back with the results. 

0
0
12 Jul 2023
Copy Link
2024-11-07 03-28-42
Stuart Harris
Champion

Hi Diego and Ronaldo,

So.. I managed to check the latest version and you are both correct, I had not uploaded the fix. I thought I had, but due to mainly being a bit of a dill, I was wrong.

So please accept my apologies and enjoy the new version.

Kind regards,

Stuart

0
0
12 Jul 2023
Copy Link
UserImage.jpg
Diego Velilla

Replying to Stuart Harris' comment on 12 Jul 2023 13:06:10

Thanks for your help Stuart!. 

I can confirm the latest version work as expected.

Kind Regards.

1
0
12 Jul 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.