You can translate the question and the replies:

Same query run in different servers, one is fine and another has errors

When run a query, got below error: QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] [ERROR] QUERY [JDBC ROUTE] [ERROR] Received exception with message 'ORA-20000: Error in pkg_get_read_data.fn_pl_get_entity_detail ORA-01792: maximum number of columns in a table or view is 1000 ORA-06512: at "CRDB.PKG_GET_READ_DATA", line 599 ORA-06512: at line 1' Same query in the other server and it works fine. Both servers connecct to the same database.
user
30-11-2019 09:34:43 -0500

1 Answer

Hi, I’ve come across this issue before as it is a known Oracle bug. What I did to solve this issue was to disable the checking by setting "_fix_control" to "17376322:OFF". I used [this article on Oracle Community](https://community.oracle.com/message/12970776#12970776) to learn about this. Particularly answer #9 offers this workaround. However, it seems that if the query executes fine in other server you could be facing a problem that can be fixed by mirroring the configuration on both servers. What I would do as a first step is to go to the [Execution Trace](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/appendix/execution_trace_information/execution_trace_information) and at the bottom, at the data source level, look at the delegated SQL sentence. I would then compare both the delegated SQL from the server that is working and the one that pulls the error from Oracle and see if there are any differences. If that is the case this difference might point out the source of the configuration discrepancy between both servers. Hope this helps!
Denodo Team
02-12-2019 16:29:31 -0500
You must sign in to add an answer. If you do not have an account, you can register here