Appcrash event error during reload oracle view in qvw file

[narender123]

HI All,

I am fetching oracle tables and view from ODBC connection in Qlikview Generator(QVW file).I am able to fetch all tables and views in Qvw file except 1 view which is not reload in my qlikview file from oracle database.

I ran that view in oracle database and running successfully but during reload that view is qlikview showing error problem event name : appcrash and qvconnect 11.0 sr2 stopped working.

Note: All other tables and views running fine.

Thanks,

Narender

[tresesco]

I would try:

• Use OLEDB rather than ODBC
• Upgrade ODBC (if applicable)

[amit_saini]

Hi,

Agree with Tresesco!

Also plz check:

https://www.devart.com/odbc/oracle/docs/index.html?using_odbc_driver.htm

Thanks,
AS

[jagan]

Hi Narender,

Try reading that view by using OLEDB connection, I too faced this issue and resolved by using OLEDB connection.

Hope this helps you.

Regards,

Jagan.

[narender123]

Thanks Tresko, Amit and Jagan.

But i am facing this error only for 1 view , All other views are reloading successfully with ODBC connection.

Why it is happening with 1 view only?

Narender

[tresesco]

Yes, ODBC could be that erratic sometimes (I experienced similar) . Try what I suggested above.

[jagan]

There will be issues with ODBC sometimes especially with larger tables.  Did you tried with Oledb?

Regards,

Jagan.