3 Replies Latest reply on Oct 26, 2020 5:27 AM by Rajesh Thiagarajan

    Session fails with error - Failed to bind id property for credential object with name <Unknown>

    B K New Member

      @@@Hi All,

       

      We recently moved to Azure Datawarehouse as our ETL target appliance. Some of the workflows are failing with the error given below, when we use Azure Connector(DWV3). Has anyone faced the same? Could you please shed some light on why this error is throws?

       

      PowerCenter version: 10.2 HF 2

      Target: Azure Syanpse

       

       

      Thank you.

       

      2020-10-03 17:42:49 : ERROR : (3452 | WRITER_1_*_1) : (IS | IS_HM_AZP_Biscuit) : node02 : AZUREDWV3_10000 : [FATAL] Error : Failed to bind id property for credential object with name <Unknown>

      2020-10-03 17:42:49 : INFO : (3452 | WRITER_1_*_1) : (IS | IS_HM_AZP_Biscuit) : node02 : AZUREDWV3_10000 : [INFO] Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to bind id property for credential object with name <Unknown>

       

       

      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)

       

       

      at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)

       

       

      at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:845)

       

       

      at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:752)

       

       

      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)

       

       

      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)

       

       

      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)

       

       

      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)

       

       

      at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:729)

       

       

      at com.informatica.adapter.azuredwv3.metadata.adapter.DWUtil.execSqlQuery(DWUtil.java:84)

       

       

      at com.informatica.adapter.azuredwv3.metadata.adapter.DWUtil.createExternalTableForWrite(DWUtil.java:324)

       

       

      at com.informatica.adapter.azuredwv3.runtime.adapter.write.InsertHandler.copyBlobToDW(InsertHandler.java:239)

       

       

      at com.informatica.adapter.azuredwv3.runtime.adapter.write.InsertHandler.execute(InsertHandler.java:134)

       

       

      at com.informatica.adapter.azuredwv3.runtime.adapter.write.AzureDWNativeWriter.deinit(AzureDWNativeWriter.java:251)

       

       

      at com.informatica.adapter.azuredwv3.runtime.adapter.AzureDWv3TableDataAdapter.deinitDataSession(AzureDWv3TableDataAdapter.java:382)

       

       

      at com.informatica.cci.runtime.impl.CDataAdapterImpl.deinit(CDataAdapterImpl.java:256)

       

       

      at com.informatica.cci.cloud.client.impl.CCIRuntimeDataClientImpl.deinitDataAdapter(CCIRuntimeDataClientImpl.java:142)

       

       

      at com.informatica.cloud.api.adapter.cci.writer.CCIWrtPartitionDriver.deinit(CCIWrtPartitionDriver.java:213)

       

      VIJAYKARTHP