This is a query that displays on a table. When I run the query on a large file, 207MB it crashes. I will appreciate any help/direction that you can provide! This is the error detail:
The 'TABLE_QRY_IMP_IIPAS_REV' control cannot be initialized, the following HFSQL error occurred: ============================= OLE DB access error. Error Number = 170129
Failure opening file. =============================
System Error Details:
Description = Class not registered Source = Provider Help Context = 1240640 (0x12ee40) Error Number = -2147221164 (0x80040154) Native Error Number = -2147221164 (0x80040154)
----- Technical Information -----
Project : BVS11
What happened? The 'TABLE_QRY_IMP_IIPAS_REV' control cannot be initialized, the following HFSQL error occurred: ============================= OLE DB access error. Error Number = 170129
Failure opening file. =============================
Error code: 10085 Level: fatal error (EL_FATAL) WD55 error code: 3001
System error message: Description = Class not registered Source = Provider Help Context = 1240640 (0x12ee40) Error Number = -2147221164 (0x80040154) Native Error Number = -2147221164 (0x80040154)
Dump of the error of 'wd200obj.dll' module (20.0.373.11). Identifier of detailed information (.err): 10085 Debugging information: Query before correction: Text of the query: SELECT DISTINCT `IIPAS_REV$`.`EXTR_FINC_ARNG_CD` AS `EXTR_FINC_ARNG_CD` , `IIPAS_REV$`.`pri_chnl_nm` AS `pri_chnl_nm` , `IIPAS_REV$`.`ModifiedPolicyNumber` AS `ModifiedPolicyNumber` , `IIPAS_REV$`.`Policy_Customer` AS `Policy_Customer` , `IIPAS_REV$`.`GL_PROD` AS `GL_PROD` , `IIPAS_REV$`.`PRDCT_NM` AS `PRDCT_NM` , `IIPAS_REV$`.`PRI_CHNL_CD` AS `PRI_CHNL_CD` FROM `IIPAS_REV$` WHERE ( ( `IIPAS_REV$`.`Policy_Customer` <> ) AND ( `IIPAS_REV$`.`EXTR_FINC_ARNG_CD` = ) ) ORDER BY `IIPAS_REV$`.`ModifiedPolicyNumber` , `IIPAS_REV$`.`GL_PROD` ,1,2,4,6,7 Number of Parameters: =2 Parameter 0 : WLanguage Type: 110 = <(null)> Parameter 1 : WLanguage Type: 110 =
Text of the query: SELECT DISTINCT `IIPAS_REV$`.`EXTR_FINC_ARNG_CD` AS `EXTR_FINC_ARNG_CD` , `IIPAS_REV$`.`pri_chnl_nm` AS `pri_chnl_nm` , `IIPAS_REV$`.`ModifiedPolicyNumber` AS `ModifiedPolicyNumber` , `IIPAS_REV$`.`Policy_Customer` AS `Policy_Customer` , `IIPAS_REV$`.`GL_PROD` AS `GL_PROD` , `IIPAS_REV$`.`PRDCT_NM` AS `PRDCT_NM` , `IIPAS_REV$`.`PRI_CHNL_CD` AS `PRI_CHNL_CD` FROM `IIPAS_REV$` WHERE ( ( `IIPAS_REV$`.`Policy_Customer` <> ? ) AND ( `IIPAS_REV$`.`EXTR_FINC_ARNG_CD` = ? ) ) ORDER BY `IIPAS_REV$`.`ModifiedPolicyNumber` , `IIPAS_REV$`.`GL_PROD` ,1,2,4,6,7 Number of Parameters: 2 Parameter 0 ADO type: : <8> = Value: : <(null)> Parameter 1 ADO type: : <8> = Value: : IEWDOLDB=111.6 Module= Version=<20.0.23.0>
[Current Recordset parameters] Wanted = LockType = , Location = , Type = , Capacities = Got = LockType = , Location = , Type = , Capacities = Error defining options of ADO object. Cursor Location: <2> Cursor Type: <1> Lock Type: <3> Provider: Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0; Data source: C:\BIVSER\DATA_LOAD\REV_201801.xlsx Connection time-out: 30 Command time-out: 30 Unicode supported: 1 Page code of WL: 1252 Page code of the connection: UTF-16
MDAC Version = <6.1.7601.17514>.
[Data format] Query Parameter Checked = <0> = <> Query Parameter Needing conversion = <0> = <> DecimalSeparator = DateFormat =
[Cursor settings Match] LockType = , Location = , Type = , Capacities = LockType = , Location = , Type = , Capacities = LockType = , Location = , Type = , Capacities =
Additional Information: EIT_NATIVECODE : <170129> EIT_ADOCODE : <-2147221164> EIT_BASECODE : <-2147221164> EIT_ODBCDESCRIPTION : EIT_LOGICALTABLENAME : |