Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Am getting a error ORA-20249 when i try to update data in PowerBI

Deborah OliveiraFeb 19 2024

So am using Power bi and am connecting to my data base that is Oracle SQL Developer and some of tables are showing this error ORA-20249 when i try to connect to obtain more data. I have no idea what this error is about and how to fix it, i have been trying to fix it with Microsoft for more than 2 months and they suggested for me to come here and try to see what could it be. Could anyone please help me? thank you so much.

This is the error when i try to connect this table in PowerBI:

This is the error in English:
ORA-20249:
Company: 1
Product: 100021
Version: 1
Attribute: 4
Value: 0.921
INI-20249 - The value entered for the attribute is invalid, it is not numeric.

ORA-06512: at "ADMIN.PCP_ATRIB", line 441
ORA-06512: at "ADMIN.F_BUSCA_VALOR_FICHA", line 33
ORA-06512: at "ADMIN.F_RETORNA_PESO", line 96
ORA-06512: at line 1
Details:
DataSourceKind=Oracle
DataSourcePath=192.168.55.35/iniflex
Message=ORA-20249: Error in attribute formula: 900
ORA-20249:
Company: 1
Product: 100021
Version: 1
Attribute: 4
Value: 0.921
INI-20249 - The value entered for the attribute is invalid, it is not numeric.

ORA-06512: at "ADMIN.PCP_ATRIB", line 441
ORA-06512: at "ADMIN.F_BUSCA_VALOR_FICHA", line 33
ORA-06512: at "ADMIN.F_RETORNA_PESO", line 96
ORA-06512: at line 1
ErrorCode=-2147467259

Comments
Post Details
Added on Feb 19 2024
3 comments
116 views