0

I am trying to connect ODBC 64bit Driver to allow me execute query to extract data from JDE 8.12 After building open SQL Connection and execute simple query it appear an error "Error in SQL statement Arithmetic operation resulted in an overflow."

Could you please advise what is missing in order to allow the query to be execute?

Steps which I did:

1 - I selected Microsot OLE DB Provider for ODBC Driver

enter image description here

2- Selected Driver (Driver - Oracle in OraClient 11g64_home1)

enter image description here

3 -Test The connection and show successful

4 - Build simple query to test the Flow

enter image description here

5- After run the Flow I get error

"Error in SQL statement Arithmetic operation resulted in an overflow."

After successful connection , I was expecting simple query to be executed without issue.

Lajos Arpad
  • 64,414
  • 37
  • 100
  • 175
RBV
  • 1

1 Answers1

0

It is possible that your Orale client is 32-bit only and the application using it is not x86 compiled.

Also, it's possible that you have a numeric field of certain limitation and a value is being computed arithmetically and then attempted to be stored into the field, overflowing its bounds.

Lajos Arpad
  • 64,414
  • 37
  • 100
  • 175
  • Hi Lajos, Oracle Client is 64bit ( step1 connection was succefull ). I am running very simple query for testing only SELECT * FROM PRODDTA.f0101 – RBV Feb 15 '23 at 13:17
  • @RBV can you share the schema of the `PRODDTA.f0101` table? – Lajos Arpad Feb 15 '23 at 13:22
  • select ABAN8 from PRODDTA.f0101 where ABAN8= ##### ( Customer number) – RBV Feb 15 '23 at 13:23
  • @RBV that's not the schema. – Lajos Arpad Feb 15 '23 at 13:25
  • sorry. i dont know what is it. let me google – RBV Feb 15 '23 at 13:26
  • @RBV no worries. I wonder what fields your table has. See https://stackoverflow.com/questions/18264584/show-create-table-equivalent-in-oracle-sql – Lajos Arpad Feb 15 '23 at 13:36
  • 1
    He's asking for the table structure... provide the column names, datatypes, precision, scale, length, etc.. of the columns of this table. Particularly ABAN8. You can find this info in all_tab_columns – Paul W Feb 15 '23 at 13:43
  • OWNER - PRODDTA ; TABLE_NAME- F0101; COLUMN_NAME - ABAN8; DATA_TYPE - NUMBER; DATA_LENGTH - 22; DATA_SCALE NULLABLE - N; COLUMN_ID - 1; NUM_DISTINCT - 749681; LOW_VALUE - C147; HIGH_VALUE - C464646464; DENSITY - 1.3339E-06; NUM_NULLS - 0; NUM_BUCKETS - 1; SAMPLE_SIZE - 749681; GLOBAL_STATS - YES; USER_STATS - NO; AVG_COL_LEN - 6; CHAR_LENGTH - 0; CHAR_USED V80_FMT_IMAGE - NO; DATA_UPGRADED - YES; HISTOGRAM - NONE; additinoal info https://jde.erpref.com/?schema=920&system=01&table=F0101 – RBV Feb 15 '23 at 14:02
  • @RBV the query is simple indeed but the table is not simple. Can you run your query for only a subset of your fields? Do you get the same error then? – Lajos Arpad Feb 15 '23 at 14:03
  • if consider subset "Where' clause then I did before like this select ABAN8 from PRODDTA.f0101 where ABAN8= ##### and gave me same error in PowerAutomate Desktop – RBV Feb 15 '23 at 14:15
  • @RBV I asked about a subset of columns, you answered about a test with a filter. Can you run a query like `SELECT ABAN8 FROM F0101` ? – Lajos Arpad Feb 15 '23 at 14:30
  • Hi Lajos, i did it before and did work. Gives me error "Error in SQL statement ERROR [42S02] [Oracle][ODBC][Ora]ORA-00942: table or view does not exist" – RBV Feb 15 '23 at 18:32
  • @RBV Your table or view does not exist, so it was dropped for some reason, at least according to the error message – Lajos Arpad Feb 16 '23 at 11:07
  • correct becuase it's missing the proddta. guess – RBV Feb 16 '23 at 16:46
  • @RBV you will need to perform the experiment of running a query that loads only a part of the fields where the table or view actually exists. – Lajos Arpad Feb 17 '23 at 10:50