https://community.qlik.com/t5/Qlik-Replicate/Cannot-able-to-create-the-quot-attrep-apply-exceptions-quot/m-p/2144239#M8403 <P>Hello</P> <P>The problem is with the user authorization:</P> <P><SPAN>This Azure storage request is not authorized. The storage account's 'Firewalls and virtual networks' settings may be blocking access to storage services. Please verify your Azure storage credentials or firewall exception settings.</SPAN></P> <P><SPAN>Please check with the Databricks team</SPAN></P> <P><SPAN>Boaz</SPAN></P> Tue, 05 Dec 2023 08:52:28 GMT boaz_newman 2023-12-05T08:52:28Z https://community.qlik.com/t5/Qlik-Replicate/Cannot-able-to-create-the-quot-attrep-apply-exceptions-quot/m-p/2143832#M8386 <P>My source is Azure SQL. My target is Databricks Lakehouse(delta)connector. Full load for a table is failing because of the issues below:<BR /><BR />Stream component 'st_0_lakehouse_test' terminated<BR />Stream component failed at subtask 0, component st_0_lakehouse_chandra_test <BR />Error executing command<BR />Cannot create Exception table<BR />Cannot create Special table<BR />Execute create table statement failed, statement CREATE OR REPLACE TABLE `dbo`.`attrep_apply_exceptions`<SPAN>( `TASK_NAME` VARCHAR(128) NOT NULL, `TABLE_OWNER` VARCHAR(128) NOT NULL, `TABLE_NAME` VARCHAR(128) NOT NULL, `ERROR_TIME` TIMESTAMP NOT NULL, `STATEMENT` STRING NOT NULL, `ERROR` STRING NOT NULL ) USING DELTA LOCATION</SPAN></P> <P><SPAN>TBLPROPERTIES (delta.autoOptimize.optimizeWrite = true)<BR />RetCode: SQL_ERROR SqlState: HY000 NativeError: 35 Message: [Simba][Hardy] (35) Error from server: error code: '0' error message: 'org.apache.hive.service.cli.HiveSQLException: Error running query: org.apache.spark.SparkException: This Azure storage request is not authorized. The storage account's 'Firewalls and virtual networks' settings may be blocking access to storage services. Please verify your Azure storage credentials or firewall exception settings.<BR />at org.apache.spark.sql.hive.thriftserver.HiveThriftServerErrors$.runningQueryError(HiveThriftServerErrors.scala:48)<BR />at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.$anonfun$execute$1(SparkExecuteStatementOperation.scala:611)<BR />at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23)<BR />at com.databricks.unity.EmptyHandle$.runWith(UCSHandle.scala:124)<BR />at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.org$apache$spark$sql$hive$thriftserver$SparkExecuteStatementOperation$$execute(SparkExecuteStatementOperation.scala:501)<BR />at org.apache.spark.sql.hive.</SPAN></P> Mon, 04 Dec 2023 10:42:09 GMT https://community.qlik.com/t5/Qlik-Replicate/Cannot-able-to-create-the-quot-attrep-apply-exceptions-quot/m-p/2143832#M8386 chandraprakash_j_volvo 2023-12-04T10:42:09Z https://community.qlik.com/t5/Qlik-Replicate/Cannot-able-to-create-the-quot-attrep-apply-exceptions-quot/m-p/2144239#M8403 <P>Hello</P> <P>The problem is with the user authorization:</P> <P><SPAN>This Azure storage request is not authorized. The storage account's 'Firewalls and virtual networks' settings may be blocking access to storage services. Please verify your Azure storage credentials or firewall exception settings.</SPAN></P> <P><SPAN>Please check with the Databricks team</SPAN></P> <P><SPAN>Boaz</SPAN></P> Tue, 05 Dec 2023 08:52:28 GMT https://community.qlik.com/t5/Qlik-Replicate/Cannot-able-to-create-the-quot-attrep-apply-exceptions-quot/m-p/2144239#M8403 boaz_newman 2023-12-05T08:52:28Z