topic Re: Error: [Oracle][ODBC][Ora]ORA-21561 in QlikView

Error: [Oracle][ODBC][Ora]ORA-21561

nayanpatel — Wed, 09 Aug 2017 05:06:37 GMT

Hi,

I am getting this error for some tasks very often. If I run same task manually after 30 min or 1 hour then the task will run successfully. Please provide solution to resolve the issue.

Error: Information: SQL##f - SqlState: S1000, ErrorCode: 21561, ErrorMsg: [Oracle][ODBC][Ora]ORA-21561: OID- generation failed

Thanks & regards--

Nayan

Re: Error: [Oracle][ODBC][Ora]ORA-21561

prma7799 — Wed, 09 Aug 2017 05:10:32 GMT

Please check this

Oracle ORA-21561 : OID generation failed | ORACLE DBA BLOG

Oracle ORA-21561 : OID generation failed

Giving below error when trying to connect from Oracle client

“ORA-21561 : OID generation failed”

ERROR:

sqlplus <test_user>/<test_user_password>@<database_name>
xxxxx xxxx
xxxx xxxx
ERROR:
ORA-21561 : OID generation failed

Enter user-name: <username>/<password> @ <tns connect string>

SOLUTION:

Then the problem is most likely in the client machine hosts file.
Check that there is client machine fully qualified name and short name in the client machine hosts file. If these are missing you’ll get ORA-21561 errors when trying to connect server.
Example:

127.0.0.1 localhost.localdomain localhost
10.160.116.10 dbamasters.oracle.com dbamasters

Re: Error: [Oracle][ODBC][Ora]ORA-21561

Anil_Babu_Samineni — Wed, 09 Aug 2017 05:11:22 GMT

I faced earlier when i was with DB Developer. Cause: The handles passed in may not be valid. Action: Check the validity of the env, svc handles.

Then the problem is most likely in the client machine hosts file. Check that there is client machine fully qualified name and short name in the client machine hosts file. If these are missing you will get ORA-21561 errors when trying to connect to the server.

Re: Error: [Oracle][ODBC][Ora]ORA-21561

nayanpatel — Wed, 09 Aug 2017 05:19:05 GMT

Hi Thanks for prompt response. However, I did not understand

1) what is client machine here

2) I am getting the error at morning 6:00 AM as per my scheduler. But at 8:00 AM if i try to run manually, it working fine. which means error at 6:00 AM only. and I am trying to find out what was the issue at 6:00 AM

Re: Error: [Oracle][ODBC][Ora]ORA-21561

nayanpatel — Wed, 09 Aug 2017 05:19:32 GMT

Hi Thanks for prompt response. However, I did not understand

1) what is client machine here

Re: Error: [Oracle][ODBC][Ora]ORA-21561

Anil_Babu_Samineni — Wed, 09 Aug 2017 07:27:53 GMT

1) Client Machine here - It's called your DB installation machine

2) How you are scheduling this? Any Triggers assigned in your Database tasks. If so,, How your trigger query or script looks like

Re: Error: [Oracle][ODBC][Ora]ORA-21561

nayanpatel — Wed, 09 Aug 2017 13:39:36 GMT

Hi Tanks for response.

1) QlikView jobs scheduled with publisher in QlikView Server

2) We don't have database access, so cant check for trigger assigned etc at DB level. We are getting ODBC connection string from DB side which we are using in QlikView application

Re: Error: [Oracle][ODBC][Ora]ORA-21561

Anil_Babu_Samineni — Wed, 09 Aug 2017 14:01:34 GMT

1) There must be Services may gets down that time (6 AM) - Check tomorrow and confirm the same

2) When you done in Qlikview environment only i don't think DB has any triggers AON. You have to wait till Tomorrow for confirmation

Re: Error: [Oracle][ODBC][Ora]ORA-21561

nayanpatel — Fri, 11 Aug 2017 05:07:25 GMT

Hi,

1) Yes there must be something at database side which prevent me to extract data at 6:00 AM and that I have to find out and tell to customer. I want those details only. but no luck from where to get those details.

2) My jobs failing once or twice in week. So its already under observation.

Re: Error: [Oracle][ODBC][Ora]ORA-21561

Anil_Babu_Samineni — Mon, 14 Aug 2017 04:43:01 GMT

1) I doubt, Still whether they done this in DB side because you said, we are scheduling this in QVS / QVP. I am not sure, how you came to know (May be check this in DB end) and share with us. We will always learning new things

2) This is the case, I assume your qlikview services may be stops that time for 2 days. Could be the main reason here. May be contact to support and explain same they may help you in remote if needed qoncierge@qlik.com